Blogger Tips and TricksLatest Tips And TricksBlogger Tricks

Tuesday, 1 September 2015

DBMS

1. Introduction and Conceptual Modeling
2. Database System Concepts and Architecture
3. Data Modeling Using the Entity-Relationship (ER) Model
4. Enhanced Entity-Relationship and UML Modeling part I
5. Enhanced Entity-Relationship and UML Modeling part II
6. The Relational Data Model and Relational Database Constraints
7. The Relational Algebra and Calculus  
8. Relational Database Design by ER- and EERR-to-Relational Mapping
9. SQL-99: Schema Definition, Basic Constraints, and Queries
10. MORE SQL: Assertions, Views, and Programming Techniques
11. Functional Dependencies and Normalization for Relational Databases
12. Relational Database Design Algorithms and Further Dependencies
13. Practical Database Design Methodology and Use of UML Diagrams
14. Disk Storage, Basic File Structures, and Hashing.
15. Indexing Structures for Files
16. Algorithms for Query Processing and Optimization
17. Practical Database Design and Tuning  
18. Introduction to Transaction Processing Concepts and Theory
19. Concurrency Control Techniques
20. Database Recovery Techniques
21. Concepts for  Object-Oriented Databases
22. Object Database Standards, Languages, and Design
23. Object-Relational and Extended-Relational Systems
24. Database Security  and Authorization
25. Enhanced Data Models for Advanced Applications
26. Distributed Databases and Client–Server Architectures
27. XML and Internet Databases
28. Data Mining Concepts
29. Overview of Data Warehousing and OLAP
30. Emerging Database Technologies and Applications