Your shopping cart is empty.

Teach Yourself Database Technologies By Ivan Bayross

Rs. 202.00

Author: Ivan Bayross

Features:

  • Language: English
  • Binding: Paperback
  • Publisher: BPB Publications
  • ISBN: 9788176565516
  • Edition:2010
  • Pages: 285
  • Dimension: 24 X 18 X 1.5 cm

Description:

This book has been written to give an excellent grounding to those who wish to learn SQL & PL/SQL natural language of Oracle. Like all his earlier books this book also has several illustrative examples, which have a logical link between them. There are also Hands on exercises and their solutions to support the illustrative examples. Each set of examples and their associated Hands on exercises helps build skills that will take the reader to the next set of examples, which in turn lead upwards until a great deal of confidence has been established in the use of SQL & PL/SQL. 
Table Of Contents:

1.     Client / Server Computing

2.     RDBMS Technology

3.     Codd's Rules

4.     Data Models

5.     Normalization

6.     Entity Relationship Diagrams

7.     Data Flow Diagrams

8.     Data Integrity

9.     Data Security

10.  Overview Of Oracle

11.  SQL *Plus

12.  DDL, DML and DCL

13.  Tables, Indexes and Views

14.  Clusters, Sequences and Snapshots

15.  Introduction to PL/SQL

 

 

16.  Cursors

17.  Stored Procedures

18.  Triggers

19.  Basics of Oracle Database Architecture

20.  Creating a Database

21.  Database Administration

22.  Creating and Managing Users

23.  Oracle Networking

24.  Database Backup and Recovery

25.  Importing and exporting data

26.  Oracle Replication

27.  SQL Server Architecture

28.  Application Development Architecture

29.  MS SQL Server administration

30.  Data Transformation Services

Index