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

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. 02 Mar 2018
  2. MORE DATES

Belfast, UK

  1. 02 Mar 2018
  2. MORE DATES

Birmingham, UK

  1. 02 Mar 2018
  2. MORE DATES

Bournemouth, UK

  1. 02 Mar 2018
  2. MORE DATES

Brighton, UK

  1. 02 Mar 2018
  2. MORE DATES

Bristol, UK

  1. 02 Mar 2018
  2. MORE DATES

Cambridge, UK

  1. 02 Mar 2018
  2. MORE DATES

Cardiff, UK

  1. 02 Mar 2018
  2. MORE DATES

Dublin, UK

  1. 02 Mar 2018
  2. MORE DATES

Edinburgh, UK

  1. 02 Mar 2018
  2. MORE DATES

Glasgow, UK

  1. 02 Mar 2018
  2. MORE DATES

Leeds, UK

  1. 02 Mar 2018
  2. MORE DATES

Liverpool, UK

  1. 02 Mar 2018
  2. MORE DATES

London, UK

  1. 02 Mar 2018
  2. MORE DATES

Manchester, UK

  1. 02 Mar 2018
  2. MORE DATES

Milton Keynes, UK

  1. 02 Mar 2018
  2. MORE DATES

Newcastle, UK

  1. 02 Mar 2018
  2. MORE DATES

Norwich, UK

  1. 02 Mar 2018
  2. MORE DATES

Nottingham, UK

  1. 02 Mar 2018
  2. MORE DATES

Reading, UK

  1. 02 Mar 2018
  2. MORE DATES

Sheffield, UK

  1. 02 Mar 2018
  2. MORE DATES

Southampton, UK

  1. 02 Mar 2018
  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.