Database Management System - Complete Course

Sundeep Saradhi Kanthety via YouTube

Start learning Write review

Details

Start learning

Provider

YouTube
Pricing

Free Video
Languages

English
Duration & workload

17 hours 4 minutes
Sessions

On-Demand
Level

Intermediate

Found in

Learn comprehensive database management concepts and SQL programming through this extensive course covering fundamental DBMS principles, relational database theory, and practical SQL implementation. Master the differences between DBMS and RDBMS systems while exploring essential database terminology including schemas, instances, and various database languages (DDL, DML, DCL, TCL). Understand core database components such as entities, attributes, and relationships, then dive deep into Entity-Relationship modeling with detailed coverage of ER diagrams, notations, and symbols. Explore different types of keys including super keys, candidate keys, primary keys, and foreign keys, followed by comprehensive relational algebra operations covering unary operations, set theory operations, and various types of joins. Develop practical SQL skills starting with basic syntax, data types, and essential commands like CREATE, INSERT, ALTER, DROP, and TRUNCATE, then advance to complex queries using SELECT statements with WHERE clauses, ORDER BY, and aggregate functions. Practice with real-world examples using Sailors, Boats, and Reserves tables while learning to create and manage views from single and multiple tables. Study database design principles including anomalies, functional dependencies, Armstrong's axioms, and attribute closure techniques for finding superkeys and candidate keys. Complete your understanding with normalization theory covering all normal forms from 1NF through BCNF, ensuring optimal database design and eliminating data redundancy.

Syllabus

INTRODUCTION TO DATABASE - DATABASE MANAGEMENT SYSTEM
TYPES OF DATABASES - DATABASE MANAGEMENT SYSTEM
INTRODUCTION TO RDBMS & BASIC TERMINOLOGY OF RDBMS || RELATIONAL DATABASE MANAGEMENT SYSTEM || DBMS
DIFFERENCES BETWEEN DBMS & RDBMS || DBMS VS RDBMS || RELATIONAL DATABASE MANAGEMENT SYSTEM || DBMS
WHAT IS DATA, DATABASE, DBMS & SQL || DBMS TEREMINOLOGY
SCHEMA AND INSTANCE IN DBMS || TYPES OF SCHEMA IN DBMS || DATABASE MANAGEMENT SYSTEM
DBMS LANGUAGES (DDL, DML, DCL, TCL) IN DATABASE MANAGEMENT SYSTEM || COMMANDS || SQL COMMANDS
ENTITY, ENTITY SET, ENTITY TYPES & TYPES OF ENTITY TYPE IN DBMS || TYPES OF ENTITY TYPE WITH EXAMPLE
WHAT IS ATTRIBUTE & TYPES OF ATTRIBUTES || ATTRIBUTE TYPES IN DBMS || DATABASE MANAGEMENT SYSTEM
RELATIONSHIP AND TYPES OF RELATIONSHIPS IN DBMS || ONE TO ONE || ONE TO MANY || MANY TO MANY
INTRODUCTION TO ER-MODEL || COMPONENTS OF ER-MODEL|| ER-DIAGRAM || ENTITY RELATIONSHIP MODEL || DBMS
NOTATIONS OF ER-MODEL IN DBMS || SYMBOLS OF ER-DIAGRAM || DBMS || DATABASE MANAGEMENT SYSTEM
TYPES OF KEYS IN DBMS || SUPER KEY || CANDIDATE KEY || PRIMARY KEY || FOREIGN KEY || ALTERNATE KEY
INTRODUCTION TO RELATIONAL ALGEBRA IN DBMS || RELATIONAL MODEL || RELATIONAL ALGEBRA OPERATIONS
UNARY OPERATIONS OF RELATIONAL ALGEBRA IN DBMS || SELECTION || PROJECTION || RENAME || DBMS
SET THEORY OPERATIONS OF RELATIONAL ALGEBRA IN DBMS ||UNION || INTERSECTION ||CROSS PRODUCT || MINUS
JOINS IN DBMS || INNER JOIN || OUTER JOIN || THETA JOIN || NATURAL JOIN || LEFT OUTER || RIGHT OUTER
INTRODUCTION TO SQL (Structured Query Language) || SQL COMMANDS || DDL || DML || DCL || TCL || DBMS
DATATYPES IN SQL || SQL DATATYPES || INTEGER || NUMBER || VARCHAR || DATETIME || DBMS || SQL
CREATE COMMAND IN SQL || DDL COMMANDS || CREATE DATABASE || CREATE TABLE || MYSQL || CREATE QUERY
INSERT COMMAND IN SQL || DML COMMANDS || SQL COMMANDS || INSERT SINGLE / MULTIPLE ROW || MYSQL
CONSTRAINTS IN SQL || PRIMARY KEY || NOT NULL || DEFAULT || CHECK || UNIQUE || FOREIGN KEY || DBMS
ALTER COMMAND IN SQL || DDL COMMANDS || SQL COMMANDS || ALTER DATABASE || MYSQL || DBMS
DROP & TRUNCATE COMMANDS IN SQL || DDL COMMANDS || SQL COMMANDS || DROP || TRUNCATE || SQL || DBMS
SELECT COMMAMD IN SQL || DML COMMANDS || SQL COMMANDS || WHERE CLAUSE || ORDER BY || SQL || DBMS
UPDATE & DELETE COMMAMDS IN SQL || UPDATE || DELETE || DML COMMANDS || SQL COMMANDS || SQL || DBMS
SQL AGGREGATE FUNCTIONS || COUNT( ), SUM( ), AVG( ), MIN( ), MAX( ) || SQL COMMANDS || SQL || DBMS
GROUP BY & HAVING CLAUSE IN SELECT COMMAMD || SQL COMMANDS || GROUP BY || HAVING || SQL || DBMS
CREATION & INSERTION OF SAILORS , BOATS & RESERVES TABLES IN SQL || SQL QUERIES || FOREIGN KEY
QUERIES ON SAILORS, BOATS & RESERVES TABLE IN SQL || QUERIES IN SQL || DBMS
VIEWS IN SQL || CREATE VIEW FROM SINGLE TABLE / MULTIPLE TABLES || DROP VIEW
ANOMALIES IN DBMS || TYPES OF ANOMALIES || INSERT , DELETE , UPDATE ANOMALIES || DBMS || SQL
FUNCTIONAL DEPENDENCY IN DBMS ||FULL & PARTIAL FUNCTIONAL DEPENDENCY ||WHAT IS FUNCTIONAL DEPENDENCY
ARMSTRONG's AXIOMS IN DBMS || PROPERTIES OF FUNCTIONAL DEPENDENCY || INFERENCE RULES || DBMS
TYPES OF FUNCTIONAL DEPENDENCIES IN DBMS || TRIVIAL || NON TRIVIAL || MULTIVALUED || TRANSITIVE
ATTRIBUTE CLOSURE WITH EXAMPLE IN DBMS || CLOSURE SET OF ATTRIBUTES || HOW TO FIND CLOSURE || DBMS
HOW TO FIND SUPERKEYS AND CANDIDATE KEYS WITH EXAMPLE IN DBMS || FINDING CANDIDATE KEYS || DBMS
PRACTICE PROBLEMS ON FINDING SUPERKEYS AND CANDIDATE KEYS WITH EXAMPLE IN DBMS || DBMS
INTRODUCTION TO NORMALIZATION IN DBMS || NORMAL FORMS || 1NF, 2NF, 3NF, BCNF, 4NF & 5NF || DBMS
FIRST NORMAL FORM (1NF) IN NORMALIZATION || NORMAL FORMS || 1NF, 2NF, 3NF, BCNF, 4NF & 5NF || DBMS
SECOND NORMAL FORM (2NF) IN NORMALIZATION || NORMAL FORMS || 1NF, 2NF, 3NF, BCNF, 4NF & 5NF || DBMS
THIRD NORMAL FORM (3NF) IN NORMALIZATION || NORMAL FORMS || 1NF, 2NF, 3NF, BCNF, 4NF & 5NF || DBMS
BOYCE CODD NORMAL FORM (BCNF) IN NORMALIZATION || NORMAL FORMS || 1NF, 2NF, 3NF, BCNF, 4NF, 5NF,DBMS
SQL Full Course for Beginners (4.5 Hours) || Master Structured Query Language (2025)
Top 5 Free Websites for Practice Coding || Practice Coding || Learn Coding from Free Websites