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 14: Network Threats and Mitigation
  • Recognizing Security Threats
  • Vulnerabilities
  • Understanding Mitigation Techniques
  • Policies and Procedures
  • Anti-malware software
  • 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 Network+ N10-007 Practice Lab:
  • Configuring a Network Adaptor
  • ARP and Packet Analysis
  • IP Address Configuration
  • IP Addressing Schemes
  • Configuring DHCP Clients and Servers
  • IPv6 Addressing
  • Configuring Routing
  • TCP and Port Scanning
  • Name Resolution
  • Configuring Email Services
  • Configuring a NAT Firewall
  • Authentication Methods
  • Configuring Certificate Services and HTTPs
  • Performance Testing and Monitoring
  • Monitoring and Management Tools
  • Configuring Routing Using Cisco Devices
  • Configuring VPNs
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:

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.


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