MasteryVault

Mastering SQL query with MySQL server

Get course

ABOUT THE COURSE

SQL is Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in a relational database.

It is the standard language for Relational Database System. All the Relational Database Management Systems (RDMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server use SQL as their standard database language. In this tutorial i’m going to be making use of mysql relational database management system in teaching.

WHY YOU NEED TO KNOW SQL

SQL is widely popular because it offers the following advantages −

  • Allows users to access data in the relational database management systems.
  • Allows users to describe the data.
  • Allows users to define the data in a database and manipulate that data.
  • Allows to embed within other languages using SQL modules, libraries & pre-compilers.
  • Allows users to create and drop databases and tables.
  • Allows users to create view, stored procedure, functions in a database.

SECTION 1

1
Introduction To SQL
10 min
This video will introduce the concept and the evolution of structured query language as a way of communicating with a relational database system.
2
Installation Of MySQL Server
5 min
How to install the server needed for d course
3
creating a database and importing a table
6 min
4
QUIZ
4 questions

SECTION 2

1
SQL show statement
6 min
2
SQL SELECT query
11 min
In this video we will be looking in one of the major statements in SQL,SELECT statement is used to select data from a database.
3
Giving your SELECT result set distinct and limit
6 min
The SELECT DISTINCT statement is used to return only distinct (different) values
4
Result sorting using ORDER BY clause
6 min
5
QUIZ
6 questions

SECTION 3

1
SQL WHERE clause
4 min
The WHERE clause is used to specify the rows you want to retrieve in a table.
2
Result set filtering using between operator
4 min
3
Result set filtering using AND & OR operators
5 min
4
QUIZ
6 questions

SECTION 4

1
SQL IN clause
7 min
The IN operator allows you to specify multiple values in a WHERE clause.
2
Wild cards and how it works
8 min
A wildcard character can be used to substitute for any other character(s) in a string.
3
Making use of regular expression
7 min
4
QUIZ
5 questions

SECTION 5

1
SQL UPPER() function
3 min
SQL contains a lot of built-in functions for working with strings and numbers. In this video we will be learning how some of this SQL built-in functions are used.
2
SQL CONCAT() function
4 min
3
SQL count() function
3 min
4
SQL AvG () function
4 min
5
SQL Group by () function
4 min
6
QUIZ
6 questions

SECTION 6

1
Joining tables in SQL
9 min
SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them.
2
Outer JOIN
6 min
3
SQL UNION clause
4 min
4
QUIZ
5 questions

SECTION 7

1
SQL INSERT INTO statement
7 min
The INSERT INTO statement is used to insert new records in a table.
2
Inserting multiple rows in a table
5 min
3
SQL Update clause
3 min
The UPDATE statement is used to modify the values of one or more columns in selected rows of a single database table.
4
SQL Delete clause
3 min
The DELETE statement is used to remove selected rows of data from a single table in a database.
5
Creating a table with SQL
8 min
we will be creating tables in this video which is what holds the data in a database
6
QUIZ
6 questions

SECTION 8

1
Auto increment and NOT null
7 min
Auto-increment allows a unique number to be generated when a new record is inserted into a table.
2
Altering, dropping and renaming a table
8 min
3
SQL View clause
9 min
4
QUIZ
5 questions

Be the first to add a review.

Please, login to leave a review
Layer 1
Login Categories