Sign In
    Saved
      Sign In
      Saved

SQL Fundamentals by DataCamp

tag
Total Duration
21 Hours

Gain the fundamental skills you need to interact with and query your data in SQL—a powerful language used by data-driven businesses large and small to explore and manipulate their data to extract meaningful insights. In this track, you'll learn the skills you need to level up your data skills and leave Excel behind you. Through hands-on exercises, you’ll discover how to quickly summarize, join tables, and use window functions and built-in PostgreSQL functions to analyze your data. 

Courses in this Learning Path
1
Introduction to SQL
DataCamp Course via DataCamp
learnpath-img
Duration : 4 hours
Price :₹1,093
Level :Beginner
Learn Type :Certification
Introduction to SQL

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 …

Read More
2
Joining Data in SQL
DataCamp Course via DataCamp
learnpath-img
Duration : 5 hours
Price :₹1,093
Level :Intermediate
Learn Type :Certification
Joining Data in SQL

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 …

Read More
3
Intermediate SQL
DataCamp Course via DataCamp
learnpath-img
Duration : 4 hours
Price :₹1,093
Level :Intermediate
Learn Type :Certification
Intermediate SQL

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 …

Read More
4
PostgreSQL Summary Stats and Window Functions
DataCamp Course via DataCamp
learnpath-img
Duration : 4 hours
Price :₹1,093
Level :Intermediate
Learn Type :Certification
PostgreSQL Summary Stats and Window Functions

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 …

Read More
5
Functions for Manipulating Data in PostgreSQL
DataCamp Course via DataCamp
learnpath-img
Duration : 4 hours
Price :₹1,093
Level :Intermediate
Learn Type :Certification
Functions for Manipulating Data in PostgreSQL

This course will show you how to use the PostgreSQL function within your SQL queries to manipulate different types of data including string, numeric and date/time. We'll travel back to the time when Blockbuster video shops could be found everywhere. You had to walk outside to rent a DVD. We will also introduce the robust full-text search capabilities that allow you to match and index keywords in …

Read More