SQL
Video Lessons & Revision Notes
SQL - Basic Concepts and Queries
1. SQL - Basic Concepts and Queries
In this 56 mins Video Lesson
Introduction, Data Types, Schema And Catalog, Select-From-Where, Cross Product, Aliasing / Rename, Star Symbol (*), SQL results as MultiSet, Set Operations, Generalized Projection - Use of Math. Ops, Order By, String Comparison - Like, and other topics.
Introduction, Data Types, Schema And Catalog, Select-From-Where, Cross Product, Aliasing / Rename, Star Symbol (*), SQL results as MultiSet, Set Operations, Generalized Projection - Use of Math. Ops, Order By, String Comparison - Like, and other topics.
Data Definitions, Schemas and Views
2. Data Definitions, Schemas and Views
In this 39 mins Video Lesson
Table Creation, Domain Creation, Deleting a table - Drop Table, Modifying a Table - Alter Table, Views, and other topics.
Table Creation, Domain Creation, Deleting a table - Drop Table, Modifying a Table - Alter Table, Views, and other topics.
NULL Comparisons, Nested and Co-related Queries
3. NULL Comparisons, Nested and Co-related Queries
In this 41 mins Video Lesson
Introduction, NULL Comparison, Nested Queries - In/ Some/ Any/ All, Co-Related Query - Exist/ Not Exist, and other topics.
Introduction, NULL Comparison, Nested Queries - In/ Some/ Any/ All, Co-Related Query - Exist/ Not Exist, and other topics.
Joins, Aggregate Functions, Group By, Having clause and DB Modifications
4. Joins, Aggregate Functions, Group By, Having clause and DB Modifications
In this 33 mins Video Lesson
Joins , Aggregate Functions, Grouping, Having Clause, Insert, Delete, and other topics.
Joins , Aggregate Functions, Grouping, Having Clause, Insert, Delete, and other topics.
Assertions, Triggers, Roles and Embedded SQL
5. Assertions, Triggers, Roles and Embedded SQL
In this 43 mins Video Lesson
Assertions, Triggers, Privileges, Roles, Embedded SQL, and other topics.
Assertions, Triggers, Privileges, Roles, Embedded SQL, and other topics.
Dynamic SQL and Stored Procedures
6. Dynamic SQL and Stored Procedures
In this 28 mins Video Lesson
Cursors, Dynamic SQL, Stored Procedures, and other topics.
Cursors, Dynamic SQL, Stored Procedures, and other topics.
Revision Notes
Advanced SQL
(2.28 Mb)
SQL
(1.98 Mb)
Characteristics and advantages, SQL Data Types and Literals, DDL, DML, SQL Operators, Tables: Creating, Modifying, Deleting, Views: Creating, Dropping, Updating using Views, Indexes, Nulls
SELECT Query and clauses, Set Operations, Predicates and Joins, Set membership, Tuple Variables, Set comparison, Ordering of Tuples, Aggregate Functions, Nested Queries, Database Modification using SQL Insert, Update and Delete Queries, concept of Stored Procedures, Cursors, Triggers, assertions, roles and privileges Programmatic SQL: Embedded SQL, Dynamic SQL.