Introduction to Microsoft SQL Server

Duration: 4 days
Labs: Yes
Language: English
Level: Foundation

In this intro to Microsoft SQL Server® training, 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 (Business Intelligence) 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.

Introduction to Microsoft SQL Server Delivery Methods

In-Person
Online

Introduction to Microsoft SQL Server Course Information

In this Introduction to Microsoft SQL Server training, 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 components.
Introduction to Microsoft SQL Server Training Prerequisites

This is 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.

Introduction to Microsoft SQL Server 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

Constructing a relational database

Choosing optimal file size and growth parameters
Working with database schemas

Defining tables

Specifying appropriate data types
Indexing tables with Management Studio
Adding, modifying, or removing columns

Safeguarding data with constraints

Enforcing uniqueness through primary key constraints
Validating conditions with check constraints
Protecting relationships with foreign keys

Module 3: Leveraging Server Programmability

Retrieving data with Transact-SQL

Employing Query Designer to construct select statements
Retrieving subsets of data from multiple tables using joins and the WHERE clause criteria
Analyzing data for aggregate functions

Modifying data with SQL commands

Inserting new rows into tables
Updating targeted data
Deleting specific rows

Introduction to developing programming constructs

Creating stored procedures for productivity
Writing user-defined functions to simplify queries
Deploying triggers to capture change events

Module 4: Administering SQL Server Databases

Executing the Maintenance Plan Wizard

Defragmenting data and checking database integrity
Improving performance by rebuilding indexes

Automating administrative tasks

Scheduling repeating jobs
Implementing a backup strategy

Monitoring SQL Server resources

Displaying current activity and expensive queries
Running reports with Management Studio

Securing the database infrastructure

Authenticating SQL Server and Windows logins
Assigning users to database and server roles
Granting or revoking permissions

Module 5: Integrating External Applications

Connecting to Microsoft Office

Pulling data from SQL Server into Excel
Creating a front-end interface with Access

Transferring business information

Importing and exporting data from text files
Migrating an Access database to SQL Server

Module 6: Implementing Business Intelligence Solutions

Extracting data with Integration Services

Transforming and cleaning data
Loading data into a data warehouse

Information delivery with Reporting Services

Design reports quickly with the Report Builder
Deploying reports for centralized access

Aggregating data with Analysis Services

Building multidimensional cubes
Predicting trends with data mining

Developing a Business Intelligence strategy

Leveraging Excel and Power Pivot
Transferring data into knowledge with BI functionality

Commercial Pricing

£2,515

4-day instructor-led training course
After-course computing sandbox
One-on-one after-course instructor coaching

Would you like to take this course as a team?

Include dates with afternoon start times

Nov 17 - 20 2:00 pm - 9:30 pm GMT

Herndon, VA or Virtual
Guaranteed-to-Run - You can rest assured this class will not be canceled. Delivery format is subject to change – please call Customer Service if you have any questions.
Dec 15 - 18 2:00 pm - 9:30 pm GMT

Ottawa or Virtual
Jan 26 - 29 9:00 am - 4:30 pm GMT

London or Virtual
Feb 16 - 19 2:00 pm - 9:30 pm GMT

Herndon, VA or Virtual
Mar 16 - 19 1:00 pm - 8:30 pm GMT

Ottawa or Virtual
Jun 14 - 17 2:00 pm - 9:30 pm BST

Ottawa or Virtual
Jul 13 - 16 2:00 pm - 9:30 pm BST

Herndon, VA or Virtual

Speak with a Learning Consultant

Inquiring For

Myself

Team/Group

First Name*

Last Name*

Email*

Phone Number*

Company*

Job Title

I'm interested In

* Required Fields

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Introduction to Microsoft SQL Server Training FAQs

This class runs on Microsoft SQL Server 2017 on Windows Server 2012 R2. However, the class is valuable to users on previous versions of SQL Server and SQL Server 2019.

This course applies to those using earlier versions of SQL Server.

Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want, including online training.