MySQL Mastery - SQL Bootcamp

Focused View

Sanderson Labousse

1:18:24

7 View

1. MYSQL Foundation

1. Create a Database.mp4

03:32

2. Download MySQL for Windows.mp4

04:42

3.1 Bike Sales.csv

3. How to Import Data into MySQL.mp4

02:37

4. The SELECT statement.mp4

02:05

5. How to Rename a Table.mp4

01:49

6. How to Alter a Table.mp4

02:20

7. How to DROP a Column.mp4

01:17

8. The INSERT Statement.mp4

02:52

9. The WHERE Statement.mp4

02:28

10. The ORDER BY Clause.mp4

02:57

11. The LIMIT Statement.mp4

02:33

2. Functions

1. The COUNT Function.mp4

02:27

2. The AVG Function.mp4

01:20

3. The SUM Function.mp4

01:09

3. Real World Projects

1.1 Successful Movies.csv

1. Download the successful movie file.mp4

00:58

2. Import Success Movie file Into MYSQL.mp4

03:48

3. Find The 5 Highest Rated Movies.mp4

01:49

4. Test Your Knowledge.html

5. Movies That Lost Money.mp4

01:51

6. Movie category with the highest average revenue.mp4

01:43

7.1 countries world.csv

7. Create Countries Database.mp4

03:44

8. Find the SUM Total Population.mp4

01:49

9. How many countries are in each region.mp4

01:51

10. Find the average birthrate for each country around the world.mp4

02:30

4. Database Mastery

1. How to Create a Table.mp4

04:45

2. How to Insert Data Into a Table.mp4

03:36

3. How to Insert Multiple Data At Once.mp4

05:34

4. How to Add a Row with Missing Values.mp4

03:17

5. How to Update Columns in a Table.mp4

05:11

6. How to Delete Data from a Table.mp4

01:50

Description

Develop MySQL Queries For Real World Projects

What You'll Learn?

Use SQL to query a database
Use SQL to perform data analysis
Use real-world company database and query reports
Learn to perform GROUP BY statements

Who is this for?

Anyone interested in learning more about SQL, MYSQL, or basic data analysis!

What You Need to Know?

No programming experience needed. You will learn everything you need to know

More details

Description
The MySQL Mastery - SQL Bootcamp is designed in a very easy to understand way to take you from a total beginner to expert. This course is the only SQL bootcamp you'll ever need to land your dream job. In thisÂ SQL course, you'll learn how to perform complex queries to a database using one of the most in demand skills - MYSQL. These skills are also applicable to any other major SQL database, such as PostgreSQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.
Learning SQL is one of the greatest ways to increase your values in the job marketplace as it is one of the most in demand tech skills! In this course you'll learn quickly and receive challenge excercises along the way to improve your understanding!
In this course you will learn everything you need to become a SQL Pro! Including:
Get started with MySQL , the world's most popular SQL tools

Learn he basics of SQL syntax

Analyzing data using aggregate functions with GROUP BY commands

Running advanced queries with string operations and comparison operations

Learn to use logical operators to add logic flow to your SQL queries

Learn common SQL JOIN commands

Learn to create tables and databases with constraints on data entries
and much, much more!

This is course that builds you up to become a master, having you create simple table and further progress to set up complex databases throughout the course, instead of watching someone else code. Every section comes with fresh challenge questions and tasks, modeled after real world tasks and situations.
As an efficient Data Analyst, I've combined all my skills to bring you this awesome course with real world examples. You will start with the basics and soon find yourself working with advanced commands, dealing with timestamp data and variable character information like a seasoned professional.
SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skill set quickly and add SQL to your resume by joining today!

I'll see you inside the course!

Check out the free preview videos for more information!
Who this course is for:
Anyone interested in learning more about SQL, MYSQL, or basic data analysis!

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Sanderson Labousse

Instructor's Courses

I strive to be the architect of transformation, converting data-driven revelations into strategies that shape industries and redefine paradigms. I am a data analyst with a proven track record of leveraging analytical skills to extractmeaningful insights from complex datasets. Experienced in transforming raw data intoactionable recommendations, driving operational efficiency and informed decision-making. Proficient in data visualization, statistical analysis, and database management. I strive to be the architect of transformation, converting data-driven revelations into strategies that shape industries and redefine paradigms.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.