SQL BootCamp - Learn MySQL for Data Analysis

What you'll learn:

SQL – MySQL Masterclass: Learn MySQL and Database Management

• Learn how to write MySQL queries

• How to filter the data

• Learn how to create MySQL databases

• Learn how to update MySQL databases

Requirements:

• There are no prerequisites to this class, other than a pc/mac, and a healthy appetite for learning new things

Description:

Do you want to be able to gain insights from your data? Will you like to have a competitive advantage over your peers? Do you want to be work with Databases but do not know where to start? If your answer is Yes! then this course is for you.

This mega course offers over 14 hours of content and teaches you all you need to Land that SQL data analyst Job. SQL is one of the most in demand skills of Data analysts and with this course you will learn the foundations of SQL, Database concepts and practice writing SQL queries. I have also provided quizzes after every section to help you hone your skills.

Course Outline

1. Introduction

In this section we introduce SQL and what we are going to learn

2. Environment Setup

Here we install all the tools we will use (MySQL and all the sample databases)

3. All about select

Select is the backbone of SQL. Here we practice writing select queries and also different clauses in SQL

4. Functions

Here we discuss in detail MySQL in-built functions like Date Functions, Null functions etc

5. Joins

We discuss how you can join two different tables

6. Set Operators

Here we talk about the different set operators SQL handles

7. Advanced select statements

We look in More detail at the SQL select statements

8. Modifying Data

We talk about how you can modify existing data using SQL

9. Creating Databases and Tables

Here we look at how you can create your own Databases and Tables

10. Other DDL commands

We look into Other DML commands like Drop, Truncate etc

11.Advanced SQL

Here we look at Stored procedures, Indexes, views etc

12. Bonus Section

Here I give any important information that has helped me in the field. I will always be updating this for your benefit.

This is an exciting Journey that I hope you take with me. I am not expecting you to know anything at all about SQL and will start from scratch.

Cheers!

Sandra

Who this course is for:

• Beginners Interested in Business Intelligence
• Anyone interested in Learning SQL
• Beginners interested in Data Analysis

Course Details:

• 15 hours on-demand video
• 6 coding exercises
• 5 downloadable resources
• Access on mobile and TV
• Full lifetime access
• Certificate of completion

More: SQL BootCamp - Learn MySQL for Data Analysis