With this course, you will learn SQL and how databases work, create and manage a MySQL database, and perform CRUD and complex SELECT queries. You can also download 40 algorithmic exercises (pseudo-code).
These courses are intended for and important for computer science students or future students, web developers (or not), self-taught developers and other developers.
You will begin by taking a look at the basics:
– Define basic queries using the keywords SELECT and FROM
– Add filters to our queries using the WHERE clause
– Perform calculations using the functions provided by MySQL
– String manipulation using MySQL functions
Perform joins on multiple tables
– Use of external joins (LEFT JOIN / RIGHT JOIN)
– Grouping information using the keywords GROUP BY and HAVING
Nested query application
You will learn how to manage the database using:
– Scheduling management queries: create/modify/delete
– Queue management queries: insert/update/delete
Format: MP4
Language : French
Duration : 3 hours
Size : 1.37 GB
101 queries to master SQL
This article was updated on September 28, 2022
