The Complete SQL Bootcamp: Go from Zero to Hero by Udemy
Become an expert at SQL!
Course Highlights
- Use SQL to query a database
- Use SQL to perform data analysis
- Be comfortable putting SQL and PostgreSQL on their resume
- Learn to perform GROUP BY statements
- Replicate real-world situations and query reports
Skills you will learn!
Curriculum
8 Topics
Welcome Message
Introduction
Course Curriculum Overview
Overview of Databases
Course FAQs
Windows Installation - PostGreSQL and PgAdmin with Database Setup
MacOS Installation - PostgreSQL and PgAdmin with First Query
pgAdmin Overview
18 Topics
Overview of Challenges!
SQL Cheat Sheet
SQL Statement Fundamentals
SELECT Statement
Challenge: SELECT
SELECT DISTINCT
Challenge: SELECT DISTINCT
COUNT
SELECT WHERE - Part One
SELECT WHERE - Part Two
Challenge: SELECT WHERE
ORDER BY
LIMIT
Challenge: ORDER BY
BETWEEN
IN
LIKE and ILIKE
General Challenge 1
7 Topics
Introduction to GROUP BY
Aggregation Functions
GROUP BY - Part One
GROUP BY - Part Two
GROUP BY - Challenge
HAVING
HAVING - Challenge Tasks
3 Topics
Overview of Assessment Test 1
Assessment Test 1
Solutions to Assessment Test 1
9 Topics
Overview of JOINS
Introduction to JOINs
AS Statement
Inner Joins
Full Outer Joins
Left Outer Join
Right Joins
UNION
JOIN Challenge Tasks
9 Topics
Overview of Advanced SQL Commands
Timestamps and Extract - Part One
Timestamps and Extract - Part Two
Quick Note on TO_CHAR
Timestamps and Extract - Challenge Tasks
Mathematical Functions and Operators
String Functions and Operators
SubQuery
Self-Join
4 Topics
READ ME FIRST PLEASE
Setting up New Database for Assessment Exercises
Assessment Test 2
Solutions to Assessment Test 2
11 Topics
Introduction to Section
Data Types
Primary Keys and Foreign Keys
Constraints
CREATE Table
INSERT
UPDATE
DELETE
ALTER Table
DROP Table
CHECK Constraint
2 Topics
Assessment Test 3
Solutions to Assessment Test 3
8 Topics
Conditional Expressions and Procedures Introduction
CASE
CASE - Challenge Task
COALESCE
CAST
NULLIF
Views
Import and Export
3 Topics
Overview of Python and PostgreSQL
Psycopg2 Example Usage
Psycopg2 Resources
1 Topic
Bonus Lecture
The Complete SQL Bootcamp: Go from Zero to Hero
Related SQL Courses
Thank You!
Your review has been submitted successfully.