Job Guarantee Program: Digital Marketing | CAD | Database | Networking
We are OPEN and delivering training as usual. View our COVID-19 statement.

MCSA: SQL Server 2016 Database Development

Synopsis

  • Fast Track (4 Days) – Mon to Thurs (10:00-18:00)
    Weekend Track (7 Weeks) – Every Saturday (10:00–14:00)
    Regular Track (7 Weeks) – Every Friday (09:30–13:30)
    Evening Track (5 Weeks) – Every Tue & Thurs (18:30–21:30)
  • Course Fee: £1200 + VAT
  • Industry Expert and Certified Instructors
  • Training Venue: Central London Location
  • Tutor Led Classroom Training

Request Brochure


Attend Instructor Led Training From Anywhere

Course Information

MCSA: SQL Server 2016 Database Development Course Description

Early age of Information Technology has experienced an unimaginable growth, e.g. comparing the early invention of colossus computer to hand held computers of today is just unbelievable! . These tiny hand held computer can perform thousand times better and are much more reliable than those colossus computers. The development of the modern technology has enabled us to store data in very compact form where millions and trillions of data are stored and finding the information will just take fraction of a second.

The growing amount of data in every organization has to be stored in the Database; which is an organized form of data stored digitally. These data will grow gradually and can be really big and difficult to maintain and manage without proper infrastructure. Take an example of a bank which has over 30 million customers' records, making transactions every second which might be colossal records a day. It would be absolutely impossible to track the informtion without having database in a reliable, easy accessible and secure platform. Here comes the Microsoft SQL Server 2016 database server which has the capacity to manage huge amount of data. Microsoft SQL Server 2016 is very reliable, robust and secure platform used by many organizations to store their growing data.

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.

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.

Career Prospect

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.

How we deliver this course?

Our MCSA: Data Platform course is delivered by certified, industry expert and experienced trainers who have over 12 years of experience in Database Technologies. We provide hands-on, tutor led and classroom based training in Central London.

Career Prospect

Microsoft Database Engineer, Microsoft SQL DBA, DatMicrosoftabase Administrator, Microsoft Database Consultant, Freelancer Microsoft SQL DBA, Microsoft Database Designer

Learning Facilities

We have immaculate learning facilities with state of art technology, fully equipped with high specs latest servers, workstations and software.

General Facilities

We also provide Free Wifi Internet, Refreshment, Water, Tea and Coffee Facilities.

Registration Process

Speak with course advisor about MCSA SQL Developer training in London. Call us: 0207 256 7722

Course Fee: £1200 + VAT

  • 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
Interest Free Credit for IT course

Pay Monthly.

Interest Free Installments Upto 1 Year.

Contact


MCSA: SQL Server 2016 Database Development

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

Course Syllabus

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

What Our Customers says

MCSA: SQL Server 2016 Database Development Package Offer: Great Savings!!!

Giveaway Price
£2000 +VAT
Silver Package
  • Package Includes
  • MCSA: SQL 2016 Database Administration £1200
  • MCSA: SQL 2016 Database Development £1200
  • Total Price £2400
  • Offer Price £2000
  • Savings £400
Giveaway Price
£4000 +VAT
Diamond Package
  • Package Includes
  • MCSA: SQL 2016 Database Administration £1200
  • MCSA: SQL 2016 Database Development £1200
  • MCSA SQL 2016 BI Development £1200
  • MCSA MS SQL 2012 Data Platform £1200
  • Total Price £4800
  • Offer Price £4000
  • Savings £800
Giveaway Price
£3000 +VAT
Gold Package
  • Package Includes
  • MCSA: SQL 2016 Database Administration £1200
  • MCSA: SQL 2016 Database Development £1200
  • MCSA SQL 2016 BI Development £1200
  • Total Price £3600
  • Offer Price £3000
  • Savings £600

Time Table and Pricing

This is an On-Demand course. Please call us on 0207 256 7722 to arrange the training as per your requirement.

Training Facilities

Training And Certification

Why Choose London Training ?

  • Authorized Training Center
  • Hands-on Training
  • Tutor Led Classroom
  • Small Class Size 5-7 max
  • Central London Locations
  • Expert and Certified Trainers
  • Price includes Tuition Fee, Classroom Training and Course Material
  • Expert and Certified Trainers
  • Classes on Week Days, Evening or Weekends
  • Free Re-training
  • Modern Training Facilities
  • Inclusive Books / Materials
  • Mock Exams / Projects