Monthly Subscription Starting at AED 99 + VAT

Intermediate PostgreSQL
  • Level Professional
  • المدة 16 ساعات hours
  • الطبع بواسطة University of Michigan
  • Offered by

عن

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.

الوحدات

Lectures

    • 12 Videos
    • 2 Readings
Show info about module content

12 Videos

  • 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

2 Readings

  • Help Us Learn More About You
  • Syllabus

Assignments

    • 4 Readings
    • 5 ExternalTool
    • 1 Assignment
Show info about module content

1 Assignment

  • Intermediate SQL

5 External Tool

  • Initial Database Setup
  • Making our First Tables
  • Alter Table
  • SELECT DISTINCT
  • Creating a Stored Procedure

4 Readings

  • Each Course Uses a Different Database
  • How Assignments Work
  • Connecting to Your Database Server
  • Assessment Philosophy

Bonus Materials

    • 2 Videos
Show info about module content

2 Videos

  • Office Hours Hyderabad, India - PyCon
  • Office Hours: Puebla, Mexico

Lectures

    • 3 Videos
Show info about module content

3 Videos

  • Demo Reading and Parsing Files
  • Demonstration: Creating and Loading a Database
  • Demonstration: Loading and Normalizing CSV Data

Assignments

    • 3 ExternalTool
Show info about module content

3 External Tool

  • Musical Tracks Many-to-One
  • Unesco Heritage Sites Many-to-One
  • Musical Track Database plus Artists

Bonus

    • 2 Videos
Show info about module content

2 Videos

  • Office Hours - Gingerman Raceway, South Haven, Michigan, USA
  • Office Hours - Haag, Netherlands

Lectures

    • 8 Videos
    • 1 Readings
Show info about module content

8 Videos

  • 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

1 Readings

  • Bruce Schneier - Cryptography, Hashing, and NIST

Assignments

    • 2 ExternalTool
    • 1 Assignment
Show info about module content

1 Assignment

  • Text and PostgreSQL

2 External Tool

  • A Hash-based Puzzle
  • Generating Text

Bonus

    • 2 Videos
Show info about module content

2 Videos

  • Office Hours - New York City
  • Office Hours, Miami, Florida, USA

Lectures

    • 4 Videos
Show info about module content

4 Videos

  • Regular Expressions
  • Using Regular Expressions
  • Demonstration: Regular Expressions
  • Demonstration: Flat files, Regex, Email

Assignments

    • 1 ExternalTool
    • 1 Assignment
Show info about module content

1 Assignment

  • Regular Expressions

1 External Tool

  • Regular Expression Queries

Wrap Up

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Course Wrap Up

1 Readings

  • Post-Course Survey

Bonus

    • 1 Videos
Show info about module content

1 Videos

  • Office Hours, Mountain View, California, USA

Auto Summary

Elevate your SQL skills with the "Intermediate PostgreSQL" course, designed for those looking to deepen their understanding and application of SQL techniques in the realm of IT & Computer Science. Led by Coursera, this professional-level course dives beyond basic CRUD operations, offering a comprehensive exploration of advanced SQL functionalities within PostgreSQL. Throughout the course, you will master the intricacies of aggregation, transactions, and text data handling, including the use of regular expressions. By engaging in practical assignments, you'll gain hands-on experience in altering table schemas, creating stored procedures, constructing sophisticated queries, and effectively sorting and grouping data. Spanning a duration of 960 minutes, this course is perfect for IT professionals and database enthusiasts aiming to enhance their expertise. Flexible subscription options, including Starter and Professional plans, are available to suit your learning needs. Join us to unlock the full potential of PostgreSQL and take your database management skills to the next level.

Charles Russell Severance
Instructor

Charles Russell Severance