Learn SQL using MySQL Database
- Description
- Curriculum
- FAQ
- Reviews
Now-a-days, everyone should have a sound knowledge in maintaining databases. You may be an IT expert, Business professional or in any other profession, if you don’t know how to maintain data then you would not feel comfortable with your profession.
SQL and MySQL, both are the powerful tools for managing and analyzing relational databases. In this course you are going to learn both of them.
Each topics of the course have been demonstrated in MySQL Prompt that may enable you to understand the process of writing a high quality SQL.
The Instructor of this course has a Master’s degree in Computer Science and Engineering with 15+ years of experience. He teaches in a very fundamental level and prepares you to learn in an expertise level.
If you are seriously interested in learning a Database with so many practical example then the Course may be a best choice for you.
Enroll in this course and take an opportunity to learn a very on-demand skill.
Course Content
—————————-
=> Introduction
Introduction to Database, SQL and MySQL
=> Data Definition Language (DDL)
CREATE, ALTER, RENAME, DROP
=> Data Manipulation Language (DML)
INSERT, UPDATE, DELETE
=> Data Query Language (DQL)
SELECT, ORDER BY, WHERE, IN, HAVING, LIKE, DISTINCT etc.
=> DQL in Multiple Table
JOIN Concepts, LEFT Join, RIGHT Join, FULL OUTER Join, SELF Join
=> Transaction Control Language (TCL)
COMMT, ROLLBACK, SAVEPOINT etc.
=> MySQL Functions
Numeric, String, Date etc.
-
7Data Types (INT, FLOAT, CHAR, VARCHAR, DATE etc.)Video lesson
-
8Creating a Database (CREATE DATABASE)Video lesson
-
9Creating a new Table (CREATE TABLE)Video lesson
-
10Creating Duplicate Table (CREATE TABLE)Video lesson
-
11Constraints (NOT NULL, UNIQUE, CHECK, PRIMARY KEY etc.)Video lesson
-
12Adding Column in a Table (ALTER)Video lesson
-
13Modifying and Deleting a Column in a Table(ALTER)Video lesson
-
14Renaming, Deleting All Data and Deleting a Table (RENAME, TRUNCATE , DROP)Video lesson
-
15DATA DEFINATION LANGUAGE (DDL)Quiz
-
16Data Definition Language (DDL) SQL QueriesText lesson
-
22Displaying Records (SELECT)Video lesson
-
23Displaying Records in an Order (ORDER BY ASC / DESC)Video lesson
-
24Displaying Records as per Criteria (WHERE)Video lesson
-
25Displaying Records as per Criteria with multiple values (IN)Video lesson
-
26Grouping Records as per specific values (GROUP BY)Video lesson
-
27Displaying Records within a specified range (BETWEEN)Video lesson
-
28Displaying Records as per Aggregate function as criteria (HAVING)Video lesson
-
29Displaying Records as per a Specified Similar values (LIKE)Video lesson
-
30Displaying Records with Unique values (DISTINCT)Video lesson
-
31Sub Query / Inner Query - Query within an another QueryVideo lesson
-
32DATA QUERY LANGUAGE (DQL)Quiz
-
33DATA QUERY LANGUAGE (DQL) SQL Queries.Text lesson
-
34Referencial-integerity-CONCEPTVideo lesson
-
35Referencial-integerity-PRACTICALVideo lesson
-
36JOIN-CONCEPTVideo lesson
-
37INNER JoinVideo lesson
-
38Multiple INNER JoinVideo lesson
-
39LEFT JoinVideo lesson
-
40RIGHT JoinVideo lesson
-
41FULL-OUTER-JoinVideo lesson
-
42Self JoinVideo lesson
-
43DATA QUERY LANGUAGE (MULTIPLE TABLE)Quiz
-
44DATA QUERY LANGUAGE (MULTIPLE TABLE), SQL QUERIES ON JOINText lesson
External Links May Contain Affiliate Links read more