SQL for Data Analysis using PostgreSQL for Beginners

SQL for Data Analysis using PostgreSQL for Beginners, available at $34.99, has an average rating of 4.1, with 26 lectures, based on 5 reviews, and has 1211 subscribers.

You will learn about Install and connect to PostgreSQL Database Server Restore Sample Database into PostgreSQL Database Server Create Database Tables Insert data into Database Tables Fetch data from Database Analyse data from database using Aggregate Functions Analyse data from database using Analytic Functions This course is ideal for individuals who are Beginners to Data Analysis using SQL on PostgreSQL Database It is particularly useful for Beginners to Data Analysis using SQL on PostgreSQL Database.

Enroll now: SQL for Data Analysis using PostgreSQL for Beginners

Summary

Title: SQL for Data Analysis using PostgreSQL for Beginners

Price: $34.99

Average Rating: 4.1

Number of Lectures: 26

Number of Published Lectures: 26

Number of Curriculum Items: 26

Number of Published Curriculum Objects: 26

Original Price: $22.99

Quality Status: approved

Status: Live

What You Will Learn

Install and connect to PostgreSQL Database Server
Restore Sample Database into PostgreSQL Database Server
Create Database Tables
Insert data into Database Tables
Fetch data from Database
Analyse data from database using Aggregate Functions
Analyse data from database using Analytic Functions

Who Should Attend

Beginners to Data Analysis using SQL on PostgreSQL Database

Target Audiences

Beginners to Data Analysis using SQL on PostgreSQL Database

SQL (Structured Query Language) is a programming language designed for managing data in a relational database. It’s been around since the 1970s and is the most common method of accessing data in databases today. SQL has a variety of functions that allow its users to read, manipulate, and change data. Though SQL is commonly used by engineers in software development, it’s also popular with data analysts. SQL is a standard language for accessing and manipulating databases.

What Can SQL do?

SQL can execute queries against a database
SQL can fetch and analyse data stored inside a database
SQL can retrieve data from a database
SQL can insert records in a database
SQL can update records in a database
SQL can delete records from a database
SQL can create new databases
SQL can create new tables in a database
SQL can create stored procedures in a database
SQL can create views in a database
SQL can set permissions on tables, procedures, and views

PostgreSQL is an advanced, enterprise class open source relational database that supports both SQL (relational) and JSON (non-relational) querying. It is a highly stable database management system, backed by more than 20 years of community development which has contributed to its high levels of resilience, integrity, and correctness. PostgreSQL is used as the primary data store or data warehouse for many web, mobile, geospatial, and analytics applications.

Course Curriculum

Chapter 1: Introduction to SQL and Relational Databases

Lecture 1: Overview of SQL and its role in data analysis

Lecture 2: Introduction to relational databases and their structure

Lecture 3: Understanding tables, columns, and rows

Lecture 4: Basics of SQL syntax and statements

Chapter 2: PostgreSQL Database Setup

Lecture 1: Introduction

Lecture 2: What is SQL

Lecture 3: What is PostgreSQL

Lecture 4: Install PostgreSQL on Windows

Lecture 5: What is PGAdmin

Lecture 6: Connect to PostgreSQL with PgAdmin

Lecture 7: Install PostgreSQL on Macs

Lecture 8: Install PgAdmin on Macs

Lecture 9: Restore a sample database

Chapter 3: Create Database Objects

Lecture 1: Create a table

Lecture 2: Insert data into table

Lecture 3: Fetch data from database

Lecture 4: Create more tables

Chapter 4: Data Analysis with SQL Aggregate Functions

Lecture 1: What are Aggregate Functions

Lecture 2: Analysing data using COUNT Function

Lecture 3: Analysing data using SUM Function

Lecture 4: Analysing data using AVG Function

Chapter 5: Data Analysis with SQL Analytic Functions

Lecture 1: What are Analytic Functions

Lecture 2: Analysing data using AVG as Windows Function

Lecture 3: Analysing data using RANK Functions

Lecture 4: Analysing data using DENSE RANK Functions

Lecture 5: Analysing data using LAG Function

Instructors

247 Learning
An investment in knowledge pays the best interest

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 0 votes
4 stars: 2 votes
5 stars: 2 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!

Menu