Afrimaven Academy - Data Analysis Bootcamp Using SQL

What you'll learn

Data Analysis using SQL

Embark on a journey to master SQL and unlock the power of data analysis with AfriMaven Academy's comprehensive course. Whether you're a beginner or an experienced professional, this course is designed to provide you with the skills and knowledge needed to succeed in the world of data.

What You'll Learn:

Create your own database or interact with existing databases.
Write complex SQL join queries across multiple tables.
Master MySQL 8 Window Functions such as LEAD, LAG, RANK, and more.
Model real-world data and generate reports using SQL.
Answer company performance or sales questions using data analysis techniques.
Learn the ins and outs of MySQL 8.x syntax for efficient data manipulation.

This course offers 21 hours of on-demand video content, supplemented with articles and downloadable resources. You'll have access to mobile and TV platforms, with full lifetime access to course materials and a certificate of completion upon finishing.

Requirements:

No Database, SQL, or MySQL experience needed! Complete beginners to MySQL are welcome.
All you need is a working computer for this course; PC, Mac, and Linux users are all welcome.
No previous programming language experience required, but basic JavaScript knowledge is beneficial.

Join thousands of students who have transformed their careers with SQL expertise. This course covers new topics including Window Functions, Views, and SQL modes, using MySQL 8.x. You'll learn how to generate reports, analyze data, and model real-world scenarios using SQL.

Why Learn SQL?

SQL is consistently ranked as one of the most in-demand skills in the business sector. Whether you work in sales, marketing, or run your own company, mastering SQL is crucial for making data-driven decisions and answering complex business questions.

Why This Course Is Different

This course goes beyond traditional SQL tutorials, providing hands-on exercises, challenges, and real-world projects to reinforce learning. With over 325 brand new videos recorded, the course offers a fresh perspective on SQL education.

Upon completing this course, you'll be equipped to interact with and query any SQL database, generate insightful reports, and integrate SQL into your applications seamlessly. Enroll today and start your journey to becoming a proficient SQL analyst!

Who this course is for:

Anyone interested in learning SQL to advance their career or transition to a new role.
Business owners, sales professionals, and marketers seeking to leverage data for decision-making.
Developers looking to build applications (e.g., social networks, e-commerce sites) using MySQL.

Start your SQL journey today and unlock the potential of data analysis!

Show More

Course Content

1 This Course Was Just Updated!

2 Join The Community!

3 Course Intro

4 About Me

5 Getting The Course Code

6 First 5 Minutes of SQL

1 Section Introduction

2 What Is A Database

3 SQL vs. MySQL

4 Installation START HERE!

5 Installation Windows Instructions

6 IMPORTANT Mac Installation Notes

7 Installation Mac Instructions

1 Section Introduction

2 Showing Databases

3 CODE Showing Databases

4 Creating Databases

5 CODE Creating Databases

6 Dropping and Using Databases

7 CODE Dropping and Using Databases

8 Introducing Tables

9 Data Types The Basics

10 Basic Datatypes Challenge

11 CODE Basic Datatypes Challenge

12 Creating Tables

13 CODE Creating Tables

14 How Do We Know It Worked

15 CODE How Do We Know It Worked

16 Dropping Tables

17 CODE Dropping Tables

18 Tables Basics Activity

19 SOLUTION Tables Basics Activity

20 MySQL Comments

1 Section Introduction

2 INSERT The Basics

3 CODE INSERT The Basics

4 A Quick Preview of SELECT

5 CODE A Quick Preview of SELECT

6 Multi-inserts

7 CODE Multi-inserts

8 INSERT Exercise

9 SOLUTION INSERT Exercise

10 Working With NOT NULL

11 CODE Working With NOT NULL

12 Sidenote Quotes In MySQL

13 Adding DEFAULT Values

14 CODE Adding DEFAULT Values

15 Introducing Primary Keys

16 CODE Introducing Primary Keys

17 Working With AUTO_INCREMENT

18 CODE Working With AUTO_INCREMENT

19 Create Table Insert Exercise

20 SOLUTION Insert Exercise

1 Section Introduction

2 Introducing CRUD

3 Getting Our New Dataset

4 CODE

5 Officially Introducing SELECT

6 CODE

7 The WHERE clause

8 CODE

9 Rapid Fire Exercises

10 Rapid Fire Exercises SOLUTION

11 SOLUTION CODE

12 Aliases

13 CODE

14 Using UPDATE

15 CODE

16 A Quick Rule Of Thumb

17 UPDATE Exercise

18 UPDATE Exercise SOLUTION

19 SOLUTION CODE

20 Introducing DELETE

22 DELETE Exercise

23 DELETE Exercise SOLUTION

1 Section Introduction

2 Introducing the CRUD Challenge

3 CRUD Challenge Solution Creating

4 SOLUTION CODE

5 CRUD Challenge Solution Reading

6 SOLUTION CODE

7 CRUD Challenge Solution Updating

8 SOLUTION CODE

9 CRUD Challenge Solution Deleting

10 SOLUTION CODE

1 Section Introduction

2 The World Of String Functions

3 Book Data (SQL)

3 Loading Our Books Data

4 CODE

5 CONCAT

6 CODE

7 SUBSTRING

8 CODE

9 Combining String Functions

10 CODE

11 Sidenote SQL Formatting

12 REPLACE

13 CODE

14 REVERSE

15 CODE

16 CHAR_LENGTH

17 CODE

18 UPPER & LOWER

19 CODE

20 Other String Functions

21 CODE

22 String Functions Exercise

23 String Functions Exerise SOLUTION

24 SOLUTION CODE

1 Section Introduction

2 Adding Some New Books

3 CODE

4 DISTINCT

5 CODE

6 ORDER BY

7 CODE

8 More On ORDER BY

9 CODE

10 LIMIT

11 CODE

12 LIKE

13 CODE

14 Escaping Wildcards

15 CODE

16 Refining Selections Exercise

17 Refining Selections Exercise SOLUTION

18 SOLUTION CODE

1 Section Introduction

2 Count Basics

3 CODE

4 GROUP BY

5 CODE

6 MIN and MAX Basics

7 CODE

8 Subqueries

9 CODE

10 Grouping By Multiple Columns

11 CODE

12 MIN and MAX With GROUP BY

13 CODE

14 SUM

15 CODE

16 AVG

17 CODE

18 Aggregate Functions Docs

19 Agg Functions Exercise

20 Agg Functions Exercise SOLUTION

21 SOLUTION CODE

1 Section Introduction

2 Surveying Other Data Types

3 CHAR vs. VARCHAR

4 INT, TINYINT, BIGINT, etc

5 DECIMAL

6 FLOAT & DOUBLE

7 DATE and TIME

8 Working With Dates

9 CODE

10 CURDATE, CURTIME, & NOW

11 CODE

12 Date Functions

13 CODE

14 Time Functions

15 CODE

16 Formatting Dates

17 CODE

18 Date Math

19 TIMESTAMPS

20 DEFAULT & ON UPDATE TIMESTAMPS

21 CODE

22 Data Types Exercise

23 Data Types Exercise SOLUTION

24 SOLUTION CODE

1 Section Introduction

2 Not Equal

3 CODE

4 NOT LIKE

5 CODE

6 Greater Than

7 CODE

8 Less Than Or Equal To

9 CODE

10 Logical AND

11 CODE

12 Logical OR

13 CODE

14 Between

15 CODE

16 Comparing Dates

17 CODE

18 The IN Operator

19 CODE

20 CASE

21 CODE

22 IS NULL

23 Exercise

24 Exercise SOLUTION

25 SOLUTION CODE

001 UNIQUE Constraint

002 CODE

003 CHECK Constraints

004 CODE

005 Named Constraints

006 CODE

007 Multiple Column Constraints

008 CODE

009 ALTER TABLE Adding Columns

010 CODE

011 ALTER TABLE Dropping Columns

012 CODE

013 ALTER TABLE Renaming

014 CODE

015 ALTER TABLE Modifying Columns

016 CODE

017 ALTER TABLE Constraints

018 CODE

1 Section Introduction

2 Data is Messy

3 Relationships Basics

4 One to Many Relationship

5 Working with FOREIGN KEY

6 CODE

7 Cross Joins

8 CODE

9 Inner Joins

10 CODE

11 Inner Joins With Group By

12 CODE

13 Left Join

14 CODE

15 Left Join With Group By

16 CODE

17 Right Join

18 CODE

19 On Delete Cascade

20 CODE

21 Joins Exercise

22 EXERCISE STARTER DATA

23 Joins Exercise SOLUTION

24 SOLUTION CODE

1 Section Introduction

2 Many to Many Basics

3 Creating Our Many To Many Tables

4 CODE

5 TV Series Challenge #1

6 CODE

7 TV Series Challenge #2

8 CODE

9 TV Series Challenge #3

10 CODE

11 TV Series Challenge #4

12 CODE

13 TV Series Challenge #5

14 CODE

15 TV Series Challenge #6

16 CODE

17 TV Series Challenge #7

18 CODE

1 Introducing Views

2 CODE

3 Updateable Views

4 ReplacingAltering Views

5 CODE

6 HAVING clause

7 CODE

8 WITH ROLLUP

9 CODE

10 SQL Modes Basics

11 CODE

12 STRICT_TRANS_TABLES

13 More Modes

1 Important Note (please read)

2 Introducing Window Functions

3 Using OVER()

4 CODE

5 PARTITION BY

6 CODE

7 ORDER BY with Windows

8 CODE

9 RANK()

10 DENSE_RANK, & ROW_NUMBER()

11 CODE

12 NTILE()

13 CODE

14 FIRST_VALUE

15 CODE

16 LEAD and LAG

17 CODE

1 Section Introduction

2 IMPORTANT NOTE ABOUT THIS SECTION!

3 Introducing Instagram Clone

4 Users Schema

5 CODE

6 Photos Schema

7 CODE

8 Comments Schema

9 CODE

10 Likes Schema

11 CODE

12 Followers Schema

13 CODE

14 Note!

15 3 Approaches for Hashtags

16 Implementing Hashtags Table

17 CODE

18 Complete Instagram Schema

1 Section Introduction

2 Getting Lots of Instagram Data

3 CODE

4 Instagram Challenge #1

5 CODE

6 Instagram Challenge #2

7 CODE

8 Instagram Challenge #3

9 CODE

10 Instagram Challenge #4

11 CODE

12 Instagram Challenge #5

13 CODE

14 Instagram Challenge #6

15 CODE

16 Instagram Challenge #7

17 CODE

ig-clone-data

Course Comments

Please sign up or log into your account to submit and view comments.

Enrolled3
Lectures383
LanguageEnglish
Duration4 - 8 months
CertificateYes
Pass Percentage70 %

Show More

Copyright © - Afrimaven Academy - 2025 - All Rights Reserved