Gaining insight from collected data plays an important role in today's information-driven world. During this online course, you'll practically learn how to write basic SQL queries to find answers to your business questions in the PostgreSQL database. No previous IT experience required.
This online course is designed for people who have no prior knowledge of databases. It will also be of interest to analysts who want to go beyond spreadsheets, students taking courses in relational databases, and more. Scroll down for details.
No matter what you do on the Internet, you always leave a mark. Whether you're seeking to buy a speaker or checking flights to Paris, your web behavior will be visible to professionals who can then analyze it and draw some conclusions.
Data is collected everywhere, and knowing how to analyze it helps improve decision-making. Analysts all over the world use spreadsheets to deal with their data, but over time, they reach the point where spreadsheets just aren't enough. Here's where SQL comes into play: When used in relational databases, like PostgreSQL, SQL is called "spreadsheets on steroids." So if you want or need to level-up your analytical skills, start learning PostgreSQL queries today!
In this beginner-friendly tutorial, you will find out what you need to start "talking" with the PostgreSQL database. That is, you will learn what relational databases are, how tables work, and how to write simple queries. If you're already feeling overwhelmed, don't worry!
Looking to get started in SQL? Give this course a try – the fascinating world of SQL queries is only a click away!
Everything will be explained systematically. Ultimately, after you complete PostgreSQL Queries, your boosted data analysis skills will let you go beyond those pesky spreadsheets.
We'll start by explaining how to use the SELECT statement to retrieve information from an individual table. The next step will be working with multiple tables; you will learn how to JOIN them, GROUP BY a specific metric, build unions and intersections, and perform an aggregation. Moreover, you will be introduced to dealing with subqueries.
At the end of each section, you will find a short quiz that will both check as well as consolidate what you've learned. If you complete all the exercises throughout the online course, you will be awarded with a certificate. You can publish your certificate on your LinkedIn profile, or print it out and show it to your boss.
Skyrocket your data analysis skills by learning PostgreSQL basics! Start the online course immediately to become an SQL insider.
Just a web browser and an Internet connection
92%
off
Reg. price
$1372
Includes 36 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, Introduction to Python for Data Science, How to Read and Write CSV Files in Python, How to Read and Write JSON Files in Python, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS, How to Read and Write Excel Files in Python
Bundle price $99
36 hours left at this price!
86%
off
Reg. price
$324
Includes 8 courses SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Creating Basic SQL Reports in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS
Bundle price $45
36 hours left at this price!
Find out what relational databases are and get to know SQL – a language to talk to databases.
0% completed 0 of 6 exercises done
Discover how to select data from a single table.
0% completed 0 of 22 exercises done
Learn how to select data from multiple tables.
0% completed 0 of 13 exercises done
Computations in SQL? Why not? You will learn how to group rows and compute statistics with aggregate functions.
0% completed 0 of 25 exercises done
Learn about various kinds of JOINs to best suit your needs.
0% completed 0 of 22 exercises done
Queries within queries? That's right! Discover how to build and use subqueries.
0% completed 0 of 22 exercises done
Combine query results using set operations like UNION, INTERSECT or EXCEPT.
0% completed 0 of 11 exercises done
Check your SQL skills.
0% completed 0 of 9 exercises done
