bag

SQL Programming and MySQL Developer Certification Training

3 years ago

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

Free USD $59.99

Created by: Uplatz Training

Expired Coupon

Share if you liked:

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

Published en 18 Dec 2020

Udemy UK


Lo que aprenderás


  • 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

  • Requisitos


  • Enthusiasm and determination to make your mark on the world!

  • Descripción


    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


    ¿Para quién es este curso?


  • 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

  • You should keep in mind that the Coupons last a maximum of 4 days or until 1000 registrations are exhausted, but it can expire anytime. Get the course with coupon by clicking on the following button:

    (Coupon valid for the first 1000 registrations): SQL_UPLATZ
    Udemy UK
    Tags:
    • #Sql
    • #Mysql

    Add a new comment

    Subscribe to our newsletter
    Receive the latest Coupons and promotions Request Coupon