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