📚Learn SQL from scratch and fill in the missing gaps
💻Install the necessary tools and write SQL queries
🗄️Retrieve, insert, update, and delete data in databases
🧩Understand tables, relationships, and different types of joins
🔍Use sub-queries, regular expressions, and more
Is this course suitable for beginners?
—Yes, this course is ideal for beginners who want to learn SQL from scratch.
Do I need any prior knowledge of SQL?
—No, this course is designed for beginners and covers all the essential concepts you need to know.
What tools will I need to install?
—You'll need to install MySQL and MySQL Workbench, which are both covered in the course.
Will I learn how to write SQL queries?
—Yes, this course will teach you how to write queries to retrieve, insert, update, and delete data in databases.
What will I learn by the end of the course?
—By the end of the course, you'll have a solid understanding of SQL concepts and be able to work with databases effectively.
00:00In this three-hour course, Mosh Hamedani teaches you everything you need to know to get started with SQL.
01:04Learn about databases, database management systems, and the SQL language.
02:08Discover different types of database management systems, including relational and non-relational.
04:52Explore the history and pronunciation of SQL, and learn about MySQL as a popular open-source database.
06:52Find out how to install MySQL on both Mac and Windows machines and set up MySQL Workbench.
09:52Learn how to connect to the MySQL server using MySQL Workbench and test the connection.
13:28Get step-by-step instructions on installing and setting up MySQL on both Mac and Windows.
14:40Learn how to create databases in MySQL using the provided SQL code.
