Understanding Databases using SQL – Basic, SQL with Entity Relationship Model and constraints.
Course Description
Overview of Database Management Systems –
Overview of DBMS, Advantages of DBMS, Introduction to RDBMS, overall system architecture
Database Management System Models –
Relational model, Normalization, ER model, Mapping Cardinalities.
Structured Query Language –
DQL, DDL, DML, DCL, and TCL
Introduction to SQL, SQL Datatypes, Components of SQL, Range Operators(In, Between, Like, NULL Predicate), Clauses(into, where), Constraints, implementation of constraints in SQL
Free