(Valid For First 1000 Enrollment)
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
You can support us by donate with buy us a coffee. We appreciate your donation to our work for share free udemy courses.
Get courses alert everyday on our Telegram Channel. Join Now
Insidelearn Telegram ChannelShare this courses to your friends, community.