DBMS & SQL
Lecture notes of Database Mgt System & SQL
- 4.5/5.0
- 1k Enrolled
- All levels
- Last updated 11/2023
- English
PPT Viewer
Syllabus of Database Management Systems & SQL
Title: Mastering RDBMS: A Comprehensive Guide to Database Management Systems & SQL
In the digital age, data has become the backbone of all operations, be it in businesses, academia, or everyday life. Relational Database Management Systems (RDBMS) play a pivotal role in efficiently organizing, storing, and retrieving vast amounts of data. In this comprehensive guide, we will delve into the world of RDBMS and explore the key concepts, principles, and practical applications of this powerful database technology. Download the lecture notes of RDBMS
Course Syllabus: Relational Database Management Systems (RDBMS)
| Sr. No. | Topics | Hours |
| 1 | Introduction to Databases:Data: Types, Organization and Applications , Database : Definition, Evolution , Database Management : Structure, Limitations of traditional file processing systems, Advantages and disadvantages of DBMS, Users of DBMS | 2 |
| 2 | Database System Concepts and Architecture:Database architecture and Environment : Components of DBMS : functions, Architecture : Physical, Logical and View, Data languages : DDL & DML, Schemas, Life cycle of Database system development, Functions of DBMS | 3 |
| 3 | Conceptual Database Modeling : Concepts &Applications, Types of Data Models : Hierarchical, Network, Relational, Object Oriented | 2 |
| 4 | Data Modeling Using the Entity –Relationship ModelEnhanced Entity-Relationship and UML Modeling. Entity Relationship model : concepts of entity, entity sets, attributes, domains, Existence dependency, Candidate/Primary/ composite keys, Strong and Weak entities, Cardinality, E-R model : symbols, specialization, generalization, aggregation | 10 |
| 5 | Relational Database Systems : Characteristics, Concepts : Relation, Attribute, Tuple, Domain, Relational Schemas, Relational constraints : Entity, Domain, Null, Key and Referential, Normalization : 1NF, 2NF, 3NF, BCNF and rules | 10 |
| 6 | Introduction to Transaction Processing Concepts and Theory: ACID properties. Introduction to Schedule. Concept of Serializability. | 5 |
| 7 | Concurrency Control Techniques : Database recovery : Need, Techniques, log based, check point, differed and immediate updates, shadowing, Catastrophic and non-catastrophic failures, Recovery in multi-database environments, Two phase commit protocol | 6 |
| 8 | Database security : Type of security, legal and ethical issues, System policies, levels of security : Physical, Os, Network, DBMS, Privileges : Grant and Revoke | 3 |
| 9 | Advances in Databases : Active databases : ECA model, Data warehousing, Data Mining, OLAP, OLTP | 3 |
| 10 | Introduction to : Architecture, Processes (Background list), | 2 |
| 11 | Introduction to SQLDDL: Create table, Alter table, Drop table, DML: Insert, update, delete, select DTL (TCL) : grant, revoke.With Practice examples | 2 |
| 12 | Select command with all clauses.Table Constraint Definition, Domain, Entity, & Referential integrity, SQL functions, (Union, intersect, minus),Functions (Date, Numeric, Character, Conversion, Miscellaneous, Group function), Group by clause, Having Clause |
