We are OPEN and delivering training as usual. View our COVID-19 statement.

MCSA: SQL 2016 Database Development

MCSA: SQL 2016 Database Development Course

SQL Training Overview:

Certification:

  • Microsoft Certified Solutions Associate(MCSA) SQL 2016 Certification

Delivery:

  • SQL classroom training. Instructor led hands-on classes.

SQL Certification Exams:

  • 2 Exams, Real Time Simulation, Single and Multiple Choice Questions
  • MCSA: SQL 2016 Database Administration training

SQL Course Length:

  • 4 Weeks or Fast Track 4 Days

SQL Training Includes:

  • Hands-on Training, Lab Exercises, Project work, Unlimited Lab Access, Free Re-training

SQL Training Locations:

  • Liverpool Street, London
  • London Bridge, London
  • Moorgate, London

Flexible Starting Dates:

  • SQL Training on Weekdays, Weekends and Evenings

Brochure Request



Live Instructor-Led Classes

Virtual Training is the same as Face-to-Face Training

Virtual Classroom is the best option for anyone wishing to get an instructor-led training - while staying in the comfort of their home or office.

Call Us: 0207 256 2268

 

COVID-19 Statement

We are open and delivering training as normal

Monday 30th June 2020

To all our valued students,

We are all experiencing incredibly confusing and unpredictable times. In consideration of the ongoing uncertainty regarding COVID-19, we wish to reassure you that we are taking necessary precautions to protect the health, safety and well-being of our customers, our employees and our partners.

We will continue to operate our business in accordance with government guidelines. We are accepting new registration and delivering on going training as normal.

We understand the importance of our customers feeling safe and comfortable in their homes. For your peace of mind, we are offering a safe and contact free LIVE online tutor led training too.

We are closely monitoring the advice and information provided by the government and commit to updating you if anything changes. Rest assured, our priority remains providing you with the quality training in the safest possible way.

We would also like to take some time to thank our incredible emergency services and NHS staff for their unbelievable and unprecedented support. We give thanks to those working tirelessly to keep us all safe and healthy. For more information, please click here.

As always our customer services team are available to help with any queries on 0207-256-2268 and through our contact us pages.

We wish good health to you, your friends and your family at this time.

Stay safe.

Training Square Team.

Yes we are open for training with a small number of students per class, considering government guidelines, and with social distancing in place.

- Our opening and closing hours are:
Mon to Fri - 10:00 till 17:00
Saturday - 10:00 till 1700

Yes, we have followed the government guidelines with social distancing. We are providing access to hand sanitizer to all our students, providing disposable masks and keeping the place clean and tidy.

Yes, the majority of our courses can be done LIVE online tutor led. You can join the scheduled classes with the tutor online. The online live classes are the same as the scheduled classes and the only difference is, you will be attending from wherever you wish to, as long as you have reliable internet access.

Finance Available

0% Interest

Spread The Cost of Your Training Across 12 Months

Course Fee: £1450

3 months - £290 Upfront and monthly payments of £387

6 months - £290 Upfront and monthly payments of £193

12 months - £290 Upfront and monthly payments of £97

Enquire Now



Time Table

Start Date End Date Session Time Location Learning Type Booking
16-01-2021 MCSA: SQL 2016 Database Development27-02-2021 Saturday 10:00-14:00 Central London Wilson Street , Liverpool Street , EC2M 2SJ
01-02-2021 MCSA: SQL 2016 Database Development04-02-2021 M,T,W,T 10:00-18:00 Central London Wilson Street , Liverpool Street , EC2M 2SJ
13-03-2021 MCSA: SQL 2016 Database Development24-04-2021 Saturday 10:00-14:00 Central London Wilson Street , Liverpool Street , EC2M 2SJ
15-03-2021 MCSA: SQL 2016 Database Development18-03-2021 M,T,W,T 10:00-18:00 Central London Wilson Street , Liverpool Street , EC2M 2SJ
26-04-2021 MCSA: SQL 2016 Database Development29-04-2021 M,T,W,T 10:00-18:00 Central London Wilson Street , Liverpool Street , EC2M 2SJ
08-05-2021 MCSA: SQL 2016 Database Development19-06-2021 Saturday 10:00-14:00 Central London Wilson Street , Liverpool Street , EC2M 2SJ
07-06-2021 MCSA: SQL 2016 Database Development10-06-2021 M,T,W,T 10:00-18:00 Central London Wilson Street , Liverpool Street , EC2M 2SJ
03-07-2021 MCSA: SQL 2016 Database Development14-08-2021 Saturday 10:00-14:00 Central London Wilson Street , Liverpool Street , EC2M 2SJ
19-07-2021 MCSA: SQL 2016 Database Development22-07-2021 M,T,W,T 10:00-18:00 Central London Wilson Street , Liverpool Street , EC2M 2SJ
28-08-2021 MCSA: SQL 2016 Database Development09-10-2021 Saturday 10:00-14:00 Central London Wilson Street , Liverpool Street , EC2M 2SJ
31-08-2021 MCSA: SQL 2016 Database Development03-09-2021 T,W,T,F 10:00-18:00 Central London Wilson Street , Liverpool Street , EC2M 2SJ
11-10-2021 MCSA: SQL 2016 Database Development14-10-2021 M,T,W,T 10:00-18:00 Central London Wilson Street , Liverpool Street , EC2M 2SJ
23-10-2021 MCSA: SQL 2016 Database Development04-12-2021 Saturday 10:00-14:00 Central London Wilson Street , Liverpool Street , EC2M 2SJ
22-11-2021 MCSA: SQL 2016 Database Development25-11-2021 M,T,W,T 10:00-18:00 Central London Wilson Street , Liverpool Street , EC2M 2SJ
20-12-2021 MCSA: SQL 2016 Database Development23-12-2021 M,T,W,T 10:00-18:00 Central London Wilson Street , Liverpool Street , EC2M 2SJ

MCSA: SQL 2016 Database Development Course Description

Get trained in Microsoft Certified Solutions Associate (MCSA) Certification - SQL Server 2016 and gain the essential skills needed in all aspects of the Microsoft's premier database system – suitable for all sizes of businesses.

MCSA SQL Server 2016 will enable you to establish your technical skills required to build a sustainable career in IT. Be equipped with the skills that would facilitate you to demonstrate the ability to provide innovative solutions across multiple technologies to your clients. By achieving MCSA SQL 2016 certification you will quite simply be an expert in database technology and can provide solutions for complex business environments.

Microsoft SQL Server has become the most popular, secure, reliable and robust database platform in the IT industry currently. On achieving SQL Server 2016 certification, you will maximise your chances of becoming more employable and more marketable in the current competitive IT job market.

SQL Server 2016 can perform 1 million commands in just 1 second which makes it the fastest, reliable and robust solution for small to large enterprises. SQL Server 2016 also provides higher productivity for DBAs, System Admins and Application Developers. It is also capable to avoid mission critical outages or data loss and the Excellent BI and reporting tools, large scale data warehousing capabilities, make SQL Server 2016 stands out in the market.

Whether you are novice in database technology or a basic user, we have a well structured classroom based, hands-on, tutor led training on SQL courses in London, delivered by our expert, certified and industry experienced trainers.

We would like to warmly welcome you to our SQL server 2016 course where you would be well equipped with SQL Server industrial skills and eventually be fully prepared for MCSA SQL 2016 Certification.

MCSA: SQL 2016 Database Development Course Highlight

  • EXAM 70-761 - Querying Data with Transact-SQL
  • EXAM 70-762 - Developing SQL Databases
  •  
  • MCSA: SQL 2016 Database Administration
 

MCSA: SQL 2016 Database Development

MCSA 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

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

Price Info: £1450

  • Hands-on Tutor Led Training
  • Classroom Based Practical Training
  • Unlimited Practice Lab Access
  • Small Size Class and Interactive Sessions
  • Lab Exercises
  • Mock Exam
  • WiFi Internet
  • Refreshments
  • Completion Certificate
  • Free Re-training
  • Cost is calculated at 70 percent Tuition Vatable and 30 percent Training Book(s) with 0 rated Vat

 

 

 

 

 

Package Offer: Great Savings!!!

Professional Package

£4200Saving £550

Request Info 0207 256 2268
Package Includes
MCSA SQL Server 2012 - £1250
+
Oracle 11g OCP - £3500

Total Price £4750

Offer Price £4200

Saving £550

MOST
POPULR

Career Package

£4000Saving £750

Request Info 0207 256 2268
Package Includes
MCSA SQL Server 2012 - £1250
+
MCSE SQL Server 2012 - £3000 +
MCSE Server 2012 - £1750

Total Price £4750

Offer Price £4000

Saving £750

Specialised Package

£2700Saving £300

Request Info 0207 256 2268
Package Includes
MCSA SQL Server 2012 - £1250
+
MCSE Server 2012 - £1750

Total Price £3000

Offer Price £2700

Saving £300

Trustpilot Training Square Review

The following reviews were taken at the end of the course and are 100% verifiable


Kolade

Tutor takes his time to explain and uses various examples to clarify a point.

Trainer:

Facilities:

Recommend friends and families? Yes

Consider future courses with us? Yes


Steven

Tutor has extensive knowledge of the subject and was very helpful

Trainer:

Facilities:

Recommend friends and families? Yes

Consider future courses with us? Yes


Mark

Tutor was very good at explaining concepts and applying real world examples…

Trainer:

Facilities:

Recommend friends and families? Yes

Consider future courses with us? Yes


Lee

Tutor was very knowledgeable and answered all questions

Trainer:

Facilities:

Recommend friends and families? Yes

Consider future courses with us? Yes


Ali

Tutor was very helpful and professional.

Trainer:

Facilities:

Recommend friends and families? Yes

Consider future courses with us? Yes




Recently Trained Customers

"Your success is our goal"