This course is part of the PostgreSQL for Everybody Specialization

4.9
stars
125 ratings

Charles Russell Severance

3,994 already enrolled

Offered By

PostgreSQL for Everybody SpecializationUniversity of Michigan

About this Course

30,991 recent views

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.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 2 of 4 in the

PostgreSQL for Everybody Specialization

Intermediate Level

Completion of first two courses in the Python for Everybody specialization or an equivalent basic understanding of Python

Approx. 16 hours to complete

English

Subtitles: English

What you will 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.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 2 of 4 in the

PostgreSQL for Everybody Specialization

Intermediate Level

Completion of first two courses in the Python for Everybody specialization or an equivalent basic understanding of Python

Approx. 16 hours to complete

English

Subtitles: English

Instructor

Instructor rating

4.9/5 (33 Ratings)

Charles Russell Severance

Clinical Professor

School of Information

3,219,547 Learners

47 Courses

Offered by

University of Michigan

The mission of the University of Michigan is to serve the people of Michigan and the world through preeminence in creating, communicating, preserving and applying knowledge, art, and academic values, and in developing leaders and citizens who will challenge the present and enrich the future.

Syllabus - What you will learn from this course

Week

Week 1

7 hours to complete

SQL Techniques

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.

7 hours to complete

14 videos (Total 122 min), 6 readings, 6 quizzes

14 videos

Welcome to Intermediate SQL!1m

Altering Table Schema4m

Dates14m

DISTINCT / GROUP BY11m

Demonstration: SELECT DISTINCT8m

Demonstration: GROUP BY6m

Subqueries9m

Demonstration: Subqueries8m

Concurrency and Transactions15m

Demonstration: Concurrency and Transactions19m

Stored Procedures8m

Demonstration: Stored Procedures5m

Office Hours Hyderabad, India - PyCon5m

Office Hours: Puebla, Mexico1m

6 readings

Help Us Learn More About You5m

Syllabus10m

Each Course Uses a Different Database10m

How Assignments Work10m

Connecting to Your Database Server10m

Assessment Philosophy5m

1 practice exercise

Intermediate SQL10m

Week

Week 2

3 hours to complete

Using SQL Techniques

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.

3 hours to complete

5 videos (Total 25 min)

Week

Week 3

4 hours to complete

Text in PostgreSQL

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

4 hours to complete

10 videos (Total 113 min), 1 reading, 3 quizzes

10 videos

Text in Databases4m

Text Function20m

Character Sets17m

Character Sets in Python6m

Inside Hashes20m

Bruce Schneier - Cryptography, Hashing, and NIST11m

Index Choices and Index Techniques14m

Demonstration: Generating and Scanning Text11m

Office Hours - New York City4m

Office Hours, Miami, Florida, USA2m

1 reading

Bruce Schneier - Cryptography, Hashing, and NIST10m

1 practice exercise

Text and PostgreSQL10m

Week

Week 4

2 hours to complete

Regular Expressions

In our final week, we will focus on regular expressions: their functions, and how to construct them to select rows from a table that match a pattern.

2 hours to complete

6 videos (Total 41 min), 1 reading, 2 quizzes

Reviews

4.9

26 reviews

5 stars
90.69%
4 stars
9.30%

About the PostgreSQL for Everybody Specialization

Across these four courses, you’ll learn how to use the PostgreSQL database and explore topics ranging from database design to database architecture and deployment. You’ll also compare and contrast SQL and NoSQL approaches to database design. The skills in this course will be useful to learners doing data mining or application development.

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Is financial aid available?
Yes, Coursera provides financial aid to learners who cannot afford the fee. Apply for it by clicking on the Financial Aid link beneath the "Enroll" button on the left. You'll be prompted to complete an application and will be notified if you are approved. You'll need to complete this step for each course in the Specialization, including the Capstone Project. Learn more.

More questions? Visit the Learner Help Center.

Intermediate PostgreSQL