SQL Programming and MySQL Developer Certification Training
Learn SQL Programming with MySQL Database from scratch. SQL Commands, Functions, Expressions, Joins, Procedures, Views.
- Description
- Curriculum
- FAQ
- Reviews
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
SQL Basic Understanding
Introduction to SQL
SQL Basic Commands
SQL Basic and Aggregate Functions
SQL Regular Expressions
SQL Comparison Clauses
SQL String Functions
SQL Numeric Functions and Data Functions
SQL Joins Introduction and Demonstration
MySQL Workbench, Procedures and Views
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
Please, login to leave a review
Course available for 2 days
Course details
Video
8 hours
Certificate of Completion
Full lifetime access
Access on mobile and TV
Popular courses
