course-premium

MCSA: SQL Server 2016 Database Development

London Training Group LTD
4.8
7 reviews
  • The course was good and intense. One can learn a lot from the tutors. Highly recommended.
    ← | →
  • Sayed is an amazing tutor and his teaching style is nice. I would highly recommend it to the people.
    ← | →
  • The trainer for Microsoft SQL was extremely helpful and explained everything so well. The topics were so good and knowledgeable.
    ← | →

Course

In City of London

£ 1,200 + VAT

Learn to manage huge amount of data!

  • Type

    Intensive workshop

  • Level

    Intermediate

  • Location

    City of london

  • Class hours

    32h

  • Duration

    4 Days

"Virtual LIVE" training is available

Microsoft SQL Server 2016 is capable of providing unlimited amount of tables, Terabytes of data, relational data capabilities, database mirroring capabilities, automatic recovery, easy backup and restore, server cluster, database replications, data warehouse, jobs and alerts, monitoring tools, analysing tools and many more.

With this course, imparted by London Training, you will learn from certified, industry expert and experienced trainers who have over 12 years of experience in Database Technologies to properly use the core database technologies, features and implementation of Microsoft SQL Server 2016.

This way, you will be able to develop as a Microsoft Database Engineer, Microsoft SQL DBA, DatMicrosoftabase Administrator, Microsoft Database Consultant, Freelancer Microsoft SQL DBA or a Microsoft Database Designer.

Plus, London Training offers facilities to attendances such as fully equipped with high specs latest servers, workstations and software. Also, WIFI, Refreshment, Water, Tea and Coffee Facilities.

Don’t miss this chance, ask for further information to emagister.co.uk. You won’t regret it!

Facilities

Location

Start date

City of London (London)
See map
4th Floor Bowman House,29 Wilson Street, EC2M 2SJ

Start date

OctoberEnrolment now closed
OctoberEnrolment now closed
NovemberEnrolment now closed
DecemberEnrolment now closed

About this course

Microsoft SQL Server 2016 is widely used by many organizations both small and large and this has created lots of opportunities for database administrators, software developers, system analysts, project managers, business entrepreneurs etc. Why not start your MS SQL Server 2016 training with London Training and get certified or enhance your career and knowledge to next level and find your dream job.

Why not prove your abilities and add value to your employer or to your business, by learning the core database technologies, features and implementation of Microsoft SQL Server 2016 with London Training. Microsoft have introduced IT Professional certification called Microsoft Certified Solutions Expert (MCSA): Data Platform certification which validates your skills needed to run a highly efficient Database infrastructure in this innovative SQL Server 2016 platform.

Basic computer knowledge

EXAM 70-761 - Querying Data with Transact-SQL
EXAM 70-762 - Developing SQL Databases

Hands-on Tutor Led Training
Classroom Based Practical Training
Unlimited Practice Lab Access
Small Size Class and Interactive Sessions
Lab Exercises
Project Work
WiFi Internet
Refreshments
Completion Certificate
Free Re-training
The course fee excludes VAT

Our experts will contact you to speak about the MCSA: SQL Server 2016 Database Development training in London.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.8
excellent
  • The course was good and intense. One can learn a lot from the tutors. Highly recommended.
    ← | →
  • Sayed is an amazing tutor and his teaching style is nice. I would highly recommend it to the people.
    ← | →
  • The trainer for Microsoft SQL was extremely helpful and explained everything so well. The topics were so good and knowledgeable.
    ← | →
100%
4.7
excellent

Course rating

Recommended

Centre rating

Qiaofeng Qi

5.0
01/12/2019
About the course: The course was good and intense. One can learn a lot from the tutors. Highly recommended.
Would you recommend this course?: Yes

Edward

4.5
29/11/2019
About the course: Sayed is an amazing tutor and his teaching style is nice. I would highly recommend it to the people.
Would you recommend this course?: Yes

Piotr Wietlicki

5.0
29/11/2019
About the course: The trainer for Microsoft SQL was extremely helpful and explained everything so well. The topics were so good and knowledgeable.
Would you recommend this course?: Yes

Linus Baptiste

5.0
28/11/2019
About the course: The training staff is so knowledgeable and friendly. The course is delivered the way it says, the price of the course is too worth. I have always received the support I need from them.
Would you recommend this course?: Yes

Bhavesh

4.5
28/11/2019
About the course: My tutor has made my experience amazing.
Would you recommend this course?: Yes

Ilyaas

5.0
27/11/2019
About the course: The training center was so nice and the support is always there.
Would you recommend this course?: Yes

Kevin

4.5
18/05/2017
What I would highlight: SQL course helped me alot in real time. Very clear, engaging.
What could be improved: .
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2019

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 11 years

Subjects

  • Monitoring
  • Access
  • Audit
  • Server
  • Database
  • SQL
  • Database Administration
  • MCSA training
  • MCSA
  • Technology
  • Import
  • Microsoft Database Engineer
  • Microsoft SQL DBA
  • DatMicrosoftabase Administrator
  • Microsoft Database Consultant
  • Freelancer Microsoft SQL DBA
  • Microsoft Database Designer

Teachers and trainers (1)

Teaching Staff

Teaching Staff

Teachers

Course programme

Course SyllabusMCSA SQL Exam 70-761: Querying Data with Transact-SQL

INTRODUCTION TO SQL SERVER 2016
  • SQL Server Architecture
  • SQL Server Versions
  • SQL Server Editions
  • SQL Server Databases
INTRODUCTION TO T-SQL QUERYING
  • Categories of T-SQL Statements
  • T-SQL Elements
  • Logical Order of Operations in SELECT Statements
SQL SERVER 2016 Data Types
  • Exact Numeric
  • Approximate Numeric
  • Character Strings
  • Date & Time
  • Unicode Characters
  • Binary Strings
  • Others
CREATING T-SQL SELECT QUERYING
  • SELECT Statements
  • Duplicates & DISTINCT
  • Using Column and Table Aliases
  • CASE Expressions
MODIFYING DATA AND TABLE DEFINITION
  • Insert
  • Update
  • Delete
  • Create
  • Alter
  • Drop
DEFINING SQL SERVER CONSTRAINTS
  • Not NULL
  • Primary Key
  • Foreign Key
  • Check
  • Default
  • Unique
  • Identity
SORTING AND FILTERING DATA
  • Top
  • Order By
  • Offset
  • Fetch
SET OPERATIONS
  • Union
  • Union ALL
  • Except
  • Intersect
QUERYING MULTIPLE TABLES BY USING JOINS
  • Introduction to Joins
  • INNER JOIN
  • LEFT/RIGHT/FULL OUTER JOIN
  • CROSS JOIN & Self Join
  • Using AND and OR
PROGRAMMING CONCEPTS
  • Variables
  • IF / IF – ELSE / IF – ELSE IF
  • While
BUILT-IN AND USER DEFINED FUNCTIONS
  • Conversion Functions
  • Scalar-Valued Functions
  • Table-Valued Functions
  • Aggregate Function
  • Date and Time Functions
  • Mathematical Functions
  • String Functions
  • Functions to work with NULL
SUBQUERIES AND APPLY
  • Self-Contained / Correlated Subqueries
  • Cross Apply
  • Outer Apply
  • Exists and IN Predicate
PIVOTING, GROUPING AND AGGREGATING DATA
  • Pivoting
  • Group By
  • Using Aggregate Functions
  • Using Having Clause in Group By
TEMPORARY TABLES AND TABLE EXPRESSIONS
  • Temporary Tables
  • Local Temporary Tables
  • Global Temporary Tables
  • CTE
STORED PROCEDURES
  • Creating/Modifying/Dropping/Encrypting
  • Different ways to Execute Stored Procedures
  • Stored Procedures with Input and Output Parameters
  • Nested Stored Procedures
VIEWS
  • Creating/Modifying/Dropping
  • Indexed Views
  • Views to provide Row Level / Column Level Security
TRANSACTIONS AND ERROR HANDLING
  • Atomicity, Consistency, Isolation, and Durability
  • Isolation Level
  • Problems
  • Try / Catch / RAISERROR / Throw
Exam 70-762: Developing SQL Databases (70-762)

DESIGNING AND IMPLEMENTING DB OBJECTS
  • Designing Schemas based on Business Requirements
  • Designing Tables
  • Using Most Efficient Data Types
DESIGNING AND IMPLEMENTING INDEXES
  • Introduction to Indexes
  • What is the Need to Implement Indexes
  • Clustered Indexes
  • Non Clustered Indexes
  • Composite Indexes
MAINTAINING AND OPTIMIZING INDEX PERFORMANCE
  • Finding the Fragmentation of Indexes
  • Reorganizing Indexes
  • Rebuilding Indexes
  • Disabling / Dropping an Existing Index
  • Column Store Indexes
VIEWS
  • Creating/Modifying/Dropping
  • Indexed Views
  • Views to provide Row Level / Column Level Security
ENSURING DATA INTEGRITY CONSTRAINTS
  • Not NULL
  • Primary Key
  • Foreign Key
  • Check
  • Default
  • Unique
  • Identity
WORKING WITH STORED PROCEDURES
  • Creating/Modifying/Dropping/Encrypting
  • Different ways to Execute Stored Procedures
  • Stored Procedures with Input and Output Parameters
  • Nested Stored Procedures
  • Moving Values between Scalar-Valued Function and SP
  • Implementing Transactions in Stored Procedures
  • Implementing Error Handling in Stored Procedures
CREATING TRIGGERS
  • Creating/Modifying/Dropping
  • DML Triggers
  • DDL Triggers
  • Logon Triggers
  • Advanced Trigger Concepts
MANAGING TRANSACTIONS AND ISOLATION LEVELS
  • Atomicity, Consistency, Isolation, and Durability
  • Isolation Level
  • Read Uncommitted
  • Read Committed
  • Repeatable Read
  • Serialisable
  • Snapshot
  • Impact of all Isolation Levels
OPTIMISING CONCURRENCY AND LOCKING BEHAVIOUR
  • Troubleshoot Locking Issues
  • Identify Lock Behaviours
  • Capture and Analyse Deadlock Graphs
  • Identify Ways to Remediate Deadlocks
WORKING WITH XML
  • RAW
  • AUTO
  • PATH
STORING AND QUERYING BLOBS IN SQL SERVER
  • Filestream
  • Full-Text Search
  • Storing .docx, Images and other files in SQL SERVER

Additional information

*Installment option available

0% interest available .Pay Monthly.Interest Free Installments Upto 1 Year

Duration

Fast Track (1 Week) – Mon to Thu (10:00-18:00) 
Weekend Track (7 Weeks) – Every Saturday (10:00–14:00)

See related categories

MCSA: SQL Server 2016 Database Development

£ 1,200 + VAT