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