Database Languages and Architecture
Loading Video Lesson
In this 41 mins Lesson you will Learn about following concepts.
.jpg)
Database Languages, DDL, Data Dictionary, DML, DataBase Users, DataBase Administrator, System Architecture, Application / Multi User Architecture, and related Topics.
Related Video Lessons in this Series
Database, File based sytems and need for DBMS
39 mins Video LessonData, Database, Properties of Database, Database Management System, File Systems, Drawbacks of File Systems, and other topics.
DBMS - Concepts, Advantges and Data Models
35 mins Video LessonDBMS - Advantages, Data Abstraction, Data independence, Schema, Instance of DB, Data Models, and other topics.
Database Languages and Architecture
41 mins Video LessonDatabase Languages, DDL, Data Dictionary, DML, DataBase Users, DataBase Administrator, System Architecture, Application / Multi User Architecture, and other topics.
SQL - Basic Concepts and Queries
56 mins Video LessonIntroduction, 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 LessonTable 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 LessonIntroduction, 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 LessonJoins , Aggregate Functions, Grouping, Having Clause, Insert, Delete, and other topics.
Assertions, Triggers, Roles and Embedded SQL
43 mins Video LessonAssertions, Triggers, Privileges, Roles, Embedded SQL, and other topics.
