Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL Fundamentals for beginners
Rating: 4.3 out of 5(357 ratings)
23,395 students

SQL Fundamentals for beginners

Learn to interact with databases using SQL
Created byBluelime Learning Solutions
Last updated 3/2026
English

What you'll learn

  • Installing PostgreSQL relational database management system
  • Connecting to a database
  • Loading a sample database
  • Creating database and table
  • Using constraints to ensure data intergrity
  • Using SQL SELECT Statement to retrieve data
  • Using SQL CREATE Statement to create a table
  • Using SQL UPDATE Statement to modify data
  • Using SQL DELETE to remove data
  • Using SQL DISTINCT to filter duplicate data
  • Filter data using SQL WHERE Clause
  • Sort data using SQL ORDER BY
  • Manipulating data with various operators
  • Retrieve and combine data from multiple tables
  • Manipulating data using Aggregate Functions

Course content

6 sections • 53 lectures • 6h 13m total length

  • Introduction2:00
  • What is SQL2:29
  • Basic Database Concepts9:00
  • What is PostgreSQL1:41
  • Download and install PostgreSQL for Windows10:46
  • Download and install PostgreSQL for Mac3:15
  • Connecting to a PostgreSQL Database9:35
  • Load sample database11:49
  • Exploring some database objects10:53
  • Using Constraints for data integrity6:09
  • Create database5:40
  • Create a table with PgAdmin7:48
  • Schema2:50

Requirements

  • Basic knowledge of using a computer
  • Basic knowledge of using the internet

Description

Almost all applications you interact with on a daily basis involves data which are stored in databases . Applications such as Facebook, Instagram, Whatsapp, Twitter, Hospitals ,Banks etc all interacts with data stored in databases.

SQL is the language used to interact with the data inside these databases. SQL skills are always in demand due to the ever increasing use and reliance of data.

In this  beginners course, you will learn the building blocks of SQL by interacting with a PostgreSQL database. From creating a brand new table, up through organizing and aggregating data across multiple tables, you will learn the fundamental skills of SQL — and you’ll be prepared to apply them right away.


Topics include:

  • Installing PostgreSQL Relational Database System

  • Connecting to PostgreSQL Default Database

  • Load sample database

  • Creating database and tables

  • Using constraints

  • Retrieving data from database table

  • Updating data inside a table

  • Deleting data inside a database table

  • Filtering data returned from  a database table

  • Sorting data returned from a database table

  • Retrieving data using various operators

  • Combining data from multiple tables

  • Using aggregate functions to manipulate data.

  • Using subqueries

Who this course is for:

  • Beginners to SQL
  • Beginners to database

Report abuse