Java Script needs to be enabled for Video to Load.

Data Definitions, Schemas and Views

Loading Video Lesson

If you dont see the Video even after 10 seconds,
then please download and Install the Flash Player

In this 39 mins Lesson you will Learn about following concepts.
Data Definitions, Schemas and Views

Table Creation, Domain Creation, Deleting a table - Drop Table, Modifying a Table - Alter Table, Views, and related Topics.

Related Video Lessons in this Series

SQL - Basic Concepts and Queries

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.

Data Definitions, Schemas and Views

39 mins Video Lesson

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

41 mins Video Lesson

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

33 mins Video Lesson

Joins , Aggregate Functions, Grouping, Having Clause, Insert, Delete, and other topics.

Assertions, Triggers, Roles and Embedded SQL

43 mins Video Lesson

Assertions, Triggers, Privileges, Roles, Embedded SQL, and other topics.

Dynamic SQL and Stored Procedures

28 mins Video Lesson

Cursors, Dynamic SQL, Stored Procedures, and other topics.

Concurrency and Concept of Schedules

40 mins Video Lesson

Introduction, Concurrency, Advantages of Concurrency, Schedule, Serial Schedule, Equivalence of Schedules, Conflicting Set of Operations, Conflict Serializability, Serializability, and other topics.

Serializability, View Equivalence and Recoverability

49 mins Video Lesson

Need For Serializability, Example: Confilct serializability, Conflict Equivalence, Test For Conflict Serializability, View Equivalence, View Serializability, Recoverability, Recoverable Schedule, Cascadeless Schedule, and other topics.

Member's Zone