The ‘The Complete SQL Bootcamp: Go from Zero to Hero Course’ is taught by Jose Portilla. He has years of experience in teaching Data Science and Python programming to employees working at big MNCs including Cigna, The New York Times, McKinsey, and Credit Suisse. The course primarily focuses on PostgreSQL but the skills learned can also be applied to other databases such as MySQL, Oracle, Microsoft SQL, etc.

The course covers topics such as PostgreSQL, PgAdmin, SQL syntax, SQL JOIN commands, and more. The course is usually available for INR 3,399 on Udemy but students can click on the link and get the ‘The Complete SQL Bootcamp: Go from Zero to Hero Course’ for INR 449.

Who all can opt for this course?

Anybody wants to learn more about SQL, PostgreSQL, or the fundamentals of data analysis.

Course Highlights

Key HighlightsDetails
Registration LinkApply Now!
PriceINR 449 (INR 3,39987% off
Duration9 hours
Student Enrollment6,47,319 students
InstructorJose Portilla https://www.linkedin.com/in/joseportilla
Topics CoveredPostgreSQL, PgAdmin, SQL syntax, GROUP BY commands, SQL JOIN commands, etc.
Course LevelBeginner
Total Student Reviews1,67,128

Learning Outcomes

  • Use SQL for database query
  • Do data analysis using SQL
  • Understand how to use GROUP BY statements
  • Recreate actual circumstances and run reports

Course Content

S.No.Module (Duration)Topics
1.Course Introduction (01 hour 07 minutes)Welcome Message
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
2.SQL Statement Fundamentals (01 hour 37 minutes)Overview of Challenges!
SQL Cheat Sheet
SQL Statement Fundamentals
SELECT Statement
Challenge: SELECT
Challenge: ORDER BY
General Challenge 1
3.GROUP BY Statements (40 minutes)Introduction to GROUP BY
Aggregation Functions
GROUP BY – Part One
GROUP BY – Part Two
GROUP BY – Challenge
HAVING – Challenge Tasks
4.Assessment Test 1 (01 minute)Overview of Assessment Test 1
Assessment Test 1
Solutions to Assessment Test 1
5.JOINS (01 hour 08 minutes)Overview of JOINS
Introduction to JOINs
AS Statement
Inner Joins
Full Outer Joins
Left Outer Join
Right Joins
JOIN Challenge Tasks
6.Advanced SQL Commands (01 hour 01 minutes)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
7.Assessment Test 2 (32 minutes)READ ME FIRST PLEASE
Setting up New Database for Assessment Exercises
Assessment Test 2
Solutions to Assessment Test 2
8.Creating Databases and Tables (01 hour 17 minutes)Introduction to Section
Data Types
Primary Keys and Foreign Keys
DROP Table
CHECK Constraint
9.Assessment Test 3 (01 minute)Assessment Test 3
Solutions to Assessment Test 3
10.Conditional Expressions and Procedures (01 hour 10 minutes)Conditional Expressions and Procedures Introduction
CASE – Challenge Task
Import and Export
11.Extra: PostgreSQL with Python (11 minutes)Overview of Python and PostgreSQL
Psycopg2 Example Usage
Psycopg2 Resources
12.BONUS SECTION: THANK YOU! (10 seconds)Bonus Lecture

Resources Required

No prior technical knowledge is necessary. All students need is a PC and a stable internet connection.

Featured Review

John P Keldon (5/5): Starting out in this course is looking good. More thoughts on this later. After completing this course, I was so impressed of how it was laid out for me to learn it. The instructor taught in such a way, that I was able to grasp what I’m learning. Thanks, Jose!


  • Danny Clynes (5/5): Very impressed with Jose and the lectures he put together here.
  • Vyankatesh Kulkarni (5/5): This course is really awesome even if you don’t have any knowledge about PostgreSQL still you can be master this course.
  • Matthew Nakos (5/5): This was the perfect course for what I needed at this time.
  • Balakiran Polisetty (4/5): Hi @All, very excellent knowledge, I have gained through this session.


  • Aravind P. (2.5/5): Some topics feel like they are done in a hurry. Much exercise is needed in the later part of the course.
  • Adam S. (2.5/5): Some of the instructions on how to download the resources are outdated. I also had to look up a youtube video on how to set the binary path. This class needs to be updated.
  • EL-Sayed G. (2/5): In the JOIN part the instructor made it look very complicated although it’s so direct and easy to understand, Also the slides don’t help, I wish the course had no slides at all because SQL is only understandable by practical examples.
  • Vincent R. (2/5): I expected way more content and theory. Way too basic vs free youtube content.

About the Author

The instructor of this course is Jose Portilla who is the head of the Data Science department at Pierian Training. With a 4.6 instructor rating and 1,021,606 reviews on Udemy, he offers 60 courses and has taught 3,287,742 students so far.

  • Jose Marcial Portilla holds BS and MS degrees in mechanical engineering from Santa Clara University. He has years of experience working as a qualified instructor and trainer for Python programming, machine learning, and data science.
  • He has written articles and received patents in a number of disciplines, including data science, materials science, and microfluidics.
  • He has acquired a set of abilities for data analysis throughout the course of his career, and he wants to combine both his teaching and data science knowledge to educate others on the power of programming, how to analyse data, and how to display the data in attractive visualisations.
  • He currently serves as the Head of Data Science for Pierian Training, where he teaches data science and Python to employees working at top organisations like General Electric, Cigna, The New York Times, Credit Suisse, McKinsey, and others.

Comparison Table

ParametersThe Complete SQL Bootcamp: Go from Zero to HeroSQL – MySQL for Data Analytics and Business IntelligenceThe Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert
OffersINR 449 (INR 3,39987% offINR 455 (INR 3,499) 87% offINR 455 (INR 3,499) 87% off
Duration9 hours12 hours37.5 hours
Student Enrollments6,47,3191,96,4033,74,258
InstructorsJose Portilla365 CareersColt Steele
Register HereApply Now!Apply Now!Apply Now!

Leave feedback about this

  • Rating