In this intro to SQL Server course, you gain the introductory skills to maximize SQL Server’s benefits. Learn how to use the various administrative and development tools within SQL Server, including the Microsoft BI stack of Integration Services, Analysis Services, and Reporting Services.
SQL Server offers a platform for enterprise data management, robust development, and implementation of modern Business Intelligence solutions. Attend this hands-on course and learn to leverage these features.
Microsoft SQL Server® Introduction Delivery Methods
In-Person
Online
Microsoft SQL Server® Introduction Course Information
In this Microsoft SQL Server® Introduction course, you will learn how to:
Create and administer SQL Server databases.
Write Transact-SQL queries to retrieve and manipulate data.
Secure, back up, and monitor databases with Management Studio.
Integrate SQL Server with Microsoft Office.
Transform data into strategic information using Business Intelligence (BI) components.
Microsoft SQL Server® Introduction Prerequisites
This is a SQL Server training for beginners, so no prior experience is needed to take this course. You will learn the basics of SQL Server and gain the introductory skills needed to maximize SQL Server’s benefits.
Microsoft SQL Server® Introduction Course Outline
Module 1: Introducing SQL Server
Overview of the SQL Server suite of products
Fundamentals of the relational database engine
Benefits of the Business Intelligence stack
SQL Server components and tools
SQL Server Agent and Management Studio
Integration Services
Analysis Services
Reporting Services
Data Quality Services
Master Data Services
Module 2: Building the Database
Module 3: Leveraging Server Programmability
Module 4: Administering SQL Server Databases
Module 5: Integrating External Applications
Module 6: Implementing Business Intelligence Solutions
العربية