For training call 07702 166301

Your basket is empty View Cart shopping cart

SQL Server Training

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

MAKE AN ENQUIRY Download Course Outline

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 four-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 3-day course for getting to grips with the basics.

SQL Server Training Course Content

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

Booking

* Required

For in-company or private training please request a quote

 
 

Course Details

  1. Course Title

    SQL Server Training

  2. Duration

    1 Day

  3. Price Starting From

    £995.00 + VAT

Upcoming Dates

Aberdeen, UK

  1. 01 Dec 2017
  2. MORE DATES

Belfast, UK

  1. 01 Dec 2017
  2. MORE DATES

Birmingham, UK

  1. 01 Dec 2017
  2. MORE DATES

Bournemouth, UK

  1. 01 Dec 2017
  2. MORE DATES

Brighton, UK

  1. 01 Dec 2017
  2. MORE DATES

Bristol, UK

  1. 01 Dec 2017
  2. MORE DATES

Cambridge, UK

  1. 01 Dec 2017
  2. MORE DATES

Cardiff, UK

  1. 01 Dec 2017
  2. MORE DATES

Dublin, UK

  1. 01 Dec 2017
  2. MORE DATES

Edinburgh, UK

  1. 01 Dec 2017
  2. MORE DATES

Glasgow, UK

  1. 01 Dec 2017
  2. MORE DATES

Leeds, UK

  1. 01 Dec 2017
  2. MORE DATES

Liverpool, UK

  1. 01 Dec 2017
  2. MORE DATES

London, UK

  1. 01 Dec 2017
  2. MORE DATES

Manchester, UK

  1. 01 Dec 2017
  2. MORE DATES

Milton Keynes, UK

  1. 01 Dec 2017
  2. MORE DATES

Newcastle, UK

  1. 01 Dec 2017
  2. MORE DATES

Norwich, UK

  1. 01 Dec 2017
  2. MORE DATES

Nottingham, UK

  1. 01 Dec 2017
  2. MORE DATES

Reading, UK

  1. 01 Dec 2017
  2. MORE DATES

Sheffield, UK

  1. 01 Dec 2017
  2. MORE DATES

Southampton, UK

  1. 01 Dec 2017
  2. MORE DATES

Onsite Training

This course can be run in-company anywhere in the world & we can tailor the content to focus on your requirements.

We regularly provide training in London, Manchester, Bristol and all over the United Kingdom.

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.