Note: Please check your Spam or Junk folder, in case you didn't receive the email with verification code.
Unit–I
Database Concepts and Modeling
Introduction – Data, Database, DBMS, Database Users and Administrators, History of Database Systems, Overview of Client/Server Technology: 3Tier Architecture, Data Modeling, Hierarchical, Network, Object Oriented, Introduction to Distributed Databases. Relational Data Structure: Tuple, Attributes, Set, Relational Algebra Operators, Entity Relationship Diagrams, Design of E-R Schema, E-R Schema to Tables.
Unit–II
Relational Languages and Relational Database
Functional Dependence: Normal Forms, Integrity Constraints, Domain, Referential Integrity, Codd’s Rules. Elementary Operators, Set Operations, Aggregate Functions, Null Values, Nested Sub Queries, Derived Relations, Views, Joined Relations, DDL, Embedded SQL, QBE, QUEL, Advantages and Limitations of RDBMS.
Unit–III
Transaction Processing
Transaction Concepts, States, Atomicity, Durability, Serializability, Isolation, Transaction Definition in SQL, Concurrency Control, Locking, Deadlock, Handling, Recovery Systems, Log Based Shadow Paging.
Unit–IV
Distributed and Special Database
Distributed Data Storage, Network Transparency, Distributed Query Processing, Commit Protocols, Concurrency Controls, Deadlock Handling, Data Analysis, Data Mining, Data Warehousing, Spatial and Geographical, Multimedia Database, Mobility and Personal Database, Distributed Information System, World Wide Web, OLAP.
Unit–V
ORACLE
Introduction : SQL, SQL Commands for Data Definition and Data Manipulation, Views – Procedures, Indexing, PL/SQL, Forms Design Process, Triggers, SQL Report Writer, SQL Menus, Approach and Advantages – Exception Handling – Procedures – Functions – Packages – Triggers.
No Preview is available for this book
CategoriesManagement
Format EPUB
TypeeBook