Скачать или смотреть L1.4 Database Languages | DDL, DML, DCL, TCL Commands | DBMS | Shanu Kuttan

#DatabaseLanguages #DBMSLanguages #DDL #DML #DCL #TCL

This video explains Database Languages in DBMS, or DBMS Languages, different types of database Languages:

00:00 Database Languages in DBMS
03:08 Data Definition Language (DDL)
06:34 DDL Commands in SQL
08:30 Data Manipulation Language (DML):
09:26 Two types of DML: 1. Procedural DMLs/Highlevel DMLs, 2. Declarative DMLs/ Non-Procedural DMLs/Low-level DMLs
11:25 DML Commands
12:45 Data Control Language (DCL)
14:55 Transaction Control Language (TCL)

Along with types of Database Languages this video explains SQL commands(Structured Query Language Commands) in DDL, DML, DCL, TCL with examples:

DDL commands: create, alter, drop, truncate, rename;
DML commands: select, insert, update, delete;
DCL commands: grant & revoke;
TCL commands: commit, rollback, savepoint.

This is a lecture 4 for Database Management System (DBMS) unit 1 according to CSVTU bhilai.

For more videos on DBMS follow the given link:

DBMS Playlist:    • DBMS Playlist  

ER Model Playlist:    • ER Model in hindi  

Relational Model Playlist:    • Relational Model & Relational Algebra  

SQL Playlist:    • SQL  

Lecture 1: Database Management System (DBMS) Introduction    • L1.1 Database Management System |DBMS Intr...  
Lecture 2: View of Data in DBMS | Three Levels of Abstraction | Schema & Instance | Data Independence    • L1.2 View of Data|Data Abstraction|Schema ...  
Lecture 3: Data Models | Relational Model | ER Model |Object Based Model | Semi-Structured Model    • L1.3 Data Models | Relational, ER, Object-...  
Lecture 4: Database Languages | DDL, DML, DCL, TCL    • L1.4 Database Languages | DDL, DML, DCL, T...  
Lecture 5: Database Access from Application Programs | SQL | APIs - ODBC & JDBC | Embedded SQL    • L1.5 Database Access from Application Prog...  
Lecture 6: Database Users and Administrators    • L1.6 Database Users and Administrators | D...  
Lecture 7: Transaction Management & Storage Management    • L1.7 Transaction Management & Storage Mana...  
Lecture 8: Database System Structure, Query Processor, Storage Manager    • L1.8 Database System Structure | DBMS Stru...  
Lecture 9: DBMS Architecture: 1-tier 2-tier 3-tier Architecture    • L1.9 DBMS Architecture | 1-tier 2-tier 3-t...  
Lecture 10: History of Database Systems    • L1.10 History of Database Systems | DBMS |...  
Lecture 11: Introduction to ER Model, Entity-Attributes-Relationships    • L2.1 Introduction to ER Model | Entity, At...  
Lecture 12: Types of Attributes in ER Model    • L2.2 Attributes Types in ER Model |Simple,...  
Lecture 13: Mapping Cardinalities & Participation Constraints    • L2.3 Mapping Cardinalities (Cardinality Ra...  
Lecture 14: Keys in DBMS - Super Key, Candidate Key, Primary Key, Foreign Key, Alternate Key, Composite Key    • L2.4 Keys in DBMS | Super Key, Candidate K...  
Lecture 15: Strong Entity & Weak Entity in DBMS    • L2.5 Strong Entity & Weak Entity in DBMS |...  
Lecture 16: Extended ER Features: Generalization, Specialization, Aggregation in DBMS    • L2.5 Strong Entity & Weak Entity in DBMS |...  
Lecture 17: Converting ER Diagrams to Tables with Examples | Rules    • L2.7 Converting ER Diagrams to Tables | 6 ...  
Lecture 18: Questions on Conversion of ER Diagrams to Tables | Part 1 -    • L2.8 Questions on ER Diagrams Conversion t...  
Lecture 19: Questions on Conversion of ER Diagrams to Tables | Part 2 -   • L2.9 Questions on ER Diagrams Conversion t...  
Lecture 20: How to draw ER diagram| ER Diagram for Banking System | ER Notations    • L2.10 How to draw ER Diagram? | Banking Sy...  
Lecture 21: Relational Model in DBMS | RDBMS    • L3.1 Relational Model in DBMS | RDBMS | Re...  
Lecture 22: Relational Model Mathematical Structure in DBMS    • L3.2 Relational Model Mathematical Structu...  
Lecture 23: Integrity Constraints    • L3.3 Integrity Constraints | Domain, Entit...  

Welcome to this youtube channel "Shanu Kuttan CSE Classes " by Shanu Kuttan. This is a technical educational channel for subjects of computer science and engineering subjects (CSE) as per university syllabus and also cover GATE topics. It provides Computer Science and engineering classes in Hindi. This channel’s video helps Computer Science and Engineering students to understand different subjects like Computer System Architecture (CSA) i.e. Computer Organization and Architecture (COA) or simply Computer Architecture, Database Management System (DBMS), Parallel Processing and Computing (PPC) unit wise as per the CSVTU syllabus i.e. Chhattisgarh Swami Vivekanand Technical University, Bhilai

For other Topics follow the given link of this channel:
Contact Link in Facebook :
  / shanukuttan.cseclasses