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

7 + 1 =

Upcoming Courses

LOCATION