5.00
(2 Ratings)

SQL – MySQL for Data Analytics and Business Intelligence

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Learn SQL with this comprehensive and practical course, taught in MySQL – the most popular SQL database management system. This course will teach you everything you need to know about SQL, from the basics to advanced concepts. You will learn how to work with a real-life database and gain the skills needed for a successful career in data analytics and business intelligence.

This free course will cover:

  • The basics of SQL
  • Data types and operators
  • Creating, modifying, and deleting tables
  • Selecting, inserting, updating, and deleting data
  • Joining tables
  • Creating views and stored procedures
  • Using functions and aggregates
  • Working with subqueries
  • Understanding database security

This course is perfect for beginners with no prior experience in SQL. You will learn everything you need to know about SQL in a step-by-step manner. The course also includes plenty of downloadable exercises, course notes, and quiz questions to help you learn and practice. This course is offered free of charge and is available on Theetay, a website that provides free access to online courses from platforms like Udemy, Udacity, Coursera, MasterClass, and NearPeer.

Benefits of learning SQL:

  • High-paying career: The average salary of a SQL developer is $103,400.
  • In-demand skill: As data continues to grow in importance, so too will the demand for SQL skills.
  • Analytical reasoning: Learning SQL can help you develop analytical reasoning skills.

Enroll in this free course today and start your journey to becoming a SQL expert.

Show More

What Will You Learn?

  • Become an expert in SQL
  • Learn how to code in SQL
  • Boost your resume by learning an in-demand skill
  • Create, design, and operate with SQL databases
  • Start using MySQL – the #1 Database Management System
  • Prepare for SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
  • Adopt professionally tested SQL best practices
  • Gain theoretical insights about relational databases
  • Work with a sophisticated real-life database throughout the course
  • Get maximum preparation for real-life database management
  • Add data analytical tools to your skillset
  • Develop business intuition while solving tasks with big data
  • Study relational database management theory that you will need in your workplace every day
  • Learn how to create a database from scratch
  • The ability to take control of your dataset – insert, update, and delete records from your database
  • Be confident while working with constraints and relating data tables
  • Become a proficient MySQL Workbench user
  • Acquire top-notch coding techniques and best practices
  • Know how to answer specific business questions by using SQL’s aggregate functions
  • Handle complex SQL joins with ease
  • Approach more advanced topics in programming like SQL’s triggers, sequences, local and global variables, indexes, and more
  • Merge coding skills and business acumen to solve complex analytical problems
  • Become a proficient SQL user by writing flawless and efficient queries
  • Tons of exercises that will solidify your knowledge
  • The freedom to query anything you like from a database

Course Content

01 – Introduction to databases SQL and MySQL

  • A Message from the Professor
  • 001 – What does the course cover.mp4
    00:00
  • 002 – Why SQL.mp4
    00:00
  • 003 – Why MySQL.mp4
    00:00
  • 004 – Introduction to databases.mp4
    00:00
  • Section Quiz

02 – SQL theory

03 – Basic database terminology

04 – Installing MySQL and getting acquainted with the interface

05 – First steps in SQL

06 – MySQL constraints

07 – SQL best practices

08 – Loading the employees database

09 – SQL SELECT statement

10 – SQL INSERT statement

11 – SQL UPDATE Statement

12 – SQL DELETE Statement

13 – MySQL Aggregate functions

14 – SQL Joins

15 – SQL Subqueries

16 – SQL Self Join

17 – SQL Views

18 – Stored routines

19 – Advanced SQL Topics

20 – SQL Window Functions

21 – SQL Common Table Expressions CTEs

22 – SQL Temporary Tables

23 – Combining SQL and Tableau Introduction

24 – Combining SQL and Tableau Task 1

25 – Combining SQL and Tableau Task 2

26 – Combining SQL and Tableau Task 3

27 – Combining SQL and Tableau Task 4

28 – Combining SQL and Tableau Task 5

29 – Practice SQL 10 Final Query Questions

30 – BONUS LECTURE

Earn a certificate

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

selected template

Student Ratings & Reviews

5.0
Total 2 Ratings
5
2 Ratings
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
AK
1 month ago
best course on SQL
FZ
2 months ago
it was perfect

Want to receive push notifications for all major on-site activities?

×