Intermediate PostgreSQL

  • 4.9
Approx. 16 hours to complete

Course Summary

Learn how to work with complex database systems using PostgreSQL. This intermediate-level course covers advanced querying, indexing, and optimization techniques.

Key Learning Points

  • Understand advanced PostgreSQL concepts such as window functions and recursive queries
  • Learn how to optimize database performance through indexing and query planning
  • Develop skills in database design and modeling for complex systems

Related Topics for further study


Learning Outcomes

  • Develop advanced skills in PostgreSQL
  • Optimize database performance for complex systems
  • Understand database design and modeling for effective data management

Prerequisites or good to have knowledge before taking this course

  • Basic understanding of SQL and database management
  • Experience working with PostgreSQL

Course Difficulty Level

Intermediate

Course Format

  • Online
  • Self-paced
  • Video lectures
  • Quizzes
  • Hands-on exercises

Similar Courses

  • Advanced SQL for Data Science
  • Database Design and Management
  • Big Data Analytics Using Spark

Related Education Paths


Notable People in This Field

  • PostgreSQL Contributor
  • PostgreSQL Expert

Related Books

Description

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.

Specifically, students will do assignments that alter table schemas, create stored procedures, construct advanced queries, explore sorting and grouping query data, and techniques for working with text in databases including regular expressions.

Knowledge

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

Outline

  • SQL Techniques
  • Welcome to Intermediate SQL!
  • Altering Table Schema
  • Dates
  • DISTINCT / GROUP BY
  • Demonstration: SELECT DISTINCT
  • Demonstration: GROUP BY
  • Subqueries
  • Demonstration: Subqueries
  • Concurrency and Transactions
  • Demonstration: Concurrency and Transactions
  • Stored Procedures
  • Demonstration: Stored Procedures
  • Office Hours Hyderabad, India - PyCon
  • Office Hours: Puebla, Mexico
  • Help Us Learn More About You
  • Each Course Uses a Different Database
  • How Assignments Work
  • Connecting to Your Database Server
  • Assessment Philosophy
  • Intermediate SQL
  • Using SQL Techniques
  • Demo Reading and Parsing Files
  • Demonstration: Creating and Loading a Database
  • Demonstration: Loading and Normalizing CSV Data
  • Office Hours - Gingerman Raceway, South Haven, Michigan, USA
  • Office Hours - Haag, Netherlands
  • Text in PostgreSQL
  • Text in Databases
  • Text Function
  • Character Sets
  • Character Sets in Python
  • Inside Hashes
  • Bruce Schneier - Cryptography, Hashing, and NIST
  • Index Choices and Index Techniques
  • Demonstration: Generating and Scanning Text
  • Office Hours - New York City
  • Office Hours, Miami, Florida, USA
  • Bruce Schneier - Cryptography, Hashing, and NIST
  • Text and PostgreSQL
  • Regular Expressions
  • Regular Expressions
  • Using Regular Expressions
  • Demonstration: Regular Expressions
  • Demonstration: Flat files, Regex, Email
  • Course Wrap Up
  • Office Hours, Mountain View, California, USA
  • Post-Course Survey
  • Regular Expressions

Summary of User Reviews

Learn intermediate PostgreSQL with Coursera. This course has received high praise from users for its comprehensive curriculum and expert instructors.

Key Aspect Users Liked About This Course

The course is praised for its thorough and easy-to-understand explanations of complex database concepts.

Pros from User Reviews

  • Comprehensive curriculum that covers intermediate PostgreSQL topics
  • Expert instructors who provide thorough explanations and answer questions
  • Hands-on assignments and quizzes to reinforce learning
  • Flexible schedule allows for self-paced learning
  • Access to a supportive community of learners

Cons from User Reviews

  • Some users found the course material to be too basic
  • The course may be challenging for beginners
  • Some users had technical difficulties with the online platform
  • The course may require a significant time commitment
  • The course may be expensive for some learners
English
Available now
Approx. 16 hours to complete
Charles Russell Severance
University of Michigan
Coursera

Instructor

Share
Saved Course list
Cancel
Get Course Update
Computer Courses