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
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
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.
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.
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.
Good to know
Good to know
Know what's good ,
what to watch for , 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
Save Intermediate PostgreSQL to your list so you can find it easily later:
Save
Save
Reviews summary
Well-received postgresql course
Learners say this course provides excellent content for students with intermediate-level PostgreSQL knowledge. The assignments are well-received by students and are considered very practical. The material is engaging, and students appreciate the friendly attitude of the knowledgeable instructor, Dr. Charles Russell Severance, who is passionate about teaching SQL.
Covers advanced PostgreSQL topics.
"Excellent course with lots of non basic SQL and Postgres material."
"Introduce performance consideration in sql database and how PostreSQL tackle this with indexes."
"This course has multiple essential things that need for every database developers :)"
Practical exercises help learners apply skills.
"The assignments seem overwhelming at first but are actually quite easy if you pay attention to the lectures."
"Very down to earth and practical course on postgres. I especially liked the interactive graded assignments as well as friendly and informal attitude of mr. Severance."
Knowledgeable and passionate instructor
"Dr. Chuck is the best. He makes learning enjoyable."
"It's always a delight to learn from Dr. Charles Russell Severance."
"The course content is challenging from the start. Excellent approach on the subject with great explanations and very complete support material."
Some students find assignments too easy.
"The course is good but the assignments are easy."
"Could have more exercises and they could be more complex too"
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.
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.
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.
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.
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.
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.
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
Here are nine courses similar to
Intermediate PostgreSQL.
Intermediate PostgreSQL
OpenCourser.com/course/8m45yz/intermediate
Intermediate PostgreSQL
Most relevant
JSON and Natural Language Processing in PostgreSQL
OpenCourser.com/course/16w6ft/json
JSON and Natural Language Processing in PostgreSQL
Database Design and Basic SQL in PostgreSQL
OpenCourser.com/course/ghigjn/database
Database Design and Basic SQL in PostgreSQL
JSON and Natural Language Processing in PostgreSQL
OpenCourser.com/course/wbdgds/json
JSON and Natural Language Processing in PostgreSQL
Database Design and Basic SQL in PostgreSQL
OpenCourser.com/course/f6b20m/database
Database Design and Basic SQL in PostgreSQL
Guided Project: Create & Load tables in PostgreSQL database
OpenCourser.com/course/jrcrw8/guided
Guided Project: Create & Load tables in PostgreSQL...
Guided Project: Create & Load tables in PostgreSQL database V2
OpenCourser.com/course/sfne1e/guided
Guided Project: Create & Load tables in PostgreSQL...
PostgreSQL Data Manipulation Playbook
OpenCourser.com/course/v5qkc2/postgresql
PostgreSQL Data Manipulation Playbook
SQL - The Complete Developer's Guide (MySQL, PostgreSQL)
OpenCourser.com/course/jbxoe9/sql
SQL - The Complete Developer's Guide (MySQL, PostgreSQL)
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:
Good to know
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
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 - 2024 OpenCourser