MySQL online course

Lessons

1. How to Access a MySQL Server Learn how to connect to MySQL with the mysql command line, MySQL Workbench, or phpMyAdmin, and choose a secure access method.
2. Tables and types Pick column types that will not fight you in a year.
3. SELECT and joins Read rows, filter them, and combine tables.
4. Advanced SELECT Statements in MySQL Learn how MySQL COUNT(), DISTINCT, and WHERE clauses count rows, remove repeated result values, and filter records without changing stored data.
5. MySQL Aggregate Functions: AVG, MIN, and MAX Learn how MySQL aggregate functions summarize multiple rows with AVG(), MIN(), and MAX(), including filtering, NULL handling, aliases, and retrieving matching rows.
6. Start the MySQL Command-Line Interface Learn how to open Windows Command Prompt, find mysql.exe, connect to a local MySQL Server as root, verify access, and exit safely.
7. How to Access a MySQL Database Server Learn how to connect to MySQL using the mysql command-line client, MySQL Workbench, or phpMyAdmin, with connection requirements, SQL examples, security guidance, and troubleshooting.
8. MySQL Aliases Learn how to use MySQL column and table aliases with AS to create readable names for functions, calculations, aggregates, and query results.
9. Combine Multiple SELECT Statements with UNION in MySQL Learn how MySQL UNION and UNION ALL combine rows from multiple SELECT statements, handle duplicates, align columns, add labels, sort results, and limit output.
10. How to Create and Select a Database in MySQL Learn how to create a MySQL database, verify it with SHOW DATABASES, select it with USE, and troubleshoot permissions and naming errors.
11. How to Create a Table in MySQL Learn how to create a MySQL table, choose columns and data types, select a storage engine, and verify the result with SHOW TABLES and DESCRIBE.
12. Create MySQL Users and Grant Database Privileges Learn how to create MySQL users, restrict connections by host, grant least-privilege database access, and verify account permissions.
13. MySQL Data Types Learn how MySQL data types work and how to choose CHAR, VARCHAR, INT, DECIMAL, DATE, DATETIME, BINARY, BLOB, and other common column types.
14. Essential MySQL Database Terms Learn essential MySQL and relational database terms, including databases, tables, rows, columns, primary keys, foreign keys, indexes, and relationships.
15. Insert New Records in MySQL Learn how to add one or more rows to a MySQL table with INSERT INTO, use column lists safely, and verify records with SELECT.
16. Install MySQL on Linux (Ubuntu) Learn how to install the MySQL server on Ubuntu with APT, handle initial authentication prompts, and verify the service from the terminal.
17. Install MySQL on Windows Learn how to download, install, configure, secure, and verify MySQL Community Server on Windows with MySQL Installer.
18. MySQL LIMIT Clause Learn how to use MySQL LIMIT to restrict SELECT results, skip rows with offsets, sort results reliably, and build simple pagination.
19. Modify Tables with ALTER TABLE in MySQL Learn how to use MySQL ALTER TABLE to rename a table, change a column data type, add a column, remove a column, and verify schema changes.
20. MySQL Date Functions: Current Dates, Date Differences, Date Arithmetic, and Weekday Names Learn MySQL date functions including CURDATE(), DATEDIFF(), DATE_ADD(), and DAYNAME() with practical SQL examples and troubleshooting tips.
21. MySQL Functions: String, Date, and Aggregate Functions Learn how MySQL functions transform text, calculate dates, summarize rows, handle NULL values, and work with WHERE, GROUP BY, and HAVING.
22. MySQL String Functions Learn how MySQL string functions transform, combine, measure, and replace text using CONCAT, LENGTH, CHAR_LENGTH, and REPLACE.
23. MySQL Primary Keys Learn how MySQL primary keys uniquely identify rows, use AUTO_INCREMENT IDs, add keys to existing tables, and create composite primary keys.
24. Query Data from a MySQL Table with SELECT Learn how to use MySQL SELECT to retrieve named columns or every column from a table, read result sets, and troubleshoot common query errors.
25. Remove Rows from a MySQL Table with DELETE Learn how to safely remove one or more rows from a MySQL table with DELETE, WHERE, LIMIT, primary keys, verification queries, and transactions.
26. Sort Query Results with ORDER BY in MySQL Learn how to sort MySQL SELECT results with ORDER BY, including ASC, DESC, multiple sort keys, aliases, NULL values, LIMIT, and performance.
27. MySQL SQL Command Syntax: Statements, Keywords, and Basic Usage Learn MySQL SQL command syntax, keywords, statements, semicolons, case rules, database selection, basic SELECT queries, and the mysql command-line client.
28. How to Update Field Values in MySQL with UPDATE Learn how to safely update one or more MySQL column values with UPDATE, SET, and WHERE, including verification, LIMIT, transactions, and troubleshooting.
29. Use Logical Operators in MySQL Learn how to use AND, OR, and NOT in MySQL WHERE clauses to combine, broaden, or exclude filtering conditions.
30. What Is MySQL? Learn what MySQL is, how relational databases and SQL work, common uses, LAMP stack context, administration tools, licensing, and MySQL alternatives.