SQL & PostgreSQL Tutorial: Become an Expert in SQL and PostgreSQL by Writing SQL Queries using PostgreSQL and PgAdmin 4.

What you'll learn

How to create a database from scratch.

Use SQL to perform data analysis.

Perform complex SQL queries using joins and subqueries.

Understand database concepts such as database relationships.

Confident putting SQL and PostgreSQL on your resume.

Requirements

No previous knowledge of SQL or PostgreSQL is needed for this course.

Description

Become an expert in SQL and PostgreSQL with this bestselling course!SQL is one of the most in-demand tech skills across many industries so learning SQL is one of the best ways to boost your career! After taking this course you will be comfortable putting SQL and PostgreSQL on your resume/CV. In the age of Big Data and Data Analysis, demand for employees with SQL skills has never been higher and will only increase in the future. Stand out from the crowd and learn SQL today. PostgreSQL is the World's most advanced open source relational database. It has a strong reputation for its reliability, data integrity and robustness. Because of this, PostgreSQL is one of the most popular and widely used database systems in the world. Companies who use PostgreSQL include Apple, Cisco, Spotify, Fujitsu, Skype, Netflix and IMDb. A 2019 survey of stackoverflow developers reported that one third of developers used PostgreSQL on a daily basis in their professional lives, up from 25% in 2018. In 2019 PostgreSQL was the fastest growing database for the third year in a row. PostgreSQL experience really is a desired skill in the tech industry. Here's what students are saying about this SQL course: Christopher says - "A really great course. The structure was well setup and the pacing was perfect. Each section and lecture flowed well in to the next. The exercises and solutions were very helpful. I was new to sql and postgresql before taking this course but I can now say that I am comfortable with both." Erin Todd says - "I love this course so far very easy to follow and interactive."Raymond Beauchamp says - "Amount of information is good for a beginner course. Was beneficial in increasing my understanding of the subject. Instructor was knowledgeable, and was easy to follow." John Hellmann says - "Very concise lectures! Was a great course overall"Abhinav Sharma says - "The explanations are really clear and the course structure is very well thought out."By the end of this course you will know how to:Create a relational database from scratchCreate, alter and delete tables from a databaseInsert, update and delete data from a table Retrieve data from a database using select queriesFilter data using where clauses and logical operators Order and limit data retrieved from a tableUse aggregate functions and group data to gain more meaningful insights from a databaseRelate tables together using database relationshipsUse SQL join queries to retrieve data from multiple tables in a single queryMaster complex SQL subqueriesApply SQL string functions to data in PostgreSQL

A step-by-step video of how to install and setup PostgreSQL is included and the setup is completely FREE.The SQL code for each video is included as a resource so you can easily access it. There are SQL exercises, and video solutions, along the way to help you improve your knowledge and SQL skills. I will be actively answering any questions you may have about the course in the Q&A section. The course will be continually updated with more sections in the future.
Watch the free preview videos and start learning SQL - one of the most important and in-demand technology skills!

Overview

Section 1: Course Introduction

Lecture 1 Course Introduction

Lecture 2 A Few Notes on this Course

Section 2: Introduction to Databases, SQL and PostgreSQL

Lecture 3 What is a Database?

Lecture 4 Relational Databases and SQL

Lecture 5 Installing PostgreSQL for Mac

Lecture 6 Installing PostgreSQL for Windows

Section 3: SQL & PostgreSQL : Data Definition Language - Creating Our Movie Database

Lecture 7 Section Introduction

Lecture 8 Database Tables

Lecture 9 Data Types Explained

Lecture 10 Primary Keys and Foreign Keys

Lecture 11 Unique, Not Null and Check Constraints

Lecture 12 Creating Our First Table

Lecture 13 Creating the Actors Table

Lecture 14 Creating a Table with a Foreign Key

Lecture 15 Creating the Movie Revenues Table

Lecture 16 Creating a Junction Table

Lecture 17 Modifying Tables Part 1: Adding Columns

Lecture 18 Modifying Tables Part 2: Changing a Columns Data Type

Lecture 19 Deleting Tables from a Database

Lecture 20 Challenge: Data Definition Language

Lecture 21 Solution: Data Definition Language

Lecture 22 Section Summary

Section 4: SQL & PostgreSQL: Data Manipulation Language

Lecture 23 Section Introduction

Lecture 24 Inserting Data into a Table

Lecture 25 Updating Data in a Table

Lecture 26 Deleting Data from a Table

Lecture 27 Inserting Data into Our Movie Data Database

Lecture 28 Challenge: Data Manipulation Language

Lecture 29 Solution: Data Manipulation Language

Lecture 30 Section Summary

Section 5: SQL & PostgreSQL : Retrieving Data from a Table - Select Queries

Lecture 31 Section Introduction

Lecture 32 Select Queries

Lecture 33 Where Clauses

Lecture 34 Logical Operators

Lecture 35 Challenge 1: Select Queries

Lecture 36 Solution 1: Select Queries

Lecture 37 In, Not In

Lecture 38 Like

Lecture 39 Between

Lecture 40 Challenge 2: Select Queries

Lecture 41 Solution 2: Select Queries

Lecture 42 Order By

Lecture 43 Limiting the Number of Results

Lecture 44 Fetch

Lecture 45 Distinct Values

Lecture 46 Challenge 3: Select Queries

Lecture 47 Solution 3: Select Queries

Lecture 48 Null Values

Lecture 49 Setting a Column Name Alias

Lecture 50 Concatenation

Lecture 51 Challenge 4: Select Queries

Lecture 52 Solution 4: Select Queries

Lecture 53 Section Summary

Section 6: SQL & PostgreSQL : Aggregate Functions and Grouping Data

Lecture 54 Section Introduction

Lecture 55 Aggregate Functions Explained

Lecture 56 Count Aggregate Functions

Lecture 57 Sum Aggregate Function

Lecture 58 Min and Max Aggregate Functions

Lecture 59 Average Aggregate Functions

Lecture 60 Challenge 1: Aggregate Functions

Lecture 61 Solution 1: Aggregate Functions

Lecture 62 Grouping Data

Lecture 63 Having Clauses

Lecture 64 Challenge 2: Aggregate Functions

Lecture 65 Solution 2: Aggregate Functions

Lecture 66 Mathematical Operators

Lecture 67 Section Summary

Section 7: Database Relationships

Lecture 68 Section Introduction

Lecture 69 What Are Database Relationships?

Lecture 70 One to One Relationships

Lecture 71 One to Many Relationships

Lecture 72 Many to Many Relationships

Lecture 73 (Optional) Challenge: Database Relationships

Lecture 74 Solution: Database Relationships

Lecture 75 Section Summary

Section 8: SQL & PostgreSQL: Joining Tables

Lecture 76 Section Introduction

Lecture 77 SQL Joins Explained

Lecture 78 Inner Joins Part 1

Lecture 79 Inner Joins Part 2

Lecture 80 Inner Joins Part 3

Lecture 81 Challenge 1: Joins

Lecture 82 Solution 1: Joins

Lecture 83 Left Joins

Lecture 84 Right Joins

Lecture 85 Full Joins

Lecture 86 Challenge 2: Joins

Lecture 87 Solutions 2: Joins

Lecture 88 Joining More Than Two Tables

Lecture 89 Challenge 3: Joins

Lecture 90 Solution 3: Joins

Lecture 91 Union

Lecture 92 Union All

Lecture 93 Challenge 4: Joins

Lecture 94 Solution 4: Joins

Lecture 95 Intersect

Lecture 96 Except

Lecture 97 Challenge 5: Joins

Lecture 98 Solution 5: Joins

Lecture 99 Section Summary

Section 9: SQL & PostgreSQL: Subqueries

Lecture 100 Section Introduction

Lecture 101 Subqueries Explained

Lecture 102 Uncorrelated Subqueries Part 1

Lecture 103 Uncorrelated Subqueries Part 2

Lecture 104 Challenge 1: Subqueries

Lecture 105 Solution 1: Subqueries

Lecture 106 Correlated Subqueries

Lecture 107 Challenge 2: Subqueries

Lecture 108 Solution 2: Subqueries

Lecture 109 Summary

Section 10: SQL & PostgreSQL: String Functions

Lecture 110 Section Introduction

Lecture 111 Cloning a Database

Lecture 112 Upper and Lower String Functions

Lecture 113 Initcap Function

Lecture 114 Left and Right String Functions

Lecture 115 Reverse Function

Lecture 116 Challenge 1: String Functions

Lecture 117 Solution 1: String Functions

Lecture 118 Substring Function

Lecture 119 Replace Function

Lecture 120 Split Part Function

Lecture 121 Using the Cast Operator to Apply String Functions to Non-String Data Types

Lecture 122 Challenge 2: String Functions

Lecture 123 Solution 2: String Functions

Lecture 124 Summary

Section 11: Bonus Material

Lecture 125 Bonus Lecture

Anyone wanting to learn SQL or PostgreSQL.,Anyone with a basic knowledge of SQL but is new to PostgreSQL.,Anyone wanting to learn more about databases.