Learn MySQL Databases

Learn to Create Databases, Tables, and Users with MySQL

4.9(60)12h 42m47 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

1

Database Fundamentals

4 lectures
  1. Course Highlights10:50
  2. Introduction12:09
  3. Essentials (1)19:01
  4. Essentials (2)12:36
2

Tools and Work Environment

2 lectures
  1. Tools and Work Environment (1)18:02
  2. Tools and Work Environment (2)19:35
3

SELECT Statement

3 lectures
  1. SELECT Statement (1)19:03
  2. SELECT Statement (2)17:15
  3. SELECT Statement (3)18:33
4

Tables Joins

3 lectures
  1. Table Joins (1)16:59
  2. Table Joins (2)14:50
  3. Table Joins (3)23:15
5

Grouping Functions

3 lectures
  1. Data Aggregation (1)19:52
  2. Data Aggregation (2)11:23
  3. Data Aggregation (3)12:05
6

Sub Queries

3 lectures
  1. Subqueries (1)18:22
  2. Subqueries (2)25:34
  3. Subqueries (3)25:10
7

Data Modifying

3 lectures
  1. Data Modification (1)16:52
  2. Data Modification (2)12:37
  3. Data Modification (3)20:20
8

Transactions

1 lectures
  1. Transactions15:35
9

Working with Databases and Tables

2 lectures
  1. Working with Databases and Tables (1)27:28
  2. Working with Databases and Tables (2)21:35
10

Constraints

1 lectures
  1. Database Constraints18:49
11

Saved Queries Views

1 lectures
  1. Views30:51
12

Stored Proc.

4 lectures
  1. Stored Procedures (1)9:06
  2. Stored Procedures (2)15:17
  3. Stored Programs (3)14:59
  4. Stored Programs (4)9:47
13

Conditions

3 lectures
  1. Conditional Statements (1)17:39
  2. Conditional Statements (2)9:06
  3. Conditional Statements (3)9:53
14

Looping

1 lectures
  1. Looping Statements14:14
15

Triggers

4 lectures
  1. Database Events (1)17:47
  2. Database Events (2)11:23
  3. Database Events (3)14:18
  4. Database Events (4)8:10
16

Functions

3 lectures
  1. Functions (1)13:33
  2. Functions (2)12:05
  3. Functions (3)16:21
17

Integrated Project

5 lectures
  1. Integrated Project (1)11:57
  2. Integrated Project (2)20:04
  3. Integrated Project (3)23:10
  4. Integrated Project (4)16:45
  5. Integrated Project (5)18:40
18

Add-ons

1 attachments
  1. Download Attachments Here

Instructor

Eng. Azab Mohamed Azab

Eng. Azab Mohamed Azab

Lecturer at the Arab Academy for Science, Technology and Maritime Transport, and the Egyptian Ministry of Interior, specializing in technology and information.
14.7K students28 courses