SQL Server

Core Skills

3 Days

Learn How to

Build databases

Build Queries and reports for SQL Server

Create and manage databases with SQL Server Management Studio

Generate Transact-SQL statements for data retrieval and modification

Implement security and back up databases to protect critical data

Configure merge replication and handle data conflicts

Understand business intelligence solutions such as Integration, Analysis and Reporting Services

Pre-Requisites

Delegates should be confident supporting a Windows server environment as can be gained from our Windows 2003/2008 Server Administration course.

Introduction to Databases

Client/Server Installations

Relational Database Management Systems

 

SQL Server

Editions of SQL Server

SQL Server Management Studio

Business Intelligence Development Studio

SQL Server Agent

Database Engine

 

Building a Database

File names and locations

Size and growth considerations

Understanding schemas

Understanding tables

Columns and attributes

Primary keys and Indexes

Foreign keys

Constraints

 

Using the Database

Writing SQL Queries

Sorting results sets

Working with multiple tables (using joins)

 

Modifying the Data

INSERT

UPDATE

DELETE

 

SQL Server Programming

Understanding stored procedures

Understaning functions and triggers

Client Side Programming

Integrating SQL Server and Microsoft Office

Moving from Microsoft Access

Displaying data using ASP.NET

 

Understanding SQL Server Security

SQL Server logins

Database roles

 

SQL Server Administration

Checking database consistency

Understanding database backups

Generating and scheduling automated jobs

 

Replication

Understanding replication strategies

Configuring distribution servers

Publishing data with merge replication

Pulling or pushing subscriptions

 

SQL Server Integration Services (SSIS)

Importing data into SQL Server

Exporting data to text or CSV format

Changing packages with SSIS Designer

 

Analysis Services

Storing multidimensional data

Pivoting cubes in Microsoft Excel pivot tables

Using data mining to detect patterns

 

SQL Server Reporting Services

Authoring and deploying reports

Extracting data from Analysis Services

Viewing reports from a Web site