Learning Intermediate PostgreSQL


Deal Score+1



Learn to create and maintain strong databases using the PostgreSQL relational database management system (RDBMS).

Join Other Email Learners

Follow the guide on landing page

About This Course

This four-week course from the University of Michigan forms part of the series on Python and PostgreSQL and directly follows the introductory course on database design and basic SQL.

You’ll learn intermediate PostgreSQL concepts, building on the foundational knowledge of the previous course.

By the end, you’ll be able to use the PostgreSQL RDBMS to create efficient, robust databases for all your Python programming projects.

Level up your PostgreSQL abilities

You’ll tap into the fundamentals that you already know about this RDBMS as you learn to utilise SQL commands to edit tables in PostgreSQL databases and to produce normalised tables from CSV files.

You’ll also be guided on inserting data into a database, creating stored procedures, identifying hashtag algorithms, and constructing regular expressions to select rows that match a pattern.

Get first-hand experience with SQL commands

Like the other courses in this series, you’ll be able to practice the concepts and skills that you’re learning with engaging assignments.

The combination of theory and hands-on training means you can understand and then apply the material, preparing you for whatever real-life work situation you find yourself in.

Syllabus

  • Week 1

SQL Techniques

  • Week 2

Using SQL Techniques

  • Week 3

Text in PostgreSQL

  • Week 4

Regular Expressions

Learning on this course

You can take this self-guided course and learn at your own pace. On every step of the course you can meet other learners, share your ideas and join in with active discussions in the comments.

What will you achieve?

By the end of the course, you‘ll be able to…

  • Apply SQL commands for editing tables in a PostgreSQL database and produce properly normalized tables from CSV files
  • Explore handling text and dates in databases, and create stored procedures
  • Identify hashtag algorithm and their attributes
  • Create regular expressions to select rows that match a pattern

Who is the course for?

This course is designed for programmers with a background in Python, who would like to take their PostgreSQL skills to the next level. Prior completion of the previous course on basic SQL will be very valuable.

Free Course on Learning Intermediate PostgreSQL


DISCLAIMER: Courses on Future Syllabus are free but subject to return to their original prices on host platforms upon coupon expiration. Enrol while they are free. To report any error, use the "Further Actions" tab.




Show full profile

Editor

Mass Communication Student, Federal University, Oye Ekiti and Content Creation Specialist. Join me on Twitter.

Stay active

Leave a Reply

Future Syllabus
Logo
Register New Account
Login/Register via your social accounts (fully secured)

or proceed manually
Reset Password