MCSA: SQL Server 2016 Database Development

London Training is a leading IT training company teamed up with the IT industry experts who have gained vast knowledge in the field of Information Technology.Boost your skills and get certified.An Authorized Training Center by Microsoft.

|Training Facilities|

• Authorized Training Center
• Hands-on Training
• Tutor Led Classroom
• Small Class Size 5-7 max
• Central London Locations
• Price includes Tuition Fee, VAT, 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
• Course Attendance Certificate

|Course Schedule|

Learn on your flexible hours. Classes in Fast Track, Week Days, Weekend, Evenings to suit your work and social life.

|Course Highlights| {Request Us For Full Brochure}

MCSA SQL Exam 70-761: Querying Data with Transact-SQLINTRODUCTION 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

|COURSE INFORMATION|

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.

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

|Price Info|

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

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

|Pay In Instalments|

You can also take advantage of our one-year interest-free repayment plan! Join the course today with confidence and pay as little as £108.00 per month for 12 months.

|Registration Process|

Speak with our Course Advisor

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.

Basic Knowledge of IT

|CAREER PROSPECT|

Boost your skills and get certified Database administrators, Software Developers, Project Managers etc.

Package Offers:

GREAT SAVINGS!!

Giveaway Price £3000+VAT for 3 courses / Save £600

1. MCSA: SQL Server 2016 Develop - £1200
2. MCSA: SQL Server 2016 Admin - £1200
3. MCSA: SQL Server 2016 BI Develop - £1200

Request Us For More Packages Info

LEARN THE SKILLS YOU NEED TO SUCCEED TODAY!!