We may earn an affiliate commission when you visit our partners.
Charles Russell Severance
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/v894zb/intermediate
Two deals to help you save
Save money when you learn. Here are two deals and offers that may be relevant to this course.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Valid until July 14
Coursera Plus Annual
Work toward what's next for your career with access to 10,000+ programs. Discover emerging skills and save.
Up to
40%
off
Get offer
Valid until August 30
Google AI App Builder
Learn how to use Gemini API and API Studio with a three-course series from Google DeepMind
Take
100%
off
Get offer
What's inside
Syllabus
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.
Read more
Syllabus
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.
Read more
Traffic lights
Traffic lights
Read about what's good
what should give you pause and
possible dealbreakers
Covers advanced SQL techniques beyond basic CRUD operations, making it suitable for learners with prior SQL experience
Involves assignments that challenge learners to explore advanced SQL capabilities, such as creating stored procedures, constructing advanced queries, and working with text data using regular expressions
Taught by Charles Russell Severance, an experienced instructor who is recognized for their expertise in SQL
Offers a comprehensive study of advanced SQL techniques, making it suitable for those seeking to develop their SQL skills
Save this course
Create your own learning path.
Save this course to your list so you can find it easily later.
Save
Save
Reviews summary
Intermediate postgresql: beyond basic sql
According to learners, this course provides a solid foundation in intermediate PostgreSQL techniques, effectively moving beyond basic CRUD operations. It is particularly strong in covering practical applications such as altering table schemas, creating stored procedures, and constructing advanced queries. Students generally appreciate the dedicated modules on text handling and regular expressions, finding them highly relevant for real-world data scenarios. While the course is generally well-structured and comprehensive for its stated level, some suggest that a strong prior understanding of basic SQL is essential to fully benefit from the pace and depth of the topics covered.
Thoroughly covers essential intermediate PostgreSQL features.
"The coverage of aggregation and transactions provided a solid foundation for more complex operations."
"I found the sections on how PostgreSQL handles and indexes text data particularly useful and well-explained."
"Exploring regular expressions for pattern matching in data was a valuable skill that I immediately applied."
Focuses on applying advanced SQL for real-world tasks.
"I appreciated the assignments that alter table schemas and create stored procedures, they were very hands-on."
"The course helped me construct advanced queries for complex data manipulations that I could immediately use."
"Learning to read and parse CSV files directly into the database was a very practical skill for my work."
Some advanced topics might benefit from more in-depth exploration.
"While comprehensive, the text indexing and regex sections felt more like an introduction than a deep dive into all nuances."
"I would have liked more complex optimization techniques or advanced transaction scenarios in the later weeks."
"It covers a wide range of intermediate features, but I occasionally wished for more advanced problem-solving exercises."
Requires a strong foundation in basic SQL operations.
"This course truly is intermediate; make sure you're comfortable with basic CRUD first, or you'll struggle with the pace."
"I found it challenging at times because I hadn't sufficiently mastered foundational SQL before diving into this content."
"It assumes a certain level of familiarity with database concepts, which is fair given it's titled 'intermediate'."
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Intermediate PostgreSQL with these
activities:
Database Concepts Review
Show steps
Revisit key database concepts to ensure a solid foundation for the course material, such as data modeling, normalization, and data integrity.
Browse courses on
Database Concepts
Show steps
-
Review your notes or textbooks on database concepts.
-
Complete practice exercises to test your understanding.
SQL Review
Show steps
Review the fundamentals of SQL to refresh your memory and prepare for the more advanced topics covered in the course.
Show steps
-
Revisit your notes or textbooks on basic SQL concepts.
-
Complete practice exercises to test your understanding.
Course Resource Compilation
Show steps
Gather and organize all relevant course materials, including notes, assignments, quizzes, and exams, to facilitate effective studying and revision.
Show steps
-
Create a dedicated folder or notebook for course materials.
-
Regularly update your compilation with new materials.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Advanced SQL Tutorials
Show steps
Expand your knowledge of SQL techniques by following guided tutorials that cover advanced topics such as window functions, joins, and subqueries.
Browse courses on
Advanced SQL
Show steps
-
Identify areas where you want to improve your SQL skills.
-
Find reputable online resources or books that provide tutorials on advanced SQL topics.
-
Follow the tutorials step-by-step and practice the concepts.
SQL Queries Practice
Show steps
Complete numerous SQL queries tasks to reinforce your understanding of basic CRUD operations and more advanced techniques.
Browse courses on
SQL Queries
Show steps
-
Review the course materials on basic SQL queries.
-
Attempt the practice problems provided in the course.
-
Use online resources or textbooks to find additional practice problems.
SQL Study Group
Show steps
Join or form a study group with peers to discuss course concepts, work on assignments together, and enhance your understanding.
Show steps
-
Find or create a study group with other students taking the course.
-
Meet regularly to discuss course materials, ask questions, and share knowledge.
-
Collaborate on assignments and projects to benefit from diverse perspectives.
Data Analysis Project
Show steps
Develop a data analysis project using SQL to demonstrate your skills in data manipulation, aggregation, and visualization.
Browse courses on
Data Analysis
Show steps
-
Choose a dataset that aligns with your interests.
-
Design a data analysis plan, including the research questions you want to answer.
-
Write SQL queries to extract, transform, and analyze the data.
-
Create data visualizations to present your findings.
Database Concepts Review
Show steps
Revisit key database concepts to ensure a solid foundation for the course material, such as data modeling, normalization, and data integrity.
Browse courses on
Database Concepts
Show steps
Show steps
Show steps
- Review your notes or textbooks on database concepts.
- Complete practice exercises to test your understanding.
SQL Review
Show steps
Review the fundamentals of SQL to refresh your memory and prepare for the more advanced topics covered in the course.
Show steps
Show steps
Show steps
- Revisit your notes or textbooks on basic SQL concepts.
- Complete practice exercises to test your understanding.
Course Resource Compilation
Show steps
Gather and organize all relevant course materials, including notes, assignments, quizzes, and exams, to facilitate effective studying and revision.
Show steps
Show steps
Show steps
- Create a dedicated folder or notebook for course materials.
- Regularly update your compilation with new materials.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Advanced SQL Tutorials
Show steps
Expand your knowledge of SQL techniques by following guided tutorials that cover advanced topics such as window functions, joins, and subqueries.
Browse courses on
Advanced SQL
Show steps
Show steps
Show steps
- Identify areas where you want to improve your SQL skills.
- Find reputable online resources or books that provide tutorials on advanced SQL topics.
- Follow the tutorials step-by-step and practice the concepts.
SQL Queries Practice
Show steps
Complete numerous SQL queries tasks to reinforce your understanding of basic CRUD operations and more advanced techniques.
Browse courses on
SQL Queries
Show steps
Show steps
Show steps
- Review the course materials on basic SQL queries.
- Attempt the practice problems provided in the course.
- Use online resources or textbooks to find additional practice problems.
SQL Study Group
Show steps
Join or form a study group with peers to discuss course concepts, work on assignments together, and enhance your understanding.
Show steps
Show steps
Show steps
- Find or create a study group with other students taking the course.
- Meet regularly to discuss course materials, ask questions, and share knowledge.
- Collaborate on assignments and projects to benefit from diverse perspectives.
Data Analysis Project
Show steps
Develop a data analysis project using SQL to demonstrate your skills in data manipulation, aggregation, and visualization.
Browse courses on
Data Analysis
Show steps
Show steps
Show steps
- Choose a dataset that aligns with your interests.
- Design a data analysis plan, including the research questions you want to answer.
- Write SQL queries to extract, transform, and analyze the data.
- Create data visualizations to present your findings.
Career center
Learners who complete Intermediate PostgreSQL will develop knowledge and skills
that may be useful to these careers:
Data Analyst
Data Analyst
As a Data Analyst, your primary duties involve collecting, analyzing, and interpreting data. The Intermediate PostgreSQL course from the University of Michigan would be a great resource to have under your belt, as you'll gain knowledge to organize and present this data in a clear and concise format. This course is specifically designed to provide you with the skills needed to handle and index text data, which can be invaluable for making informed decisions.
Software Developer
Software Developer
A Software Developer designs computer programs, including those used for databases. The Intermediate PostgreSQL course can bolster your ability to perform these duties, as you'll gain a thorough understanding of SQL techniques and text in PostgreSQL. This course will provide the foundation needed to develop efficient code and applications that interact with databases, which is a critical skill for Software Developers.
Database Administrator
Database Administrator
Database Administrators (DBAs) manage and maintain an organization's databases, which may include PostgreSQL. The Intermediate PostgreSQL course can help you develop the skills to perform these tasks effectively. You'll learn how to alter table schemas, create stored procedures, and construct advanced queries, all of which are valuable skills for DBAs.
Information Security Analyst
Information Security Analyst
Information Security Analysts are responsible for protecting an organization's computer systems and data from unauthorized access or damage. The Intermediate PostgreSQL course delves into teaching students how to use PostgreSQL to handle and index text data. This knowledge is vital for Information Security Analysts, as they need to be able to parse and analyze large amounts of data to identify and mitigate security risks.
Data Scientist
Data Scientist
Data Scientists use their knowledge of statistics, data analysis, and programming to extract insights from data. The University of Michigan's Intermediate PostgreSQL course provides a strong foundation for Data Scientists, as it covers topics such as SQL techniques and text in PostgreSQL. These skills are essential for Data Scientists who need to be able to query and analyze data efficiently.
Business Analyst
Business Analyst
A Business Analyst uses data to help businesses make better decisions. The Intermediate PostgreSQL course from the University of Michigan provides a solid foundation for Business Analysts, as it covers topics such as SQL techniques and text in PostgreSQL. This knowledge is essential for Business Analysts who need to be able to query and analyze data to identify trends and insights.
Statistician
Statistician
Statisticians use mathematical and statistical methods to collect, analyze, interpret, and present data. The Intermediate PostgreSQL course from the University of Michigan provides a solid foundation for Statisticians, as it covers topics such as SQL techniques and text in PostgreSQL. This knowledge is essential for Statisticians who need to be able to query and analyze data to draw conclusions.
Machine Learning Engineer
Machine Learning Engineer
Machine Learning Engineers build and maintain machine learning models. The University of Michigan's Intermediate PostgreSQL course may be useful for Machine Learning Engineers, as it covers topics such as SQL techniques and text in PostgreSQL. This knowledge may be helpful for Machine Learning Engineers who need to be able to query and analyze data to train and evaluate machine learning models.
Quantitative Analyst
Quantitative Analyst
Quantitative Analysts use mathematical and statistical models to analyze financial data. The Intermediate PostgreSQL course from the University of Michigan may be useful for Quantitative Analysts, as it covers topics such as SQL techniques and text in PostgreSQL. This knowledge may be helpful for Quantitative Analysts who need to be able to query and analyze data to make financial decisions.
Operations Research Analyst
Operations Research Analyst
Operations Research Analysts use mathematical and analytical methods to solve business problems. The Intermediate PostgreSQL course from the University of Michigan may be useful for Operations Research Analysts, as it covers topics such as SQL techniques and text in PostgreSQL. This knowledge may be helpful for Operations Research Analysts who need to be able to query and analyze data to develop and evaluate solutions to business problems.
Data Engineer
Data Engineer
Data Engineers build and maintain data pipelines that collect and process data for use in machine learning and data analysis. The Intermediate PostgreSQL course from the University of Michigan may be useful for Data Engineers, as it covers topics such as SQL techniques and text in PostgreSQL. This knowledge may be helpful for Data Engineers who need to be able to query and analyze data to build and maintain data pipelines.
Information Architect
Information Architect
Information Architects design and maintain the structure of information systems. The Intermediate PostgreSQL course from the University of Michigan may be useful for Information Architects, as it covers topics such as SQL techniques and text in PostgreSQL. This knowledge may be helpful for Information Architects who need to be able to query and analyze data to design and maintain information systems.
Data Warehouse Architect
Data Warehouse Architect
Data Warehouse Architects design and maintain data warehouses. The Intermediate PostgreSQL course from the University of Michigan may be useful for Data Warehouse Architects, as it covers topics such as SQL techniques and text in PostgreSQL. This knowledge may be helpful for Data Warehouse Architects who need to be able to query and analyze data to design and maintain data warehouses.
ETL Developer
ETL Developer
ETL Developers design and implement data pipelines that extract, transform, and load data from various sources to make it available for analysis. The Intermediate PostgreSQL course from the University of Michigan may be useful for ETL Developers, as it covers topics such as SQL techniques and text in PostgreSQL. This knowledge may be helpful for ETL Developers who need to be able to query and analyze data to design and implement data pipelines.
Database Designer
Database Designer
Database Designers create and maintain the structure of databases. The Intermediate PostgreSQL course from the University of Michigan may be useful for Database Designers, as it covers topics such as SQL techniques and text in PostgreSQL. This knowledge may be helpful for Database Designers who need to be able to query and analyze data to design and maintain databases.
For more career information including salaries, visit:
OpenCourser.com/course/v894zb/intermediate
Reading list
We've selected six books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Intermediate PostgreSQL.
The official PostgreSQL documentation. Provides comprehensive coverage of all aspects of PostgreSQL, serving as a valuable reference for both beginners and experienced users. Useful for in-depth understanding of specific topics covered in this course.
A comprehensive guide to PostgreSQL best practices and design patterns. Provides valuable insights into how to design and implement efficient and scalable PostgreSQL databases, complementing the topics covered in this course.
A comprehensive guide to SQL performance tuning. Provides a deeper understanding of SQL optimization techniques, complementing the performance-related topics covered in this course.
A comprehensive guide to regular expressions. Provides a solid foundation in regular expressions, which are used in this course for text processing and data manipulation.
A beginner-friendly guide to PostgreSQL, covering installation, configuration, and basic SQL commands. Useful for building a foundation in PostgreSQL before taking this course.
Save
The official PostgreSQL user guide. Provides a quick introduction to PostgreSQL and its features. Useful for getting started with PostgreSQL, complementing the introductory topics covered in this course.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/v894zb/intermediate
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
Rating
4.7
Effort
Approx. 16 hours
Level
Intermediate
Via
Coursera
Institution
University of Michigan
Instructor
Charles Russell Severance
Language
English
Transcripts
Español
Français
Português
Deutsch
Italiano
中文
العربية
한국어
日本語
हिंदी
Nederlands
Svenska
Pусский
Türkçe
Polski
Ελληνικά
українська мова
magyar nyelv
Bahasa Indonesia
ไทย
қазақша
اُردُو,
فارسی
বাংলা
پښتو
آذربایجان دیلی
This course belongs to a
collection
called
PostgreSQL for Everybody. It's comprised of four courses:
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2025 OpenCourser