SQL & PostgreSQL for Beginners: Become an SQL Expert

SQL & PostgreSQL for Beginners: Become an SQL Expert

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 9 Hours | 4.55 GB

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

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 2018 survey of stackoverflow developers reported that one third of developers used PostgreSQL on a daily basis in their professional lives, up from 25% in 2017. In 2019 PostgreSQL was the fastest growing database for the second year in a row. PostgreSQL experience really is a desired skill in the tech industry.

By the end of this course you will know how to:

  • Create a relational database from scratch
  • Create, alter and delete tables from a database
  • Insert, update and delete data from a table
  • Retrieve data from a database using select queries
  • Filter data using where clauses and logical operators
  • Order and limit data retrieved from a table
  • Use aggregate functions and group data to gain more meaningful insights from a database
  • Relate tables together using database relationships
  • Use SQL join queries to retrieve data from multiple tables in a single query
  • Master complex SQL subqueries
  • Apply SQL string functions to data in PostgreSQL

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.
Table of Contents

Course Introduction
1 Course Introduction
2 A Few Notes on this Course

Introduction to Databases, SQL and PostgreSQL
3 What is a Database
4 Relational Databases and SQL
5 Installing PostgreSQL for Mac
6 Installing PostgreSQL for Windows

SQL & PostgreSQL Data Definition Language – Creating Our Movie Database
7 Section Introduction
8 Creating a Junction Table
9 Modifying Tables Part 1 Adding Columns
10 Modifying Tables Part 2 Changing a Columns Data Type
11 Deleting Tables from a Database
12 Challenge Data Definition Language
13 Solution Data Definition Language
14 Section Summary
15 Database Tables
16 Data Types Explained
17 Primary Keys and Foreign Keys
18 Unique, Not Null and Check Constraints
19 Creating Our First Table
20 Creating the Actors Table
21 Creating a Table with a Foreign Key
22 Creating the Movie Revenues Table

SQL & PostgreSQL Data Manipulation Language
23 Section Introduction
24 Inserting Data into a Table
25 Updating Data in a Table
26 Deleting Data from a Table
27 Inserting Data into Our Movie Data Database
28 Challenge Data Manipulation Language
29 Solution Data Manipulation Language
30 Section Summary

SQL & PostgreSQL Retrieving Data from a Table – Select Queries
31 Section Introduction
32 Challenge 2 Select Queries
33 Solution 2 Select Queries
34 Order By
35 Limiting the Number of Results
36 Fetch
37 Distinct Values
38 Challenge 3 Select Queries
39 Solution 3 Select Queries
40 Null Values
41 Setting a Column Name Alias
42 Select Queries
43 Concatenation
44 Challenge 4 Select Queries
45 Solution 4 Select Queries
46 Section Summary
47 Where Clauses
48 Logical Operators
49 Challenge 1 Select Queries
50 Solution 1 Select Queries
51 In, Not In
52 Like
53 Between

SQL & PostgreSQL Aggregate Functions and Grouping Data
54 Section Introduction
55 Having Clauses
56 Challenge 2 Aggregate Functions
57 Solution 2 Aggregate Functions
58 Mathematical Operators
59 Section Summary
60 Aggregate Functions Explained
61 Count Aggregate Functions
62 Sum Aggregate Function
63 Min and Max Aggregate Functions
64 Average Aggregate Functions
65 Challenge 1 Aggregate Functions
66 Solution 1 Aggregate Functions
67 Grouping Data

Database Relationships
68 Section Introduction
69 What Are Database Relationships
70 One to One Relationships
71 One to Many Relationships
72 Many to Many Relationships
73 (Optional) Challenge Database Relationships
74 Solution Database Relationships
75 Section Summary

SQL & PostgreSQL Joining Tables
76 Section Introduction
77 Full Joins
78 Challenge 2 Joins
79 Solutions 2 Joins
80 Joining More Than Two Tables
81 Challenge 3 Joins
82 Solution 3 Joins
83 Union
84 Union All
85 Challenge 4 Joins
86 Solution 4 Joins
87 SQL Joins Explained
88 Intersect
89 Except
90 Challenge 5 Joins
91 Solution 5 Joins
92 Section Summary
93 Inner Joins Part 1
94 Inner Joins Part 2
95 Inner Joins Part 3
96 Challenge 1 Joins
97 Solution 1 Joins
98 Left Joins
99 Right Joins

SQL & PostgreSQL Subqueries
100 Section Introduction
101 Summary
102 Subqueries Explained
103 Uncorrelated Subqueries Part 1
104 Uncorrelated Subqueries Part 2
105 Challenge 1 Subqueries
106 Solution 1 Subqueries
107 Correlated Subqueries
108 Challenge 2 Subqueries
109 Solution 2 Subqueries

SQL & PostgreSQL String Functions
110 Section Introduction
111 Replace Function
112 Split Part Function
113 Using the Cast Operator to Apply String Functions to Non-String Data Types
114 Challenge 2 String Functions
115 Solution 2 String Functions
116 Summary
117 Cloning a Database
118 Upper and Lower String Functions
119 Initcap Function
120 Left and Right String Functions
121 Reverse Function
122 Challenge 1 String Functions
123 Solution 1 String Functions
124 Substring Function

Bonus Material
125 Course Coupons