Learn MySQL Databases

Learn to Create Databases, Tables, and Users with MySQL

Programming Basics & Databases4.9(61)12h 42m47 lectures18 sections

What you'll learn

  • Understand the basics of databases
  • Prepare the MySQL tools and work environment
  • Write SELECT queries
  • Join tables and group data
  • Use subqueries
  • Modify data inside tables
  • Handle Transactions
  • Create tables, Constraints and Views
  • Write stored programs and functions
  • Carry out a complete project

About this course

This course teaches MySQL databases. MySQL is a free, open-source database built on speed, stability and ease of use, and it is one of the best-known databases in the world. You start with an introduction and the basics of databases and preparing the tools and work environment, then learn the SELECT Statement, joining tables, grouping data, subqueries and modifying data. After that you learn how to handle Transactions, create databases and tables, database Constraints, and saved queries called Views. Then you move on to stored programs, conditional statements, Looping statements, database events and functions, and you finish with a complete project. This course suits beginners, programmers and website developers. You need no previous experience, because the explanation goes step by step from the foundation. By the end you will be able to create a database and tables, write queries, manage data, and carry out a complete hands-on project with MySQL.

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.

Learner reviews

These reviews are from learners who bought the content and completed at least 50% of it — there are no reviews from anyone who hasn't gone through the material.
4.9
★★★★★
61 reviews
5★
59
4★
0
3★
2
2★
0
1★
0
  • ★★★★★MEDHAT Y.·منذ 4 شهرشاهد 83٪

    ممتاز ويحتاج ممارسة

  • ★★★★★Youssef a.·منذ 6 شهرشاهد 100٪

    حقيقتا كورس شامل و شرح مفصل انصح به بشدة

تم عرض كل التقييمات (2)

Course content

1

Database Fundamentals

4 lectures
  1. Course HighlightsGives a map of the MySQL course lessons in order: introduction and installation, then SELECT, joining tables and grouping data, then insert, update and transactions, then creating tables, programming and triggers, ending with a complete project.10:50
  2. IntroductionIntroduction to the MySQL database course that walks through its lessons in order: SELECT, joining tables and grouping data, then insert, update, delete and transactions, then creating tables, programming and triggers, ending with a complete project.12:09
  3. Essentials (1)Introduces database basics: one database consists of several tables, a table has columns and rows, and relationships between tables such as one-to-many between departments and employees, with a Microsoft Access example.19:01
  4. Essentials (2)Introduces database basics: why we use them, that a database consists of several organized tables, installing MySQL and setting the database administrator password, and how electronic systems depend on databases.12:36
2

Tools and Work Environment

2 lectures
  1. Tools and Work Environment (1)Explains creating a schema and a table in MySQL Workbench, setting column properties such as Not Null and the primary key, altering the table by dropping a column, and inserting data.18:02
  2. Tools and Work Environment (2)Continues the MySQL tools and work environment: dropping a database with DROP SCHEMA, getting to know the sample HR database and its employees table, adjusting the Tools and Options settings in the program, with review questions.19:35
3

SELECT Statement

3 lectures
  1. SELECT Statement (1)Introduces SQL as a standard set of commands rather than a programming language, then the SELECT statement to show all columns of a table, and sorting results with ORDER BY ascending and descending.19:03
  2. SELECT Statement (2)Explains the WHERE clause in SELECT with comparison operators such as equal, not equal, greater and less than, AND and OR, IN and NOT IN, and BETWEEN, along with sorting results using ORDER BY.17:15
  3. SELECT Statement (3)Continues conditional querying in MySQL with the LIKE operator to match text patterns, then LIMIT to fetch a set number of rows after sorting with ORDER BY, and DISTINCT to remove repeated values.18:33
4

Tables Joins

3 lectures
  1. Table Joins (1)Explains joining tables to fetch data from more than one table, such as showing the department name instead of its number, using aliases and an equality condition, known as Inner Join.16:59
  2. Table Joins (2)Explains joining tables and its types: INNER JOIN, LEFT JOIN which shows all employees even without a department, and RIGHT JOIN which shows all departments even without employees, and how each differs.14:50
  3. Table Joins (3)Continues joining tables with CROSS JOIN, which pairs every row with all the other rows, and SELF JOIN, which joins a table to itself, such as getting each employee's manager name from the employees table.23:15
5

Grouping Functions

3 lectures
  1. Data Aggregation (1)Explains grouping data in MySQL with GROUP BY and aggregate functions such as COUNT, to produce summary figures for management instead of detailed rows, like employee counts per department or job.19:52
  2. Data Aggregation (2)Continues grouping data in MySQL and explains the difference between WHERE, which filters before grouping, and HAVING, which filters the group results, such as excluding small salaries before grouping and keeping groups larger than one.11:23
  3. Data Aggregation (3)Continues grouping data by adding ROLLUP to GROUP BY to show subtotals and a grand total at the end of the result, with a review of the difference between WHERE and HAVING.12:05
6

Sub Queries

3 lectures
  1. Subqueries (1)Explains subqueries, meaning a query written inside another query to fetch a value you don't know in advance, then used in the condition, for example compared with an average or a given person's department number.18:22
  2. Subqueries (2)Continues MySQL subqueries: comparing two values together as a row, using EXISTS to check that data exists in another query, and linking the subquery to the main query through the department number condition.25:34
  3. Subqueries (3)Continues subqueries by using them inside the SELECT list as a field, then explains UNION, which merges the results of two queries and removes duplicates, and UNION ALL, which keeps every row including duplicates.25:10
7

Data Modifying

3 lectures
  1. Data Modification (1)Explains modifying data in MySQL, starting with INSERT: creating a test table, adding a row by naming columns, adding several rows at once, the effect of the primary key, and the DELAYED option.16:52
  2. Data Modification (2)Continues modifying data: INSERT INTO SELECT to add a query result from one table into another, repeated values on insert, and the option to update the row when the primary key is duplicated instead of raising an error.12:37
  3. Data Modification (3)Explains the UPDATE command for changing existing data, such as raising employee salaries under a condition, the SQL_SAFE_UPDATES safe mode, using a subquery in the condition, and the difference between TRUNCATE and deleting rows.20:20
8

Transactions

1 lectures
  1. TransactionsExplains MySQL transactions: the COMMIT and ROLLBACK commands to confirm or undo changes, starting a new transaction, and SAVEPOINT to roll back to a chosen point.15:35
9

Working with Databases and Tables

2 lectures
  1. Working with Databases and Tables (1)Explains DDL commands for managing MySQL databases and tables, such as creating a database with CREATE DATABASE or CREATE SCHEMA, creating tables and choosing column types, with a school database example.27:28
  2. Working with Databases and Tables (2)Continues working with databases and tables: the AUTO_INCREMENT column that generates the number automatically, the SHOW CREATE TABLE command, dropping a table with DROP TABLE, and indexes that speed up searching.21:35
10

Constraints

1 lectures
  1. Database ConstraintsExplains MySQL constraints when creating tables, such as primary key, NOT NULL and foreign key, and how a foreign key links two tables and prevents recording a value that does not exist in the other table.18:49
11

Saved Queries Views

1 lectures
  1. ViewsExplains MySQL views: a SELECT statement saved under a name that acts as a virtual table, how to create one with CREATE VIEW, and its benefit in simplifying complex queries and limiting the data a user sees.30:51
12

Stored Proc.

4 lectures
  1. Stored Procedures (1)Introduces MySQL stored procedures: routines saved in the database that hold multiple programming statements, how to create them with CREATE PROCEDURE using BEGIN and END and a custom delimiter, and how to run them with CALL.9:06
  2. Stored Procedures (2)Continues stored procedures: procedures with parameters that take a value such as a department number to return its employees, and an example procedure that inserts a row into a table using the parameter values when called with CALL.15:17
  3. Stored Programs (3)Continues stored procedures with the OUT parameter, in which the procedure places a value returned to the caller, unlike an input parameter, then begins preparing a Function that returns a value of a given type.14:59
  4. Stored Programs (4)Continues stored programs with MySQL functions: they take input parameters only and return a value with RETURN, the setting that allows creating functions that touch data, and an example function returning an employee's name from their ID.9:47
13

Conditions

3 lectures
  1. Conditional Statements (1)Explains conditional statements inside MySQL stored functions and procedures, using IF and ELSEIF, with an example function that checks a student's grade and returns a result by range.17:39
  2. Conditional Statements (2)Continues MySQL conditional statements with an example function that computes an employee's tax from salary, using IF and ELSEIF to set the tax rate by salary bracket, then returning the result with RETURN.9:06
  3. Conditional Statements (3)Continues MySQL conditional statements with CASE WHEN, which tests several cases instead of repeating IF, with an example computing an employee's tax by salary bracket, and when to use it.9:53
14

Looping

1 lectures
  1. Looping StatementsExplains MySQL loops in three forms: LOOP with an exit condition, REPEAT UNTIL, and WHILE DO, with a counter example that increases by one each round and prints its value.14:14
15

Triggers

4 lectures
  1. Database Events (1)Introduces MySQL triggers, code that runs automatically on a table event such as an insert, with examples of updating a customer's balance on deposit or withdrawal and adjusting product quantity, plus their pros and cons.17:47
  2. Database Events (2)Applies MySQL triggers in practice by creating a trigger that fires after an insert on a table and testing it to confirm its code runs automatically, as a lead-in to the customer deposit and balance example.11:23
  3. Database Events (3)Applies the full trigger example with customer deposit and withdrawal tables and a balance table, where the trigger automatically raises the balance on deposit and lowers it on withdrawal, creating tables with CREATE TABLE LIKE.14:18
  4. Database Events (4)Explains database Triggers through an example that logs who deleted or changed a table row, and updates customer and item balances on deposits, withdrawals, sales and purchases, covering the before and after variants for insert, delete and update.8:10
16

Functions

3 lectures
  1. Functions (1)Explains MySQL built-in functions and their split into aggregate functions and single-row functions, covering string functions such as UPPER, LOWER, TRIM, LTRIM and RTRIM, and the difference between COUNT on a column and on asterisk.13:33
  2. Functions (2)Continues MySQL functions: SUBSTRING to cut part of a text, LEFT and RIGHT, REPLACE and REVERSE, math functions such as ROUND and TRUNCATE and how they differ, and the date functions SYSDATE and NOW.12:05
  3. Functions (3)Continues MySQL functions with date functions, such as adding days to a date to work out installment due dates, formatting dates in different patterns, then the conditional IF function, with a review of the text and math functions.16:21
17

Integrated Project

5 lectures
  1. Integrated Project (1)Starts a complete MySQL database project and explains the stages of building a database application, beginning with the study stage that defines the project's requirements, then the analysis and design stages using diagrams.11:57
  2. Integrated Project (2)Continues the database project in the analysis stage: drawing the product, customer and employee tables and their relationships in the diagram, linking employees to payments and invoices, then the FHD diagram that splits a system into basic operations, transactions and queries.20:04
  3. Integrated Project (3)Continues the database project in the design stage: creating the category, customer and supplier tables with their column types, generating one table from another to save time, and designing the invoice screens and their data.23:10
  4. Integrated Project (4)Applies the table design stage of a complete database project, choosing field types such as integer, decimal and date, and notes that the link between categories and products is only logical, not yet a real foreign key.16:45
  5. Integrated Project (5)Completes the full project by linking tables and updating a customer balance, explains designing screens and programming them on top of the tables, then sums up the database project stages and points to the PHP course as a companion.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.
68.9K views28 courses

This course is part of the diploma

Related courses