0
0 reviews
Mastering SQL query with MySQL server
- Description
- Curriculum
- Reviews
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
-
1Introduction To SQLPreview 10 minThis video will introduce the concept and the evolution of structured query language as a way of communicating with a relational database system.
-
2Installation Of MySQL ServerThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.How to install the server needed for d course
-
3creating a database and importing a tableThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
4QUIZThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
SECTION 2
-
5SQL show statementThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
6SQL SELECT queryThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.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.
-
7Giving your SELECT result set distinct and limitThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.The SELECT DISTINCT statement is used to return only distinct (different) values
-
8Result sorting using ORDER BY clauseThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
9QUIZThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
SECTION 3
-
10SQL WHERE clauseThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.The WHERE clause is used to specify the rows you want to retrieve in a table.
-
11Result set filtering using between operatorThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
12Result set filtering using AND & OR operatorsThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
13QUIZThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
SECTION 4
-
14SQL IN clauseThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.The IN operator allows you to specify multiple values in a WHERE clause.
-
15Wild cards and how it worksThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.A wildcard character can be used to substitute for any other character(s) in a string.
-
16Making use of regular expressionThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
17QUIZThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
SECTION 5
-
18SQL UPPER() functionThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.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.
-
19SQL CONCAT() functionThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
20SQL count() functionThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
21SQL AvG () functionThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
22SQL Group by () functionThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
23QUIZThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
SECTION 6
-
24Joining tables in SQLThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them.
-
25Outer JOINThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
26SQL UNION clauseThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
27QUIZThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
SECTION 7
-
28SQL INSERT INTO statementThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.The INSERT INTO statement is used to insert new records in a table.
-
29Inserting multiple rows in a tableThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
30SQL Update clauseThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.The UPDATE statement is used to modify the values of one or more columns in selected rows of a single database table.
-
31SQL Delete clauseThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.The DELETE statement is used to remove selected rows of data from a single table in a database.
-
32Creating a table with SQLThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.we will be creating tables in this video which is what holds the data in a database
-
33QUIZThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
SECTION 8
-
34Auto increment and NOT nullThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.Auto-increment allows a unique number to be generated when a new record is inserted into a table.
-
35Altering, dropping and renaming a tableThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
36SQL View clauseThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
37QUIZThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Please, login to leave a review
Related courses
![sql image](https://masteryvault.com/wp-content/uploads/2022/01/sql-image-1-870x440.jpg)
Share
Course details
Duration
3 hours
Lectures
29
Video
29
Quizzes
8
Level
Beginner
Popular courses