Course Introduction Video

About

About This Course

Data Analysis using SQL Embark on a journey to master SQL and unlock the power of data analysis with Centora Academys 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:

Syllabus

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 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

Course Info

Lessons 187

Duration 4 - 8 months

Language English

Students 13

Certificate Certificate of Completion

Data Analysis Bootcamp Using SQL

Course Introduction Video

About This Course

Course Content

Course Info

Ratings & Reviews