Products/Courses List
-
- MCITP: Server Administrator on Server 2008
- MCSA
- MCSE
- MCPD
-
- Bookkeeping and Pastel Accounting
- Receptionist
- Data Capturer
- Office Administrator
- Call Centre Agent (Non Aligned)
- Customer Service Consultant
- Executive Secretary
- Executive Secretary - Marketing and Sales
- Personal Assistant (PA)
- Office Administrator
- Business & Project Management
MCSE: Data Platform
This certification enables you to demonstrate building and administering enterprise data solutions. The skill sets required cover both cloud and onsite environments.
MCSE: Data Platform
- 1 x Microsoft 70-461: Querying SQL Server 2012
- 1 x Microsoft 70-462: Administering SQL Server 2012 Databases
- 1 x Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012
- 1 x Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases
- 1 x Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012
Course Duration: TBA
Learning segments
Microsoft Exam 70-461: Querying Microsoft SQL Server 2012 Certification Training Course Curriculum
Instructor Introduction
Course Outline
Module 1
- Introduction to SQL Server 2012
- SQL Instances
- Editions and Licensing
- SQL Server Objects
- System Databases
- SQL Server Data Tools
- Object Explorer
- Object Scripting
- Template Explorer
- Query Tabs
- Projects and Solutions
- Customizing SSDT
- Debugging T-SQL
- SQLCMD
- Exam Scenarios
- Module Review
Module 2
- T-SQL Overview
- T-SQL Elements
- Batch Separators
- Line Terminator
- Variables
- Control Flow
- Expressions
- Functions
- Predicates and Operators
- SELECT
- Column Aliasing
- SELECT Execution
- Exam Scenarios
- Module Review
Module 3
- SELECT Statements
- Basic SELECT Statement
- Specifying Columns
- Derived Columns
- Aliasing Columns
- Calculated Columns
- Ordering Results
- Returning Distinct Results
- Exam Scenarios
- Module Review
Module 4
- Filtering
- WHERE Syntax
- BETWEEN
- WHERE Syntax IN
- Filtering NULL Values
- LIKE
- Data Type Comparison
- Filtering Data with WHERE
- TOP
- OFFSET-FETCH
- Exam Scenarios
- Module Review
Module 5
- Join and Set Operators
- Using Joins
- Categories of Joins
- INNER JOIN
- OUTER JOIN
- JOIN Demo
- Set Operators
- Set Operators Demo
- Exam Scenarios
- Module Review
Module 6
- Subqueries and Table Expressions
- Subqueries
- Self Contained Subquery
- Correlated Subquery
- Subquery Demo
- EXISTS
- Common Table Expressions
- Temporary Tables
- Table Variables
- Table Demo
- Exam Scenarios
- Module Review
Module 7
- System Functions
- Scalar Functions
- ROWSET
- System Function Demo
- Aggregate Functions
- DISTINCT
- Aggregation Demo
- GROUP BY
- HAVING
- Conversion Functions
- Exam Scenarios
- Module Review
Module 8
- T-SQL Programming
- Logical Functions
- IIF, CHOOSE and CASE
- Logical Function Demo
- Using Views
- Stored Procedures
- Functions
- Triggers
- Views Demo
- TRY CATCH
- Exam Scenarios
- Module Review
Module 9
- Transactions
- Introduction to Transactions
- INSERT and UPDATE
- DELETE and TRUNCATE
- Transactions Demo
- Managing Transactions
- XACT_ABORT
- Managing Transactions Demo
- Exam Scenarios
- Module Review
Module 10
- Query Performance
- Indexing
- Index Strategies
- Indexes Demo
- Execution Plans
- Statistics IO
- Execution Plans Demo
- Exam Scenarios
- Module Review
- Program Review
NB :
- Our price does NOT include any exam vouchers.
- Qualification exams are held and managed by independent third parties.
- Vouchers will need to be purchased separately when you are ready.
- We sell vouchers at cost to all our students.
For More Information Email us at info@studyitonline.co.za
