From the course: Data Analysis with PostgreSQL
Join today to access over 25,500 courses taught by industry experts.
What you should know - PostgreSQL Tutorial
From the course: Data Analysis with PostgreSQL
What you should know
- [Presenter] To get the most out of this course, I'll expect that you have some familiarity with PostgreSQL databases, and writing basic select queries. You should understand the structure of a database and how tables, columns, and data types work within that structure. If you've taken my PostgreSQL essential training course, then you'll be ready for everything that we're going to cover here. Before we get into the course though, let me take a moment to make sure that everyone is on the same page when it comes to using functions in PostgreSQL. The function name can be written in either lowercase or uppercase letters. PostgreSQL doesn't really care which one you use, but you should pick a convention that you feel comfortable with and be consistent. Next, we use a pair of parentheses and inside are the arguments that the function requires. Most functions take a single argument, but some don't take any, and others will require two or more. When there are multiple arguments, you'll use a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.