Programming
Aptitude
Syllabus
Interview Preparation
Interview Exp.
Off Campus
0
Notifications Mark All Read
- Login
- Get Prime
0
DBMS Online Course
What is this course about ?
DBMS is very important subject of computer science courses and is well asked in various placement exams both in the online tests as MCQ’s and also in Interviews for various companies. Most Data Science companies have DBMS as requirement for you to learn. Structured Database Management Systems (DBMS) based on relational and other models have long formed the basis for such databases. … More specifically, the course introduces relational data models; entity-relationship modeling, SQL, data normalization, and database design.
Introduction
What we will learn?
What is a database?
More into DBMS
What is DBMS and its characterstics?
Types of Data Bases
Evolution of Databases
DBMS vs RDBMS
DBMS vs File System
Architecture and Models
Types of Database Architecture
Database Schema
ER Models Advanced
ER Diagram Part 1
ER Diagram Part 2
ER Diagram Part 3
ER Diagram Part 4
Generalisation, Specialisation and Aggregation
Relational Database Model
Codd Rule
Keys in DBMS
Candidate Key
Super Key
Primary Key
Alternate Key
Composite Key
Foreign Key
Primary Key vs Candidate Key
Unique Key
Normalisation and Functional Dependencies Part 1
Normalization Introduction
1NF Normalization
2NF Normalization
2NF Question 1
2NF Question 2
2NF Question 3
2NF Question 4
2NF Question 5
2NF Question 6
2NF Question 7
2NF Question 8
2NF Question 9
2NF Question 10
Normalisation and Functional Dependencies Part 2
3NF Normalization
3NF Question 1
BCNF Normalization and Problems
Normalization Problem 1
Normalization Problem 2
Normalization Problem 3
Normalization Problem 4
Normalization Problem 5
Normalization Problem 6
SQL Part 1
SQL Intro
DDL,DML,TCL AND DCL
Create DB, Create Table, Insert
Alter Table
Delete vs Drop vs Truncate
Constraints Introduction
NOT NULL Constraint
Primary Key Constraint
Unique constraints
Foreign Key
Check Constraints
Default and auto increment constraints
SQL Part 2
Select and Distincts Statement
Order by Merge
Update and Delete
Limit – Min & Max
Nth Highest or Lowest Salary
Count, Avg and Sum
Like and wild card
SQL Part 3
Alias
JOINS Introduction
INNER JOIN Video 1
INNER JOIN Video 2
INNER JOIN Video 3
Left Outer Join
Right Join
Full Join
Self Join
SQL Part 4
Group By
Having
Additional topics and InfyTQ
MySQL Intro
SQL Intro
Introduction to Databases
Why SQL
Execution of SQL
Install MySQL
MySQL Basics
Load Databases
Use, Show & Describe
Select
Limit and Offset
Order By
Distinct Part 1
Distinct Part 2
MySQL Advanced Queries
Where, Comparison Operators, NULL
Logical Operators
Aggregate Function
Window Function: Row Number
Window Function: Rank and Denserank
Group By & Having Clause
Order of Keywords
MySQL More Advanced queries
Joins and Inner Join
Natural Join
Left Outer Join
Right Outer Join
Full Outer Join
Subqueries
MySQL Creating and Modifying Databases
DML Insert
DML Update
DML Delete
DDL: Data Types
DDL: Constraints
DDL: Create
DDL Alter
DDL Drop and Truncate
Comparison: Delete, Drop and Truncate
DCL Grant and Revoke
SQLite
Introduction to SQLite
Install SQLite
Working with SQLite
Basic SQL clauses
SQLite Functions
CRUD Operartions
Python MySQL Connector part 1
Python MySQL Connector part 2
Python MySQL Connector part 3
Python MySQL Connector part 4
IMDB Questions with SQLite3
Get over 200+ course One Subscription
Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others