Video Lectures

32x32

Chapter 1 : Introduction to DBMS
Topic : Introduction to DBMS
Content : Database, DBMS ?? Definition, Overview of DBMS 46 MB ,24:52 MIN , THEORY


32x32

Chapter 1 : Introduction to DBMS
Topic : Purpose of Database
Content : Purpose of Database 43 MB ,24:33 MIN , THEORY


32x32

Chapter 1 : Introduction to DBMS
Topic : Levels of abstraction
Content : Levels of abstraction, Data Independence 29 MB ,15:25 MIN , THEORY


32x32

Chapter 2 : Data Models
Topic : Data Models-Introduction
Content : Data Models-Introduction 23 MB ,13:7 MIN , THEORY


32x32

Chapter 2 : Data Models
Topic : Relational Data Model
Content : Relational Data Model 21 MB ,11:12 MIN , THEORY


32x32

Chapter 2 : Data Models
Topic : Hierarchical & Network Data Model
Content : Hierarchical & Network Data Model 15 MB ,8:38 MIN , THEORY


32x32

Chapter 3 : Entity Relationship Model
Topic : ER Model
Content : Entities, attributes, entity sets, relations, relationship sets, ER Model 51 MB ,28:46 MIN , THEORY


32x32

Chapter 3 : Entity Relationship Model
Topic : Entity Relationship - Design Issues
Content : Entity Relationship - Design Issues 21 MB ,11:59 MIN , THEORY


32x32

Chapter 3 : Entity Relationship Model
Topic : Weak Entity Sets
Content : Weak Entity Sets 15 MB ,8:34 MIN , THEORY


32x32

Chapter 5 : DDL Statements
Topic : DDL Statements
Content : DDL Statements - CREATE, ALTER, DROP, RENAME, TRUNCATE 14 MB ,8:5 MIN , THEORY + PRACTICAL


32x32

Chapter 5 : DDL Statements
Topic : Create Table
Content : Create Table, Drop Table 33 MB ,19:34 MIN , THEORY + PRACTICAL


32x32

Chapter 5 : DDL Statements
Topic : Alter Table
Content : Alter Table 29 MB ,16:14 MIN , THEORY + PRACTICAL


32x32

Chapter 6 : DML Statements
Topic : Aggregate Functions
Content : Aggregate Functions (count, min, max, avg, sum), group by clause, having clause 42 MB ,23:40 MIN , THEORY + PRACTICAL


32x32

Chapter 6 : DML Statements
Topic : DML Statements
Content : insert, update, delete 16 MB ,8:28 MIN , THEORY + PRACTICAL


32x32

Chapter 6 : DML Statements
Topic : SELECT Statement
Content : Viewing the structure of a table, Select all columns, specific columns, unique records, conditional select, in clause, between clause 57 MB ,29:7 MIN , THEORY + PRACTICAL


32x32

Chapter 1 : Relational data model
Topic : Relational data model
Content : Domains, attributes, Tuples and Relations, Relational Model Notation 22 MB ,12:17 MIN , THEORY


32x32

Chapter 1 : Relational data model
Topic : Keys
Content : Keys 28 MB ,17:7 MIN , THEORY


32x32

Chapter 1 : Relational data model
Topic : Constraints
Content : Relational Constraints - primary key, referential integrity, unique constraint, Null constraint, Check constraint 94 MB ,53:7 MIN , THEORY + PRACTICAL


32x32

Chapter 1 : Relational data model
Topic : Referential integrity - Constraints
Content : Referential integrity - Constraints Primary Key, Foreign Key, Unique key 66 MB ,37:19 MIN , THEORY + PRACTICAL


32x32

Chapter 4 : Joining Tables
Topic : Joining Tables
Content : inner join, outer join (left outer, right outer, full outer) 20 MB ,11:49 MIN , THEORY + PRACTICAL


32x32

Chapter 5 : S
Topic : Subqueries
Content : Subqueries 17 MB ,10:49 MIN , THEORY + PRACTICAL


32x32

Chapter 2 : Relational Algebra
Topic : Relational Algebra Operations
Content : Relational Algebra operations (selection, projection, set operations union, intersection, difference, cross product, Joins ??conditional, equi join and natural joins, division) 100 MB ,58:26 MIN , THEORY


32x32

Chapter 3 : Functions
Topic : String Functions
Content : String Functions (concat, instr, left, right, mid, length, lcase/lower, ucase/upper, replace, strcmp, trim, ltrim, rtrim) 22 MB ,12:36 MIN , THEORY + PRACTICAL


32x32

Chapter 3 : Functions
Topic : Math Functions
Content : Math Functions (abs, ceil, floor, mod, pow, sqrt, round, truncate) MB , MIN , THEORY + PRACTICAL


32x32

Chapter 3 : Function
Topic : Date Functions
Content : Date Functions (adddate, datediff, day, month, year, hour, min, sec, now) 13 MB ,7:19 MIN , THEORY + PRACTICAL


32x32

Chapter 1 : Schema refinement and Normal forms
Topic : Schema refinement and Normal forms
Content : Functional dependencies, first, second, third, and BCNF normal forms based on primary keys, lossless join decomposition. 48 MB ,26:24 MIN , THEORY + PRACTICAL


32x32

Chapter 4 : DCL Statements (TCL Statements)
Topic : Transaction control commands
Content : Transaction control commands ?? Commit, Rollback 30 MB ,16:57 MIN , THEORY + PRACTICAL


32x32

Chapter 4 : DCL Statements (TCL Statements)
Topic : Transaction control commands
Content : Transaction control commands 10 MB ,4:44 MIN , PRACTICAL


32x32

Chapter 3 : Views
Topic : Views
Content : creating, altering dropping, renaming and manipulating views) 58 MB ,32:9 MIN , THEORY + PRACTICAL


32x32

Chapter 3 : Transaction Management
Topic : Lock Management - Lock Based Protocols
Content : Need of locks, Lock Granularity, Lock Based Protocols, binary locking, Shared/Exclusive locking, 2PL - Two Phase Locking 30 MB ,15:31 MIN , THEORY


The Shikshak App

The Shikshak App is an honest attempt to provide quality education.

https://play.google.com/store/apps/details?id=com.weit.theshikshak&hl=en_IN