Mastering Database Management
0 of 79 lessons complete (0%)
Exit Course
Introduction to Databases
Overview of DBMS
Understanding the Importance of Data
Types of databases (relational, NoSQL, etc.)
Definition of DBMS
Characteristics of DBMS
ACID Properties
DBMS Architecture
7 lessons
Relational Models
Understanding Entity-Relationship Diagrams (ERD)
Data Models
Entity-Relationship Model
Types of Attributes
Entity Set and Keys
Relationships & Mapping Cardinalities
Quiz 1 – Relationship Sets
Generalization and Specialization
Relational Data Model
Relational Integrity Constraints
Quiz 2 – Key Constraints
Relational Algebra
Relational Calculus
13 lessons, 2 quizzes
Setting Up the Environment
Installation of necessary software (MySQL Database)
Creating the first database and tables
2 lessons
Basic SQL Commands with CRUD Operations
Introduction to SQL and its variations
SQL Statement Lanugauge
SELECT, INSERT, UPDATE, DELETE
Filtering and Sorting Data
Joins
Subqueries
6 lessons
Lab Assignment/Tutorial
Lab Tutorial 1
Lab Tutorial 2
Assignment 1
Lab Tutorial 3
Lab Tutorial 4 : ORDER BY & AGGREGATE Functions
Lab Tutorial 5: Scaler Functions
Lab Tutorial 6: IN & BETWEEN
Lab Tutorial 7: Joins
Lab Tutorial 8: SQL Operators
9 lessons, 1 quiz
Data Modeling
Dependencies in Database Normalization
Quiz: Dependencies
Normalization and denormalization
First Normal Form
Second Normal Form
Third Normal Form
Fourth Normal Form
Boyce-Codd Normal Form
Quiz: Normalization
9 lessons, 1 quiz
How to think of a Solution…
Translating ERD to Database Schema
1 lesson
Project: MySql with PHP
MySql with PHP
1 lesson
Advanced SQL Concepts
Indexing and optimization
Stored procedures and triggers
Transactions and ACID properties
3 lessons
Project: MySQL with Python using Flask
MySQL with Python and Flask
1 lesson
Project: Inventory Managment
Think of an Inventory Management
Define Entities and Relations among them
Designing the database schema for the project
Implementing CRUD operations for the project
Entire Project with PYTHON CODE
Answers of the questions
6 lessons
Transaction Processing Concept
What is Transaction?
Serializability
Equivalence Schedules
States of Transaction
Recovery and Atomicity
Deadlock
6 lessons
Concurrency Control Techniques
Concurrency Control
Lock Based Protocol
Timestamp based Protocol
Recovery with Concurrent Transaction
Transaction Processing in Distributed Systems
5 lessons
Data Backup and Recovery
Strategies for data backup
Point-in-time recovery
Data Replication and Allocation
3 lessons
Security and Permissions
Database user roles and permissions
Securing against SQL injection and other attacks
2 lessons
Data Migration
Importing and exporting data
Database versioning and migration tools
2 lessons
Final Project
Building a comprehensive database-backed project
Presenting and documenting the project
2 lessons
Downloads
PPT
1 lesson
Relational Models
Quiz 2 – Key Constraints
You don’t have access to this lesson
Please register or sign in to access the course content.
Take course
Sign in
Take Quiz
Previous
Next
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.
Ok