SQL Fundamentals by DataCamp

Data scientists transform raw data into actionable insights. Relational databases are structured tables. These databases store large amounts of data from all over the world, including transaction histories for customers and electronic medical records. Data scientists use these tables to modify and extract data using SQL language. This course will teach you syntax for SQL common to multiple databases such as PostgreSQL and MySQL. This course will provide all the information that you need to get started working with databases.

Once you've completed the Introduction to SQL course and have a good understanding of the basics of SQL, it's time to improve your queries with joins or relational set theory. This course will teach you about the power and benefits of joining tables, as well as the unique characteristics of cities around the world. Learn inner and outer joins as well as self, semi, and anti joins. Cross joins are a vital tool in any PostgreSQL wizards' toolbox. After you've mastered intersections, exception clauses, and unions using simple diagrams and examples you won't have to worry about setting it up theory. You will also learn about subqueries. These ideas can also be visualized using Venn diagrams or other linking illustrations.

What can you do next after you have mastered the ability to combine and join data from different tables in your database? What can you do to transform your data and make them meaningful? Intermediate-level training will teach you how to organize, filter and categorize data within relational databases. This training will help you increase your SQL knowledge and solve difficult questions. You will learn CASE statements, subqueries, and window functions. Through the European Soccer Database, you'll also discover interesting facts about football.

Wondering how data professionals use SQL to solve business problems such as deduplicating data and creating rankings? Or calculating running totals or moving averages? If you're familiar with SQL, this course will teach you how to select, filter, join, join and group data. By the end of the course, you will be able write queries like a pro! You will learn how to use window functions, the SQL secret tool, to create queries for data engineering or analytics. It will be easy to learn how windows functions work and how flexible and efficient they can be used with flights data.

This course focuses on teaching you how to effectively use PostgreSQL functions in your SQL queries to manipulate various types of data, such as strings, numbers, and dates. It also covers the concept of full-text search in PostgreSQL, allowing you to match and index keywords within your files. Additionally, the course explores the use of PostgreSQL Extensions to enhance these search capabilities. By the end of this course, you will be equipped with the knowledge and skills needed to utilize PostgreSQL function for data manipulation in data science applications.