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.
What Will You Learn?
- ✔ 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
Course Overview
-
Overview
15:41
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
-
Lesson 24 MySQL Normalization
39:29
PART 2: SQL Server Database
SQL Server Fundamentals
-
Lesson 1 Introduction to SQL Server
18:20 -
Lesson 2 Download SQL Server Tools
02:54 -
Lesson 3 Installation
09:31 -
Lesson 4 Overview Interface
07:04
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