Job-Ready SQL in an Afternoon

Job-Ready SQL in an Afternoon, available at $64.99, has an average rating of 4.8, with 45 lectures, based on 60 reviews, and has 408 subscribers.

You will learn about Understand SQL databases Understand the relational model Learn to insert data into SQL databases Extract data from SQL databases Write complex queries to perform tasks like as required in technical interviews or on the job This course is ideal for individuals who are Anyone who wants to learn about database or Anyone who wants to integrate databases into their code or Anyone who wants to learn about SQL databases It is particularly useful for Anyone who wants to learn about database or Anyone who wants to integrate databases into their code or Anyone who wants to learn about SQL databases.

Enroll now: Job-Ready SQL in an Afternoon

Summary

Title: Job-Ready SQL in an Afternoon

Price: $64.99

Average Rating: 4.8

Number of Lectures: 45

Number of Published Lectures: 45

Number of Curriculum Items: 45

Number of Published Curriculum Objects: 45

Original Price: 114.99

Quality Status: approved

Status: Live

What You Will Learn

Understand SQL databases

Understand the relational model

Learn to insert data into SQL databases

Extract data from SQL databases

Write complex queries to perform tasks like as required in technical interviews or on the job

Who Should Attend

Anyone who wants to learn about database

Anyone who wants to integrate databases into their code

Anyone who wants to learn about SQL databases

Target Audiences

Anyone who wants to learn about database

Anyone who wants to integrate databases into their code

Anyone who wants to learn about SQL databases

SQL is the language that you can use to interact with one major database type (SQL databases), one that is very wide-spread in today’s world. 

Knowing SQL will give you a nice ability and understanding of how to handle data and databases, and being able to integrate it into Python code enables you to create great, dynamic, and automatic systems that combine the power of programming and data.

In this course we’ll be learning SQL. We’ll start by going through some fundamental knowledge like learning about the relational model, as well as what schemas are, the different data types available, and how database tables are organized. Then we’ll go ahead and set up our own local Postgres database and populate it with data so that we have data to run queries against. Once our setup is done we’re then ready to directly jump into writing SQL code.

We’ll start with the basics like creating databases and tables, inserting and selecting data, and performing filtering and result ordering. This way we can make sure we’re comfortable with how the data is laid out and that we feel good performing the basic operations that usually make up all queries.

Then we’ll jump deeper into SQL by learning about aggregations, subqueries, joins, unions, and window functions.

By the end of this course you should be ready to successfully apply your SQL knowledge in both technical interviews as well as on the job.

Course Curriculum

Chapter 1: Fundamentals and Setup

Lecture 1: Intro to Relational Databases

Lecture 2: Data Types and Schemas

Lecture 3: [Mac] Setting Up a Local PostgreSQL Server

Lecture 4: [Windows] Setting Up a Local PostgreSQL Server

Lecture 5: [Mac] SQL Editor Postico

Lecture 6: SQL Editor DataGrip

Lecture 7: SQL Editor CLI

Lecture 8: Creating and Removing a Database

Chapter 2: Databases, Tables, and Basic Queries

Lecture 1: Creating Schemas

Lecture 2: Creating Tables

Lecture 3: Altering Tables

Lecture 4: Enumerated Types

Lecture 5: Inserting Values

Lecture 6: Running an SQL Script

Lecture 7: Reading Data

Lecture 8: Creating Tables Using Query Results

Lecture 9: Aliases and Ordering

Chapter 3: Conditionals and Arithmetics

Lecture 1: Conditional Filtering Direct Comparisons

Lecture 2: Conditional Filtering Grouped Comparisons

Lecture 3: Joining Conditionals

Lecture 4: Negating Conditionals

Lecture 5: Filtering Null Values

Lecture 6: Creating New Columns and Arithmetics

Lecture 7: Datatype Conversions

Lecture 8: Logic Statements

Chapter 4: Dates, Times, and Manipulating Data

Lecture 1: Manipulating Strings

Lecture 2: String Positional Information

Lecture 3: String Subsets and Concatenations

Lecture 4: String Replacements

Lecture 5: Date and Time

Lecture 6: Date and Time Intervals

Lecture 7: Comments

Lecture 8: Aggregation Functions

Lecture 9: Grouping and Filtering Aggregations

Chapter 5: Joins, Unions, and Subqueries

Lecture 1: Inner Join

Lecture 2: Left, Right, and Outer Joins

Lecture 3: Self Joins

Lecture 4: Unions

Lecture 5: Subqueries

Lecture 6: CTEs

Chapter 6: Window Functions

Lecture 1: Window Functions and Aliases

Lecture 2: Row Numbers and Ranks

Lecture 3: Using Other Rows with Window Functions

Lecture 4: NTiles

Lecture 5: Understanding Query Performance

Instructors

Max S
Data Engineer

Rating Distribution

1 stars: 3 votes

2 stars: 2 votes

3 stars: 8 votes

4 stars: 16 votes

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