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

  •   Transaction Processing
  •   Data Import/Export
  •   Relational Databases
  •   Query Languages
  •   Text Mining
  •   SQL
  •   Stored Procedure
  •   Data Manipulation
  •   Database Management
  •   Database Design
  •   Data Integrity
  •   PostgreSQL

    • There are 4 modules in this course

    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.

    Using SQL Techniques

    Text in PostgreSQL

    Regular Expressions

    Explore more from Software Development

    Database Design and Basic SQL in PostgreSQL

    PostgreSQL Fundamentals

    PostgreSQL for Everybody

    Performing Data Definition and Manipulation in SQL

    ©2025  ementorhub.com. All rights reserved