Simplified Approach to DBMS is one of the best selling book in the field of database. The major strength of this book, is simplicity of the contents without loosing the details of the topic. This book is excellent for College and University students preparing for DBMS Course. It covers the syllabus of all major Universities. It has very detailed illustrations about the basics of database, architecture of DBMS, Data Models, Relational Model, Relational algebra and Calculus, Designing of ER Model, Conversion of ER Model to Tables, Normalization, Transaction Management and Concurrency Control. It has full coverage of SQL, PL/SQL and NOSQL.
Other Advantages
- The book is available at amazon platform
- All the PPTs of the book chapters are available for Teachers and Students.
- For PPTs visit PPTs for Simplified Approach to DBMS Book – Parteek Bhatia
- All the chapters of book are also explained in Online Udemy Course titled as “Simplified Approach to DBMS”. You will get full sets of videos based on the contents of this course.
https://www.udemy.com/course/simplified-approach-to-dbms/
- The whole PL/SQL discussed in this book is available in Online Udemy Course titled as “Mastering PL/SQL”. This is the highest rated course over Udemy Portal for the PL/SQL learning. This course has been among 2% courses.
https://www.udemy.com/course/mastering-plsql/
- The whole SQL discussed in this book is also available in Online Udemy Course titled as “Learn SQL in a Simplified manner”.
https://www.udemy.com/course/learn-sql-in-a-simplified-manner/
- By following this book and joining these video courses. You can easily learn DBMS on your own pace, any where at any time.
Table of Contents
| Simplified approach to DBMS 1. Fundamentals of Database Management System 2. The architecture of Database Management System 3. Data Models 4. Relational Database Management System 5. Relational Algebra and Calculus 6. Entity-Relationship Model 7. Conversion of ER Diagrams to Tables 8. Normalization for refinement of data 9. Physical Database design 10. Transaction Management 11. Concurrency Control 12. Security and Integrity of data 13. Recovery of data 14. Distributed Database 15. Object-Oriented Databases and expert system 16. DBTG Model 17. Data Warehouse and Data mining 18. No-SQL Database 19. Enterprise Database Products 20. Beginning with SQL 21. Invoking SQL* Plus 22. Performing basic SQL operations 23. Basic SELECT statement 24. Inbuilt functions 25. Grouping of data 26. Joining of tables 27. Sub Queries 28. Managing Tables 29. Database objects, DCL and TCL statements 30. Pl/SQL Fundamentals and its statements 31. Error Handling 32. Cursor Management 33. Subprograms and packages 34. Database triggers 25. Advanced Topics Index |