Learn SQL Using PostgreSQL- From Zero to Hero

Learn SQL Using PostgreSQL: From Zero to Hero, available at $84.99, has an average rating of 4.52, with 189 lectures, based on 3406 reviews, and has 18206 subscribers.

You will learn about Perform sophisticated queries Join tables together Use Group By to answer questions on aggregated date Create and modifying tables Create indexes to improve search speed Put in constraints to keep data clean Use pgAdmin tool Learn recursive queries How views make accessing data simpler Subqueries Sequences to auto increment fields Common Table Expressions Conditional Expressions Window Functions How to handle date and time data SQL Functions Transactions and Concurrency Control PL/pgSQL Functions Triggers Composite Data Types Array Data Types This course is ideal for individuals who are Someone wanting to master PostgreSQL and SQL query language or Anyone wanting to learn advanced query expressions It is particularly useful for Someone wanting to master PostgreSQL and SQL query language or Anyone wanting to learn advanced query expressions.

Enroll now: Learn SQL Using PostgreSQL: From Zero to Hero

Summary

Title: Learn SQL Using PostgreSQL: From Zero to Hero

Price: $84.99

Average Rating: 4.52

Number of Lectures: 189

Number of Published Lectures: 182

Number of Curriculum Items: 189

Number of Published Curriculum Objects: 182

Original Price: $109.99

Quality Status: approved

Status: Live

What You Will Learn

Perform sophisticated queries

Join tables together

Use Group By to answer questions on aggregated date

Create and modifying tables

Create indexes to improve search speed

Put in constraints to keep data clean

Use pgAdmin tool

Learn recursive queries

How views make accessing data simpler

Subqueries

Sequences to auto increment fields

Common Table Expressions

Conditional Expressions

Window Functions

How to handle date and time data

SQL Functions

Transactions and Concurrency Control

PL/pgSQL Functions

Triggers

Composite Data Types

Array Data Types

Who Should Attend

Someone wanting to master PostgreSQL and SQL query language

Anyone wanting to learn advanced query expressions

Target Audiences

Someone wanting to master PostgreSQL and SQL query language

Anyone wanting to learn advanced query expressions

Learning SQL was one of the most valuable skills I learned while building Match. ?We had one of the largest instances of Microsoft SQL Server in the 90s with millions of records to keep the site running. ?The better we got at SQL, the better we could make the site work for our users and answers sophisticated questions about our users. ?

I want to teach you how to use PostgreSQL. ?We will walk through

Basic selection statements

Joining multiple tables together

Grouping records to get aggregate data

Inserting, updating and deleting records

Creating tables and indexes

Subqueries to create sophisticated reports

Table constraints to keep data clean

Sequences to create auto incrementing fields

CTE – common table expressions that include recursive queries

Views to simply accessing complex queries

Conditional Expressions for queries

Window functions to combine regular queries with aggregate data

How to work with date, time and intervals

Create SQL Functions to capture complex statements

Create PL/pgSQL Functions that allow programming with if/then and loops

Triggers

Array data types

Composite data types

Transactions and concurrency control

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Installing PostgreSQL and pgAdmin

Lecture 1: Installing PostgreSQL on Mac

Lecture 2: Installing PostgreSQL on Windows

Lecture 3: Installing PostgreSQL on Ubuntu

Lecture 4: Install Northwind Database

Lecture 5: Install Some Additional Databases.

Chapter 3: Simple Selection of All Records

Lecture 1: Selecting All Data From a Table

Lecture 2: Selecting Specific Fields

Lecture 3: Selecting Distinct Values

Lecture 4: Counting Results

Lecture 5: Combining Fields in SELECT

Lecture 6: Practice What Youve Learned

Chapter 4: Using WHERE to Select Records

Lecture 1: What If You Dont Want All Records

Lecture 2: Searching For Specific Text

Lecture 3: Searching Numeric Fields

Lecture 4: Searching Date Fields

Lecture 5: WHERE Using Logical AND Operator

Lecture 6: WHERE Using Logical OR Operator

Lecture 7: WHERE Using Logical NOT Operator

Lecture 8: WHERE Combining AND, OR, and NOT

Lecture 9: Using BETWEEN

Lecture 10: Using IN

Lecture 11: Practice What Youve Learned

Chapter 5: Schemas

Lecture 1: Schema Basics

Chapter 6: Using psql To Connect To Postgres

Lecture 1: Connecting With psql

Lecture 2: Eliminate Typing Connection Parameters

Lecture 3: Databases In psql

Lecture 4: Schemas In psql

Chapter 7: Intermediate SELECT Statements

Lecture 1: ORDER BY

Lecture 2: Using MIN and MAX Functions

Lecture 3: Using AVG and SUM

Lecture 4: LIKE to Match Patterns

Lecture 5: Renaming Columns With Alias

Lecture 6: LIMIT to Control Number of Records Returned

Lecture 7: NULL Values

Lecture 8: Practice What Youve Learned

Chapter 8: Joining multiple tables together

Lecture 1: Diagramming Table Relationships

Lecture 2: Grabbing Information From Two Tables

Lecture 3: Grabbing Information From Multiple Tables

Lecture 4: Left Joins

Lecture 5: Right Joins

Lecture 6: Full Joins

Lecture 7: Self Joins

Lecture 8: USING To Reduce Typing

Lecture 9: Even Less Typing With NATURAL

Lecture 10: Practice What Youve Learned

Chapter 9: Grouping and Aggregation Functions

Lecture 1: Group By

Lecture 2: Use HAVING to Filter Groups

Lecture 3: Grouping Sets

Lecture 4: Rollup

Lecture 5: Cube – Rollup On Steroids

Chapter 10: Combining Queries

Lecture 1: Union

Lecture 2: Intersect

Lecture 3: Except

Chapter 11: Subqueries

Lecture 1: Subquery Using EXISTS

Lecture 2: Subquery Using ANY and ALL

Lecture 3: IN Using Subquery

Chapter 12: Modifying Data In Tables: INSERT, UPDATE and DELETE

Lecture 1: INSERT INTO

Lecture 2: UPDATE

Lecture 3: DELETE

Lecture 4: SELECT INTO

Lecture 5: INSERT INTO SELECT

Lecture 6: Returning Data From Update, Delete, and Insert

Chapter 13: Indexes and Performance Tuning

Lecture 1: What Are Indexes?

Lecture 2: CREATE INDEX

Lecture 3: DROP INDEX

Lecture 4: How To Kill Runaway Queries

Lecture 5: Using Explain To See Query Plan

Lecture 6: Use Analyze To Update Table Statistics

Lecture 7: How Is Query Plan Cost Calculated

Lecture 8: Using Indexes On More Than One Field

Lecture 9: Expression Indexes

Lecture 10: Types Of Indexes

Lecture 11: Speeding Up Text Matching

Chapter 14: Database Design and Normalization

Lecture 1: Design Process Overview

Lecture 2: Database Terminology

Lecture 3: A Design Process

Lecture 4: Finding Mission Statement And Ojectives

Lecture 5: Analyzing Current Systems

Lecture 6: Create Table Structure

Lecture 7: Establishing Keys

Lecture 8: Specifying Fields

Lecture 9: Relationships Between Tables

Lecture 10: Business Rules

Lecture 11: Establish Needed Views

Lecture 12: Double Checking Data Integrity

Instructors

Will Bunker
Cofounder of bootstrapped company that became Match.com

Rating Distribution

1 stars: 34 votes

2 stars: 63 votes

3 stars: 348 votes

4 stars: 1285 votes

5 stars: 1676 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!