The Complete SQL For Absolute Beginners Course

The Complete SQL For Absolute Beginners Course, available at $94.99, has an average rating of 4.53, with 70 lectures, 40 quizzes, based on 237 reviews, and has 1580 subscribers.

You will learn about Manipulate Data using SQL How to Create Tables How to Insert Data into Tables How to Combine Different Tables How to Build Tables using a practical Case Study This course is ideal for individuals who are Data Analysts or Data Scientists or Data Engineers or Full Beginners that want to learn how to work with SQL or Marketing, Finance and Supply Chain Professionals or IT Professionals It is particularly useful for Data Analysts or Data Scientists or Data Engineers or Full Beginners that want to learn how to work with SQL or Marketing, Finance and Supply Chain Professionals or IT Professionals.

Enroll now: The Complete SQL For Absolute Beginners Course

Summary

Title: The Complete SQL For Absolute Beginners Course

Price: $94.99

Average Rating: 4.53

Number of Lectures: 70

Number of Quizzes: 40

Number of Published Lectures: 70

Number of Published Quizzes: 39

Number of Curriculum Items: 110

Number of Published Curriculum Objects: 109

Original Price: 54.99

Quality Status: approved

Status: Live

What You Will Learn

Manipulate Data using SQL

How to Create Tables

How to Insert Data into Tables

How to Combine Different Tables

How to Build Tables using a practical Case Study

Who Should Attend

Data Analysts

Data Scientists

Data Engineers

Full Beginners that want to learn how to work with SQL

Marketing, Finance and Supply Chain Professionals

IT Professionals

Target Audiences

Data Analysts

Data Scientists

Data Engineers

Full Beginners that want to learn how to work with SQL

Marketing, Finance and Supply Chain Professionals

IT Professionals

So, you’ve decided that you want to learn SQL or you want to get familiar with it, but don’t know where to start? Or are you a data/business analyst or data scientist that wants to power up your data skills by performing queries with Structured Query Language?

Then, this course was designed just for you!

This course was designed to be your first step into the SQL programming world! We will delve deeper into the concepts of SQL queries, understand the MySQL user interface and play around with several datasets. This course contains lectures around the following groups: 

1. Code along lectures where we will go step-by-step in each instruction, compounding our SQL knowledge.

2. Test your knowledge with questions and practical exerciseswith different levels of difficulty!

3. Analyze real datasetsand understandthe thought process from question to SQL code solution!

This course was designed to be focused on the practical side of coding in SQL – instead of teaching you every possible function out there, we’ll learn all the fundamentals slowly and build our knowledge from scratch. We’ll use a case study to cement every concept we will learn, so that you can have a hands-on learning process, making it easier to apply the concepts in your projects.

At the end of the course you should be able to use SQL to build and manipulate tables. Along the way we will also learn the most important SQL statements such as GROUP BY, INSERT INTO or CREATE TABLE.

Here are some examples of things you will be able to do after finishing the course:

Join different tablesusing SQL;

Create your own tables with the appropriate structure.

Use different data types according to their characteristics.

Create columnsusing data available from your existing tables.

Use subqueries, building complex instructions.

Join thousands of professionals and students in this SQL journey and discover the amazing power of this querying language.

This course will be constantly updated based on students feedback.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Course Materials

Chapter 2: Installing MySQL and Loading the Sakila DataBase

Lecture 1: Installing MySQL Server and Workbench

Lecture 2: Installing MySQL On Mac

Lecture 3: [Windows] – Starting MYSQL Server from Scratch

Lecture 4: Setting up the Sakila Database

Chapter 3: Basic Querying

Lecture 1: Basic Select Statements

Lecture 2: Column and Table Aliases

Lecture 3: Table Filtering – Simple Filters

Lecture 4: Table Filtering – Multiple Filters, AND and OR

Lecture 5: Table Filtering – Other Concepts

Lecture 6: Creating New Columns – Same Value for all Rows

Lecture 7: Creating New Columns – Using Functions and Existing Columns

Lecture 8: Creating New Columns – Mathematical Expressions

Lecture 9: Query Clauses – Group By

Lecture 10: Query Clauses – Having

Lecture 11: Query Clauses – Order By

Lecture 12: [Case Study] – Basic Querying

Lecture 13: [Case Study] – Code Along Solutions

Lecture 14: Tutorial on [Coding Exercises]

Chapter 4: Data Types

Lecture 1: Data Types – Integers

Lecture 2: Data Types – Decimals/Floats

Lecture 3: Data Types – Text and Characters

Lecture 4: Data Types – Dates

Lecture 5: Data Types – Implicit Conversions

Lecture 6: Data Types – Explicit Conversions

Lecture 7: [Case Study] – Data Types

Lecture 8: [Case Study] – Code Along Solutions

Chapter 5: Creating and Modifying Tables

Lecture 1: Create Database Command

Lecture 2: Creating Tables

Lecture 3: Inserting Data into a Table

Lecture 4: Inserting Multiple Rows and Inserting Into Specific Columns

Lecture 5: Common Pitfalls when Inserting Data

Lecture 6: Deleting Data and Tables

Lecture 7: Alter Table – Changing and Modifying Tables

Lecture 8: [Case Study] – Creating and Modifying Tables

Lecture 9: [Case Study] – Code Along Solutions

Lecture 10: Detail on the Udemy Platform Coding Exercises

Chapter 6: Combining Tables

Lecture 1: Table Join Example

Lecture 2: Inner Join Explanation

Lecture 3: Left and Right Join Explanation

Lecture 4: Multiple Key Joins – Composite Key Definition

Lecture 5: Multiple Key Joins – Explanation and Syntax

Lecture 6: Union and Union All

Lecture 7: [Case Study] – Combining Tables

Lecture 8: [Case Study] – Code Along Solutions

Chapter 7: More on Select Statements

Lecture 1: SubQueries Introduction

Lecture 2: More on SubQueries

Lecture 3: Combining Insert Into and Select Statements

Lecture 4: Insert Into and Select with Multiple Columns

Lecture 5: [Case Study] – More on Select Statements

Lecture 6: [Case Study] – Code Along Solutions

Chapter 8: Updating Information on Tables

Lecture 1: Update -> Set -> Where Sequence

Lecture 2: Updating Tables with Multiple Conditions

Lecture 3: Updating Multiple Columns and Where Clause Warning

Lecture 4: [Case Study] – Updating Information on Tables

Lecture 5: [Case Study] – Code Along Solutions

Chapter 9: Advanced Filtering

Lecture 1: The NOT Clause

Lecture 2: Filtering – Order of Operations

Instructors

Ivo Bernardo
Partner and Senior Data Scientist @ Daredata Engineering

Rating Distribution

1 stars: 2 votes

2 stars: 4 votes

3 stars: 15 votes

4 stars: 87 votes

5 stars: 129 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!