SQL Server Training

Overview

Outline

Feedback

What is SQL Server Training?

SQL Server is Microsoft's flagship relational database application.

This is the perfect training course for those with experience of working with databases in a commercial environment e.g. VB – ActiveX or ASP/ADO and a good knowledge of at least one programming/scripting language, preferably Microsoft e.g.VBScript, VBA, VB. Our one-day SQL Server training course provides a grounding in relational database design methodology and in its practical application using SQL Server.

What are the objectives of SQL Server Training?

Our SQL Server Training course you will learn how to:

Build and manage SQL Server databases
Retrieve and manipulate data with SQL queries
Integrate SQL Server with .NET, Microsoft Office and XML
Secure and monitor databases with Management Studio
Replicate data over multiple servers with merge replication
Transform data into strategic information using business intelligence processes

Who is SQL Server Training intended for?

You must have experience of working with databases in a commercial environment e.g. VB – ActiveX or ASP/ADO and a good knowledge of at least one programming/scripting language, preferably Microsoft e.g.VBScript, VBA, VB to attend this course.

If you are planning on using SQL Server on a regular basis then we thoroughly recommend our one-day course for getting to grips with the basics.

Who is this course for?

The perfect course for those with experience of working with databases in a commercial environment e.g. VB – ActiveX or ASP/ADO and a good knowledge of at least one programming/scripting language, preferably Microsoft e.g.VBScript, VBA, VB.

Getting Started with SQL Server

Overview of SQL Server architecture
SQL Server editions
SQL Server components and tools
Constructing the Database
Creating a database
Designing tables
Protecting data with constraints

Server-Side Programming

Data retrieval with Transact-SQL
Modifying data
Programming constructs
Integrating with Client Applications
Connecting to SQL Server
Interacting with Microsoft Office
Leveraging XML and .NET features
Administering SQL Server
Securing the database infrastructure
Running the Maintenance Plan Wizard
Monitoring SQL Server activity
Sharing Data through Replication
Defining the replication architecture
Configuring merge replication
Business Intelligence Components
Transforming data with Integration Services
Producing information with Analysis Services
Information delivery with Reporting Services

The content was detailed with a good variety of activities, instruction and interaction; practical aspects helped cement the learning. We covered a very large subject matter in a well structured manner.

Nicola Ross - BUPA International