Course Hive
Courses
Summaries
Continue with Google
or

Database Management Systems

5.0 (1)
33 learners

What you'll learn

This course includes

  • 10.3 hours of video
  • Certificate of completion
  • Access on mobile and TV

Course content

1 modules • 57 lessons • 10.3 hours of video

Database Management Systems

57 lessons • 10.3 hours
  • Introduction to Structured Query Language (SQL)08:41
  • Data Definition Language (DDL)06:00
  • DDL Commands - CREATE13:56
  • Constraints in SQL07:24
  • Constraints in SQL (Example Queries)09:50
  • Primary Key and Foreign Key Constraints in SQL12:40
  • DDL Commands - ALTER11:15
  • DDL Commands - TRUNCATE, DROP, and RENAME06:05
  • DML Commands - INSERT and UPDATE11:25
  • DML Commands - DELETE and SELECT10:55
  • Data Control Language (DCL)10:31
  • Transaction Control Language (TCL)08:44
  • Aggregate Functions in SQL11:41
  • GROUP BY and HAVING Clause in SQL07:57
  • ORDER BY in SQL05:37
  • LIKE in SQL08:55
  • IN in SQL06:13
  • BETWEEN in SQL06:26
  • Alias (AS) in SQL10:06
  • TOP, LIMIT, FETCH FIRST, and ROWNUM in SQL07:03
  • NULL Functions in SQL15:03
  • ANY and ALL Operators in SQL11:07
  • CASE Expression in SQL09:42
  • Comments in SQL11:36
  • Joins in SQL24:08
  • SQL - Solved Problem 108:55
  • SQL - Solved Problem 207:29
  • SQL - Solved Problem 306:22
  • SQL (Rapid Fire Quiz)22:25
  • MySQL Practicals | Chapter 5 | Database Management Systems (DBMS)01:39
  • Introduction to Database Management Systems11:03
  • DBMS Characteristics12:46
  • Database Users10:51
  • Advantages & Disadvantages of DBMS15:50
  • History of Database Applications08:21
  • Fundamentals of Database Systems06:25
  • Three-Schema Architecture & Data Independence06:49
  • DBMS Languages, Interfaces, and Classification12:23
  • Database System Environment07:28
  • DBMS Architecture08:01
  • Basic Concepts of Entity-Relationship Model08:49
  • Database Design Process11:20
  • Concept of Relationships in ER Diagram15:06
  • Exercises based on ER Model Concepts (Part 1)14:41
  • Exercises based on ER Model Concepts (Part 2)11:54
  • Introduction to Relational Data Model06:53
  • Characteristics of Relations07:40
  • Relational Model Constraints12:49
  • Update Operations/Dealing with Constraint Violations09:56
  • Exercises based on Relational Model (Part 1)12:29
  • Exercises based on Relational Model (Part 2)08:31
  • Relational Algebra Operations - Unary15:25
  • Relational Algebra Operations - Set Theory11:49
  • Relational Algebra Operations - Binary19:04
  • Additional Relational Algebra Operations21:58
  • Relational Algebra Queries (Part 1)21:39
  • Relational Algebra Queries (Part 2)11:36

You may also be interested in

FAQs

Suggest a Youtube Course

Our catalog is built based on the recommendations and interests of students like you.

Course Hive
Download now and unlock unlimited audiobooks — 100% free
Explore Now