4.2 out of 5
4.2
12 reviews on Udemy

Learn SQL using PostgreSQL Server – Beginner to Expert

Practical Hands-on Real World SQL Skills
Instructor:
Bluelime Learning Solutions
2,495 students enrolled
English [Auto-generated]
Create Database
Create Tables
Extract Data from databases
Update existing data in database
Remove duplicate data
Extract data using sub queries
Create stored procedures
Group data
Sort data
Summarize data with aggregate functions
Analyse data with Analytic functions
Filter data from query
Query data using various operators
Create Triggers
Create views

SQL -Structured Query Language is an internationally recognised language used to communicate and manipulate various database systems.

Data is everywhere and growing at a rapid rate. Most Software application we interact with daily deals with stored data . From our interaction with our banks to social media applications like Facebook and Instagram..

Due to the relevance and dependency on data , professionals that are skilled in SQL are always in high demand  to help interact with various databases to help business intelligence and other sectors that relies on data.

This course will teach you from absolute beginner to expert so you can be confident with enough skills to build simple to complex queries to communicate and interact with databases.

We will be using PostgreSQL  Server to host our database.

PostgreSQL Server is a relational database management system  -RDBMS   used by lots  of companies all over the world

What You Will Learn include:

  • How to extract  data from multiple Database Tables using Joins

  • How to insert new data into database with SQL

  • How to update existing data inside a database

  • How to delete data from a database

  • How to filter data

  • How to sort data

  • How to create and query views

  • How to  build a stored procedure

  • How to use Aggregate functions to summarize returned data

  • How to group data

  • Creating views

  • Creating Triggers

  • Creating sub-queries

  • Data Analysis with Analytic functions

SQL can be used for Data Analysis to transform data already present in the database to valuable useful information that help companies and organisations make key business and management decisions.

Everywhere data is being collected, every transaction, every web page visit,every payment—all these and much, much more are filling relational databases with raw data that can be analysed to provide useful information.

There is a demand for people who can use  data to perform reporting and analysis thus helping businesses and organizations make important and critical decisions.

Setting Up PostgreSQL Database Server

1
Introduction
2
What is SQL
3
What is PosgreSQL
4
Some Companies using PostgreSQL
5
PostgreSQL Installation Requirements
6
Please Read
7
Installing PostgreSQL Server Version10
8
Connecting to a PostgreSQL Database
9
Download and load Sample PostgreSQL Database
10
Download PostgreSQL version 9.6
11
Install PostgreSQL 9.6 on windows
12
Verify PostgreSQL 9.6 installation
13
Connecting to PostgreSQL 9.6 database
14
Load sample database on PostgreSQL 9.6
15
Installing PostgreSQL 9.6 on Mac
16
Database Concepts
17
What is Schema
18
Data Types
19
Unique Constraint

SQL C R U D Operations

1
Introduction
2
Creating a database
3
Create a table with Pgadmin
4
Create a table with SQL CREATE Statement
5
Reading Data with SELECT Statement
6
Extracting and Reading all data from a table
7
Extracting and Reading data from a specific Column
8
Updating existing data in a table
9
Deleting (dropping) data in a table
10
Inserting new data into a table

Some SQL Fundamentals

1
Filtering Data with WHERE clause
2
Removing duplicate data with DISTINCT
3
Sorting Data with ORDER BY
4
Dropping and Truncating a table

Extracting Data with SQL Operators

1
Extracting data with Comparison Operators
2
Extracting data with BETWEEN Operator
3
Extracting data with LIKE operator
4
Extracting data with NOT Operator
5
Extracting data with AND Operator
6
Extracting data with OR Operator
7
Combining AND & OR operators
8
Extracting data with LIMIT Operator
9
Extracting data with IN Operators
10
Extracting data with UNION Operator
11
Extracting data with UNION ALL Operator
12
Extracting data with INTERSECT Operator
13
Extracting data with EXCEPT Operator

Getting Data from Multiple Tables

1
What are table joins
2
Retrieving data with INNER Join
3
Retrieving data with LEFT Join
4
Retrieving data with FULL OUTER Join
5
Retrieving data with CROSS Join
6
Retrieving data with NATURAL Join

Grouping Data and Aggregate Functions

1
Grouping data with GROUP BY clause
2
Using HAVING clause
3
What are aggregate functions
4
Summarizing data with AVG aggregate function
5
Summarizing data with COUNT aggregate function
6
Summarizing data with MAX aggregate function
7
Summarizing data with MIN aggregate function
8
Summarizing data with SUM aggregate function

Data Analysis with Analytic Functions

1
What are Analytic Functions
2
Let's create sample tables
3
Using AVG as window function
4
Analysing data with ROW NUMBER function
5
Analysing data with RANK function
6
Analysing data with DENSE RANK function
7
Analysing data with FIRST VALUE function
8
Analysing data with LAST function
9
Analysing data with LAG function
10
Analysing data with LEAD function

Triggers | Sub-queries | Stored Procedures

1
Introduction to Triggers
2
Creating a trigger - part 1
3
Creating a trigger - part 2
4
Creating a trigger - part 3
5
Managing triggers
6
Creating and using sub-queries
7
Creating and using stored procedures

SQL Views ( Virtual Tables )

1
What are views
2
Benefits of using views
3
How to create a view
4
How to modify and delete a view
5
How to update views
6
What are materialized views
7
How to create a materialized view
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.2
4.2 out of 5
12 Ratings

Detailed Rating

Stars 5
4
Stars 4
4
Stars 3
2
Stars 2
0
Stars 1
2
4f24b497ab6ea86fc5058ad989135022
30-Day Money-Back Guarantee

Includes

9 hours on-demand video
1 article
Full lifetime access
Access on mobile and TV
Certificate of Completion