We may earn an affiliate commission when you visit our partners.
Charles 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.
Read more
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.
Read more
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.
What you'll 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.
Register for this course and see more details by visiting:
OpenCourser.com/course/8m45yz/intermediate
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Introduces students to a wide range of SQL techniques that are more advanced than basic CRUD operations, which are common to all SQL databases
Provides practical experience by having students complete assignments that involve altering table schemas, creating stored procedures, constructing advanced queries, and working with text in databases including regular expressions
Teaches students how to utilize SQL commands for editing tables in a PostgreSQL database and producing properly normalized tables from CSV files
Ideal for those looking to enhance their understanding of SQL beyond basic operations and gain practical experience with more advanced techniques
Offers insights into working with text and dates in databases, and creating stored procedures
Taught by Charles Severance, an experienced instructor with a strong reputation in the field
Save this course
Save Intermediate PostgreSQL to your list so you can find it easily later:
Save
Save
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:
Review SQL Alter Table Syntax
Show steps
Get up-to-speed by refreshing your knowledge of SQL Alter Table syntax, a fundamental skill that lays the foundation for successful database management.
Browse courses on
SQL
Show steps
-
Read up on ALTER TABLE command
-
Go through examples of common use cases
-
Try out the syntax in practice exercises
Organize Course Notes and Assignments
Show steps
Stay organized by compiling course notes, assignments, and materials in a central location, ensuring you have easy access to important resources throughout the learning process.
Show steps
-
Gather all course materials
-
Create a system for organizing the materials
-
Store the materials in an accessible location
Discuss Advanced SQL Techniques
Show steps
Connect with fellow learners to discuss advanced SQL techniques covered in the course, fostering a deeper understanding through shared perspectives and collective problem-solving.
Browse courses on
SQL
Show steps
-
Identify a specific SQL technique
-
Prepare talking points and examples
-
Join a peer session and engage in discussions
Five other activities
Expand to see all activities and additional details
Show all eight activities
Aggregate Functions Exercise
Show steps
Strengthen your understanding of SQL aggregate functions through targeted practice, enabling you to effectively summarize and analyze data in your database.
Browse courses on
SQL aggregate functions
Show steps
-
Review common aggregate functions (e.g., SUM, COUNT, AVG)
-
Work through a series of exercises involving data aggregation
-
Check your answers and identify areas for improvement
Sorting and Grouping Query Data Exercises
Show steps
Sharpen your skills in sorting and grouping query data through targeted practice exercises, enabling you to organize and retrieve data in a meaningful way.
Browse courses on
SQL
Show steps
-
Review concepts of sorting and grouping in SQL
-
Complete a series of exercises involving sorting and grouping data
-
Analyze results and identify patterns
Develop a PostgreSQL Stored Procedure
Show steps
Enhance your practical skills by creating a PostgreSQL stored procedure, gaining hands-on experience with automating complex database operations and improving code reusability.
Browse courses on
SQL
Show steps
-
Design the stored procedure
-
Write the SQL code for the stored procedure
-
Test the stored procedure
Visualize Data with a Bar Chart
Show steps
Gain hands-on experience in presenting data visually by creating a bar chart using SQL. This activity will enhance your ability to communicate insights effectively.
Browse courses on
Data Visualization
Show steps
-
Choose a dataset and identify relevant variables
-
Use SQL to generate the data for the bar chart
-
Select a visualization tool and create the bar chart
Explore Regular Expressions in PostgreSQL
Show steps
Delve deeper into the use of regular expressions in PostgreSQL by following guided tutorials, equipping yourself with powerful tools for manipulating and extracting data from text.
Browse courses on
Regular Expressions
Show steps
-
Understand the basics of regular expressions
-
Follow tutorials on using regular expressions in PostgreSQL
-
Practice using regular expressions on sample data
Review SQL Alter Table Syntax
Show steps
Get up-to-speed by refreshing your knowledge of SQL Alter Table syntax, a fundamental skill that lays the foundation for successful database management.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Read up on ALTER TABLE command
- Go through examples of common use cases
- Try out the syntax in practice exercises
Organize Course Notes and Assignments
Show steps
Stay organized by compiling course notes, assignments, and materials in a central location, ensuring you have easy access to important resources throughout the learning process.
Show steps
Show steps
Show steps
- Gather all course materials
- Create a system for organizing the materials
- Store the materials in an accessible location
Discuss Advanced SQL Techniques
Show steps
Connect with fellow learners to discuss advanced SQL techniques covered in the course, fostering a deeper understanding through shared perspectives and collective problem-solving.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Identify a specific SQL technique
- Prepare talking points and examples
- Join a peer session and engage in discussions
Five other activities
Expand to see all activities and additional details
Show all eight activities
Aggregate Functions Exercise
Show steps
Strengthen your understanding of SQL aggregate functions through targeted practice, enabling you to effectively summarize and analyze data in your database.
Browse courses on
SQL aggregate functions
Show steps
Show steps
Show steps
- Review common aggregate functions (e.g., SUM, COUNT, AVG)
- Work through a series of exercises involving data aggregation
- Check your answers and identify areas for improvement
Sorting and Grouping Query Data Exercises
Show steps
Sharpen your skills in sorting and grouping query data through targeted practice exercises, enabling you to organize and retrieve data in a meaningful way.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Review concepts of sorting and grouping in SQL
- Complete a series of exercises involving sorting and grouping data
- Analyze results and identify patterns
Develop a PostgreSQL Stored Procedure
Show steps
Enhance your practical skills by creating a PostgreSQL stored procedure, gaining hands-on experience with automating complex database operations and improving code reusability.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Design the stored procedure
- Write the SQL code for the stored procedure
- Test the stored procedure
Visualize Data with a Bar Chart
Show steps
Gain hands-on experience in presenting data visually by creating a bar chart using SQL. This activity will enhance your ability to communicate insights effectively.
Browse courses on
Data Visualization
Show steps
Show steps
Show steps
- Choose a dataset and identify relevant variables
- Use SQL to generate the data for the bar chart
- Select a visualization tool and create the bar chart
Explore Regular Expressions in PostgreSQL
Show steps
Delve deeper into the use of regular expressions in PostgreSQL by following guided tutorials, equipping yourself with powerful tools for manipulating and extracting data from text.
Browse courses on
Regular Expressions
Show steps
Show steps
Show steps
- Understand the basics of regular expressions
- Follow tutorials on using regular expressions in PostgreSQL
- Practice using regular expressions on sample data
Career center
Learners who complete Intermediate PostgreSQL will develop knowledge and skills
that may be useful to these careers:
Data Engineer
Data Engineer
Data Engineers design, build, and maintain data pipelines and infrastructure to support data analysis and machine learning applications. This course can equip Data Engineers with the necessary skills to work with PostgreSQL, including handling CSV files, creating stored procedures, and optimizing database performance, which are essential for building robust and efficient data pipelines.
Data Analyst
Data Analyst
Data Analysts use data to identify trends and patterns, solve problems, and make informed decisions. This course can benefit Data Analysts by enhancing their SQL skills and providing them with advanced techniques for data analysis, such as aggregation, sorting, and grouping query data, which can help them extract meaningful insights from complex datasets.
Operations Analyst
Operations Analyst
Operations Analysts analyze business processes and data to identify inefficiencies and opportunities for improvement. This course can provide Operations Analysts with a strong understanding of PostgreSQL, enabling them to effectively collect, manage, and analyze operational data, which is essential for process optimization and decision-making.
Database Administrator
Database Administrator
Database Administrators (DBAs) are responsible for the day-to-day administration and maintenance of database systems, including performance tuning, security, and backup and recovery. This course can provide DBAs with a strong foundation in PostgreSQL, enabling them to effectively manage and optimize database performance and ensure data integrity.
Business Intelligence Analyst
Business Intelligence Analyst
Business Intelligence Analysts use data analysis techniques to help businesses understand their operations and make informed decisions. This course can equip Business Intelligence Analysts with advanced SQL skills, such as data aggregation and grouping, which are essential for extracting meaningful insights and developing actionable recommendations from complex datasets.
Data Scientist
Data Scientist
Data Scientists use scientific methods, processes, algorithms, and systems to extract knowledge and insights from data in various forms, both structured and unstructured. This course can provide Data Scientists with a solid understanding of PostgreSQL, enabling them to effectively retrieve, manipulate, and analyze data for data modeling, machine learning, and predictive analytics.
Market Researcher
Market Researcher
Market Researchers conduct research to understand consumer behavior and market trends. This course can benefit Market Researchers by providing them with advanced SQL techniques for data analysis, such as sorting and grouping query data, which can help them extract meaningful insights from market research data and identify opportunities for businesses.
Statistician
Statistician
Statisticians collect, analyze, interpret, and present data to provide insights and make informed decisions. This course can provide Statisticians with a strong foundation in PostgreSQL, enabling them to effectively manage and manipulate data for statistical analysis, modeling, and forecasting.
Database Manager
Database Manager
Database Managers are responsible for the planning, implementation, and maintenance of database systems, including database design, performance monitoring, and security. This course can help individuals in this role by providing them with a deeper understanding of SQL techniques and how to handle and index text data in PostgreSQL, which can aid in data management and analysis tasks.
Web Developer
Web Developer
Web Developers design, build, and maintain websites and web applications. This course can help Web Developers create dynamic and data-driven web applications by providing them with a deeper understanding of PostgreSQL and advanced SQL techniques for data manipulation and retrieval, which can enhance the functionality and performance of their web applications.
IT Auditor
IT Auditor
IT Auditors evaluate the security and effectiveness of IT systems and processes. This course can benefit IT Auditors by providing them with a deeper understanding of PostgreSQL, including data security, access control, and auditing techniques, which are essential for ensuring the integrity and compliance of IT systems.
Financial Analyst
Financial Analyst
Financial Analysts use financial data and analysis to make investment recommendations and advise clients on financial matters. This course can equip Financial Analysts with the necessary SQL skills to effectively analyze financial data, perform financial modeling, and make data-driven investment decisions.
Software Engineer
Software Engineer
Software Engineers design, develop, test, and maintain software systems. This course can be beneficial for Software Engineers who work with PostgreSQL in their projects, as it provides them with advanced SQL techniques, such as stored procedures and regular expressions, which can help them optimize database interactions and enhance software performance.
Information Security Analyst
Information Security Analyst
Information Security Analysts protect computer systems and networks from unauthorized access, use, disclosure, disruption, modification, or destruction. This course can equip Information Security Analysts with the necessary SQL skills to analyze security logs, identify vulnerabilities, and investigate security incidents in PostgreSQL databases.
Information Architect
Information Architect
Information Architects design and organize information systems to meet the needs of users. This course can provide Information Architects with a solid understanding of PostgreSQL, enabling them to effectively structure and manage data, ensuring that it is accessible, consistent, and easily retrievable for users.
For more career information including salaries, visit:
OpenCourser.com/course/8m45yz/intermediate
Reading list
We've selected eight 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.
This guide comprehensive introduction to PostgreSQL. It covers the basics of PostgreSQL, including installation, configuration, and basic SQL commands.
Provides a collection of recipes for PostgreSQL administration. It covers all aspects of PostgreSQL administration, from backups to security.
Teaches you how to use PostgreSQL for DevOps. It covers all aspects of DevOps, from continuous integration to continuous delivery.
A comprehensive textbook on database systems, covering all aspects of database design, implementation, and management. It provides theoretical background and practical examples.
A guide to SQL performance optimization, covering topics such as query tuning, index design, and data modeling. It provides practical tips and techniques.
A guide to relational theory and SQL, covering topics such as data modeling, query optimization, and database normalization. It provides theoretical background and practical examples.
A guide to software development best practices, covering topics such as design patterns, testing, and refactoring. It provides practical advice and insights for software developers of all levels.
A cookbook of regular expressions for various tasks, including text parsing, data validation, and pattern matching. It provides practical examples and explanations.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/8m45yz/intermediate
Share
Similar courses
Here are nine courses similar to
Intermediate PostgreSQL.
Intermediate PostgreSQL
OpenCourser.com/course/v894zb/intermediate
Intermediate PostgreSQL
Most relevant
Introduction to Regular Expressions in SQL
OpenCourser.com/course/zj0vng/introduction
Introduction to Regular Expressions in SQL
Most relevant
Managing Relational Databases
OpenCourser.com/course/dhv4t2/managing
Managing Relational Databases
Most relevant
Learn SQL Using PostgreSQL: From Zero to Hero
OpenCourser.com/course/249csj/learn
Learn SQL Using PostgreSQL: From Zero to Hero
Most relevant
Database Design and Basic SQL in PostgreSQL
OpenCourser.com/course/ghigjn/database
Database Design and Basic SQL in PostgreSQL
Most relevant
SQL: A Practical Introduction for Querying Databases
OpenCourser.com/course/54rc5b/sql
SQL: A Practical Introduction for Querying Databases
Most relevant
Inheritance and Data Structures in Java
OpenCourser.com/course/pf5rad/inheritance
Inheritance and Data Structures in Java
Most relevant
Relational Database Basics
OpenCourser.com/course/r7wyip/relational
Relational Database Basics
Most relevant
Database Design and Basic SQL in PostgreSQL
OpenCourser.com/course/f6b20m/database
Database Design and Basic SQL in PostgreSQL
Most relevant
Effort
2 to 4 hours per week for 4 weeks
Level
Introductory
Via
edX
Institution
The University of Michigan
Instructor
Charles Severance
Language
English
Transcript
English
Good to know
Introduces students to a wide range of SQL techniques that are more advanced than basic CRUD operations, which are common to all SQL databases
Provides practical experience by having students complete assignments that involve altering table schemas, creating stored procedures, constructing advanced queries, and working with text in databases including regular expressions
Teaches students how to utilize SQL commands for editing tables in a PostgreSQL database and producing properly normalized tables from CSV files
Ideal for those looking to enhance their understanding of SQL beyond basic operations and gain practical experience with more advanced techniques
Offers insights into working with text and dates in databases, and creating stored procedures
Taught by Charles Severance, an experienced instructor with a strong reputation in the field
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