MySQL 2 Hour FREE COURSE for Beginners

This is MySQL training course for beginners. We have installed and used MySQL on Ubuntu. In this course you will learn that how you can install the MySQL and how you can use it for creating and managing your databases. We have covered each topic from installation to configuring replication and we have explained it briefly.
1. Installing MySQL 8 on Ubuntu 0:56
2. Configuring Secure Access 5:41
3. Creating a database, switching between databases 9:02
4. Create tables 12:04
5. Getting a list of tables 14:50
6. Describing the columns in a table 12:04
7. Inserting rows into a table 12:04
8. Selecting rows from a table 16:50
9. Using Predicates with WHERE Clause 22:07
10. Primary and foreign keys 28:06
11. Group by Aggregates (SUM, COUNT, MIN, MAX, AVG) 44:50
12. Joining tables 50:57
13. HAVING condition on Aggregate 1:00:00
14. Creating indexes 1:07:40
15. Running SQL from a file 1:13:13
16. Transactions, Rollback, Commit, Auto-commit 1:17:06
17. Using INNODB storage engine 1:24:48
18. Changing Server Configuration Parameters 1:31:18
19. Reading the MYSQL server log file for error messages 1:37:15
20. Creating new accounts 1:39:11
21. Granting and revoking access to tables to accounts 1:42:23
22. How to use mysqldump 1:46:42
23. point in time recovery using binary log 1:51:40
24. Configuring replication 1:56:47

#Mysql #Ubuntu

[richardlo]

thank you so much for the tutorials, it really helps alot for beginners!!

[deepankarchaudhary]

please tell, how to connect with mysql workbench

[muhammadusman]

Thank you so much for this course it helped me alot

[Ahmed_Abdelmageed]

bro please tell me
What are the specifications of your device that you installed Linux on