Database Languages | DDL, DML, DCL, TCL | DBMS Lecture 4 | Shanu Kuttan | in Hindi
HTML-код
- Опубликовано: 22 июл 2020
- #DatabaseLanguages #DBMSLanguages #DDL #DML #DCL #TCL
This video explains Database Languages in DBMS, or DBMS Languages, different types of datatabase Languages:
• Data Definition Language (DDL)
• Data Manipulation Language (DML): Its types 1.Procedural DMLs/Highlevel DMLs, 2. Declarative DMLs/ Non-Procedural DMLs/Low-level DMLs
• Data Control Language (DCL)
• 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 & Rel...
SQL Playlist: • SQL
Lecture 1: Database Management System (DBMS) Introduction • Database Management Sy...
Lecture 2: View of Data in DBMS | Three Levels of Abstraction | Schema & Instance | Data Independence • View of Data in DBMS |...
Lecture 3: Data Models | Relational Model | ER Model |Object Based Model | Semi-Structured Model • Data Models | Relation...
Lecture 4: Database Languages | DDL, DML, DCL, TCL • Database Languages | D...
Lecture 5: Database Access from Application Programs | SQL | APIs - ODBC & JDBC | Embedded SQL • Database Access from A...
Lecture 6: Database Users and Administrators • Database Users and Adm...
Lecture 7: Transaction Management & Storage Management • Transaction Management...
Lecture 8: Database System Structure, Query Processor, Storage Manager • Database System Struct...
Lecture 9: DBMS Architecture: 1-tier 2-tier 3-tier Architecture • DBMS Architecture | 1-...
Lecture 10: History of Database Systems • History of Database Sy...
Lecture 11: Introduction to ER Model, Entity-Attributes-Relationships • Introduction to ER Mod...
Lecture 12: Types of Attributes in ER Model • Types of Attributes in...
Lecture 13: Mapping Cardinalities & Participation Constraints • Mapping Cardinalities ...
Lecture 14: Keys in DBMS - Super Key, Candidate Key, Primary Key, Foreign Key, Alternate Key, Composite Key • Keys in DBMS | Super K...
Lecture 15: Strong Entity & Weak Entity in DBMS • Strong Entity & Weak E...
Lecture 16: Extended ER Features: Generalization, Specialization, Aggregation in DBMS • Strong Entity & Weak E...
Lecture 17: Converting ER Diagrams to Tables with Examples | Rules • Converting ER Diagrams...
Lecture 18: Questions on Conversion of ER Diagrams to Tables | Part 1 - • Questions on Conversio...
Lecture 19: Questions on Conversion of ER Diagrams to Tables | Part 2 - • Questions on Conversio...
Lecture 20: How to draw ER diagram| ER Diagram for Banking System | ER Notations • How to draw ER Diagram...
Lecture 21: Relational Model in DBMS | RDBMS • Relational Model in DB...
Lecture 22: Relational Model Mathematical Structure in DBMS • Relational Model Mathe...
Lecture 23: Integrity Constraints • Integrity Constraints ...
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
Mam you have an absolutely fantastic way of teaching 😊😊 simple concise to the point....before coming to your channel I was not able to solve even a single question based on ER model but after completely watching the playlist I am able to solve all the assignment questions based on ER model by my self. Thankyou so so much mam for such precious content delivery...highly grateful for your efforts.🙏🙏🙏
Thank you mam aap hamare liye video bnate ho apna special tym dete ho thank you so much mam....😊
Also
Yhi to Inka kaam hai
Puure youtube pr, meri university(Pune) se milta-julta syllabus aapka hi he. Thanku Mam
Amezing video mam. For a full exaplanation
mam ur way of explaining is superb.....................
Helping me a lot 😅 one day before exam mam
Very helpful video tq mam 🙏🙏🙏💫💫👏👏
Great and wonderful lecture !!!! Lots of Love from Bahawalpur, Pakistan 🙏🙏🙏
Thank you so much mam for this .
Great explanation with notes ...ty ma'am ⭐
great video......thankful for your efforts....
I am your new subscriber thank you ma'am 🥰
Whole dbms ke note description me dijiye mam❤
Amazing 😍
Amazing ❤
Thank you mam 👍
Thank you Ma'am beautiful explanation
Thank you so much ma'am for enhancing our knowledge love from Pakistan.
Thanku mam
Great mam❤
Thank you
Thanks mam
Nice class
Thanks for this video 💫
Great video 👌
Thanks a lot ma'am ☺️
thank you ma'am....😇😇😇
Thank you so much mam 🙏
Good method very helpful 👍
Thanku so much mem ☺️☺️
Thank you ma'am..
Very helpful mam.
Thanks 👍
Thank you Mam
i love ur voice
Thank u so much mam
Thank you so much maim
Thanks a lots mam
Please ma'am 🙏 inform us from where we can get your pdf or ppt ?
Thank you, for all your efforts mam .....Thank you so much mam.... ☺☺
Also
Best
Hi mam ma apaka Naya students
😮
Thank you maim
good voice
Ma'am Can you please provide me a full notes of DBMS?
tnx mam
Thank you mam for this video
Thanks all
❤❤❤❤❤
Mam please make a video about Normalisation
Mam where can I get the PDF of your lectures
thank you for the video mam
Thanks all
Awesome teaching ma'am but please can you share ppts 🙏
Thank you so much mam
Most welcome 😊
Lot of respect and Thank you from pakistan
My pleasure
Mam please upload videos on computer networks and theory of computation pleaseeee
Your voice so nice
Ur voice is great mam
There is another type that is DCL which is Data Communication Language.
Bpsc computer science tet ka batch start kijye mam
12:49 dcl
Mam please make an urgent video on Business rule in DBMS. Kindly, exam is near...
🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻
Why delete is dml snd truncate is ddl!?
Ooo
Hello sister
Cañ u help me in database.....plz
Mam dCL nHI pura chapter
Jai shree ram
Thank you mam
Thanks u mam
Thank you mam
Thanks mam