IIRF Online > Development > Database Design & Development > PostgreSQL > SQL and PostgreSQL for Beginners: Become an SQL Expert
SQL and PostgreSQL for Beginners: Become an SQL Expert by Udemy
Become an Expert in SQL and PostgreSQL: Master SQL Database Querying with PostgreSQL and PgAdmin 4
Course Highlights
- 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.
Skills you will learn!
Curriculum
3 Topics
Course Introduction
Course Curriculum
A Few Notes on this Course
4 Topics
What is a Database?
Relational Databases and SQL
Installing PostgreSQL for Mac
Installing PostgreSQL for Windows
16 Topics
Section Introduction
Database Tables
Data Types Explained
Primary Keys and Foreign Keys
Unique Not Null and Check Constraints
Creating Our First Table
Creating the Actors Table
Creating a Table with a Foreign Key
Creating the Movie Revenues Table
Creating a Junction Table
Modifying Tables Part 1: Adding Columns
Modifying Tables Part 2: Changing a Columns Data Type
Deleting Tables from a Database
Challenge: Data Definition Language
Solution: Data Definition Language
Section Summary
8 Topics
Section Introduction
Inserting Data into a Table
Updating Data in a Table
Deleting Data from a Table
Inserting Data into Our Movie Data Database
Challenge: Data Manipulation Language
Solution: Data Manipulation Language
Section Summary
23 Topics
Section Introduction
Select Queries
Where Clauses
Logical Operators
Challenge 1: Select Queries
Solution 1: Select Queries
In Not In
Like
Between
Challenge 2: Select Queries
Solution 2: Select Queries
Order By
Limiting the Number of Results
Fetch
Distinct Values
Challenge 3: Select Queries
Solution 3: Select Queries
Null Values
Setting a Column Name Alias
Concatenation
Challenge 4: Select Queries
Solution 4: Select Queries
Section Summary
14 Topics
Section Introduction
Aggregate Functions Explained
Count Aggregate Functions
Sum Aggregate Function
Min and Max Aggregate Functions
Average Aggregate Functions
Challenge 1: Aggregate Functions
Solution 1: Aggregate Functions
Grouping Data
Having Clauses
Challenge 2: Aggregate Functions
Solution 2: Aggregate Functions
Mathematical Operators
Section Summary
8 Topics
Section Introduction
What Are Database Relationships?
One to One Relationships
One to Many Relationships
Many to Many Relationships
(Optional) Challenge: Database Relationships
Solution: Database Relationships
Section Summary
24 Topics
Section Introduction
SQL Joins Explained
Inner Joins Part 1
Inner Joins Part 2
Inner Joins Part 3
Challenge 1: Joins
Solution 1: Joins
Left Joins
Right Joins
Full Joins
Challenge 2: Joins
Solutions 2: Joins
Joining More Than Two Tables
Challenge 3: Joins
Solution 3: Joins
Union
Union All
Challenge 4: Joins
Solution 4: Joins
Intersect
Except
Challenge 5: Joins
Solution 5: Joins
Section Summary
10 Topics
Section Introduction
Subqueries Explained
Uncorrelated Subqueries Part 1
Uncorrelated Subqueries Part 2
Challenge 1: Subqueries
Solution 1: Subqueries
Correlated Subqueries
Challenge 2: Subqueries
Solution 2: Subqueries
Summary
15 Topics
Section Introduction
Cloning a Database
Upper and Lower String Functions
Initcap Function
Left and Right String Functions
Reverse Function
Challenge 1: String Functions
Solution 1: String Functions
Substring Function
Replace Function
Split Part Function
Using the Cast Operator to Apply String Functions to Non-String Data Types
Challenge 2: String Functions
Solution 2: String Functions
Summary
1 Topic
Bonus Lecture
SQL and PostgreSQL for Beginners: Become an SQL Expert
Related PostgreSQL Courses
Thank You!
Your review has been submitted successfully.