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-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
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
WORKING WITH XML
STORING AND QUERYING BLOBS IN SQL SERVER
