What you'll learn

SQL is the foundational tool to retrieve data from relational data sources. Learning to select and work with specific data is an important part of effective data analysis. In this course, Filter and Sort Data with SQL in PostgreSQL, you will get a comprehensive introduction of how to refine your queries to retrieve only the data you specify. First, you will learn how to apply filtering conditions to refine your queries. Next, you will discover how to apply additional tools to search and match text data. Then, you will learn how to use conditional logic to filter your data dynamically based on specific conditions. Finally, you will learn how to sort your query output. When you’re finished with this course, you will have the skills and knowledge of PostgreSQL necessary to retrieve specific data from relational databases to conduct your analysis.