We may earn an affiliate commission when you visit our partners.
Gerald Britton
Most programming languages come with built-in functions and SQL is no exception. In this course, you'll learn about the ANSI SQL functions and operators implemented by PostgreSQL and a good portion of the of those unique to this popular system.
Read more
Most programming languages come with built-in functions and SQL is no exception. In this course, you'll learn about the ANSI SQL functions and operators implemented by PostgreSQL and a good portion of the of those unique to this popular system.
Read more
Most programming languages come with built-in functions and SQL is no exception. In this course, you'll learn about the ANSI SQL functions and operators implemented by PostgreSQL and a good portion of the of those unique to this popular system.
At the core of a database developer's skill set is a solid knowledge of Structured Query Language, often called by its acronym, SQL. Most database vendors strive to implement as many of the ANSI SQL standards as possible, including the functions defined in that standard. PostgreSQL does a better job than some others in its adherence to the standard, including the ANSI SQL functions.
In this course, PostgreSQL Functions Playbook, you will learn both sets of functions and how they can be used to write simpler, more effective queries. First, you'll have a quick review of the most common data types and how to use functions to build, convert, and format them to get started. Then, you will explore the many other functions and operators that work on those types for a wide variety of purposes. Finally, you'll discover how to use system functions to extract data about the system itself. When you are finished with this course, you'll have a foundational knowledge of PostgreSQL functions as well as the ANSI functions it implements, that will help you move forward as a database developer, both in PostgreSQL and other database systems.
Software required: You will need access to a running PostgreSQL database with populated tables and an IDE to use for editing and running queries. The demos in the course use an instance of PostgreSQL running in a docker container and Azure Data Studio for the IDE but you are free to use a PostgreSQL database and IDE of your choice.
Register for this course and see more details by visiting:
OpenCourser.com/course/e83bmi/postgresql
What's inside
Syllabus
Course Overview
Introducing Built In Functions in PostgreSQL
Understanding Data Types
Doing Math with Operators and Functions
Read more
Syllabus
Course Overview
Introducing Built In Functions in PostgreSQL
Understanding Data Types
Doing Math with Operators and Functions
Read more
Handling Character Data with String Functions and Operators
Time Travel with Date and Time Functions
Calculating Values over Row Groups Using Windowing Functions
Controlling Results with Subquery and Conditional Functions
Using Array and Range Functions
Digging into Metadata with System Information and Administration Functions
Course Summary
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Suitable for both Postgres SQL beginners and users of other database systems
Provides comprehensive understanding of PostgreSQL functions, including those defined under ANSI SQL
Taught by experienced instructor Gerald Britton
Leverages multiple learning formats to enhance the learning experience
Provides opportunity for hands-on practice through access to a running PostgreSQL database
Save this course
Save PostgreSQL Functions Playbook 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 PostgreSQL Functions Playbook with these
activities:
Review SQL Basics
Show steps
Reinforce your understanding of fundamental SQL concepts, making it easier to follow along with the course material.
Show steps
-
Go over your notes from a previous SQL course or tutorial.
-
Review online tutorials or documentation on SQL basics.
-
Try solving some practice problems or exercises.
Seek Guidance from Experienced PostgreSQL Professionals
Show steps
Connect with experts in the field to gain valuable insights and accelerate your learning.
Show steps
-
Attend industry events or conferences.
-
Reach out to PostgreSQL professionals on LinkedIn or other platforms.
-
Request guidance or mentorship on specific PostgreSQL topics.
Join a Study Group or Online Forum
Show steps
Engage with other learners and discuss course concepts, enhancing your understanding through collaboration.
Show steps
-
Find a study group or online forum dedicated to PostgreSQL.
-
Participate in discussions and ask questions.
-
Help other learners by answering their questions.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Follow Along with PostgreSQL Tutorials
Show steps
Gain practical experience by following step-by-step tutorials on PostgreSQL.
Show steps
-
Search for online tutorials or courses on PostgreSQL.
-
Choose a tutorial that aligns with your learning goals.
-
Follow the instructions in the tutorial and complete the exercises.
Practice Writing SQL Queries
Show steps
Improve your proficiency in writing SQL queries by practicing regularly.
Show steps
-
Find a set of practice problems or exercises online.
-
Set aside some time each week to work on these problems.
-
Review your solutions and identify areas where you can improve.
Build a Simple PostgreSQL Database
Show steps
Apply your knowledge by creating a functional PostgreSQL database, solidifying your understanding of the concepts.
Show steps
-
Design the schema for your database.
-
Create the database and tables using PostgreSQL commands.
-
Populate the database with sample data.
-
Write queries to retrieve and manipulate data from the database.
Write a Blog Post about PostgreSQL Functions
Show steps
Solidify your understanding by summarizing and explaining PostgreSQL functions in a written format.
Show steps
-
Choose a specific aspect of PostgreSQL functions to focus on.
-
Research the topic thoroughly.
-
Write a clear and concise blog post explaining the topic.
Contribute to an Open-Source PostgreSQL Project
Show steps
Gain real-world experience by contributing to the PostgreSQL community, deepening your knowledge and skills.
Show steps
-
Find an open-source PostgreSQL project that interests you.
-
Identify a way to contribute, such as fixing a bug or adding a new feature.
-
Submit a pull request with your changes.
Review SQL Basics
Show steps
Reinforce your understanding of fundamental SQL concepts, making it easier to follow along with the course material.
Show steps
Show steps
Show steps
- Go over your notes from a previous SQL course or tutorial.
- Review online tutorials or documentation on SQL basics.
- Try solving some practice problems or exercises.
Seek Guidance from Experienced PostgreSQL Professionals
Show steps
Connect with experts in the field to gain valuable insights and accelerate your learning.
Show steps
Show steps
Show steps
- Attend industry events or conferences.
- Reach out to PostgreSQL professionals on LinkedIn or other platforms.
- Request guidance or mentorship on specific PostgreSQL topics.
Join a Study Group or Online Forum
Show steps
Engage with other learners and discuss course concepts, enhancing your understanding through collaboration.
Show steps
Show steps
Show steps
- Find a study group or online forum dedicated to PostgreSQL.
- Participate in discussions and ask questions.
- Help other learners by answering their questions.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Follow Along with PostgreSQL Tutorials
Show steps
Gain practical experience by following step-by-step tutorials on PostgreSQL.
Show steps
Show steps
Show steps
- Search for online tutorials or courses on PostgreSQL.
- Choose a tutorial that aligns with your learning goals.
- Follow the instructions in the tutorial and complete the exercises.
Practice Writing SQL Queries
Show steps
Improve your proficiency in writing SQL queries by practicing regularly.
Show steps
Show steps
Show steps
- Find a set of practice problems or exercises online.
- Set aside some time each week to work on these problems.
- Review your solutions and identify areas where you can improve.
Build a Simple PostgreSQL Database
Show steps
Apply your knowledge by creating a functional PostgreSQL database, solidifying your understanding of the concepts.
Show steps
Show steps
Show steps
- Design the schema for your database.
- Create the database and tables using PostgreSQL commands.
- Populate the database with sample data.
- Write queries to retrieve and manipulate data from the database.
Write a Blog Post about PostgreSQL Functions
Show steps
Solidify your understanding by summarizing and explaining PostgreSQL functions in a written format.
Show steps
Show steps
Show steps
- Choose a specific aspect of PostgreSQL functions to focus on.
- Research the topic thoroughly.
- Write a clear and concise blog post explaining the topic.
Contribute to an Open-Source PostgreSQL Project
Show steps
Gain real-world experience by contributing to the PostgreSQL community, deepening your knowledge and skills.
Show steps
Show steps
Show steps
- Find an open-source PostgreSQL project that interests you.
- Identify a way to contribute, such as fixing a bug or adding a new feature.
- Submit a pull request with your changes.
Career center
Learners who complete PostgreSQL Functions Playbook will develop knowledge and skills
that may be useful to these careers:
Database Administrator
Database Administrator
A Database Administrator may use PostgreSQL Functions Playbook to automate database management tasks, which can improve efficiency and reduce the risk of errors. The course covers functions for manipulating data, working with dates and times, and performing calculations, which are all essential skills for a Database Administrator. Additionally, the course covers system functions that can be used to extract information about the database itself, which can be useful for troubleshooting and performance tuning.
Data Analyst
Data Analyst
A Data Analyst may use PostgreSQL Functions Playbook to explore and analyze data more efficiently. The course covers functions for manipulating data, working with dates and times, and performing calculations, which are all essential skills for a Data Analyst. Additionally, the course covers windowing functions, which can be used to perform calculations over groups of rows, and subquery and conditional functions, which can be used to filter and transform data.
Data Engineer
Data Engineer
A Data Engineer may use PostgreSQL Functions Playbook to build and maintain data pipelines. The course covers functions for manipulating data, working with dates and times, and performing calculations, which are all essential skills for a Data Engineer. Additionally, the course covers system functions that can be used to extract information about the database itself, which can be useful for troubleshooting and performance tuning.
Software Engineer
Software Engineer
A Software Engineer may use PostgreSQL Functions Playbook to develop applications that use PostgreSQL. The course covers functions for manipulating data, working with dates and times, and performing calculations, which are all essential skills for a Software Engineer. Additionally, the course covers system functions that can be used to extract information about the database itself, which can be useful for troubleshooting and performance tuning.
Database Developer
Database Developer
A Database Developer may use PostgreSQL Functions Playbook to develop and maintain databases. The course covers functions for manipulating data, working with dates and times, and performing calculations, which are all essential skills for a Database Developer. Additionally, the course covers system functions that can be used to extract information about the database itself, which can be useful for troubleshooting and performance tuning.
Information Architect
Information Architect
An Information Architect may use PostgreSQL Functions Playbook to design and implement data models. The course covers functions for manipulating data, working with dates and times, and performing calculations, which are all essential skills for an Information Architect. Additionally, the course covers system functions that can be used to extract information about the database itself, which can be useful for understanding the structure and relationships of the data.
Data Scientist
Data Scientist
A Data Scientist may use PostgreSQL Functions Playbook to explore and analyze data more efficiently. The course covers functions for manipulating data, working with dates and times, and performing calculations, which are all essential skills for a Data Scientist. Additionally, the course covers windowing functions, which can be used to perform calculations over groups of rows, and subquery and conditional functions, which can be used to filter and transform data.
Business Intelligence Analyst
Business Intelligence Analyst
A Business Intelligence Analyst may use PostgreSQL Functions Playbook to explore and analyze data more efficiently. The course covers functions for manipulating data, working with dates and times, and performing calculations, which are all essential skills for a Business Intelligence Analyst. Additionally, the course covers windowing functions, which can be used to perform calculations over groups of rows, and subquery and conditional functions, which can be used to filter and transform data.
Technical Writer
Technical Writer
A Technical Writer may use PostgreSQL Functions Playbook to learn about the features and functionality of PostgreSQL. The course covers functions for manipulating data, working with dates and times, and performing calculations, which are all essential concepts for a Technical Writer to understand. Additionally, the course covers system functions that can be used to extract information about the database itself, which can be useful for troubleshooting and performance tuning.
Product Manager
Product Manager
A Product Manager may use PostgreSQL Functions Playbook to learn about the features and functionality of PostgreSQL. The course covers functions for manipulating data, working with dates and times, and performing calculations, which are all essential concepts for a Product Manager to understand. Additionally, the course covers system functions that can be used to extract information about the database itself, which can be useful for understanding the performance and scalability of the product.
Project Manager
Project Manager
A Project Manager may use PostgreSQL Functions Playbook to learn about the features and functionality of PostgreSQL. The course covers functions for manipulating data, working with dates and times, and performing calculations, which are all essential concepts for a Project Manager to understand. Additionally, the course covers system functions that can be used to extract information about the database itself, which can be useful for understanding the performance and scalability of the project.
Sales Engineer
Sales Engineer
A Sales Engineer may use PostgreSQL Functions Playbook to learn about the features and functionality of PostgreSQL. The course covers functions for manipulating data, working with dates and times, and performing calculations, which are all essential concepts for a Sales Engineer to understand. Additionally, the course covers system functions that can be used to extract information about the database itself, which can be useful for understanding the performance and scalability of the product.
Systems Administrator
Systems Administrator
A Systems Administrator may use PostgreSQL Functions Playbook to learn about the features and functionality of PostgreSQL. The course covers functions for manipulating data, working with dates and times, and performing calculations, which are all essential concepts for a Systems Administrator to understand. Additionally, the course covers system functions that can be used to extract information about the database itself, which can be useful for understanding the performance and scalability of the system.
Quality Assurance Analyst
Quality Assurance Analyst
A Quality Assurance Analyst may use PostgreSQL Functions Playbook to learn about the features and functionality of PostgreSQL. The course covers functions for manipulating data, working with dates and times, and performing calculations, which are all essential concepts for a Quality Assurance Analyst to understand. Additionally, the course covers system functions that can be used to extract information about the database itself, which can be useful for troubleshooting and performance tuning.
Network Administrator
Network Administrator
A Network Administrator may use PostgreSQL Functions Playbook to learn about the features and functionality of PostgreSQL. The course covers functions for manipulating data, working with dates and times, and performing calculations, which are all essential concepts for a Network Administrator to understand. Additionally, the course covers system functions that can be used to extract information about the database itself, which can be useful for understanding the performance and scalability of the network.
For more career information including salaries, visit:
OpenCourser.com/course/e83bmi/postgresql
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
PostgreSQL Functions Playbook.
Save
Comprehensive guide to the ANSI SQL standard. It valuable resource for both beginners and experienced users.
This textbook provides a comprehensive overview of database systems, including concepts relevant to PostgreSQL's implementation.
Discusses common pitfalls in SQL development and provides guidance on avoiding them.
Provides insights into how SQL Server executes queries, which can be beneficial for understanding PostgreSQL's query optimization techniques.
Discusses SQL injection vulnerabilities and provides techniques to prevent and mitigate them, which is relevant for securing PostgreSQL applications.
Guide to PostgreSQL performance tuning that covers a wide range of topics, including functions, queries, data types, and performance tuning.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/e83bmi/postgresql
Share
Similar courses
Here are nine courses similar to
PostgreSQL Functions Playbook.
SQL Mathematical Functions
OpenCourser.com/course/rufsn6/sql
SQL Mathematical Functions
Most relevant
Database Design and Basic SQL in PostgreSQL
OpenCourser.com/course/ghigjn/database
Database Design and Basic SQL in PostgreSQL
Most relevant
Querying Data from PostgreSQL
OpenCourser.com/course/hy0y07/querying
Querying Data from PostgreSQL
Most relevant
Using SQL String Functions to Clean Data
OpenCourser.com/course/eeyrvd/using
Using SQL String Functions to Clean Data
Most relevant
SQL Date Time Functions
OpenCourser.com/course/71tyf6/sql
SQL Date Time Functions
Most relevant
SQL CASE Statements
OpenCourser.com/course/jng90x/sql
SQL CASE Statements
Most relevant
SQL and PostgreSQL for Beginners: Become an SQL Expert
OpenCourser.com/course/etybww/sql
SQL and PostgreSQL for Beginners: Become an SQL Expert
Most relevant
Introduction to SQL
OpenCourser.com/course/0t1qcg/introduction
Introduction to SQL
Most relevant
Database Architecture, Scale, and NoSQL with Elasticsearch
OpenCourser.com/course/1qh2q5/database
Database Architecture, Scale, and NoSQL with Elasticsearch
Most relevant
Time
149 hours
Level
Advanced
Via
Pluralsight
Instructor
Gerald Britton
Language
English
This course belongs to a
collection
called
Querying Data with SQL from PostgreSQL. It's comprised of five courses:
- Querying Data from PostgreSQL
- Combining and Filtering Data with PostgreSQL 9
- PostgreSQL Data Manipulation Playbook
- PostgreSQL Functions Playbook (viewing)
- Capturing Logic with Custom Functions in PostgreSQL
Good to know
Suitable for both Postgres SQL beginners and users of other database systems
Provides comprehensive understanding of PostgreSQL functions, including those defined under ANSI SQL
Taught by experienced instructor Gerald Britton
Leverages multiple learning formats to enhance the learning experience
Provides opportunity for hands-on practice through access to a running PostgreSQL database
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