SQL Fundamentals for beginners

Learn to interact with databases using SQL

4.15 (335 reviews)
Udemy
platform
English
language
Databases
category
SQL Fundamentals for beginners
23,355
students
6 hours
content
Jun 2021
last update
$54.99
regular price

What you will 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

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

Content

Introduction and Database Setup

Introduction
What is SQL
Basic Database Concepts
What is PostgreSQL
Download and install PostgreSQL for Windows
Download and install PostgreSQL for Mac
Connecting to a PostgreSQL Database
Load sample database
Exploring some database objects
Using Constraints for data integrity
Create database
Create a table with PgAdmin
Schema

C R U D Operations

Introduction
Create a table with SQL
Retrieve all data from Table with SQL SELECT
Retrieve specific data from Table with SQL SELECT
Modify data in table using SQL UPDATE
Remove data from table using SQL DELETE
Filtering Data using SQL WHERE Clause
Ordering data using SQL ORDER BY Clause
Subqueries
Removing Duplicate Records
Truncating a Table
Adding new data to table using SQL INSERT

SQL Operators

Comparison Operators
BETWEEN Operators
NOT BETWEEN Operators
LIKE Operators
NOT Operators
OR Operators
AND Operators
Combining OR | AND Operators
IN Operators
UNION OPerators
UNION ALL Operators
INTERSECT Operators

Combining Data From Multiple Tables

Introduction to Table Joins
SQL INNER Joins
SQL LEFT JOIN
SQL OUTER JOIN
SQL CROSS JOIN
SQL NATURAL JOIN

SQL AGGREGATE FUNCTIONS

Introduction to aggregate functions
SQL AVG Aggregate Function
SQL COUNT Aggregate Function
SQL MAX Aggregate Function
SQL MIN Aggregate Function
SQL SUM Aggregate Function
Grouping Data using SQL GROUP BY Clause
Splitting Groups using HAVING Clause

Reviews

Avi
September 29, 2023
this course is good and really informative, at some place during join lectures. the explanation needs improvement. like without selecting both tables in FROM clause, sir was selecting 1st_table.column1
Muyiwa
August 23, 2023
I really appreciate the fact that the instructor repeats some things he has earlier said and this is very good for emphasis, especially for newbies in SQL. I'll definitely take more courses with Blueline.
Antoan
March 10, 2023
Everything is great. I am so happy to learn new things and i am going to apply for another course. Thank you again.
Laxman
September 21, 2022
I am still going through the content in the SQL and instructor is giving the content delivery in understandable way thanks for that and i still need to install the SQL and practice It is going very well
AJ
August 14, 2022
The course was great, the instructor explains extremely well. There might be a section added about the having clause before one continues to section 5 as it is skipped. This confused me.
Daniel
April 19, 2022
I needed the basics in a general SQL format, which is exactly what I got. Everything is clearly done at a steady pace (I have completed 20% of the course). It is a bit boring in its delivery and I would repeat a comment I read that there is repetition when the author signs into the database every time, which was not needed. Otherwise, very good.
Casey
March 22, 2022
Just finished the first section. All 13 lectures. The expected time is 1.5 hours, and it took me almost 4 hours of searching the internet and banging my head on my desk on the example problem in step 8. I'm on a Mac and the course doesn't tell you how to load the data into the example database at all. I've been stuck for hours and finally moved on without finishing it. Very frustrated so far. Also, so much repetition! Why can't we just get to learning the SQL component? This feels more like a PostgreSQL admin class than a SQL for Beginners class. 3 hours in and we've only learned the UNIQUE function. Update: I'm halfway done, and there is still a lot of repetition, but we're deep into the operators now. So far I feel like I could have just read this on a SQL dictionary site. Update after completion. Ultimately this was a poor course. 1.5 stars simply because the instructor was slow and unengaging, the content was in a bad order and the examples were sometimes useless. I could have found all of this information for free with a quick google search to any SQL dictionary online, and avoided the instructors frequent syntax and spelling errors. This was my first Udemy course and I'm shocked at the quality for the money. I don't think I'll be coming back.
Erik
May 4, 2021
The first half worked really well, everything was explained in detail, whereas the quality of the second half of the course was lacking a little bit
Sudeen
April 25, 2021
If you are a beginner in SQL topic then this course will surely help you to know all the widely used basic & imp Queries.
Pranav
January 29, 2021
I Enrolled with Zero Programming Knowledge, Now i am proud to say that i can Analyse the PostgreSQL Code, Hereon i can work on to gain more hands on training with in the SQL Programming
Aniebiet
January 20, 2021
Yes, it was a good match for me; a good content for a beginners course. A little problem I have is that the tutor goes over the basics too often (for example, almost all videos show how to open the pgAdmin 4 tool) and that is time-consuming.
Akshita
January 5, 2021
well, a good course some things are not explainable in the course like AS, USING when to use this. overall nice course.
Jibril
January 3, 2021
I LEARN ALOT HERE, LIKE WHAT IS POSGRESQL,HOW TO INSTALL POSGRESQL ON MACK BECAUSE I USE MACK, HOW TO RUN IT AND CONNECTING A POSTGRESQL TO DATABASE, CREATE DATABASE USING PG4ADIM, WHAT IS FOREIGN KEY USE FOR,CONSTRAINTS
Kanthraj
June 28, 2019
It was totally good session which you have provided in this course thank you for this. Missing for after every section if you have Questions to be answered by us that would be great learning in a two way communication. Opening the PGADMIN 4 tools in every videos it took almost 30secs to 1min is wasted the video content, in the initial video was fine but in all the section and video completely made video length more
Ejigayehu
May 13, 2019
A very wonderful presentation! His calm and confidence voice add more interest to it! Thanks a lot! Great teacher!

Coupons

DateDiscountStatus
1/1/2021100% OFF
expired

Charts

Price

SQL Fundamentals for beginners - Price chart

Rating

SQL Fundamentals for beginners - Ratings chart

Enrollment distribution

SQL Fundamentals for beginners - Distribution chart

Related Topics

2358302
udemy ID
5/8/2019
course created date
11/20/2019
course indexed date
Bot
course submited by