Sign In
    Saved
      Sign In
      Saved

SQL Server for Database Administrators

tag
Total Duration
24 Hours

Data is one of your business’s most valuable commodities. In this track you’ll learn the key skills you need to set-up, design, maintain, and monitor your team’s database. Dive in and learn the key SQL Server skills you need to securely manage access and monitor database performance using SQL server.

Courses in this Learning Path
1
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
2
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
3
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
4
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
5
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
6
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