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.
Dada Defination Languge (DDL)
Data Manipulation Language (DML)
-
7Data Types (INT, FLOAT, CHAR, VARCHAR, DATE etc.)
-
8Creating a Database (CREATE DATABASE)
-
9Creating a new Table (CREATE TABLE)
-
10Creating Duplicate Table (CREATE TABLE)
-
11Constraints (NOT NULL, UNIQUE, CHECK, PRIMARY KEY etc.)
-
12Adding Column in a Table (ALTER)
-
13Modifying and Deleting a Column in a Table(ALTER)
-
14Renaming, Deleting All Data and Deleting a Table (RENAME, TRUNCATE , DROP)
-
15DATA DEFINATION LANGUAGE (DDL)
-
16Data Definition Language (DDL) SQL Queries
Data Querying Language (DQL)
DQL in Multiple Table
-
22Displaying Records (SELECT)
-
23Displaying Records in an Order (ORDER BY ASC / DESC)
-
24Displaying Records as per Criteria (WHERE)
-
25Displaying Records as per Criteria with multiple values (IN)
-
26Grouping Records as per specific values (GROUP BY)
-
27Displaying Records within a specified range (BETWEEN)
-
28Displaying Records as per Aggregate function as criteria (HAVING)
-
29Displaying Records as per a Specified Similar values (LIKE)
-
30Displaying Records with Unique values (DISTINCT)
-
31Sub Query / Inner Query - Query within an another Query
-
32DATA QUERY LANGUAGE (DQL)
-
33DATA QUERY LANGUAGE (DQL) SQL Queries.