SQL Tutorial: Learn SQL with MySQL Database -Beginner2Expert

Description

In this course you'll learn :

• Database installation and SQL fundamentals.
• Data definition language(DDL) and Data manipulation language(DML).
• SQL joins, SQL functions and SQL data types.
• Database relationships and database normalization.
• Database export and import.
• MySQL workbench.

Syllabus :

1. An Overview of SQL

• What is DBMS and RDBMS?
• Difference between Database Engine, Database Server and Database Software
• 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)?

 

2. Important SQL Clauses (Data Manipulation Language)

• Learn about SQL SELECT Clause
• SQL SELECT DISTINCT Statement
• Learn about SQL FROM Clause
• Learn about SQL WHERE Clause

 

3. Conditions and Operators (Data Manipulation Language)

• 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

 

4. 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

 

5. 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?

 

6. 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

 

7. 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

 

8. 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)

 

9. 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

 

10. Data Control Language - DCL

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

 

11. Transaction Control Language (TCL)

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

 

12. 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

 

13. 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

 

14. 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

 

15. 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

Show more