MCSA: SQL 2016 Database Development
Deal of the Month: 20% Discount on this Course. Limited Availability.
Training Square
Summary
Finance Available @ 0% Interest, Spread The Cost of Your Training Across 12 Months.
- Exam(s) / assessment(s) not included in price, and must be purchased separately
- Tutor is available to students
Location & dates
Overview
Training Square is the UK’s only digital media learning and development provider. we are a MICROSOFT Authorized Training Center with Industry Certified Expert Trainers.
MCSA SQL Server 2016 Database (Development)Training Include's: Classroom-based, Tutor Led, hands-on training giving you real-life experience, Lab Exercises, Project work, Unlimited Lab Access, Books, Materials, Course Completion Certificate, Free Re-training, and free refreshment.
Training Options: (Flexible Time & Start Dates)
- Fast Track
- Weekend Track
- Evening Track
Detail Syllabus:
MCSA: SQL 2016 Database DevelopmentMCSA 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 DatabasesDeveloping 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
Certification
Microsoft Certified Solutions Associate (MCSA) SQL Server
Course media
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.
-----------------------------------------------------------------------------------
Finance Available:
Choose from one of the following Finance Options @ 0% interest:
- 3 months - £145 Upfront and monthly payments of £435.00
- 6 months - £145 Upfront and monthly payments of £217.00
- 12 months - £145 Upfront and monthly payments of £108.00
----------------------------------------------------------------------------------
Who is this course for?
People aspiring for a career in Database
Whether you are a 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.
Requirements
Basic knowledge of Database / Web Design
Career path
Plan a career in a technical Database field as SQL Server Database Administrator (DBA), SQL Server Developer, SQL Server Business Intelligence (BI) Developer.
Enhance your skills by joining our Career packages.
Professional Package > £4200 Save £550 [Package Includes: MCSA SQL Server +Oracle 11g OCP]
* Call us to find out more about career packages.
Join us Now 100% satisfaction guarantee.
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.