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.

You will learn about Introduction to Databases Connect to MySQL Introduction to MySQL Beginner's 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
Beginner's 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!

Menu