Intermediate PostgreSQL

Intermediate PostgreSQL

This course is part of PostgreSQL for Everybody Specialization

Instructor: Charles Russell Severance

What you'll learn

Utilize SQL commands for editing tables in a PostgreSQL database and produce properly normalized tables from CSV files.
Appropriately handle text and dates in databases and create stored procedures.
Identify hashtag algorithm and their attributes.
Construct regular expressions to select rows that match a pattern.

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

3 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Build your subject-matter expertise

This course is part of the PostgreSQL for Everybody Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 4 modules in this course

This course covers a wide range of SQL techniques, beyond basic CRUD (Create, Read, Update, and Delete) operations in PostgreSQL. You will learn the specifics of aggregation, transactions, reading and parsing CSV files and inserting data into a database. You’ll also take a look at how PostgreSQL handles and indexes text data.

In this first week, you'll be introduced to the course and look at SQL commands for editing columns and tables in a PostgreSQL Database. You'll learn to create stored procedures and also utilize the SELECT DISTINCT command.

What's included

14 videos6 readings1 assignment5 app items

14 videosTotal 121 minutes

Welcome to Intermediate SQL!1 minutePreview module
Altering Table Schema4 minutes
Dates14 minutes
DISTINCT / GROUP BY11 minutes
Demonstration: SELECT DISTINCT8 minutes
Demonstration: GROUP BY6 minutes
Subqueries9 minutes
Demonstration: Subqueries8 minutes
Concurrency and Transactions15 minutes
Demonstration: Concurrency and Transactions19 minutes
Stored Procedures8 minutes
Demonstration: Stored Procedures5 minutes
Office Hours Hyderabad, India - PyCon5 minutes
Office Hours: Puebla, Mexico1 minute

6 readingsTotal 50 minutes

Help Us Learn More About You5 minutes
Syllabus10 minutes
Each Course Uses a Different Database10 minutes
How Assignments Work10 minutes
Connecting to Your Database Server10 minutes
Assessment Philosophy5 minutes

1 assignmentTotal 10 minutes

Intermediate SQL10 minutes

5 app itemsTotal 210 minutes

Making our First Tables30 minutes
Alter Table30 minutes
SELECT DISTINCT60 minutes
Creating a Stored Procedure60 minutes
Initial Database Setup30 minutes

This week, we'll focus on producing properly normalized tables from CSV files and utilizing the ALTER TABLE command to adjust the schema of tables.

What's included

5 videos3 app items

5 videosTotal 24 minutes

Demo Reading and Parsing Files3 minutesPreview module
Demonstration: Creating and Loading a Database6 minutes
Demonstration: Loading and Normalizing CSV Data9 minutes
Office Hours - Gingerman Raceway, South Haven, Michigan, USA2 minutes
Office Hours - Haag, Netherlands3 minutes

3 app itemsTotal 180 minutes

Musical Tracks Many-to-One60 minutes
Unesco Heritage Sites Many-to-One60 minutes
Musical Track Database plus Artists60 minutes

This week will focus on text in PostgreSQL, including utilizing character sets, identifying hashtag algorithms and attributes, as well as index choices and techniques.