← Back to courses
Data Science and AI
MySQL in a Week
One week through the MySQL manual's own tutorial
A one-week classroom course on the tutorial chapter of the MySQL 8.4 reference manual: connecting to the server, entering queries, creating and using a database, getting information about databases and tables, batch mode and examples of common queries. This course prepares for no exam.
6Modules
BeginnerLevel
1 weekDuration
COURSE THUMBNAIL
What you will be able to do
Create a database and its tables
Load and query data
Write the common group-wise queries
Course outline
01
Connecting to and disconnecting from the server; entering queries
02
Creating and selecting a database; creating a table
03
Loading data into a table
04
Retrieving information from a table
05
Getting information about databases and tables; batch mode
06
Common queries: maximums per group, foreign keys and AUTO_INCREMENT
Tools you will use
MySQLmysql command-line client
What you need
General computer skills
