SQL Tutorial: Learn SQL with MySQL Database

Udemy

Obtain a practical understanding of the functionalities involved with SQL for database development using DBMS like MySQL

Online

₹ 3699

particular

details

                                    Medium of instructions
                                    English

                                    Mode of learning
                                    Self study

                                    Mode of Delivery
                                    Video and Text Based

Introduction to SQL

What is SQL?
Who should learn SQL?
Quiz 1: Introduction

Setup a Testing Environment

Download & Install MySQL 8.0.11 on Windows 10 Operating System
Install MySQL database server on Mac operating system (MySQL 5.7.20)
Install MySQL database server on Linux operating system (MySQL 5.7.20)
How to add a new database user and add privileges
Quiz 2: Setup a Testing Environment

An Overview of SQL

What is DBMS and RDBMS?
Difference between Database Engine, Database Server and Database Software
What is a database? How to create and use a database?
What is a database table? How to create and use a database table?
How to add the data rows to a database table?
Understand Keywords, Identifiers, Constants and Clauses
Learn about SQL Statements
Data Definition Language(DDL) and Data Manipulation Language(DML)?
Quiz 3: An Overview of SQL

Important SQL Clauses (Data Manipulation Language)

Create example databases, tables and data rows
Learn about SQL SELECT Clause
SQL SELECT DISTINCT Statement
Learn about SQL FROM Clause
Learn about SQL WHERE Clause
Quiz 4: Important SQL Clauses

Conditions and Operators (Data Manipulation Language)

SQL True Condition
SQL False Condition
SQL AND Operator
SQL OR Operator
SQL IN Operator
SQL EXISTS Condition
SQL NOT IN or NOT EXISTS? Conditions
SQL Comparison Operators
SQL LIKE Operator
SQL BETWEEN Operator
SQL Numeric Operators
SQL Concatenation Operator
SQL Temporal Operator
Quiz 5: Conditions and Operators

Data grouping, sorting, select and dates (Data Manipulation Language)

Learn about SQL GROUP BY Clause
Learn about SQL HAVING Clause
Learn about SQL ORDER BY Clause
SQL LIMIT or TOP Clause
SQL Wildcards
SQL Aliases
SQL Dates
Quiz 6: Data grouping, sorting, select and dates

Insert, Read, Update, Delete the Data Rows (Data Manipulation Language)

Add the data rows in a table using INSERT INTO Statement
SQL INSERT INTO SELECT Statement
Update data rows using UPDATE Statement
Delete data rows using DELETE Statement
What is SQL Injection and How to secure a database?
Quiz 7: Insert, Read, Update, Delete the Data Rows (Data Manipulation Language)

Sql Joins (Data Manipulation Language)

What are JOINS in SQL? Types of SQL JOINS
Learn about INNER JOIN in SQL
Learn about LEFT OUTER JOIN in SQL
Learn about RIGHT OUTER JOIN in SQL
Learn about FULL OUTER JOIN in SQL
Learn about CROSS JOIN in SQL
SQL UNION Operator
SQL VIEWS
Derived Tables or Inline Views
Quiz 8: SQL JOINS (Data Manipulation Language)

Sql Functions

Functions in SQL and Types of SQL functions
SQL COUNT() Function
SQL FIRST() Function
SQL LAST() Function
SQL SUM() Function
SQL MIN() Function
SQL MAX() Function
SQL AVG() Function
SQL UCASE() Function
SQL LCASE() Function
SQL MID() Function
SQL LEN() Function
SQL ROUND() Function
SQL FORMAT() Function
SQL SUBSTRING() Function
SQL COALESCE() Function
SQL CHAR_LENGTH() Function
SQL CAST() Function
SQL CASE() Function
SQL NULLIF() Function
Quiz 9: SQL Functions

Sql Data Types

What is data type in SQL?
Integer Numbers in SQL (Exact Values)
Fixed-Point Numbers in SQL (Exact Values)
Floating-Point Numbers in SQL (Approximate Values)
CHAR and VARCHAR in SQL (String Values)
NCHAR and NVARCHAR in SQL (String Values)
CLOB and BLOB in SQL (String Values)
DATE, TIME and TIMESTAMP in SQL (Temporal Values)
Quiz 10: SQL Data Types

Data Definition Language

Learn how to create and display databases
Select and use existing database
Remove or delete database from database management system
Learn how to create the database table using right method
Modify or update the database table details
Remove or delete an existing table
Understand Constraints in SQL
NOT NULL Constraint in SQL
UNIQUE Constraint in SQL
PRIMARY KEY Constraint in SQL
FOREIGN KEY Constraint in SQL
CHECK Constraint in SQL
DEFAULT Constraint in SQL
AUTO INCREMENT or SEQUENCE in SQL
Quiz 11: Data Definition Language

Data Control Language - DCL

What is Data Control Language (DCL)
The GRANT statement
The REVOKE statement

Transaction Control Language (TCL)

What is Transaction Control Language (TCL)
The COMMIT statement
The ROLLBACK statement
The SAVEPOINT statement
The SET autocommit

Database Relationships

Understand Database Relationship in SQL
One-to-One (1:1) Relationship in SQL
One-to-Many (1:M) Relationship in SQL
Many-to-Many (M:M) Relationship in SQL
Quiz 12: Database Relationships

Database Normalization

What is Database Normalization in SQL?
First Normal Form (1NF) in database normalization
Second Normal Form (2NF) in database normalization
Third Normal Form (3NF) in database normalization
Quiz 13: Database Normalization

Sql Database Export and Import

What is SQL Export and Import?
How to Export the database using SQL statement
How to Import the database using SQL statement
Quiz 14: SQL Database Export and Import

MySQL Workbench

What is MySQL Workbench?
Create a new user and connect to database using MySQL Workbench
Create, Alter, Drop database using MySQL Workbench
Create, Alter, Drop table using MySQL Workbench
Insert, Read, Update, Delete data rows using MySQL Workbench
Database Export and Import using MySQL Workbench
Quiz 15: MySQL Workbench

Additional Lectures

Install MySQL database server on Windows 10 operating system (MySQL 5.7.20)
Install MySQL database server on Windows 7 operating system (MySQL 5.7.10)
Install MySQL database server on Mac operating system (MySQL 5.7.10)
Install MySQL database server on Linux operating system (MySQL 5.7.10)
MySQL shortcut for Windows users
Course Introduction

Thank You!

Thank You for completing the course

Popular Courses

Popular Platforms

Popular Searches

SQL Tutorial: Learn SQL with MySQL Database

Online

₹ 3699

Quick Facts

Course overview

The highlights

Program offerings

Course and certificate fees

Fees information

certificate availability

certificate providing authority

Who it is for

What you will learn

The syllabus

Introduction to SQL

Setup a Testing Environment

An Overview of SQL

Important SQL Clauses (Data Manipulation Language)

Conditions and Operators (Data Manipulation Language)

Data grouping, sorting, select and dates (Data Manipulation Language)

Insert, Read, Update, Delete the Data Rows (Data Manipulation Language)

Sql Joins (Data Manipulation Language)

Sql Functions

Sql Data Types

Data Definition Language

Data Control Language - DCL

Transaction Control Language (TCL)

Database Relationships

Database Normalization

Sql Database Export and Import

MySQL Workbench

Additional Lectures

Thank You!

Instructors

Articles

Popular Articles

Latest Articles

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Thank You!

Download the Careers360 App on your Android phone