Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

DataCamp

SQL Server for Database Administrators

via DataCamp

Go to class Write review

Overview

DataCamp Flash Sale:
50% Off - Build Data and AI Skills!
Grab it
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.

Syllabus

  • Introduction to Relational Databases in SQL
    • Learn how to create one of the most efficient ways of storing data - relational databases!
  • Database Design
    • Learn to design databases in SQL to process, store, and organize data in a more efficient way.
  • Transactions and Error Handling in SQL Server
    • Learn to write scripts that will catch and handle errors and control for multiple operations happening at once.
  • Writing Functions and Stored Procedures in SQL Server
    • Master SQL Server programming by learning to create, update, and execute functions and stored procedures.
  • Building and Optimizing Triggers in SQL Server
    • Learn how to design and implement triggers in SQL Server using real-world examples.
  • Improving Query Performance in SQL Server
    • In this course, students will learn to write queries that are both efficient and easy to read and understand.

Taught by

Meghan Kwartler, Timo Grossenbacher, Dean Smith, Florin Angelescu, Miriam Antona, and Lis Sulmont

Reviews

Start your review of SQL Server for Database Administrators

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.