Beginners Introduction to SQL and Database Part II

Beginners Introduction to SQL and Database Part II, available at Free, has an average rating of 4.3, with 31 lectures, based on 109 reviews, and has 6984 subscribers.

Free Enroll Now

You will learn about Introduction to Databases Connect to MySQL Introduction to MySQL Beginners SQL SQL Joins Data Analysis This course is ideal for individuals who are Analytics Students or Analysts or Product Managers or Non-technical professionals It is particularly useful for Analytics Students or Analysts or Product Managers or Non-technical professionals.

Enroll now: Beginners Introduction to SQL and Database Part II

Summary

Title: Beginners Introduction to SQL and Database Part II

Price: Free

Average Rating: 4.3

Number of Lectures: 31

Number of Published Lectures: 31

Number of Curriculum Items: 31

Number of Published Curriculum Objects: 31

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

Introduction to Databases

Connect to MySQL

Introduction to MySQL

Beginners SQL

SQL Joins

Data Analysis

Who Should Attend

Analytics Students

Analysts

Product Managers

Non-technical professionals

Target Audiences

Analytics Students

Analysts

Product Managers

Non-technical professionals

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!

Course Curriculum

Chapter 1: String and Data Manipulation

Lecture 1: Welcome Back!

Lecture 2: Data Profiling

Lecture 3: Computing Averages

Lecture 4: Computing Averages: Exercise

Lecture 5: Summing Values

Lecture 6: Summing Exercise

Lecture 7: TRIM

Lecture 8: Substrings

Lecture 9: Substring Exercise

Lecture 10: LOWER

Lecture 11: UPPER

Lecture 12: LPAD and RPAD

Lecture 13: REVERSE

Lecture 14: CONCAT

Lecture 15: CONCAT Exercise

Lecture 16: Last Word Problem

Lecture 17: Last Word Solution

Chapter 2: Subqueries

Lecture 1: Subqueries

Lecture 2: Subqueries Exercise 01

Lecture 3: Subqueries Exercise 02

Lecture 4: Comparing Subqueries

Lecture 5: Creating Tables from Queries

Chapter 3: CASE Statements

Lecture 1: CASE Statements

Lecture 2: CASE Exercise

Chapter 4: Joins

Lecture 1: Joins Explained

Lecture 2: Inner Joins

Lecture 3: Left Joins

Lecture 4: Right Joins

Lecture 5: Join Exercise

Lecture 6: Subquery Joins

Lecture 7: Subquery Cartesian Join

Instructors

Oscar Valles
Analytics and Business Intelligence Professional

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 9 votes

4 stars: 50 votes

5 stars: 50 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!