SQL for Data Analysis using PostgreSQL for Beginners

Focused View

247 Learning

1:58:27

149 View

1. PostgreSQL Database Setup

1. Introduction.mp4

00:20

2. What is SQL.html

3. What is PostgreSQL.html

4. Install PostgreSQL on Windows.mp4

09:53

5. What is PGAdmin.html

6. Connect to PostgreSQL with PgAdmin.mp4

09:35

7. Install PostgreSQL on Macs.mp4

02:54

8. Install PgAdmin on Macs.mp4

05:23

9.1 dvdrental.zip

9. Restore a sample database.mp4

11:49

2. Create Database Objects

1. Create a table.mp4

06:35

2. Insert data into table.mp4

08:32

3. Fetch data from database.mp4

06:44

4. Create more tables.mp4

06:01

3. Data Analysis with SQL Aggregate Functions

1. What are Aggregate Functions.mp4

02:03

2. Analysing data using COUNT Function.mp4

11:09

3. Analysing data using SUM Function.mp4

06:48

4. Analysing data using AVG Function.mp4

11:56

4. Data Analysis with SQL Analytic Functions

1. What are Analytic Functions.mp4

05:39

2. Analysing data using AVG as Windows Function.mp4

04:03

3. Analysing data using RANK Functions.mp4

03:11

4. Analysing data using DENSE RANK Functions.mp4

02:53

5. Analysing data using LAG Function.mp4

02:59

Description

Analyse data in PostgreSQL Database using SQL

What You'll 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 is this for?

Beginners to Data Analysis using SQL on PostgreSQL Database

More details

Description
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.

Who this course is for:
Beginners to Data Analysis using SQL on PostgreSQL Database

User Reviews

Rating

average 0

Total votes0

Focused display

Hello and welcome to 247 Learning.We create online courses that will help you acquire useful and productive technical skills that can be applied to real world jobs. We have over 18,000 students on Udemy that have signed up to our courses . We are continuously adding more courses to our course catalogues. We are looking forward to welcoming you to one or more of our courses.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.