Skip to content
CampusEduX
Free course

DBMS & SQL Tutorial

Learn DBMS and SQL through easy explanations, practical examples, and useful queries. Understand database concepts and improve your SQL skills with hands-on learning.

Sections
43 sections
Lessons
294 lessons
Practice tests
22 practice tests

What you'll learn

  • Chapter 1: Database Foundations
  • Chapter 2: DBMS Architecture
  • Chapter 3: Data Models
  • Chapter 4: Relational Model
  • Chapter 5: Keys and Integrity
  • Chapter 6: ER and EER Modeling
  • Chapter 7: Relational Algebra
  • Chapter 8: SQL Fundamentals

+ 15 more sections in the curriculum below

Course content

43 sections · 294 lessons

1Chapter 1: Database Foundations15 lessons
  1. 1Data, Information, Metadata and Knowledge
  2. 2Database and DBMS
  3. 3DBMS Goals
  4. 4DBMS Advantages and Trade-offs
  5. 5Database Users and Roles
  6. 6Database Administrator
  7. 7Database Designer
  8. 8Application Developer
  9. 9End User
  10. 10DBMS Components
  11. 11Database Engine
  12. 12Storage Manager
  13. 13Query Processor
  14. 14Transaction Manager
  15. 15Buffer Manager
2Chapter 2: DBMS Architecture14 lessons
  1. 16Three Schema Architecture
  2. 17External Schema
  3. 18Conceptual Schema
  4. 19Internal Schema
  5. 20Logical Data Independence
  6. 21Physical Data Independence
  7. 22Data Abstraction
  8. 23Client Server Architecture
  9. 24Two Tier Architecture
  10. 25Three Tier Architecture
  11. 26Database Middleware
  12. 27Connection Pooling
  13. 28Database Drivers
  14. 29Database APIs
3Chapter 3: Data Models11 lessons
  1. 30Hierarchical Model
  2. 31Network Model
  3. 32Relational Model
  4. 33Object-Oriented Model
  5. 34Object-Relational Model
  6. 35Document Model
  7. 36Key Value Model
  8. 37Column Family Model
  9. 38Graph Model
  10. 39Relational vs NoSQL
  11. 40Polyglot Persistence
Data Models - Chapter Test
4Chapter 4: Relational Model13 lessons
  1. 41Relation
  2. 42Tuple
  3. 43Attribute
  4. 44Domain
  5. 45Relation Schema
  6. 46Database Schema
  7. 47Database Instance
  8. 48Degree
  9. 49Cardinality
  10. 50Null Values
  11. 51Relational Integrity
  12. 52Relational Model Rules
  13. 53Keys in the Relational Model
Relational Model - Chapter Test
5Chapter 5: Keys and Integrity13 lessons
  1. 54Super Key
  2. 55Candidate Key
  3. 56Primary Key
  4. 57Alternate Key
  5. 58Foreign Key
  6. 59Composite Key
  7. 60Natural Key
  8. 61Surrogate Key
  9. 62Unique Constraint
  10. 63Entity Integrity
  11. 64Referential Integrity
  12. 65Cascading Actions
  13. 66Business Constraints
Keys and Integrity - Chapter Test
6Chapter 6: ER and EER Modeling21 lessons
  1. 67Entity
  2. 68Entity Set
  3. 69Strong Entity
  4. 70Weak Entity
  5. 71Attributes
  6. 72Simple Attribute
  7. 73Composite Attribute
  8. 74Single Valued Attribute
  9. 75Multi Valued Attribute
  10. 76Derived Attribute
  11. 77Relationship
  12. 78Relationship Degree
  13. 79Cardinality
  14. 80Participation
  15. 81Recursive Relationship
  16. 82Identifying Relationship
  17. 83Generalization
  18. 84Specialization
  19. 85Aggregation
  20. 86EER Diagram
  21. 87ER to Relational Mapping
ER and EER Modeling - Chapter Test
7Chapter 7: Relational Algebra14 lessons
  1. 88Selection
  2. 89Projection
  3. 90Rename
  4. 91Union
  5. 92Intersection
  6. 93Difference
  7. 94Cartesian Product
  8. 95Theta Join
  9. 96Equi Join
  10. 97Natural Join
  11. 98Outer Join
  12. 99Division
  13. 100Relational Algebra Expressions
  14. 101Relational Algebra Practice
Relational Algebra - Chapter Test
8Chapter 8: SQL Fundamentals14 lessons
  1. 102SQL Overview
  2. 103SQL Standards
  3. 104SQL Dialects
  4. 105SQL Statement Structure
  5. 106Identifiers
  6. 107Literals
  7. 108Comments
  8. 109Data Types
  9. 110NULL Semantics
  10. 111DDL
  11. 112DML
  12. 113DQL
  13. 114DCL
  14. 115TCL
SQL Fundamentals - Chapter Test
9Chapter 9: DDL and Schema Design12 lessons
  1. 116CREATE DATABASE
  2. 117CREATE SCHEMA
  3. 118CREATE TABLE
  4. 119ALTER TABLE
  5. 120DROP TABLE
  6. 121TRUNCATE TABLE
  7. 122RENAME
  8. 123Generated Columns
  9. 124Identity Columns
  10. 125Sequences
  11. 126Temporary Tables
  12. 127Schema Evolution
DDL and Schema Design - Chapter Test
10Chapter 10: SQL Constraints11 lessons
  1. 128NOT NULL
  2. 129UNIQUE
  3. 130PRIMARY KEY
  4. 131FOREIGN KEY
  5. 132CHECK
  6. 133DEFAULT
  7. 134Named Constraints
  8. 135Column Constraints
  9. 136Table Constraints
  10. 137Constraint Validation
  11. 138Deferred Constraint Concepts
SQL Constraints - Chapter Test
11Chapter 11: DML and Data Modification11 lessons
  1. 139INSERT
  2. 140Multi Row INSERT
  3. 141INSERT SELECT
  4. 142UPDATE
  5. 143DELETE
  6. 144MERGE Concept
  7. 145Upsert Patterns
  8. 146Safe Updates
  9. 147Bulk Loading
  10. 148Data Validation
  11. 149Data Modification Transactions
DML and Data Modification - Chapter Test
12Chapter 12: SELECT and Filtering15 lessons
  1. 150SELECT
  2. 151DISTINCT
  3. 152WHERE
  4. 153Comparison Operators
  5. 154Logical Operators
  6. 155BETWEEN
  7. 156IN
  8. 157LIKE
  9. 158Pattern Matching
  10. 159IS NULL
  11. 160IS NOT NULL
  12. 161CASE
  13. 162COALESCE
  14. 163NULLIF
  15. 164Operator Precedence
SELECT and Filtering - Chapter Test
13Chapter 13: Sorting and Pagination9 lessons
  1. 165ORDER BY
  2. 166Multiple Sort Keys
  3. 167NULL Ordering
  4. 168LIMIT
  5. 169OFFSET
  6. 170Keyset Pagination
  7. 171Top N Queries
  8. 172Pagination Performance
  9. 173Stable Sorting
Sorting and Pagination - Chapter Test
14Chapter 14: SQL Functions13 lessons
  1. 174Aggregate Functions
  2. 175COUNT
  3. 176SUM
  4. 177AVG
  5. 178MIN
  6. 179MAX
  7. 180String Functions
  8. 181Numeric Functions
  9. 182Date Functions
  10. 183Time Functions
  11. 184Conversion Functions
  12. 185Conditional Functions
  13. 186NULL Functions
SQL Functions - Chapter Test
15Chapter 15: GROUP BY and Aggregation9 lessons
  1. 187GROUP BY
  2. 188HAVING
  3. 189WHERE vs HAVING
  4. 190Multiple Grouping Columns
  5. 191Conditional Aggregation
  6. 192GROUPING SETS Concept
  7. 193ROLLUP Concept
  8. 194CUBE Concept
  9. 195Aggregate Query Optimization
GROUP BY and Aggregation - Chapter Test
16Chapter 16: Joins13 lessons
  1. 196INNER JOIN
  2. 197LEFT JOIN
  3. 198RIGHT JOIN
  4. 199FULL OUTER JOIN
  5. 200CROSS JOIN
  6. 201SELF JOIN
  7. 202Natural Join
  8. 203Multi Table Joins
  9. 204Join Predicate
  10. 205Join Cardinality
  11. 206Duplicate Rows
  12. 207Anti Join
  13. 208Semi Join
Joins - Chapter Test
17Chapter 17: Subqueries12 lessons
  1. 209Scalar Subquery
  2. 210Single Row Subquery
  3. 211Multiple Row Subquery
  4. 212Correlated Subquery
  5. 213EXISTS
  6. 214NOT EXISTS
  7. 215ANY
  8. 216ALL
  9. 217Subquery in SELECT
  10. 218Subquery in FROM
  11. 219Subquery in WHERE
  12. 220Subquery vs Join
Subqueries - Chapter Test
18Chapter 18: Set Operations7 lessons
  1. 221UNION
  2. 222UNION ALL
  3. 223INTERSECT
  4. 224EXCEPT
  5. 225Set Compatibility
  6. 226Duplicate Handling
  7. 227Set Operation Performance
Set Operations - Chapter Test
19Chapter 19: Views8 lessons
  1. 228Simple Views
  2. 229Complex Views
  3. 230CREATE VIEW
  4. 231View Security
  5. 232Updatable Views
  6. 233Materialized Views
  7. 234View Maintenance
  8. 235View Limitations
Views - Chapter Test
20Chapter 20: Indexes and Access Paths15 lessons
  1. 236Why Indexes Exist
  2. 237B Tree
  3. 238B Plus Tree
  4. 239Hash Index
  5. 240Clustered Index
  6. 241Non Clustered Index
  7. 242Composite Index
  8. 243Covering Index
  9. 244Unique Index
  10. 245Partial Index Concept
  11. 246Function Based Index Concept
  12. 247Selectivity
  13. 248Cardinality
  14. 249Index Maintenance
  15. 250When Not to Index
Indexes and Access Paths - Chapter Test
21Chapter 21: Normalization and Functional Dependencies18 lessons
  1. 251Data Redundancy
  2. 252Insertion Anomaly
  3. 253Update Anomaly
  4. 254Deletion Anomaly
  5. 255Functional Dependency
  6. 256Full Functional Dependency
  7. 257Partial Dependency
  8. 258Transitive Dependency
  9. 259Closure of Attributes
  10. 260Candidate Key Derivation
  11. 261Minimal Cover
  12. 2621NF
  13. 2632NF
  14. 2643NF
  15. 265BCNF
  16. 2664NF
  17. 2675NF
  18. 268Denormalization
Normalization and Functional Dependencies - Chapter Test
22Chapter 22: Transactions13 lessons
  1. 269Transaction Concept
  2. 270Transaction Boundaries
  3. 271Transaction States
  4. 272ACID
  5. 273Atomicity
  6. 274Consistency
  7. 275Isolation
  8. 276Durability
  9. 277COMMIT
  10. 278ROLLBACK
  11. 279SAVEPOINT
  12. 280Autocommit
  13. 281Nested Transaction Concepts
Transactions - Chapter Test
23Chapter 23: Concurrency Control13 lessons
  1. 282Concurrent Execution
  2. 283Serial Schedule
  3. 284Non Serial Schedule
  4. 285Conflict Serializability
  5. 286View Serializability
  6. 287Precedence Graph
  7. 288Recoverable Schedule
  8. 289Cascadeless Schedule
  9. 290Strict Schedule
  10. 291Lost Update
  11. 292Dirty Read
  12. 293Non Repeatable Read
  13. 294Phantom Read
Concurrency Control - Chapter Test
24Chapter 24: Locking Protocols0 lessons

No lessons published yet.

25Chapter 25: Isolation Levels0 lessons

No lessons published yet.

26Chapter 26: Recovery and Logging0 lessons

No lessons published yet.

27Chapter 27: Database Security0 lessons

No lessons published yet.

28Chapter 28: Stored Procedures0 lessons

No lessons published yet.

29Chapter 29: Stored Functions0 lessons

No lessons published yet.

30Chapter 30: Triggers0 lessons

No lessons published yet.

31Chapter 31: Cursors0 lessons

No lessons published yet.

32Chapter 32: Advanced SQL: CTE0 lessons

No lessons published yet.

33Chapter 33: Advanced SQL: Window Functions0 lessons

No lessons published yet.

34Chapter 34: Advanced SQL Patterns0 lessons

No lessons published yet.

35Chapter 35: Query Processing and Optimization0 lessons

No lessons published yet.

36Chapter 36: Physical Storage0 lessons

No lessons published yet.

37Chapter 37: Advanced Index Structures0 lessons

No lessons published yet.

38Chapter 38: Distributed Databases0 lessons

No lessons published yet.

39Chapter 39: NoSQL Databases0 lessons

No lessons published yet.

40Chapter 40: Database Scaling0 lessons

No lessons published yet.

41Chapter 41: Data Warehousing0 lessons

No lessons published yet.

42Chapter 42: Database Design Projects0 lessons

No lessons published yet.

43Chapter 43: Interview and Placement Preparation0 lessons

No lessons published yet.