This ‘Learn SQL Using PostgreSQL: From Zero to Hero’ Udemy course will give you an in-depth knowledge of PostgreSQL. In this course, you will learn basics to advanced features like triggers, PL/pgSQL functions, Window Functions and CTE.
The course contains 182 lectures and 16 hours of on-demand content. The course is usually available for INR 2,499 on Udemy but you can click on the link and get the ‘Learn SQL Using PostgreSQL: From Zero to Hero’ for INR 499.
Who all can opt for this course?
- Someone who wants to become proficient in SQL and PostgreSQL.
- Anyone who wants to understand sophisticated query expressions.
Course Highlights
| Key Highlights | Details |
|---|---|
| Registration Link | Apply Now! |
| Price | INR 499 ( |
| Duration | 16 Hours |
| Rating | 4.6/5 |
| Student Enrollment | 16,270 students |
| Instructor | Will Bunker https://www.linkedin.com/in/willbunker |
| Topics Covered | PostgreSQL, PL/pgSQL Functions, Window Functions, CTE |
| Course Level | Beginner |
| Total Student Reviews | 2,863 |
Learning Outcomes
- Run advanced searches.
- Glue tables together.
- To respond to queries about aggregated date, use Group By.
- Altering and making new tables.
- To speed up searches, create indexes.
- Add restrictions to keep the data organised.
- Use the pgAdmin tool.
- Study recursive search methods.
- How perspectives simplify data access.
- Subqueries.
- Standard Table Expressions.
- Expressions with conditions.
- Window Services.
- How to manage time and date information.
- Functions in SQL.
- Managing concurrency and transactions.
- Functions in PL/pgSQL.
- Triggers.
- Types of Composite Data.
- Data Types for Arrays.
Course Content
| S.No. | Module (Duration) | Topics |
|---|---|---|
| 1. | Introduction (05 minutes) | Introduction |
| 2. | Installing PostgreSQL and pgAdmin (18 minutes) | Installing PostgreSQL on Mac |
| Installing PostgreSQL on Windows | ||
| Installing PostgreSQL on Ubuntu | ||
| Install Northwind Database | ||
| Install Some Additional Databases. | ||
| 3. | Simple Selection of All Records (13 minutes) | Selecting All Data From a Table |
| Selecting Specific Fields | ||
| Selecting Distinct Values | ||
| Counting Results | ||
| Combining Fields in SELECT | ||
| Practice What You’ve Learned | ||
| 4. | Using WHERE to Select Records (21 minutes) | What If You Don’t Want All Records |
| Searching For Specific Text | ||
| Searching Numeric Fields | ||
| Searching Date Fields | ||
| WHERE Using Logical AND Operator | ||
| WHERE Using Logical OR Operator | ||
| WHERE Using Logical NOT Operator | ||
| WHERE Combining AND, OR, and NOT | ||
| Using BETWEEN | ||
| Using IN | ||
| Practice What You’ve Learned | ||
| 5. | Schemas (03 minutes) | Schema Basics |
| 6. | Using psql To Connect To Postgres (13 minutes) | Connecting With psql |
| Eliminate Typing Connection Parameters | ||
| Databases In psql | ||
| Schemas In psql | ||
| 7. | Intermediate SELECT Statements (21 minutes) | ORDER BY |
| Using MIN and MAX Functions | ||
| Using AVG and SUM | ||
| LIKE to Match Patterns | ||
| Renaming Columns With Alias | ||
| LIMIT to Control Number of Records Returned | ||
| NULL Values | ||
| Practice What You’ve Learned | ||
| 8. | Joining multiple tables together (36 minutes) | Diagramming Table Relationships |
| Grabbing Information From Two Tables | ||
| Grabbing Information From Multiple Tables | ||
| Left Joins | ||
| Right Joins | ||
| Full Joins | ||
| Self Joins | ||
| USING To Reduce Typing | ||
| Even Less Typing With NATURAL | ||
| Practice What You’ve Learned | ||
| 9. | Grouping and Aggregation Functions (34 minutes) | Group By |
| Use HAVING to Filter Groups | ||
| Grouping Sets | ||
| Rollup | ||
| Cube – Rollup On Steroids | ||
| 10. | Combining Queries (11 minutes) | Union |
| Intersect | ||
| Except | ||
| 11. | Subqueries (16 minutes) | Subquery Using EXISTS |
| Subquery Using ANY and ALL | ||
| IN Using Subquery | ||
| 12. | Modifying Data In Tables: INSERT, UPDATE and DELETE (27 minutes) | INSERT INTO |
| UPDATE | ||
| DELETE | ||
| SELECT INTO | ||
| INSERT INTO SELECT | ||
| Returning Data From Update, Delete, and Insert | ||
| 13. | Indexes and Performance Tuning (58 minutes) | What Are Indexes? |
| CREATE INDEX | ||
| DROP INDEX | ||
| How To Kill Runaway Queries | ||
| Using Explain To See Query Plan | ||
| Use Analyze To Update Table Statistics | ||
| How Is Query Plan Cost Calculated | ||
| Using Indexes On More Than One Field | ||
| Expression Indexes | ||
| Types Of Indexes | ||
| Speeding Up Text Matching | ||
| 14. | Database Design and Normalization (54 minutes) | Design Process Overview |
| Database Terminology | ||
| A Design Process | ||
| Finding Mission Statement And Ojectives | ||
| Analyzing Current Systems | ||
| Create Table Structure | ||
| Establishing Keys | ||
| Specifying Fields | ||
| Relationships Between Tables | ||
| Business Rules | ||
| Establish Needed Views | ||
| Double Checking Data Integrity | ||
| 15. | Creating and Modifying Tables (23 minutes) | CREATE TABLE |
| ALTER TABLE – Part One | ||
| ALTER TABLE – Part Two | ||
| ALTER TABLE – Part Three | ||
| DROP TABLE | ||
| 16. | Table Constraints (44 minutes) | NOT NULL Constraint |
| UNIQUE Constraint | ||
| PRIMARY KEY Constraint | ||
| FOREIGN KEY Constraint | ||
| CHECK Constraint | ||
| DEFAULT Values | ||
| Changing a Column’s Default Value | ||
| Adding and Removing a Column’s Constraint | ||
| 17. | Sequences (24 minutes) | Create A Sequence |
| Alter and Delete Sequences | ||
| Using Serial Datatypes | ||
| 18. | CTE – Common Table Expressions (25 minutes) | WITH Queries |
| Using CTE to Grab Identity Field From Insert | ||
| Creating Hierarchical Data To Use For Recursive WITH Queries | ||
| Using Recursion in CTEs | ||
| 19. | Views (30 minutes) | Views – How To Create |
| Views – How To Modify | ||
| Creating Updatable Views | ||
| With Check Option | ||
| Deleting Views | ||
| 20. | Conditional Expressions (17 minutes) | CASE WHEN |
| COALESCE | ||
| NULLIF | ||
| 21. | Using Date/Time In PostgreSQL (50 minutes) | Date, Time, and Timestamp Data Types |
| Time Zones | ||
| Interval Data Type | ||
| Date Arithmetic | ||
| Pulling Out Parts of Dates and Times | ||
| Converting One Data Type Into Another | ||
| 22. | Window Functions (29 minutes) | Basic Window Function Example |
| Using Window Functions With Subqueries | ||
| Using Rank() To Find The First N Records In Join | ||
| 23. | Composite Types (16 minutes) | Composite Type Basics |
| Using Composite Types | ||
| 24. | SQL Functions and Procedures (01 hour 05 minutes) | Write Your First Function |
| Write A Function That Returns A Single Value | ||
| Functions With Parameters | ||
| Functions That Have Composite Parameters | ||
| Functions That Return A Composite | ||
| Functions With Output Parameters | ||
| Functions With Default Values | ||
| Using Functions as Table Source | ||
| Functions That Return More Than One Row | ||
| Procedures – Functions That Don’t Return Anything | ||
| 25. | Transactions And Concurrency Control (22 minutes) | ACID Transactions |
| Simple Transaction Control | ||
| Rollbacks & Savepoints | ||
| SQL Transaction Isolation | ||
| PostgreSQL Transaction Isolation | ||
| 26. | Array Data Type (28 minutes) | Declaring Arrays |
| Inputting Array Values | ||
| Accessing Arrays | ||
| Modifying Arrays | ||
| Searching Arrays | ||
| Array Operators | ||
| 27. | PL/pgSQL – SQL Procedural Language (01 hour 18 minutes) | Build Your First PL/pgSQL Function |
| Handling Functions With Output Variables | ||
| Returning Query Results | ||
| Declaring Variables | ||
| Looping Through Query Results | ||
| Using If-Then Statements | ||
| Returning Query Results Continued | ||
| Loop and While Loops | ||
| Looping Over Array Elements | ||
| 28. | Triggers (32 minutes) | Build Your First Trigger |
| Statement Triggers | ||
| 29. | Importing CSV (13 minutes) | Importing CSV |
| Practice What You’ve Learned | ||
| 30. | JSON and JSONB Data Types (57 minutes) | What Is JSON And How To Store In Database |
| Create JSON From Tables | ||
| Aggregating JSON Fields | ||
| Building airports_json Table | ||
| Selecting Information Out of JSON Fields | ||
| Searching JSON Data | ||
| Updating And Deleting Information Inside JSON Fields | ||
| 31. | Managing Databases (06 minutes) | CREATE DATABASE |
| DROP DATABASE | ||
| 32. | Backups and Recovery (19 minutes) | Basic Import/Export With Copy |
| Basic pg_dump And Restore | ||
| Custom Format Dumps | ||
| 33. | Security Using Roles, Users and Permissions (31 minutes) | Overview of Roles and Users |
| Instance Level Security | ||
| Database Level Security | ||
| Schema Level Security | ||
| Table Level Security | ||
| Column Level Security | ||
| Row Level Security | ||
| 34. | Introduction To PostGIS (19 minutes) | Install PostGIS on Ubuntu (Not needed for Windows/Mac) |
| Converting Airport Data | ||
| Your First Geographical Query | ||
| 35. | Thanks and Good Luck (26 seconds) | Thank you |
Resources Required
- Simple computing abilities
- Being able to install software on a computer
- Computer with PostgreSQL support
Featured Review
Matt Hoyt (5/5) : The instruction pace, while deliberate, is just about ideal for learning. I really appreciate the instructor leaving their mistakes in the video instead of editing them out.
Pros
- Clay Raynor (4/5) : This is a great course for those who are looking for an introduction to SQL.
- Julien Thomazeau (5/5) : Started from “I think I know quite a lot already” to “I think there is even more that what I’ve learned” Excellent course, it pushed me to go deeper in Postgres documentation and underlying concepts.
- Jairo Suarez (4/5) : Excellent content for freshers on SQL command line; I thought that I’d found more “homeworks” between exercises.
- Adarsh Johari (5/5) : Query:- SELECT feedback FROM postgresql_learnings; 🙂 RESULT:- Awesome course and good study material.
Cons
- Lee S. (1/5) : Just a re-hash of the online documentation, no additional insights beyond what’s there.
- Khoa H. (1/5) : Some options are out dated. And lecture doesn’t provide shortcuts from people learning on windows
- Christopher K. (1/5) : This should be titled something like ‘Stuff about SQL – just happen to be using PostgreSQL’
- Sahil T. (1/5) : Horrible audio quality in 2x, broken.
About the Author
The instructor of this course is Will Bunker who is a Cofounder of bootstrapped company that became Match.com. With 4.3 Instructor Rating and 3,027 Reviews on Udemy, Will Bunker offers 2 Courses and has taught 22,810 Students so far.
- In the early 1990s, Dave Kennedy and Will Bunker launched the biggest dating site in the world from a phone closet at an insurance business.
- Will Bunker learned how to create a website from scratch, and by 1999 it was among the top 100 visited websites.
- Since then, Will Bunker invested in more than 160 digital startups and helped launch a number of more enterprises.
- Will Bunker has taught scores of people how to use technology to solve real-world problems and establish their own businesses.
- As your business succeeds, Will Bunker is going to put together a series of courses that will cover everything from prototyping to constructing an MVP to scaling into the cloud.
Comparison Table
| Parameters | Learn SQL Using PostgreSQL: From Zero to Hero | Complete beginners introduction to SQL | SQL & PostgreSQL for Beginners: Become an SQL Expert |
|---|---|---|---|
| Offers | INR 499 ( | INR 455 ( | INR 455 ( |
| Duration | 16 hours | 4.5 hours | 9 hours |
| Rating | 4.6/5 | 4.5/5 | 4.6/5 |
| Student Enrollments | 16,269 | 1,979 | 28,718 |
| Instructors | Will Bunker | Bluelime Learning Solutions | Jon Avis – SQL Instructor |
| Register Here | Apply Now! | Apply Now! | Apply Now! |
Leave feedback about this