SQL Programming and MySQL Developer Training: 2020 Edition

Learn SQL Programming with MySQL Database from scratch. SQL Commands, Functions, Expressions, Joins, Procedures, Views.

SQL Programming and MySQL – Course Syllabus

What you’ll learn

  • Fundamentals of SQL (Structured Query Language).
  • Prepare for SQL Certification.
  • Become an SQL Developer / Application Developer / DBA.
  • Basics of Databases – Data Models and basic terminologies.
  • What is DBMS? Advantages and disadvantages of DBMS.
  • What is SQL? What can SQL do?.
  • SQL Process, ACID Properties, ER Model.
  • SQL Best Practices, Database Normalization.
  • Introduction to SQL – SQL Commands, SQL Constraints, Types of Keys, MySQL Hands-on.
  • SQL Basic Commands with demonstration.
  • Aggregation Functions, Regular Expression Functions.
  • Exists, Not Exists, Create Table like, Case when, NULL Functions.
  • SQL String and Numerical Functions.
  • Date Functions.
  • SQL Joins – Introduction and demonstration.
  • Introduction MySQL Workbench.
  • Stored Procedures and Views.

Course Content

  • Basics of Database –> 1 lecture • 30min.
  • SQL Basic Understanding –> 1 lecture • 43min.
  • Introduction to SQL –> 1 lecture • 34min.
  • SQL Basic Commands –> 1 lecture • 39min.
  • SQL Basic and Aggregate Functions –> 1 lecture • 37min.
  • SQL Regular Expressions –> 1 lecture • 36min.
  • SQL Comparison Clauses –> 1 lecture • 29min.
  • SQL String Functions –> 3 lectures • 1hr 32min.
  • SQL Numeric Functions and Data Functions –> 2 lectures • 1hr 23min.
  • SQL Joins Introduction and Demonstration –> 1 lecture • 37min.

SQL Programming and MySQL Developer Training: 2020 Edition

Requirements

  • Enthusiasm and determination to make your mark on the world!.

SQL Programming and MySQL – Course Syllabus

 

1. Basics of Databases

  • Data Models and basic terminologies
  • Advantages and disadvantages of DBMS

2. SQL Basic Understanding

  • What is SQL?
  • What SQL Can do?
  • SQL Process
  • ACID Properties
  • What is ER Model?
  • Best Practices
  • Database Normalization

3. Introduction to SQL

  • SQL Commands
  • SQL Constraints
  • Types of Keys
  • MySQL Hands-on

4. SQL Basic Commands with demonstration

5. Basics and Aggregation Functions

6. Regular Expression Functions

7. SQL Comparison Clauses

  • exists
  • not exists
  • create table like
  • case when
  • NULL Functions

8. SQL String Functions

9. SQL Numerical Function

10. Introduction to Date Functions

11. SQL Joins – Introduction and demonstration

12. Introduction MySQL Workbench

13. Stored Procedures and Views