This course is part of the PostgreSQL for Everybody Specialization

4.8
stars
225 ratings

Charles Russell Severance

9,490 already enrolled

Offered By

PostgreSQL for Everybody SpecializationUniversity of Michigan

About this Course

27,910 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.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

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

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

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.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

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

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructor

Instructor rating

4.88/5 (56 Ratings)

Charles Russell Severance

Clinical Professor

School of Information

3,780,877 Learners

56 Courses

Offered by

University of Michigan

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Week1

Week 1

7 hours to complete

SQL Techniques

7 hours to complete

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

14 videos

Welcome to Intermediate SQL!1mAltering Table Schema4mDates14mDISTINCT / GROUP BY11mDemonstration: SELECT DISTINCT8mDemonstration: GROUP BY6mSubqueries9mDemonstration: Subqueries8mConcurrency and Transactions15mDemonstration: Concurrency and Transactions19mStored Procedures8mDemonstration: Stored Procedures5mOffice Hours Hyderabad, India - PyCon5mOffice Hours: Puebla, Mexico1m

6 readings

Help Us Learn More About You5mSyllabus10mEach Course Uses a Different Database10mHow Assignments Work10mConnecting to Your Database Server10mAssessment Philosophy5m

1 practice exercise

Intermediate SQL10m

Week2

Week 2

3 hours to complete

Using SQL Techniques

3 hours to complete

5 videos (Total 25 min)

Week3

Week 3

4 hours to complete

Text in PostgreSQL

4 hours to complete

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

10 videos

Text in Databases4mText Function20mCharacter Sets17mCharacter Sets in Python6mInside Hashes20mBruce Schneier - Cryptography, Hashing, and NIST11mIndex Choices and Index Techniques14mDemonstration: Generating and Scanning Text11mOffice Hours - New York City4mOffice Hours, Miami, Florida, USA2m

1 reading

Bruce Schneier - Cryptography, Hashing, and NIST10m

1 practice exercise

Text and PostgreSQL10m

Week4

Week 4

2 hours to complete

Regular Expressions

2 hours to complete

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

Reviews

4.8

55 reviews

5 stars
84.88%
4 stars
11.55%
3 stars
1.33%
2 stars
1.33%
1 star
0.88%

About the PostgreSQL for Everybody Specialization

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. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

Intermediate PostgreSQL

About this Course

What you will learn