SQL Programming and MySQL Developer Certification Training

SQL Programming and MySQL Developer Certification Training

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
  • 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:

  • SQL Developers and SQL Database Developers
  • Application Developers and Back End Programmers
  • Data Analysts and Support Analysts (SQL)
  • Database Administrators and MySQL DBAs
  • Newbies and Beginners aspiring for a career as Database/SQL Developer
  • MySQL Developers
  • Oracle, SQL, ERP Application Support Analysts
  • Anyone interested to learn SQL programming
  • SQL Analysts
  • Marketing/Financial/Operational Analysts
  • ETL Developers and Data Integration Programmers
  • Data warehousing Professionals
  • Full Stack Web Developers – SQL
  • Backend Developers Java Spring SQL
  • Data Consultants and Business Consultants
  • PHP Developers (MySQL)
  • Database Analysts & Database Tuning Experts
  • Cloud Engineers – AWS, Azure, Google, IBM
  • Database Architects & Solution Architects

Course content

11 sections • 14 lectures • 8h 1m total length
  • Basics of Database
  • 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

Created by: Uplatz Training (Fastest growing Global IT Training Provider)

Last updated 10/2020
English
English [Auto]
2.3 GB (Direct Download Available)
New
Rating: 4.3 out of 5
(112 ratings)
24,474 students

https://www.udemy.com/course/sql-programming-and-mysql-developer-training/

Download link

Add a Comment

Your email address will not be published. Required fields are marked *