SQL Programming and MySQL Developer Certification Training

Deal Score+8
Deal Score+8

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

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


Author : Uplatz Training

Ratings : 0.0 / 5.0

Students : 10,674 students

https://www.udemy.com/sql-programming-and-mysql-developer-training/?couponCode=SQL_UPLATZ

Category : Development, Database Design & Development, SQL

Coursegence
Logo