Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

PostgreSQL and MySQL for Beginners

Name: PostgreSQL and MySQL for Beginners
Rating: 4.3 (309 reviews)

Learn most popular SQL dialects, PostgreSQL & MySQL. Learn SQL concepts, practice & compare syntax of PostgreSQL & MySQL

Role Play

Created byStart-Tech Trainings, Start-Tech Academy, Pukhraj Parikh, Abhishek Bansal

Last updated 4/2026

English

What you'll learn

How to write SELECT queries to fetch relevant data in PostgreSQL and MySQL
How to filter and sort the data using WHEN, logical operators and ORDER BY
How to group and aggregate data in PostgreSQL and MySQL
How to apply joins and combining queries in PostgreSQL and MySQL
String, mathematical, date-time functions and pattern matching in PostgreSQL and MySQL
Understanding of VIEWS and INDEXES in PostgreSQL and MySQL
How to write subqueries in PostgreSQL and MySQL

Coding Exercises

This course includes our updated coding exercises so you can practice your skills as you learn.

Course content

23 sections • 141 lectures • 10h 24m total length

Introduction3:18

Installing PostgreSQL and pgAdmin in your System10:15
Install PostgreSQL and Pgadmin from the official site, set up a database, connect securely, and write and run SQL using the Pgadmin query tool.
This is a Milestone!3:52
Celebrate this milestone in PostgreSQL and MySQL for beginners, and continue with motivated learning using subtitles, adjustable playback, offline downloads, Q&A, and an AI assistant.
If pgAdmin is not opening...0:44

CREATE in PostgreSQL11:40
CREATE in MySQL4:36
Exercise 1: Create DB and Table1:24
Solutions to all Exercises0:05
INSERT in PostgreSQL9:07
INSERT in MySQL6:55
Insert data into a table using the insert command, including single and multiple rows, with or without column lists; understand nulls and type constraints when values mismatch.
Import data from File in PostgreSQL4:59
Import data from File in MySQL4:40
Exercise 2: Inserting and Importing data0:57
SELECT statement in PostgreSQL3:40
SELECT statement in MySQL2:31
Quick coding exercise on Select Statement
SELECT DISTINCT in PostgreSQL6:05
SELECT DISTINCT in MySQL2:07
Learn how to use select distinct in MySQL to eliminate duplicate records and fetch unique values from a single column or from multiple columns in a table.
Quick coding exercise on Distinct Command
WHERE in PostgreSQL4:02
Learn how to retrieve data with conditions in PostgreSQL using the where clause, including numeric and textual comparisons, distinct values, and selecting specific columns.
WHERE in MySQL3:49
Quick coding exercise on Where Statement
Logical Operators in PostgreSQL6:03
Master PostgreSQL queries by applying multiple conditions with and, or, and not to filter data precisely, including age between 20 and 30 and not equal to 25.
Logical Operators in MySQL7:02
Quick coding exercise on Logical Operators
Exercise 3: SELECT, WHERE & Logical1:16
UPDATE in PostgreSQL5:24
UPDATE in MySQL4:06
Quick coding exercise on Update Command
DELETE in PostgreSQL4:11
Learn how to delete rows in PostgreSQL using delete from with a where clause, including single-row, multi-row, and full-table deletions, and verify results in PgAdmin.
DELETE in MySQL3:07
Delete data in MySQL using delete from table where condition to remove specific rows or all rows. See examples by id and by age to illustrate affected rows.
Quick coding exercise on Delete Command
ALTER Part 1 in PostgreSQL6:49
Learn how to alter table structure in PostgreSQL using the alter table command, including adding, dropping, renaming columns, changing data types, and managing constraints and indexes on a customer table.
ALTER Part 2 in PostgreSQL10:31
Quick coding exercise on Alter Command
ALTER in MySQL7:35
Exercise 4: Update, Delete and Alter Table1:03
Quiz
About the upcoming role play0:38
SQL Concepts in an Interview Setting

IN in PostgreSQL4:18
IN in MySQL2:54
Explore how to use the in statement in MySQL to replace multiple or conditions in select, insert, update, or delete statements. See syntax and examples such as city in ('Philadelphia','Seattle').
Quick coding exercise on IN operator
BETWEEN in PostgreSQL5:40
BETWEEN in MySQL3:40
Learn how to use the between operator in MySQL to filter records by ranges, including ages and dates, with between, not between, and equivalent comparisons.
Quick coding exercise on Between Operator
LIKE in PostgreSQL8:52
LIKE in MySQL7:30
Quick coding exercise on Like operator
Exercise 6: In, Like & Between0:51
Practice using in, between, and like with where clauses to query distinct cities in north or east regions, sales orders with values 100–500, and customer last names containing four characters.
Quiz

Requirements

Just a PC with any web browser

Description

4 Reasons why you should choose this SQL course

Carefully designed curriculum teaching you everything in SQL that you will need for Data analysis in businesses
Comprehensive - covers basic and advanced SQL statements in both, PostgreSQL and MySQL
Downloadable resources covering important topics on SQL
Your queries on SQL and anything covered in the Masterclass will be responded by the Instructor himself

A Verifiable Certificate of Completion is presented to all students who undertake this SQL course.

Why should you choose this course?

This is a complete tutorial on SQL which can be completed within a weekend. SQL is the most sought after skill for Data analysis roles in all the companies. PostgreSQL and MySQL are highly desired skills for database management and data analysis roles. So whether you want to start a career as a data scientist or just grow you data analysis skills, this course will cover everything you need to know to do that.

What makes us qualified to teach you?

The course is taught by Abhishek, Pukhraj and Nadeem. Instructors of the course have been teaching Data Science and Machine Learning for over a decade. They have an in-depth knowledge in advanced SQL, PostgreSQL, MySQL, database management, and various data analysis tools available in the market.

We are also the creators of some of the most popular online courses - with over 1 million enrollments and thousands of 5-star reviews like these ones:

I had an awesome moment taking this course. It broaden my knowledge more on the power use of SQL as an analytical tools. Kudos to the instructor! - Sikiru

Very insightful, learning very nifty tricks and enough detail to make it stick in your mind. - Armand

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

By the end of this course, your confidence in using SQL will soar. You'll have a thorough understanding of how to use SQL for Data analytics as a career opportunity.

Go ahead and click the enroll button, and I'll see you in lesson 1!

Cheers

Start-Tech Academy

FAQ's

Why learn SQL?

SQL is the most universal and commonly used database language. It powers the most commonly used database engines like PostgreSQL, SQL Server, SQLite, and MySQL. Simply put, If you want to access databases then yes, you need to know SQL.
It is not really difficult to learn SQL. SQL is not a programming language, it’s a query language. The primary objective where SQL was created was to give the possibility to common people to get interesting data from the database. It is also an English-like language so anyone who can use English at a basic level can write SQL queries easily.
SQL is one of the most sought-after skills by hiring employers.
You can earn good money

How much time does it take to learn SQL?

SQL is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn SQL quickly starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to learn SQL quickly.

What's the difference between SQL and PostgreSQL?

SQL is a language. Specifically, the "Structured Query Language"

PostgreSQL is one of several database systems, or RDMS (Relational Database Management System). PostgresSQL is one of several RDMS's, others of which are Oracle, Informix, MySQL, and MSQL.

All of these RDMSs use SQL as their language. Each of them have minor variations in the "dialect" of SQL that they use, but it's all still SQL.

Which is better, PostgreSQL or MySQL?

Both are excellent products with unique strengths, and the choice is often a matter of personal preference.

PostgreSQL offers overall features for traditional database applications, while MySQL focuses on faster performance for Web-based applications.

Open source development will bring more features to subsequent releases of both databases.

Who uses these databases?

Here are a few examples of companies that use PostgreSQL: Apple, BioPharm, Etsy, IMDB, Macworld, Debian, Fujitsu, Red Hat, Sun Microsystem, Cisco, Skype.

Companies that use MySQL: Uber, Airbnb, Netflix, Udemy, Pinterest etc.

Who this course is for:

Working Professionals beginning their Data journey
Anyone curious to learn and compare both PostgreSQL and MySQL
Students about to join their first corporate job

PostgreSQL and MySQL for Beginners

What you'll learn

Explore related topics

Coding Exercises

Course content

Introduction1 lecture • 3min

Course Resources1 lecture • 1min

Setting up PostgreSQL and PGAdmin3 lectures • 15min

Installing MySQL1 lecture • 6min

Fundamental SQL statements28 lectures • 2hr 4min

Restore and Back-up in PostgreSQL5 lectures • 24min

Restore and Back-up in MySQL2 lectures • 6min

Selection commands: Filtering7 lectures • 34min

Selection commands: Ordering6 lectures • 23min

Aliases2 lectures • 6min

Requirements

Description

Who this course is for: