Beginners Introduction to SQL and Database Part II

Building your SQL foundation in a short amount of time!

4.40 (107 reviews)
Udemy
platform
English
language
Other
category
instructor
Beginners Introduction to SQL and Database Part II
6,592
students
2 hours
content
Jul 2021
last update
FREE
regular price

What you will learn

Introduction to Databases

Connect to MySQL

Introduction to MySQL

Beginner's SQL

SQL Joins

Data Analysis

Description

This is a continuation of our first course, Beginner's Introduction to SQL and Databases, where we set out to create a foundation for data manipulation and data analysis using SQL. If you are new to data analysis and are looking to work with large volumes of data in an efficient and sophisticated way, this is the course for you!

In this course, we continue complete our SQL education using examples and exercises in:

  • Data and String Manipulation

    • String Functions covered such as substring, lpad and rpad, and more that will help you deal with text data

  • Data Aggregation

    • We take our aggregations to the next level by introduction GROUP BY

  • Data Profiling

    • We cover the importance of data profiling for the purpose of understanding, interpreting and communicating information about your data effectively

  • Sub Queries

    • We introduce sub queries and provide a number of scenarios on where to use sub queries

  • Case Statements

    • A necessary part of your SQL toolkit, CASE statements enable us to customize our analysis using SQL

  • Joins

    • Joins are a very foundational part of data analysis. We cover the different types of joins, provide examples and work through challenging exercises that will help you become comfortable with joins

Are you excited about your future in Analytics, Business Intelligence or Data Analysis! You should be, because after this course you'll have a foundation for success!


Content

String and Data Manipulation

Welcome Back!
Data Profiling
Computing Averages
Computing Averages: Exercise
Summing Values
Summing Exercise
TRIM
Substrings
Substring Exercise
LOWER
UPPER
LPAD and RPAD
REVERSE
CONCAT
CONCAT Exercise
Last Word Problem
Last Word Solution

Subqueries

Subqueries
Subqueries Exercise 01
Subqueries Exercise 02
Comparing Subqueries
Creating Tables from Queries

CASE Statements

CASE Statements
CASE Exercise

Joins

Joins Explained
Inner Joins
Left Joins
Right Joins
Join Exercise
Subquery Joins
Subquery Cartesian Join

Reviews

Rich
June 14, 2023
Very easy to learn and follow along at whatever speed you need to understand the material presented. Would highly recommend.
Indrė
May 22, 2022
very nice video, just one thing: in 16 video it was needed to use locate, that wasn't described before
Ira
May 8, 2022
This course is well structured. It will be good for people who are new to SQL, and also for people with intermediate levels, to structure their knowledge. Thank you for such a nice course.

Charts

Price

Beginners Introduction to SQL and Database Part II - Price chart

Rating

Beginners Introduction to SQL and Database Part II - Ratings chart

Enrollment distribution

Beginners Introduction to SQL and Database Part II - Distribution chart
4215372
udemy ID
8/1/2021
course created date
8/2/2021
course indexed date
Bot
course submited by