Curriculum
Course:
Mastering SQL query with MySQL server
Login
Curriculum
Mastering SQL query with MySQL server
SECTION 1
0/4
Introduction To SQL
10 min
Preview
Installation Of MySQL Server
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 min
creating a database and importing a table
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 min
QUIZ
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 questions
SECTION 2
0/5
SQL show statement
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 min
SQL SELECT query
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
11 min
Giving your SELECT result set distinct and limit
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 min
Result sorting using ORDER BY clause
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 min
QUIZ
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 questions
SECTION 3
0/4
SQL WHERE clause
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 min
Result set filtering using between operator
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 min
Result set filtering using AND & OR operators
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 min
QUIZ
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 questions
SECTION 4
0/4
SQL IN clause
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
7 min
Wild cards and how it works
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
8 min
Making use of regular expression
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
7 min
QUIZ
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 questions
SECTION 5
0/6
SQL UPPER() function
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 min
SQL CONCAT() function
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 min
SQL count() function
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 min
SQL AvG () function
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 min
SQL Group by () function
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 min
QUIZ
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 questions
SECTION 6
0/4
Joining tables in SQL
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
9 min
Outer JOIN
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 min
SQL UNION clause
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 min
QUIZ
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 questions
SECTION 7
0/6
SQL INSERT INTO statement
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
7 min
Inserting multiple rows in a table
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 min
SQL Update clause
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 min
SQL Delete clause
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 min
Creating a table with SQL
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
8 min
QUIZ
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 questions
SECTION 8
0/4
Auto increment and NOT null
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
7 min
Altering, dropping and renaming a table
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
8 min
SQL View clause
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
9 min
QUIZ
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 questions
Video lesson
Introduction To SQL
Sign In
The password must have a minimum of 8 characters of numbers and letters, contain at least 1 capital letter
Delete file
Are you sure you want to delete this file?
Cancel
Delete
Remember me
Sign In
Sign Up
Restore password
Send reset link
Password reset link sent
to your email
Close
Confirmation link sent
Please follow the instructions sent to your email address
Close
Your application is sent
We'll send you an email as soon as your application is approved.
Go to Profile
No account?
Sign Up
Sign In
Lost Password?
error:
