Learn MySQL Databases
Learn to Create Databases, Tables, and Users with MySQL
0h 10m47 lectures18 sections
What you'll learn
- Understand database fundamentals
- Master advanced queries
- Learn table joins and data aggregation
- Manage databases effectively
- Handle transactions for data integrity
- Implement a practical project to apply concepts
About this course
MySQL is a database that emerged from the theory of free open-source software, available for everyone to use and develop. It is designed around three main concepts: speed, reliability, and ease of use, making it one of the most popular open-source databases globally in a short time. Companies like Google, Yahoo, Cisco, NASA, and HP are among its clients. In this course, you will learn everything about MySQL step by step, from A to Z.
Expected outcomes
- Master using MySQL to manage databases effectively.
- Ability to write advanced queries to solve programming problems.
- Understand how to handle and organize data professionally.
- Implement practical projects using MySQL databases.
- Enhance application performance through effective database management.
Course content
1Database Fundamentals
4 lectures
- Course Highlights10:50
- Introduction12:09
- Essentials (1)19:01
- Essentials (2)12:36
2Tools and Work Environment
2 lectures
- Tools and Work Environment (1)18:02
- Tools and Work Environment (2)19:35
3SELECT Statement
3 lectures
- SELECT Statement (1)19:03
- SELECT Statement (2)17:15
- SELECT Statement (3)18:33
4Tables Joins
3 lectures
- Table Joins (1)16:59
- Table Joins (2)14:50
- Table Joins (3)23:15
5Grouping Functions
3 lectures
- Data Aggregation (1)19:52
- Data Aggregation (2)11:23
- Data Aggregation (3)12:05
6Sub Queries
3 lectures
- Subqueries (1)18:22
- Subqueries (2)25:34
- Subqueries (3)25:10
7Data Modifying
3 lectures
- Data Modification (1)16:52
- Data Modification (2)12:37
- Data Modification (3)20:20
8Transactions
1 lectures
- Transactions15:35
9Working with Databases and Tables
2 lectures
- Working with Databases and Tables (1)27:28
- Working with Databases and Tables (2)21:35
10Constraints
1 lectures
- Database Constraints18:49
11Saved Queries Views
1 lectures
- Views30:51
12Stored Proc.
4 lectures
- Stored Procedures (1)9:06
- Stored Procedures (2)15:17
- Stored Programs (3)14:59
- Stored Programs (4)9:47
13Conditions
3 lectures
- Conditional Statements (1)17:39
- Conditional Statements (2)9:06
- Conditional Statements (3)9:53
14Looping
1 lectures
- Looping Statements14:14
15Triggers
4 lectures
- Database Events (1)17:47
- Database Events (2)11:23
- Database Events (3)14:18
- Database Events (4)8:10
16Functions
3 lectures
- Functions (1)13:33
- Functions (2)12:05
- Functions (3)16:21
17Integrated Project
5 lectures
- Integrated Project (1)11:57
- Integrated Project (2)20:04
- Integrated Project (3)23:10
- Integrated Project (4)16:45
- Integrated Project (5)18:40
18Add-ons
1 attachments
- Download Attachments Here
Instructor
Eng. Azab Mohamed Azab
7,309 students28 courses
This course is part of the diploma
