RiseUpp Logo
Educator Logo

Intermediate PostgreSQL

Learn advanced SQL techniques for data aggregation, transactions, parsing, and text handling in PostgreSQL databases.

Learn advanced SQL techniques for data aggregation, transactions, parsing, and text handling in PostgreSQL databases.

This comprehensive course builds on basic PostgreSQL knowledge, exploring advanced SQL techniques beyond CRUD operations. Students learn to work with aggregations, transactions, CSV file handling, and text processing using regular expressions. The course covers table schema alterations, stored procedures, advanced queries, and data sorting/grouping techniques while focusing on practical database management skills.

Instructors:

English

English

Powered by

Provider Logo
Intermediate PostgreSQL

This course includes

4 Weeks

Of Self-paced video lessons

Intermediate Level

Completion Certificate

awarded on course completion

4,925

Audit For Free

What you'll learn

  • Utilize advanced SQL commands for table manipulation and normalization

  • Implement effective text and date handling in databases

  • Create and manage stored procedures

  • Develop skills in regular expression pattern matching

  • Master data aggregation and transaction management

Skills you'll gain

PostgreSQL
SQL
Database Management
Data Parsing
Stored Procedures
Regular Expressions
Data Aggregation
Transaction Management

This course includes:

PreRecorded video

Graded assignments, Exams

Access on Mobile, Tablet, Desktop

Limited Access access

Shareable certificate

Closed caption

Get a Completion Certificate

Share your certificate with prospective employers and your professional network on LinkedIn.

Provided by

Certificate

Top companies offer this course to their employees

Top companies provide this course to enhance their employees' skills, ensuring they excel in handling complex projects and drive organizational success.

icon-0icon-1icon-2icon-3icon-4

Module Description

The course provides an in-depth exploration of intermediate PostgreSQL concepts and techniques. Students learn advanced SQL operations including table schema manipulation, stored procedures, and complex queries. The curriculum covers data aggregation, transaction handling, CSV file processing, and text manipulation with regular expressions. Emphasis is placed on practical applications and real-world database management scenarios.

Fee Structure

Instructor

Educational Technology Pioneer and Open Source Learning Advocate

Charles Severance, popularly known as Dr. Chuck, is a Clinical Professor at the University of Michigan School of Information where he has established himself as a leading figure in educational technology and open-source learning systems. His academic journey includes BS, MS, and PhD degrees in Computer Science from Michigan State University, followed by significant contributions to educational technology development. As the chief architect and later executive director of the Sakai Project, he led the development of a learning management system now used by over 300 schools worldwide. His expertise spans programming, database design, and web development, reflected in his widely-used books including "Python for Everybody," "Using Google App Engine," and "Sakai: Free as in Freedom." Beyond academia, Severance has made substantial contributions to technology education through media, hosting the television show "Internet:TCI" in the 1990s and writing the "Computing Conversations" column for IEEE Computer Magazine featuring interviews with technology pioneers. His current work focuses on developing massive open online courses (MOOCs) that have reached millions of learners globally, particularly his Python programming courses on Coursera and edX. He maintains active engagement with the technology community through his role as Chair of the Sakai Project Management Committee and his contributions to educational technology standards, including his work with the IMS Global Learning Consortium on Learning Tools Interoperability (LTI). Severance's impact on educational technology is further evidenced by his creation of innovative teaching methodologies and his commitment to making technology education accessible to global audiences through digital platforms.

Intermediate PostgreSQL

This course includes

4 Weeks

Of Self-paced video lessons

Intermediate Level

Completion Certificate

awarded on course completion

4,925

Audit For Free

Testimonials

Testimonials and success stories are a testament to the quality of this program and its impact on your career and learning journey. Be the first to help others make an informed decision by sharing your review of the course.

Frequently asked questions

Below are some of the most commonly asked questions about this course. We aim to provide clear and concise answers to help you better understand the course content, structure, and any other relevant information. If you have any additional questions or if your question is not listed here, please don't hesitate to reach out to our support team for further assistance.