Add to Wishlist
Mastering SQL query with MySQL server

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
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
How to install the server needed for d course
3
creating a database and importing a table
4
QUIZ
SECTION 2
1
SQL show statement
2
SQL SELECT query
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
The SELECT DISTINCT statement is used to return only distinct (different) values
4
Result sorting using ORDER BY clause
5
QUIZ
SECTION 3
1
SQL WHERE clause
The WHERE clause is used to specify the rows you want to retrieve in a table.
2
Result set filtering using between operator
3
Result set filtering using AND & OR operators
4
QUIZ
SECTION 4
1
SQL IN clause
The IN operator allows you to specify multiple values in a WHERE clause.
2
Wild cards and how it works
A wildcard character can be used to substitute for any other character(s) in a string.
3
Making use of regular expression
4
QUIZ
SECTION 5
1
SQL UPPER() function
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
3
SQL count() function
4
SQL AvG () function
5
SQL Group by () function
6
QUIZ
SECTION 6
1
Joining tables in SQL
SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them.
2
Outer JOIN
3
SQL UNION clause
4
QUIZ
SECTION 7
1
SQL INSERT INTO statement
The INSERT INTO statement is used to insert new records in a table.
2
Inserting multiple rows in a table
3
SQL Update clause
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
The DELETE statement is used to remove selected rows of data from a single table in a database.
5
Creating a table with SQL
we will be creating tables in this video which is what holds the data in a database
6
QUIZ
SECTION 8
1
Auto increment and NOT null
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
3
SQL View clause
4
QUIZ
Be the first to add a review.
Please, login to leave a review