SQL Server 2012 Comprehensive Introduction

DURATION

5 days

DATE

6 – 10 Aug, 3-7 Sep, 15-19 Oct, 5-9 Nov, 3-7 Dec 2018

FEE

£3850

LOCATION

Holiday Inn Express Hotel 1 Priddys Yard Croydon CR0 1TS

Course overview

This comprehensive SQL Server 2012 training course will give you an excellent overview of the entire Microsoft SQL Server 2012 product. You will get hands-on introduction to all the main features, facets, and functions of the SQL Server Database Engine, Reporting Services, Integration Services, and Analysis Services. This SQL 2012 intro class features instructor-led training for SQL Server 2012 database administration, programming, query writing, ETL with SSIS, creating and deploying SSRS reports, and working with multidimensional data and cubes in SSAS. This course also spotlights new features of SQL Server 2012. This course also makes extensive use of LearnItFirst’s video exercises which include complete walk-throughs of the solutions (and come with the files containing both the problems and the solutions).

Who should attend?

This course is ideal for someone who wants a complete overview of all the facets and features of SQL Server 2012.

Course Objectives

The goal of the course design was to be able to take someone who knew absolutely nothing about SQL Server 2012 and have them feel comfortable performing day-to-day operations such as installation, backups, automation, and more.

This course can also be taken in

Accra:19-23 Feb, 14-18May, 4-8Jun, 10-14Sep, 8-12Oct 2018

Dubai:19-23 Feb, 14-18May, 4-8Jun, 10-14Sep, 8-12Oct 2018

Texas: on request

Course Content

  1. Course Introduction
  2. Why SQL Server 2012?
  3. Installing, Configuring, and Upgrading to 2012
  4. Creating and Managing SQL Server Databases
  5. SQL Server Security: Server Level
  6. Backup and Restore
  7. High Availability/Disaster Recovery
  8. Jobs and Automating Maintenance
  9. Relational Database Design (Creating Tables and Constraints)
  10. Writing Queries and Manipulating Data
  11. Views, Indexes, and Query Plans
  12. Stored Procedures, Triggers, and Functions
  13. SQL Server Security: Database Level
  14. Business Intelligence in SQL Server 2012
  15. Analysis Services 2012
  16. Integration Services 2012
  17. Reporting Services 2012

Book this course

please send us your details & someone from our team will get back to you

SQL Server 2012 Comprehensive Introduction

10 + 11 =

Upcoming Courses

Petroleum risk and decision analysis

5 days 24-28 February 2020£3950Holiday Inn Express Hotel, London Croydon 1 Priddys Yard Croydon, CR0 1TS London, United Kingdom.  Running a successful petroleum operation...

Project and Resource Management

(Part of  oil and gas)5 days 23-27 March 2020£3950 Holiday Inn Express Hotel, London Croydon, 1 Priddys Yard Croydon CR0 1TS London United KingdomRunning a successful petroleum...

Risk Assessment & Risk Management in the Oil & Gas Industry

(Part of Oil and Gas) 5 days20-24 April 2020 £3950Holiday Inn Express Hotel, London Croydon, 1 Priddys Yard Croydon, CR0 1TS London, United Kingdom This training course will...

Essentials Of Contracting And Contract Negotiation

5 days 18-22 May 2020 £3950 Holiday Inn Express Hotel 1 Priddys Yard Croydon CR0 1TS LONDON The Essentials of Contracting and Contract Negotiation training course will help...

Coaching And Mentoring For Leaders And Managers

      5 days 8 -12 Jul, 4 - 8 Nov, 9 - 18 Dec 2019 £3850 Jurys Inn Croydon Wellesley Rd, Croydon CR0 9XY Leaders and managers are not generally looking to become...

Strategy and Effective Performance Management

      5 days 23-27 Mar 2020 £3950 Holiday Inn Express Hotel,London Croydon,1 Priddys Yard CroydonCR0 1TSLondon, United Kingdom. Strategy and Effective Performance...

LOCATION