Sign In
    Saved
      Sign In
      Saved

Data Analyst with SQL Server

tag
Total Duration
41 Hours

Learn the basics of database design and the different SQL data types. Then master the core concepts for the exam. In this track, you’ll learn how to write queries, functions, and stored procedures. You’ll also find out how to manage transactions, handle errors, and improve query performance. 

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

SQL Server is a vital skill for data analysts. It is the most widely used database in the world. This course will show you how to create simple SQL statements, and refine your queries with ORDER BY and WHERE clauses. Learn how to combine, aggregate, and work with strings. This course will show you how to create tables, as well as the most common ways to join them. You'll also learn how to insert …

Read More
2
Introduction to Relational Databases in SQL
DataCamp Course via DataCamp
learnpath-img
Duration : 4 hours
Price :₹1,093
Level :Intermediate
Learn Type :Certification
Introduction to Relational Databases in SQL

SQL is the most common way to query databases. Databases can also be used for other purposes. You can model many phenomena and their relationships. This will help you ensure your data is consistent and has a better structure. You will see this when you examine real data about questionable university affiliations. This will show you how databases can be used for your benefit column-by-column and …

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.

6
Database Design
DataCamp Course via DataCamp
learnpath-img
Duration : 4 hours
Price :₹1,093
Level :Intermediate
Learn Type :Certification
Database Design

A database is essential for high-performance applications. Before you begin building a house, it is important to think about where your data will be stored. This will save you time and reduce frustration later. It is easy to find and retrieve information from a well-designed database. When choosing a design, there are many factors to consider. This course will show you how to efficiently store, …

Read More
7
Transactions and Error Handling in SQL Server
DataCamp Course via DataCamp
learnpath-img
Duration : 4 hours
Price :₹1,093
Level :Intermediate
Learn Type :Certification
Transactions and Error Handling in SQL Server

Programming SQL scripts requires the ability to handle errors and transactions. Unhandled errors can be very dangerous and cause unexpected situations, such as inconsistency or other problems that could lead to bad business decisions.

This course will help you deal with errors and manage transactions in the case of an error. It will also show you what happens when multiple users interact with the …

Read More
8
Writing Functions and Stored Procedures in SQL Server
DataCamp Course via DataCamp
learnpath-img
Duration : 4 hours
Price :₹1,093
Level :Intermediate
Learn Type :Certification
Writing Functions and Stored Procedures in SQL Server

Learn SQL Server programming at the highest level. First, we will show you how to manipulate datetime data by using temporal exploratory analysis with the Washington DC BikeShare transactional database. Next, we'll show you how to create and update user-definable functions. You will learn the context and best practices of each modular programming tool. In the final chapter, you will learn how to …

Read More
9
Building and Optimizing Triggers in SQL Server
DataCamp Course via DataCamp
learnpath-img
Duration : 4 hours
Price :₹1,093
Level :Intermediate
Learn Type :Certification
Building and Optimizing Triggers in SQL Server

DBAs and database developers may find it difficult auditing SQL Server databases and maintaining data integrity. SQL Server triggers are special stored procedures that maintain consistency and integrity within your database. This course will teach you how to use triggers within real-world situations. This course will allow you to create and implement triggers and also teach you about their …

Read More
10
Improving Query Performance in SQL Server
DataCamp Course via DataCamp
learnpath-img
Duration : 4 hours
Price :₹1,093
Level :Intermediate
Learn Type :Certification
Improving Query Performance in SQL Server

For a mission-critical assignment, your SQL coding skills will be crucial. You are given code to fix. It is not fast or well-structured, but it does provide the results you need. It is therefore difficult to comprehend. Tomorrow is the deadline. You will need to reformat the code in order to improve performance. Now is the time to get involved! This course will teach you how to use SQL to …

Read More