DBMS
Database management systems fundamentals: DBMS vs RDBMS, relational model, ER modeling, normalization, integrity, transactions, ACID, concurrency, indexing, query optimization, database objects, and SQL vs PL/SQL.
Topic 1: DBMS and RDBMS Fundamentals
Database Concepts
Topic 2: Database, Schema and Users
Database Architecture
Topic 3: Relational Model
Tables, Rows and Columns
Topic 4: Entity-Relationship Modeling
Entities and Attributes
Topic 5: Keys and Identifiers
Primary Keys
Topic 6: Normalization and Data Modeling
First Normal Form
Topic 7: Data Types and NULL
Character and Numeric Types
Topic 8: Data Integrity
Entity and Domain Integrity
Topic 9: Transactions and ACID
ACID Properties
Topic 10: Concurrency and Locking
Concurrent Transactions
Topic 11: Indexes and Access Paths
Why Indexes Exist
Topic 12: Query Optimizer and Execution Plans
EXPLAIN PLAN
Topic 13: Database Objects and Dependencies
Tables, Views, Indexes and Sequences
Topic 14: SQL versus PL/SQL
SQL Responsibilities
Course content is locked. Please purchase or enroll to access all lessons and topics.
Course Progress
Enroll to start learning!
Course Stats
- Total Topics 14
- Total Lessons 14
- Total Sessions 14
- Total Notes 14
- Estimated Time 13.799999999999999 hours
Program Enrollment Only
This course is only available through program enrollment.
View Program: Full Stack Development