IT & Software

SQL for Developers, Data Analysts and BI. MySQL for everyone

Course Overview

  • Course Title: SQL for Developers, Data Analysts and BI. MySQL for everyone
  • Instructor: Nick Ovchinnikov
  • Target Audience:
    • Developers
    • Data Analysts
    • Business Intelligence Professionals
    • Beginners in SQL and MySQL
  • Prerequisites:
    • No special requirements. You will learn everything you need to know
    • Any experience in Computer Programming or Data Analytics is good but not required

Curriculum Highlights

  • Key Topics Covered:
    • Introduction to MySQL and SQL
    • Normal forms, Datatypes, Charset and Collation
    • Complex SQL queries with UNION and JOIN
    • Hands-on assignments and real-world use cases
    • SQL syntax branches
    • MySQL Workbench
    • EER schemas and complex databases
    • Aggregate Functions
    • CRUD operations (INSERT, SELECT, UPDATE, DELETE)
    • SQL joins
  • Key Skills Learned:
    • Creating and interacting with databases using SQL
    • Writing complex SQL queries
    • Designing EER schemas
    • Performing CRUD operations
    • Analyzing data using aggregate functions
    • Using SQL joins effectively

Course Format

  • Duration: 6.5 hours on-demand video
  • Format: Self-paced online course
  • Resources:
    • 2 practice tests
    • Assignments
    • Access on mobile and TV
    • Certificate of completion
Get Coupon on Udemy