ASEbackApplied Software Engineering
Database Management System
		
1. Introduction to Databases
     1.1 Anatomy of Database System 
     1.2 Applications of Database System
     1.3 StakeHolders, Users and Administrators 
     1.4 Client/Server concepts
     1.5 Distributed Databases concepts 
     1.6 History

2. File Systems
     2.1 Organisation of FileSystem
     2.2 Database System v/s File System

3. Types of Database System Models
     3.1 Hierarchical Model
     3.2 Network Model
     3.3 Relational Model

4. ER Models
     4.1 Elements of ER
     4.2 Design Issues
     4.3 Application of ER

5. Relational Model
     5.1 Anatomy of Relational Model 
     5.2 Relational Algebra
     5.3 Design Issues 
     5.4 Applying Relational Model

6. Principles of DataStorage and Querying
     6.1 Storage and FileStructure	
     6.2 Indexing and Hashing
     6.3 Query Processing
     6.4 Query Optimization

7. SQL   
     7.1 Introduction to SQL
     7.2 Data Definition using SQL
     7.3 Datatypes
     7.4 Creating, Manipulating and Dropping Database
     7.5 Creating, Manipulating and Dropping Tables
     7.6 Creating, Manipulating and Dropping Views
     7.7 Working with Constraints and Indexes.

8. Data Manipulation
     8.1 Recurring SQL constructs
        8.1.1 SELECT
        8.1.2 UPDATE
        8.1.3 INSERT
        8.1.2 DELETE
     8.2 Expressions
     8.3 Grouping and Aggregate Functions
     8.4 Joining Tables
     8.5 Subqueries

9. Prepared Statements
     9.1 Benefits
     9.2 Using Prepared Statements
     9.3 Executing and deallocating Prepared Statements

10. Stored Routines
     10.1 Benefits
     10.2 Procedures and functions
     10.3 Namespace
     10.4 Defining, Creating, Altering, Dropping and Invoking Stored Routines
     10.5 Privileges and Security
     10.6 Metadata

11. Triggers
     11.1 Benefits
     11.2 Creating, Restrictions and Destroying Triggers
     11.3 Privileges

12. Transaction Management
     12.1 Transactions
     12.2 Concurrency Control
     12.3 Recovery System

13. Database Connectors
     13.1 JDBC 
     13.2 ODBC
     13.3 Native

14. Advanced Topics
     14.1 Object Oriented Databases
     14.2 XML 
     14.3 Distributed Databases
     14.4 Parallel Databases 
     14.5 Advanced Transaction Processing
     14.6 Web Enabled Database Applications 
     14.7 Security
     14.8 Case Study: Oracle,SQLServer,MySql

15. Project Work
		   
Top|| Click here for Batch Info
support@rajeshpatkar.com
Rajesh Patkar Institute Of Software Engineering
26/A Patel Shopping Center, Ground Floor, Sainath Road, Opp Malad Subway, Malad (W), Mumbai.
Tel: 28809398, 9820396074, 9820860292, 32903720, 28076817.