University of Michigan - Intermediate PostgreSQL
- Offered byCoursera
Intermediate PostgreSQL at Coursera Overview
Duration | 16 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Intermediate PostgreSQL at Coursera Highlights
- 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
- Flexible deadlines Reset deadlines in accordance to your schedule.
- 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
Intermediate PostgreSQL at Coursera Course details
- 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.
Intermediate PostgreSQL at Coursera Curriculum
SQL Techniques
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
Office Hours Hyderabad, India - PyCon
Office Hours: Puebla, Mexico
Help Us Learn More About You
Each Course Uses a Different Database
How Assignments Work
Connecting to Your Database Server
Assessment Philosophy
Intermediate SQL
Using SQL Techniques
Demo Reading and Parsing Files
Demonstration: Creating and Loading a Database
Demonstration: Loading and Normalizing CSV Data
Office Hours - Gingerman Raceway, South Haven, Michigan, USA
Office Hours - Haag, Netherlands
Text in PostgreSQL
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
Office Hours - New York City
Office Hours, Miami, Florida, USA
Bruce Schneier - Cryptography, Hashing, and NIST
Text and PostgreSQL
Regular Expressions
Regular Expressions
Using Regular Expressions
Demonstration: Regular Expressions
Demonstration: Flat files, Regex, Email
Course Wrap Up
Office Hours, Mountain View, California, USA
Post-Course Survey
Regular Expressions
Intermediate PostgreSQL at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?