Udemy

Beginners Introduction to SQL and Database Part II

Building your SQL foundation in a short amount of time!
Free tutorial
Rating: 4.6 out of 5 (78 ratings)
5,950 students
1hr 57min of on-demand video
English
English [Auto]

Introduction to Databases
Connect to MySQL
Introduction to MySQL
Beginner's SQL
SQL Joins
Data Analysis

Requirements

  • Internet Connection

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!


Who this course is for:

  • Analytics Students
  • Analysts
  • Product Managers
  • Non-technical professionals

Instructor

Analytics and Business Intelligence Professional
Oscar Valles
  • 4.3 Instructor Rating
  • 782 Reviews
  • 30,622 Students
  • 7 Courses

As Analytics and Business Intelligence professional, I've had the privilege to apply analytical, technical and business expertise across a variety of domains such Marketing, Customer Success, Research and Development, Retail and Ecommerce.


Each course that I create will be aimed at helping you focus on the key aspects of the technical skills you desire to develop for the purpose of immediate application and personal acclimation.


I'm excited that you are here because it means that you want to grow your career and I want to be the there to help. I'm happy to share my experiences so that your track to success is better than mine! I've been in your shoes and together, we will get you where you want to be.

Top companies trust Udemy

Get your team access to Udemy's top 19,000+ courses