SQL Programming and MySQL Developer Certification Training

Learn SQL Programming with MySQL Database from scratch. SQL Commands, Functions, Expressions, Joins, Procedures, Views.
Instructor:
Uplatz Training
8,513 students enrolled
English [Auto]
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

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

Basics of Database

1
Basics of Database

SQL Basic Understanding

1
SQL Basic Understanding

Introduction to SQL

1
Introduction to SQL

SQL Basic Commands

1
SQL Basic Commands

SQL Basic and Aggregate Functions

1
SQL Basic and Aggregate Functions

SQL Regular Expressions

1
SQL Regular Expressions

SQL Comparison Clauses

1
SQL Comparison Clauses

SQL String Functions

1
SQL String Functions - part 1
2
SQL String Functions - part 2
3
SQL String Functions - part 3

SQL Numeric Functions and Data Functions

1
SQL Numeric Functions - part 1
2
SQL Numeric Functions part 2 and SQL Data Functions

SQL Joins Introduction and Demonstration

1
SQL Joins Introduction and Demonstration

MySQL Workbench, Procedures and Views

1
MySQL Workbench, Procedures and Views
You can view and review the lecture materials indefinitely, like an on-demand channel.
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!

Be the first to add a review.

Please, login to leave a review
831929a81d3262f4af06d7ff08ed2a9a
Course available for 2 days
30-Day Money-Back Guarantee

Includes

8 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion

External Links May Contain Affiliate Links read more

Join our Telegram Channel To Get Latest Notification & Course Updates!
Join Our Telegram For FREE Courses & Canva PremiumJOIN NOW