Professional Database Full Course (MySQL & SQL Server)

About Course

This comprehensive course covers everything you need to master database management using MySQL and SQL Server. Whether you’re a beginner or an experienced developer, this course will take you from fundamental concepts to advanced database operations, helping you build efficient and scalable databases. You’ll learn SQL queries, data manipulation, database design, indexing, stored procedures, triggers, and performance optimization. By the end of this course, you’ll be able to design, manage, and optimize databases for real-world applications.

✔ Understanding Relational Databases & SQL Basics
✔ Database Installation & Configuration (MySQL & SQL Server)
✔ Writing SQL Queries (SELECT, INSERT, UPDATE, DELETE)
✔ Data Filtering, Sorting, and Joins
✔ Database Normalization & Design Best Practices
✔ Creating and Managing Tables, Views, and Indexes
✔ Stored Procedures, Functions, and Triggers
✔ User Access Control and Security Measures
✔ Database Backup, Restore, and Performance Optimization

Course Content

MySQL Fundamentals

Lesson 1 MySQL Introduction, Downloading and Installing MSQL

19:33
Lesson 2 MySQL Create Database and table

21:30

MySQL SQL Basics

Lesson 3 MySQL Constraints, Data Type

20:25
Lesson 4 MySQL Inserting Data

22:23
Lesson 5 MySQL Updating Data

04:44
Lesson 6 MySQL Deleting Data

03:36
Lesson 7 MySQL Drop ,Delete, Truncate

08:10
Lesson 8 MySQL Select Statement

13:44
Lesson 9 MySQL View Statement

04:43
Lesson 10 MySQL Filtering Rows with WHERE

15:38
Lesson 11 MySQL Aggregate Functions

26:04
Lesson 12 MySQL Alter Statement

16:30
Lesson 13 MySQL Joins

18:03
Lesson 14 MySQL Subqueries

13:51
Lesson 15 MySQL Common Methods

30:15
Lesson 16 MySQL Store Procedure

07:32
Lesson 17 MySQL Store Procedure with Insert, Update, Delete

30:11
Lesson 18 MySQL Function

07:26
Lesson 19 MySQL Student Balance

48:06
Lesson 20 MySQL Student Statement

34:24
Lesson 21 MySQL Trigger Insert

10:00
Lesson 22 MySQL Trigger Update and Delete

12:25
Lesson 23 MySQL Backup

04:48

MySQL Database Design

PART 2: SQL Server Database

SQL Server Fundamentals

SQL Server SQL Basics

Lesson 5 Basic SQL Commands

04:49
Lesson 6 Create Database and Table

13:27
Lesson 7 SQL Constraints

16:23
Lesson 8 Insert Data

08:54
Lesson 9 Update Data

13:04
Lesson 10 Delete Data

03:58
Lesson 11 Drop, Truncate & Delete

10:52
Lesson 12 Select Statement

15:56
Lesson 13 View

04:54
Lesson 14 Aggregate Functions

17:44
Lesson 15 Alter Statement

20:13
Lesson 16 JOIN Operations INNER, LEFT, RIGHT, FULL

21:14
Lesson 17 Subquery

24:48
Lesson 18 Import Excel Data and Manage

22:16
Lesson 19 stored procedures Basic

16:46
Lesson 20 Stored procedure (Insert, Update, Delete & Retrieve Data)

43:54
Lesson 21 SQL Function

10:34
Lesson 22 SQL Triggers

39:42
Lesson 23 Backup and Restore Database

06:54

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

MySQL Fundamentals

Lesson 1 MySQL Introduction, Downloading and Installing MSQL

Lesson 2 MySQL Create Database and table

MySQL SQL Basics

Lesson 3 MySQL Constraints, Data Type

Lesson 4 MySQL Inserting Data

Lesson 5 MySQL Updating Data

Lesson 6 MySQL Deleting Data

Lesson 7 MySQL Drop ,Delete, Truncate

Lesson 8 MySQL Select Statement

Lesson 9 MySQL View Statement

Lesson 10 MySQL Filtering Rows with WHERE

Lesson 11 MySQL Aggregate Functions

Lesson 12 MySQL Alter Statement

Lesson 13 MySQL Joins

Lesson 14 MySQL Subqueries

Lesson 15 MySQL Common Methods

Lesson 16 MySQL Store Procedure

Lesson 17 MySQL Store Procedure with Insert, Update, Delete

Lesson 18 MySQL Function

Lesson 19 MySQL Student Balance

Lesson 20 MySQL Student Statement

Lesson 21 MySQL Trigger Insert

Lesson 22 MySQL Trigger Update and Delete

Lesson 23 MySQL Backup

MySQL Database Design

Lesson 24 MySQL Normalization

PART 2: SQL Server Database

SQL Server Fundamentals

Lesson 1 Introduction to SQL Server

Lesson 2 Download SQL Server Tools

Lesson 3 Installation

Lesson 4 Overview Interface

SQL Server SQL Basics

Lesson 5 Basic SQL Commands

Lesson 6 Create Database and Table

Lesson 7 SQL Constraints

Lesson 8 Insert Data

Lesson 9 Update Data

Lesson 10 Delete Data

Lesson 11 Drop, Truncate & Delete

Lesson 12 Select Statement

Lesson 13 View

Lesson 14 Aggregate Functions

Lesson 15 Alter Statement

Lesson 16 JOIN Operations INNER, LEFT, RIGHT, FULL

Lesson 17 Subquery

Lesson 18 Import Excel Data and Manage

Lesson 19 stored procedures Basic

Lesson 20 Stored procedure (Insert, Update, Delete & Retrieve Data)

Lesson 21 SQL Function

Lesson 22 SQL Triggers

Lesson 23 Backup and Restore Database

Student Ratings & Reviews

Join Our Community