SQL Programming and MySQL Developer Certification Training

SQL Programming and MySQL Developer Certification Training

weeks
-2
-5
days
0
-6
hours
-1
-5
minutes
-4
-3
seconds
-4
-6

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

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

Requirements

Enthusiasm and determination to make your mark on the world!

Description

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

Who this course is for:

  • Microsoft Power BI Analysts and Consultants
  • Power BI Developers and Consultants
  • Data and Analytics Consultants
  • Power BI Developers – Azure Data Factory, Lake
  • Anyone interested to make a career in Power BI, Analytics and Visualization
  • Data Scientists and Data Engineers
  • Business Analysts and Consultants
  • Data Analytics and Visualization Managers
  • Azure Data Engineers – Power BI
  • Reporting & Data Visualization Analysts
  • Business Intelligence Developers, Analysts, Enthusiasts
  • SQL Developers and Web Developers
  • Beginners and newbies aspiring to enter the world of Data Visualization & Business Intelligence
  • Front End and Full Stack Web Developers
  • Financial and Marketing Analysts

Leave a Reply