Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL & Database Essentials: Learn SQL from Scratch
New
16 students

SQL & Database Essentials: Learn SQL from Scratch

Learn SQL fundamentals, joins, database design, normalization, and advanced queries with PostgreSQL.
Created byYotta Academy
Last updated 9/2026
English

What you'll learn

  • Master SQL fundamentals including SELECT, filtering, joins, aggregation, subqueries, CTEs, and advanced query techniques.
  • Design scalable relational databases using ER modeling, keys, constraints, normalization, and practical schema design principles.
  • Improve database performance using indexes, EXPLAIN ANALYZE, transactions, isolation levels, locking, and query optimization.
  • Build production-ready PostgreSQL skills with functions, procedures, triggers, security, migrations, and application connectivity.

Course content

6 sections • 26 lectures • 1h 12m total length

  • What is a Database? — OLTP vs. OLAP3:43
  • The Role of a Database Engineer in 20262:59
  • Demo: PostgreSQL Environment Setup & pgAdmin2:59
  • Relational vs. Non-Relational Databases: Making the Right Choice2:38

Requirements

  • No prior SQL or database experience is required; the course starts from the fundamentals.
  • A Windows, macOS, or Linux computer capable of running PostgreSQL and pgAdmin.
  • Basic computer skills such as installing software, managing files, and using a web browser.
  • A willingness to practice SQL queries and complete the hands-on database exercises throughout the course.

Description

This course contains the use of artificial intelligence.


Learn the essential skills you need to work confidently with SQL and relational databases using PostgreSQL.

This beginner-friendly course takes you from the fundamentals of databases to writing practical SQL queries and understanding how real-world relational databases are designed. You’ll start by learning what databases are, how OLTP and OLAP systems differ, and how relational databases compare with non-relational databases. You’ll also explore the role of a database engineer and set up a PostgreSQL environment with pgAdmin for hands-on learning.

Next, you’ll build a strong foundation in SQL by learning how to retrieve, filter, sort, and manipulate data. You’ll work with SELECT statements, WHERE, LIKE, IN, data types, constraints, and the fundamentals of updating and deleting records safely.

You’ll then move into data analysis using SQL aggregations. Learn how to use functions such as SUM, AVG, and COUNT, along with GROUP BY and HAVING to summarize and analyze data. You’ll also explore sorting, NULL handling, and useful date and time operations for working with real-world datasets.

The course also covers one of the most important areas of relational database development: SQL joins. You’ll understand primary keys, foreign keys, and referential integrity before working with INNER JOIN, OUTER JOIN, self-joins, and hierarchical data across multiple tables.

You’ll then learn the principles of database design and normalization, including ER modeling and the first three normal forms: 1NF, 2NF, and 3NF. You’ll see how these concepts can be applied when designing scalable database structures, including when denormalization may be useful for improving performance.

Finally, you’ll be introduced to more advanced SQL techniques such as subqueries, Common Table Expressions (CTEs), and recursive CTEs. These concepts will help you write cleaner, more structured, and more powerful queries for complex data problems.

By the end of this course, you’ll have a practical foundation in SQL, PostgreSQL, relational database concepts, database design, normalization, joins, aggregations, and advanced querying. You’ll be well prepared to continue into more advanced SQL and database engineering topics.

Who this course is for:

  • Beginners who want to learn SQL and PostgreSQL from scratch with practical, hands-on examples.
  • Students and aspiring developers preparing for careers in backend development, database engineering, or data-related roles.
  • Backend and full-stack developers who want to design better databases, write advanced SQL queries, and improve database performance.
  • Software engineers and data professionals who want to strengthen their knowledge of indexing, transactions, normalization, security, and scalable database design.

Report abuse