A+, Network+, Security+, MCSE Data Platform

Hours: 440 / Access Length: 12 mos / Delivery: Open, Mentor Supported
Retail Price: $4,000.00

Course Overview:

Microsoft will be discontiuing the 70-461, 70-462, 70-463, 70-464, and 70-465 certification exams on June 30, 2020.
The associated courses will be discontinued May 16th, 2020.
If you are working towards those certification exams, you must pass the certification exam by June 30, 2020.
More information about these changes can be found here: MCSA, MCSD, MCSE certifications retire

CompTIA A+ exam is a globally recognized industry standard for establishing an IT career. CompTIA A+ Core Series 220-1001 exam and 220-1002 exam cover expanded content on growing IT support role including expanded baseline security topics. The certification provides a different approach to define competency in operational procedures including basic disaster prevention, recovery, and scripting basics and a greater dependency on networking and device connectivity.

This course is intended for entry-level computer support professionals with a basic knowledge of computer hardware, software, and operating systems who wish to increase their knowledge and understanding of networking concepts and acquire the required skills to prepare for a career in network support or administration, or who wish to prepare for the CompTIA Network+ certification (Exam N10-007).

Gain hands-on expertise in CompTIA Security+ certification exam by course and performance based labs. Performance based labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training. CompTIA Security+ is an entry-level, international, vendor-neutral credential designed for IT security professionals to identify risk, participate in risk mitigation activities, provide infrastructure, information, operational, and application security. CompTIA Security+ SY0-501 exam covers the application of security controls to maintain confidentiality, integrity, and availability; identification of appropriate technologies and products; troubleshooting security events and incidents, and many more.

Demonstrate your broad skill sets in building and administrating enterprise-scale data solutions both on-premises and in cloud environments with the MCSE Data Platform certification from Microsoft. This course prepares students to take the Microsoft 70-461: Querying SQL Server 2012, 70-462: Administering SQL Server 2012 Databases, 70-463: Implementing a Data Warehouse with SQL Server 2012 Server, 70-464: Developing Microsoft SQL Server 2012, 70-465: Designing Database Solutions for Microsoft SQL Server certification exams.

The Microsoft 70-461: Querying SQL Server 2012 course is intended for SQL Server database administrators, implementers, system engineers, and developers. This new SQL 2012 course is focused on anyone interested in the validation of your skills and knowledge with writing queries.

This course provides the knowledge and understanding for some of these important job functions:

Apply built-in scalar functions
Apply ranking functions
Combine datasets
Creates and alters
Design T-SQL stored procedures, views
Implementing aggregate queries, error handling, sequence generation and data types
Manage transactions
Modify data by using INSERT, UPDATE, DELETE and MERGE statements
Optimizing queries
Query data using SELECT statements and Managing XML data
OUTPUT clause to return data

This Microsoft 70-462: Administering SQL Server 2012 Databases course was created specifically for those individuals (Database Professionals) who install, maintain and configure as their primary job function. Any participants setting up database systems and/or responsible for efficient system operation, regular database backups stored effectively, and securing data from unauthorized access is also a candidate for this training course on SQL 2012.

Below is a partial list of job functions associated to this training course:

Audit SQL Server instances
Back up databases
Configure additional SQL Server components, Instances and Services
Deploying a SQL Server
Implementing strategies, column stores and High-Availability and Disaster Recovery solutions
Importing/exporting
Install SQL Server and related services.
Maintenance
Management, configuration, permissions, alerts, logins and roles.
Optimization
Installation Planning
Restoring
Troubleshooting

This Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012 course is designed for ETL and Data Warehouse Developers who most likely focus on hands-on work creating business intelligence (BI) solutions, including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation. Primary responsibilities may include:

Mastering data using Master Data Services
Cleansing data using Data Quality Services
ETL Package development for data loading/transfer/transformation
Data Synchronization
One-time data or application migration
Ad-hoc data manipulations, transformations
Scheduling ETL jobs
Managing, configuring and deploying SQL Server Integration Services (SSIS) packages

This Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases course is designed for Database developers who build and implement databases across the organization, while ensuring high levels of data availability. They perform tasks including creating database files, create data types, tables, plan create and optimize indexes, implement data integrity, implement views, stored procedures and functions, manage transactions and locks. Primary responsibilities may include:

Optimizing and tuning queries.
Creating and altering indexes and stored procedures.
Maintaining database integrity.
Optimizing indexing strategies.
Creating and altering tables.
Maintaining indexes.
Creating and modifying constraints.

This Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012 course is designed for Database professionals who design and build database solutions. These Database professionals are responsible for the creation of plans and designs for Database structure, storage, objects, and servers, as well as creating the plan for the environment in which the database solution runs. Primary responsibilities may include but are not limited to designing:

Data compression strategies
Database models
Full-Text Search strategies
High-availability solutions
Maintenance strategy for database servers
Management automation strategies
Migration, consolidation, and upgrade strategies
Database, schema, and object security parameters

This course includes FREE access for 12 months to a cloud based lab platform to assist students develop the practical information technology (IT) skills necessary to succeed in high in demand IT jobs. This cloud based lab solution uses real equipment that enables our students to execute each practical task in a safe environment that is accessible from anywhere without needing to buy their own hardware or risk damage to their own system.

Along with providing the necessary hardware in a virtual environment, students gain access to high quality practical exercises that cover many of the exam topics they will encounter on their certifying exams.

This course prepares students to take the CompTIA A+ 220-1001 & 220-1002, N10-007: Network+, SY0-501: Security+, Microsoft 70-461: Querying SQL Server 2012, 70-462: Administering SQL Server 2012 Databases, 70-463: Implementing a Data Warehouse with SQL Server 2012 Server, 70-464: Developing Microsoft SQL Server 2012, and 70-465: Designing Database Solutions for Microsoft SQL Server certification exams.

Course Outline:

CompTIA A+ 220-1001 and 220-1002 Curriculum:

Chapter 1: Troubleshooting

Module A: Troubleshooting theory
Module B: Safety
Module C: Professionalism
Summary

Chapter 2: Motherboards and CPUs

Module A: Motherboards
Module B: CPUs
Summary

Chapter 3: Computer power supplies

Module A: Power supply connectors
Module B: Power supply installation
Module C: Power supply troubleshooting
Summary

Chapter 4: Memory

Module A: Read-only memory
Module B: Random access memory
Summary

Chapter 5: Computer expansion

Module A: Expansion interfaces
Module B: Expansion card installation
Module C: Connectors and cables
Summary

Chapter 6: Physical storage

Module A: Disk drives
Module B: RAID storage
Module C: Optical drives
Module D: Other storage methods
Summary

Chapter 7: Input-output devices

Module A: Input devices
Module B: Output devices
Module C: Dual input-output devices
Summary

Chapter 8: Display Devices

Module A: Display technologies
Module B: Display management
Summary

Chapter 9: Operating systems

Module A: Windows versions and features
Module B: Non-Windows operating systems
Module C: Operating system installation and upgrades
Module D: Applications and scripting
Summary

Chapter 10: Windows management

Module A: Operating system features and tools
Module B: Control Panel utilities
Module C: Command-line tools
Module D: Troubleshooting
Summary

Chapter 11: Network basics

Module A: Classifying networks
Module B: Network devices
Module C: Internet connections
Summary

Chapter 12: Network cables and connectors

Module A: Twisted-pair connections
Module B: Coaxial connections
Module C: Optical media
Summary

Chapter 13: Network protocols

Module A: TCP/IP settings
Module B: Transport protocols
Module C: Application protocols
Summary

Chapter 14: Wireless networking

Module A: Wireless technology
Module B: Wi-Fi standards
Summary

Chapter 15: Windows networking

Module A: Network shares
Module B: Network connections
Module C: Connection troubleshooting
Summary

Chapter 16: Virtualization and cloud computing

Module A: Virtualization
Module B: Cloud computing
Summary

Chapter 17: Mobile devices

Module A: Mobile device types
Module B: Mobile device configuration
Module C: Mobile device troubleshooting
Summary

Chapter 18: Security principles

Module A: Threats and vulnerabilities
Module B: Security controls
Summary

Chapter 19: Security technologies

Module A: Operating system security
Module B: Security hardware and software
Summary

Chapter 20: Securing devices and data

Module A: Workstation security
Module B: Mobile device security
Module C: Security troubleshooting
Summary

Chapter 21: SOHO network configuration

Module A: SOHO router features
Module B: Network security
Summary

Chapter 22: Printers and multi-function print devices

Module A: Printer technologies
Module B: Printer installation and maintenance
Module C: Printer troubleshooting
Summary

Chapter 23: Custom computers

Module A: Custom computer considerations
Summary

Chapter 24: Operational procedures

Module A: IT operations
Module B: Environmental factors
Module C: Incident response
Module D: Backup and recovery
Summary

Chapter 25: Appendix A

Chapter 26: Appendix B

3D Objects

Chapter 27: Appendix: 3D Avatar based Simulation

220-1001 3D Game
220-1002 3D Game

CompTIA A+ 220-1002 Live Labs

CompTIA Network+ N10-007 Curriculum:

Lesson 1: Introduction to Networks

First Things First: What's a Network?
Physical Network Topologies
Topology Selection, Backbones, and Segments
Summary
Exam Essentials
Written Labs

Lesson 2: The Open Systems Interconnection Specifications

Internetworking Models
The OSI Reference Model
Introduction to Encapsulation
Modulation Techniques
Summary
Exam Essentials
Written Lab

Lesson 3: Networking Topologies, Connectors, and Wiring Standards

Physical Media
Cable Properties
Wiring Standards
Installing Wiring Distributions
Summary
Exam Essentials
Written Lab

Lesson 4: The Current Ethernet Specifications

Network Basics
Ethernet Basics
Ethernet at the Data Link Layer
Ethernet at the Physical Layer
Ethernet over Other Standards (IEEE 1905.1-2013)
Summary
Exam Essentials
Written Lab
Written Lab Answers

Lesson 5: Networking Devices

Common Network Connectivity Devices
Other Specialized Devices
Planning and Implementing a Basic SOHO Network Using Network Segmentation
Summary
Exam Essentials
Written Lab
Answer to Written Lab

Lesson 6: Introduction to the Internet Protocol

Introducing TCP/IP
Data Encapsulation
Summary
Exam Essentials
Written Lab
Lesson 7: IP Addressing
IP Terminology
The Hierarchical IP Addressing Scheme
IPv4 Address Types
Internet Protocol Version 6 (IPv6)
Summary
Exam Essentials
Written Lab

Lesson 8: IP Subnetting, Troubleshooting IP, and Introduction to NAT

Subnetting Basics
Troubleshooting IP Addressing
Introduction to Network Address Translation (NAT)
Summary
Exam Essentials
Written Labs

Lesson 9: Introduction to IP Routing

Routing Basics
The IP Routing Process
Testing Your IP Routing Understanding
Static and Dynamic Routing
Summary
Exam Essentials
Written Lab

Lesson 10: Routing Protocols

Routing Protocol Basics
Distance Vector Routing Protocols
Link State Routing Protocols
High Availability
IPv6 Routing Protocols
Summary
Exam Essentials
Written Lab

Lesson 11: Switching and Virtual LANs

Networking Before Layer 2 Switching
Switching Services
Spanning Tree Protocol
Virtual LANs
VLAN Trunking Protocol
Two Additional Advanced Features of Switches
Summary
Exam Essentials
Written Lab

Lesson 12: Wireless Networking

Introduction to Wireless Technology
The 802.11 Standards
Comparing 802.11 Standards
Wireless Network Components
Installing a Wireless Network
Site Survey
Wireless Security
Summary
Exam Essentials
Written Lab

Lesson 13: Authentication and Access Control

Security Filtering
Managing User Account and Password Security
User-Authentication Methods
Summary
Exam Essentials
Written Lab

Lesson 15: Physical Security and Risk

Using Hardware and Software Security Devices
Defining Firewalls
Firewall Technologies
Firewalls at the Application Layer vs the Network Layer
Scanning Services and Other Firewall Features
Intrusion Detection and Prevention Systems
VPN Concentrators
Understanding Problems Affecting Device Security
Summary
Exam Essentials
Written Lab

Lesson 16: Wide Area Networks

What's a WAN?
T-Series Connections
Transmission Media
Broadband Services
Wireless WAN Technologies
WAN Protocols
WAN Troubleshooting
Summary
Exam Essentials
Written Lab

Lesson 17: Troubleshooting Tools

Protocol Analyzers
Throughput Testers
Connectivity Software
Using Traceroute
Using ipconfig and ifconfig
Using the ping Utility
Using the Address Resolution Protocol
Using the nslookup Utility
Resolving Names with the Hosts Table
Using the Mtr Command (pathping)
Using the route Command
Using the nbtstat Utility
Using the netstat Utility
Using the File Transfer Protocol
Using the Telnet Utility
Summary
Exam Essentials
Written Lab

Lesson 18: Software and Hardware Tools

Understanding Network Scanners
Baseline
Network Monitoring and Logging
Identifying Hardware Tools
Summary
Exam Essentials
Written Lab

Lesson 19: Network Troubleshooting

Narrowing Down the Problem
Troubleshooting Steps
Troubleshooting Tips
Summary
Exam Essentials
Written Lab

Lesson 20: Management, Monitoring, and Optimization

Managing Network Documentation
Network Monitoring
Network Optimization
Summary
Exam Essentials
Written Lab

Lesson 21: Appendix A

Videos

CompTIA Security+ SY0-501 Curriculum:

Lesson 1: Measuring and Weighing Risk

Risk Assessment
Developing Policies, Standards, and Guidelines
Summary
Exam Essentials

Lesson 2: Monitoring and Diagnosing Networks

Monitoring Networks
Understanding Hardening
Securing the Network
Security Posture
Reporting Security Issues
Differentiating between Detection Controls and Prevention Controls
Summary
Exam Essentials

Lesson 3: Understanding Devices and Infrastructure

Mastering TCP/IP
Designing a Secure Network
Understanding the Various Network Infrastructure Devices
Summary
Exam Essentials

Lesson 4: Access Control, Authentication, and Authorization

Understanding Access Control Basics
Understanding Remote Access Connectivity
Understanding Authentication Services
Understanding Access Control
Implementing Access Controlling Best Practices
Summary
Exam Essentials

Lesson 5: Protecting Wireless Networks

Working with Wireless Systems
Understanding Wireless Devices
Wireless Vulnerabilities to Know
Summary
Exam Essentials

Lesson 6: Securing the Cloud

Working with Cloud Computing
Working with Virtualization
Security and the Cloud
Summary
Exam Essentials

Lesson 7: Host, Data, and Application Security

Application Hardening
Host Security
Protecting Data Through Fault Tolerance
Application Security
Best Practices for Security
Summary
Exam Essentials

Lesson 8: Cryptography

An Overview of Cryptography
Modern Cryptography
Using Cryptographic Systems
Understanding Cryptography Standards and Protocols
Using Public Key Infrastructure
Summary
Exam Essentials

Lesson 9: Malware, Vulnerabilities, and Threats

Understanding Malware
Surviving Viruses
Understanding Various Types of Attacks
Identifying Types of Application Attacks
Tools for Finding Threats
Summary
Exam Essentials

Lesson 10: Social Engineering and Other Foes

Understanding Social Engineering
Understanding Physical Security
Environmental Controls
Control Types
Data Policies
Summary
Exam Essentials

Lesson 11: Security Administration

Third-Party Integration
Understanding Security Awareness and Training
Classifying Information
Information Access Controls
Complying with Privacy and Security Regulations
Mobile Devices
Alternative Methods to Mitigate Security Risks
Summary
Exam Essentials

Lesson 12: Disaster Recovery and Incident Response

Issues Associated with Business Continuity
Reinforcing Vendor Support
Penetration Testing
Summary
Exam Essentials

Lesson 13: Video Tutorials

Introduction
Security Fundamentals and Controls
Security and Risk
Business Continuity and Load Balancing
Threats, Vulnerabilities, and Assessment Tools
Application, Data, and Host Security
Access Control and Identity Management
Security Controls and Cryptography
Virtual Private Networks
Conclusion

CompTIA Security+ SY0-501 Practice Lab:

Trojans and Malware Protection
Network Vulnerabilities
Vulnerability Scanning
Routing Protocols
Attacks against DHCP and DNS
Steganography
Configuring Certificate Services
HTTP and HTTPS
Web Application Vulnerabilities
Telnet and FTP and SSH
Password Sniffing
Baseline Security Analyzer
Network Access Protection
VPNs
Data Leakage Prevention
Computer Forensic Tools

Microsoft Exam 70-461: Querying Microsoft SQL Server 2012 Curriculum:

Instructor Introduction
Course Outline

Microsoft Exam 70-461: 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

Microsoft Exam 70-461: 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

Microsoft Exam 70-461: Module 3

SELECT Statements
Basic SELECT Statement
Specifying Columns
Derived Columns
Aliasing Columns
Calculated Columns
Ordering Results
Returning Distinct Results
Exam Scenarios
Module Review

Microsoft Exam 70-461: 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

Microsoft Exam 70-461: 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

Microsoft Exam 70-461: 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

Microsoft Exam 70-461: Module 7

System Functions
Scalar Functions
ROWSET
System Function Demo
Aggregate Functions
DISTINCT
Aggregation Demo
GROUP BY
HAVING
Conversion Functions
Exam Scenarios
Module Review

Microsoft Exam 70-461: 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

Microsoft Exam 70-461: 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

Microsoft Exam 70-461: Module 10

Query Performance
Indexing
Index Strategies
Indexes Demo
Execution Plans
Statistics IO
Execution Plans Demo
Exam Scenarios
Module Review
Program Review

Microsoft Exam 70-462: Administering Microsoft SQL Server 2012 Databases Curriculum:

Instructor Introduction
Course Outline

Microsoft Exam 70-462: Module 1

Introduction to SQL Server 2012
SQL Server
SQL Server Tools
Management Studio Demo
Data Tools
Exam Scenarios
Module Review

Microsoft Exam 70-462: Module 2

Installing SQL Server
SQL Architecture
Hardware Requirements
Software Requirements
Installation Process
Troubleshooting Installation
Upgrading and Unattended Installations
Configuration Demo
Exam Scenarios
Module Review

Microsoft Exam 70-462: Module 3

Backup and Restore a Database
Database Architecture
Database Backup
Restoration Process
Restoring System Database
Backup and Recovery Demo
Exam Scenarios
Module Review

Microsoft Exam 70-462: Module 4

Tracing Access to SQL Server
Auditing Options
Introduction to SQL Audit
Audit Objects and Implementation
Extended Events
Tracing Activity Demo
Exam Scenarios
Module Review

Microsoft Exam 70-462: Module 5

Importing and Exporting Data
Introduction to Data Transfer
ETL Tools
Improving Data Transfer
Copying Database Methods
Transferring Data Demo
Exam Scenarios
Module Review

Microsoft Exam 70-462: Module 6

SQL Server Security
Security and Authentication
Server and Database Roles
Permissions
Securing SQL Server Demo
Exam Scenarios
Module Review

Microsoft Exam 70-462: Module 7

Automating SQL Server
SQL Server Agent
Database Mail
Operators, Alerts and Jobs
Database Configuration Demo
Exam Scenarios
Module Review

Microsoft Exam 70-462: Module 8

Monitoring SQL Server
Dynamic Management Views and Functions
Profiler Trace
Database Tuning Advisor
Activity and Performance Monitor
Data Collection
Monitoring Demo
Exam Scenarios
Module Review

Microsoft Exam 70-462: Module 9

Maintaining SQL Server
Checking Database Integrity
Indexing
Ongoing Maintenance
Managing and Maintaining Demo
Exam Scenarios
Module Review

Microsoft Exam 70-462: Module 10

Troubleshooting SQL Server
Service Issues
Connectivity Issues
Locking Issues
Troubleshooting Demo
Exam Scenarios
Module Review
Program Review

Microsoft Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012 Curriculum:

Instructor Introduction
Course Outline

Microsoft Exam 70-463: Module 1

Introduction to Data Warehousing
OLTP vs. OLAP
Data Warehouse
Data Warehouse Architecture
Creating a Data Warehouse
Presenting OLAP Data
OLTP and OLAP Comparison Demonstration
Exam Scenarios
Module Review

Microsoft Exam 70-463: Module 2

Designing a Data Warehouse
Data Modeling
Data Warehouse Schemas
Time Dimensions
Data Modeling Considerations
Implementing a Data Model
Logical Model
Physical Model
Dimensions and Facts
Exam Scenarios
Module Review

Microsoft Exam 70-463: Module 3

ETL with SSIS
Introduction to SSIS
Upgrading SSIS Packages
SSIS Tools
Data Flow Tasks
Data Sources
Transformations
Utilizing SQL Server Data Tools
Data Flow Task
Exam Scenarios
Module Review

Microsoft Exam 70-463: Module 4

SSIS Control Flow
Control Flow Tasks
Integration Services Variables
Expressions
Precedence
Containers and Annotation
Transactions
Checkpoints
Control Flow Tasks and Precedence
Exam Scenarios
Module Review

Microsoft Exam 70-463: Module 5

Troubleshooting Packages
Overview of Troubleshooting
Debugging
Breakpoints
Error Handling
SSIS Log Providers
Custom Logging
Troubleshooting and Logging
Exam Scenarios
Module Review

Microsoft Exam 70-463: Module 6

Advanced Packages
Maintaining a Data Warehouse
Change Data Capture
Slowly Changing Dimensions
Script Components
Incremental Updates
Exam Scenarios
Module Review

Microsoft Exam 70-463: Module 7

Data Quality Services
Introduction to Data Quality Services
Data Quality Services Components
Working with Data Quality Services
Exam Scenarios
Module Review

Microsoft Exam 70-463: Module 8

Master Data Services
Introduction to Master Data Services
MDS vs. DQS
How MDS Works
Exam Scenarios
Module Review

Microsoft Exam 70-463: Module 9

Deployment and Security
Deployment Options
Package Deployment
Securing Packages
Deploying SSIS Packages and Projects
Exam Scenarios
Module Review
Program Review

Microsoft Exam 70-464: Developing Microsoft SQL Server 2012 Databases Curriculum:

Instructor Introduction
Course Outline

Microsoft Exam 70-464: Module 1

Introduction to SQL Server 2012
SQL Instances
SQL Editions
SQL Server Tools
SQL Server Management Studio
SQL Data Tools
SQL Command
Utilizing SQL Server Tools
Exam Scenarios
Module Review

Microsoft Exam 70-464: Module 2

Introduction to Data Types and Tables
Collations
Unicode Characters
Null Values
Converting Data Types
Introduction to Tables
Normalization
Temporary Tables
Working with Tables
Schemas
Primary and Foreign Keys
UNIQUE Constraint/Index
In Depth Look
Exam Scenarios
Module Review

Microsoft Exam 70-464: Module 3

SQL Server Indexing
Introduction to Indexing
Clustered Indexes
Non Clustered Indexes
Maintaining Indexes
Index Fragmentation
Index Tuning
Creating and Altering Indexes
Exam Scenarios
Module Review

Microsoft Exam 70-464: Module 4

Query Performance
Execution Plans
Reading Execution Plans
Execution Plan Operators
Plan Reuse
Query Performance
Exam Scenarios
Module Review

Microsoft Exam 70-464: Module 5

Common Language Runtime (CLR) Integration
Assemblies
Permissions
CLR Objects
Integrating the CLR within SQL Server
Exam Scenarios
Module Review

Microsoft Exam 70-464: Module 6

Transact-SQL (T-SQL) Error Handling
Error Severity
TRY CATCH Error Handling
TRY PARSE and TRY CONVERT
@@ ERROR
Alerts
Error Handling in T-SQL
Exam Scenarios
Module Review

Microsoft Exam 70-464: Module 7

Views and Functions
Types of Views
Working with Views
Introduction to Functions
Working with Functions
Working with Views and Functions
Exam Scenarios
Module Review

Microsoft Exam 70-464: Module 8

Stored Procedures and Triggers
Working with Stored Procedures
Introduction to Triggers
Working with Triggers
Stored Procedures and Triggers Demo
Exam Scenarios
Module Review

Microsoft Exam 70-464: Module 9

Working with XML
XML Concepts
Schemas and Schema Collections
FOR XML Clause
FLOWR Queries
Working with XML in SQL Server
Exam Scenarios
Module Review

Microsoft Exam 70-464: Module 10

Transactions
Implicit Transactions
Explicit Transactions
Locking
Working with Transactions and Locking within SQL
Exam Scenarios
Module Review
Course Review

Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012 Curriculum:

Instructor Introduction
Course Outline

Microsoft 70-465: Module 1

Course Introduction
Course Modules
Introduction to SQL Server 2012
SQL Server Instances
SQL Server Editions and Licensing
SQL Server Objects
System Databases
SQL Server Management Studio
SSMS Components
SQL Server Data Tools
SQLCMD
Working with SSMS
Working with SQLCMD
Exam Scenarios
Module Review

Microsoft 70-465: Module 2

Introduction to Databases
Database Files
Temp db
Working with Databases
Introduction to Filegroups and Files
Introduction to Log Files
Transactions
Moving Databases
Detaching and Attaching Databases
Backing Up and Restoring Databases
Copy Database Wizard
Database Catalog View
Creating and Configuring Databases
Exam Scenarios
Module Review

Microsoft 70-465: Module 3

Introduction to Data Types and Tables
Supported Data Types
Collations and Unicode Characters
Introduction to NULLS
Converting Data Types
Introduction to Tables
Normalization
Temporary Tables
Working with Tables
Schemas
Primary and Foreign Keys
UNIQUE Constraint/Index
Data Types in SQL Server Demonstration
Working with Tables Demonstration
Exam Scenarios
Module Review

Microsoft 70-465: Module 4

SQL Server Indexing
Introduction to Indexing
Heaps
Clustered Indexes
Non-Clustered Indexes
Maintaining Indexes
Index Fragmentation
SQL Server Profiler
Index Tuning
Working with Indexes Demonstration
SQL Server Tuning Advisor Demonstration
Exam Scenarios
Module Review

Microsoft 70-465: Module 5

Performance Considerations
Partitioning Function
Partition Scheme
Partitioned Table or Index
Introduction to Transaction
Implicit and Explicit Transactions
Locking
Working with Partition Tables, Transaction and Locks
Exam Scenarios
Module Review

Microsoft 70-465: Module 6

Backup and Restore
Database Data and Log Files
Recovery Model
Database Backups Types
Backup Compression and Mirrored Media Sets
Verifying Backups
Restoration Process
Restoring Backup Types
Restoring to a Point in Time
WITH STANDBY
Restoring a Database
Restoring System Databases
Restoring the Master Database
Backing Up and Restoring SQL Server
Exam Scenarios
Module Review

Microsoft 70-465: Module 7

Views and Functions
Types Of Views
Creating and Altering Views
Updatable and Indexed Views
Partitioned Views
Introduction to Functions
Function Types
Scalar and Table Valued Functions
Working with Views and Functions
Exam Scenarios
Module Review

Microsoft 70-465: Module 8

Stored Procedures and Triggers
Types of Stored Procedures
Parameters
Stored Procedure Compilation
Execution Context
Introduction to Triggers
Types of Triggers
Nested and Recursive Triggers
Trigger Firing Order
Working with Stored Procedures and Triggers
Exam Scenarios
Module Review

Microsoft 70-465: Module 9

SQL Server Security
SQL Authentication
SQL Logins
Accessing a Database
Authorization Across Servers
Server Roles
Database Roles
Application Roles
Authorizing Access
Configuring Access Using Schemas
Working with SQL Security
Exam Scenarios
Module Review

Microsoft 70-465: Module 10

Installing and Upgrading SQL
Server Resources
32 vs. 64 Bit
SQL Requirements
Software Requirements
Collations
Service Accounts
Installing SQL Server
Troubleshooting Installation
Upgrading SQL Server
Unattended Installations
Exam Scenarios
Module Review
Course Review

Querying Microsoft SQL Server 2012 Virtual Lab

Create and alter tables using Transact SQL syntax
Create and alter views
Create and modify constraints
Create and alter DML triggers
Query data by using SELECT statements
Implementing Sub queries
Implementing Data Types
Implementing Aggregate Queries
Query and Manage XML Data
Modifying Data
Working with Functions
Optimizing Queries
Troubleshooting Queries

Administering Microsoft SQL Server 2012 Databases Virtual Lab

Install SQL Server and related services
Implement a migration strategy
Configure additional SQL Server components
Manage SQL Server Agent
Manage and configure databases
Configure SQL Server instances
Manage SQL Server Instances
Identify and Resolve Concurrency Problems
Audit SQL Server Instances
Manage Logins and Server Roles
Manage Database Permissions
Troubleshoot Security
Manage Users and Database Roles

Implementing a Data Warehouse with Microsoft SQL Server 2012 Virtual Lab

Design and Implement a Data Warehouse
Define Connection Managers
Implementing Data Flow
Managing SSIS Package Execution
Implementing Script Tasks
Implement Control Flow
Implement Data Load Options
Troubleshoot Data Integration Issues
Install and Maitain SSIS Components
Implement Auditing Logging and Event Handling
Deploy SSIS Solutions
Install and maintain Data Quality Services
Implement Master Data Management Solutions
Manage Master Data Management Solutions
Create a Data Quality Project to Clean Data
Manage Data Quality Project to Clean Data

Developing Microsoft SQL Server 2012 Databases Virtual Lab

Create and alter tables
Design, implement,and troubleshoot security
Design the locking granularity level
Maintain indexes
Implement data types
Create and modify constraints
Work with XML data
Write automation scripts
Design and implement stored procedures
Design T-SQL table-valued and scalar functions
Create, use, and alter user-defined functions (UDFs)
Create and alter views
Create and alter indexes
Optimize and tune queries
Troubleshoot and resolve performance problems
Optimize indexing strategies
Capture and analyze execution plans
Collect performance and system information

All necessary materials are included.

Certifications:

System Requirements:

System Requirements:

Internet Connectivity Requirements:

Cable and DSL internet connections are recommended for the best experience.

Hardware Requirements:

CPU: 1 GHz or higher
RAM: 2 GB or higher
Resolution: 1280 x 720 or higher
Speakers / Headphones
Microphone (Webinar / Live Online sessions)

Operating System Requirements:

Microsoft Windows 7 or 10 (Home, Pro)
Mac OSX 10 or higher.
Latest Chrome OS
Latest Linux Distributions

NOTE: While we understand that our courses can be viewed on Android and iPhone devices, we do not recommend the use of these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online based courses.

Web Browser Requirements:

Latest Google Chrome is recommended for the best experience.
Latest Mozilla FireFox
Latest Microsoft Edge
Latest Apple Safari

Basic Software Requirements (These are recommendations of software to use):

Office suite software (Microsoft Office, OpenOffice, or LibreOffice)
PDF reader program (Adobe Reader, FoxIt)
Courses may require other software that is denoted in the above course outline.

** The course outlines displayed on this website are subject to change at any time without prior notice. **