Learn SQL using PostgreSQL Server Beginner to Expert

Learn SQL using PostgreSQL Server – Beginner to Expert, available at $59.99, has an average rating of 4.5, with 85 lectures, based on 67 reviews, and has 2706 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginners SQL Developer or Beginners to SQL or Beginners to PostgreSQL or Beginner Database Administrators -DBA It is particularly useful for Beginners SQL Developer or Beginners to SQL or Beginners to PostgreSQL or Beginner Database Administrators -DBA.

Enroll now: Learn SQL using PostgreSQL Server – Beginner to Expert

Summary

Title: Learn SQL using PostgreSQL Server – Beginner to Expert

Price: $59.99

Average Rating: 4.5

Number of Lectures: 85

Number of Published Lectures: 85

Number of Curriculum Items: 85

Number of Published Curriculum Objects: 85

Original Price: $99.99

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

Beginners SQL Developer

Beginners to SQL

Beginners to PostgreSQL

Beginner Database Administrators -DBA

Target Audiences

Beginners SQL Developer

Beginners to SQL

Beginners to PostgreSQL

Beginner Database Administrators -DBA

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.

Course Curriculum

Chapter 1: Setting Up PostgreSQL Database Server

Lecture 1: Introduction

Lecture 2: What is SQL

Lecture 3: What is PosgreSQL

Lecture 4: Some Companies using PostgreSQL

Lecture 5: PostgreSQL Installation Requirements

Lecture 6: Please Read

Lecture 7: Installing PostgreSQL Server Version10

Lecture 8: Connecting to a PostgreSQL Database

Lecture 9: Download and load Sample PostgreSQL Database

Lecture 10: Download PostgreSQL version 9.6

Lecture 11: Install PostgreSQL 9.6 on windows

Lecture 12: Verify PostgreSQL 9.6 installation

Lecture 13: Connecting to PostgreSQL 9.6 database

Lecture 14: Load sample database on PostgreSQL 9.6

Lecture 15: Installing PostgreSQL 9.6 on Mac

Lecture 16: Database Concepts

Lecture 17: What is Schema

Lecture 18: Data Types

Lecture 19: Unique Constraint

Chapter 2: SQL C R U D Operations

Lecture 1: Introduction

Lecture 2: Creating a database

Lecture 3: Create a table with Pgadmin

Lecture 4: Create a table with SQL CREATE Statement

Lecture 5: Reading Data with SELECT Statement

Lecture 6: Extracting and Reading all data from a table

Lecture 7: Extracting and Reading data from a specific Column

Lecture 8: Updating existing data in a table

Lecture 9: Deleting (dropping) data in a table

Lecture 10: Inserting new data into a table

Chapter 3: Some SQL Fundamentals

Lecture 1: Filtering Data with WHERE clause

Lecture 2: Removing duplicate data with DISTINCT

Lecture 3: Sorting Data with ORDER BY

Lecture 4: Dropping and Truncating a table

Chapter 4: Extracting Data with SQL Operators

Lecture 1: Extracting data with Comparison Operators

Lecture 2: Extracting data with BETWEEN Operator

Lecture 3: Extracting data with LIKE operator

Lecture 4: Extracting data with NOT Operator

Lecture 5: Extracting data with AND Operator

Lecture 6: Extracting data with OR Operator

Lecture 7: Combining AND & OR operators

Lecture 8: Extracting data with LIMIT Operator

Lecture 9: Extracting data with IN Operators

Lecture 10: Extracting data with UNION Operator

Lecture 11: Extracting data with UNION ALL Operator

Lecture 12: Extracting data with INTERSECT Operator

Lecture 13: Extracting data with EXCEPT Operator

Chapter 5: Getting Data from Multiple Tables

Lecture 1: What are table joins

Lecture 2: Retrieving data with INNER Join

Lecture 3: Retrieving data with LEFT Join

Lecture 4: Retrieving data with FULL OUTER Join

Lecture 5: Retrieving data with CROSS Join

Lecture 6: Retrieving data with NATURAL Join

Chapter 6: Grouping Data and Aggregate Functions

Lecture 1: Grouping data with GROUP BY clause

Lecture 2: Using HAVING clause

Lecture 3: What are aggregate functions

Lecture 4: Summarizing data with AVG aggregate function

Lecture 5: Summarizing data with COUNT aggregate function

Lecture 6: Summarizing data with MAX aggregate function

Lecture 7: Summarizing data with MIN aggregate function

Lecture 8: Summarizing data with SUM aggregate function

Chapter 7: Data Analysis with Analytic Functions

Lecture 1: What are Analytic Functions

Lecture 2: Lets create sample tables

Lecture 3: Using AVG as window function

Lecture 4: Analysing data with ROW NUMBER function

Lecture 5: Analysing data with RANK function

Lecture 6: Analysing data with DENSE RANK function

Lecture 7: Analysing data with FIRST VALUE function

Lecture 8: Analysing data with LAST function

Lecture 9: Analysing data with LAG function

Lecture 10: Analysing data with LEAD function

Chapter 8: Triggers | Sub-queries | Stored Procedures

Lecture 1: Introduction to Triggers

Lecture 2: Creating a trigger – part 1

Lecture 3: Creating a trigger – part 2

Lecture 4: Creating a trigger – part 3

Lecture 5: Managing triggers

Lecture 6: Creating and using sub-queries

Lecture 7: Creating and using stored procedures

Chapter 9: SQL Views ( Virtual Tables )

Lecture 1: What are views

Lecture 2: Benefits of using views

Lecture 3: How to create a view

Lecture 4: How to modify and delete a view

Lecture 5: How to update views

Lecture 6: What are materialized views

Lecture 7: How to create a materialized view

Lecture 8: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 4 votes

2 stars: 0 votes

3 stars: 9 votes

4 stars: 29 votes

5 stars: 25 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

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!