PostgreSQL For Data Science And Data Analyst

• Write complex SQL statements to query the database and gain critical insight into the data
• The transition from the Very Basics to a Point Where You can Effortlessly Work with Large SQL Queries
• Learn Advanced Querying Techniques
• Become a Master SQL Developer

Course Content:

Module1:Introduction

• Course Overview

Module2: Database Basics:

• What is a Database
• How to Proceed in this Course
• Install Postgres Database on Ma
• Troubleshoot Connection
• Install Postgres on Window
• Create Table and Insert a Statement
• Prepare the Database
• Assignment 1: Create More Tables and Populate Data

Module3: SQL Query Basics

• Filter Data Using the WHERE Clause + AND & OR
• WHERE Clause and Operators
• ORDER BY, LIMIT, DISTINCT and Renaming Columns
• Assignment 2: Practice Writing Basic Queries (5 Problems)

Module4:Using Functions:

• UPPER(), LOWER(), LENGTH() + Boolean Expressions & Concatenation
• String Functions: SUBSTRING(), REPLACE()
• Grouping Functions: MIN(), MAX(), AVG(), SUM(), COUNT()
• Assignment 3: Practice with Functions, Conditional Expressions and Concatenation