Sign In
    Saved
      Sign In
      Saved

SQL Server Fundamentals

tag
Total Duration
22 Hours

Gain the starting SQL Server skills you need to summarize data, join tables, and analyze data using built-in SQL Server functions. In this track, you’ll discover how SQL Server is like a supercharged Microsoft Excel. Through interactive exercises, you’ll learn how to access, query, and extract huge amounts of data from multiple databases. Using real-world data you’ll also learn how to perform powerful cross-database analyses that you can then apply in your own role. 

Courses in this Learning Path
1
Introduction to SQL Server
learnpath-img
Duration : 2.15 hours
Price :₹1,499
Level :Beginner
Learn Type :Certification
Introduction to SQL Server

The course begins with an introduction to relational database concepts. This course continues with an introduction to relational databases.

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 Server
DataCamp Course via DataCamp
learnpath-img
Duration : 4 hours
Price :₹1,093
Level :Intermediate
Learn Type :Certification
Intermediate SQL Server

Databases hold the vast majority of data. These databases are crucial for data cleaning and analysis. This course will be focused on T-SQL, which is the version that Microsoft SQL Server uses to perform data analysis. This course will show you how to handle missing dates and how advanced queries can be used for summary statistics. This course will give you the skills and knowledge to analyze …

Read More
4
Time Series Analysis in SQL Server
DataCamp Course via DataCamp
learnpath-img
Duration : 5 hours
Price :₹1,093
Level :Intermediate
Learn Type :Certification
Time Series Analysis in SQL Server

SQL Server provides many tools that enable you to create, aggregate, and query time series data. This course will show you how to manipulate dates, parse strings and deal with invalid strings. It also shows you how dates are formatted in reports. Learn how SQL Server's built-in aggregation operators and window functions can help you solve business problems like calculating running totals, …

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

This course will show you how to use SQL Server's most important functions for manipulating data. These functions can be used transform and process data to get the results you want.