Every computer expert in the world today woke up at some point in their life knowing nothing about computers. What did they learn when they were beginners? This course is idea for the beginner who wants to do all the hands on that makes is possible to go way past just passing the certification test. This allows you to have the knowledge to be ace most SQL Job interviews. This track gives you the complete Joes 2 Pros (Vol. 1 to 5) training lessons and follows them up with a solid review of the Microsoft materials.
After completing this lesson the students will be able to:
Introduction to Databases and Viewing Information
Viewing Combined Information
Query Strategies
Data Definition Language (DDL)
Data Manipulation Language (DML) and Scripting
Maintaining Tables
Concurrency and Transaction Control Language TCL
Security Data Control Language (DCL) (3 hours)
Aggregating Data
Top Records
Ranking Functions
Working with UNION, UNION ALL, EXCEPTION, and INTERSECTION
Common Table Expressions (CTE)
Data Recursion (3 hours)
Using Subqueries and Correlated Subqueries
Table data Actions (3 hours)
The Merge Statement (3 hours)
Advanced Query Clauses (3 hours)
Table and Field value Functions (3 hours)
Database File Structures
Database Schema, snapshots & Properties
Data Type Usage and special Data Type Options
Spatial Data
Creating altering and removing Partitioned Tables
Creating Indexes and Coding Indexes
Index Analysis and Index Maintenance
Special Index Types
Full Text Indexing
Constraints (Primary, Unique, Foreign, and Check)
After Triggers
Instead of Triggers and DDL Triggers
Creating, Updating and Maintaining Views
Stored Procedures and Stored Procedure Techniques
Functions
SQL Server Errors and Structured Error handling
Change Tracking
Change Data Capture CDC
Introduction to XML and SQL XML Modes
Shredding XML Attributes, Elements, and Levels
xQuery Extensions
SQL to XML Binding
Creating .Net Applications
Using the SQL CLR
Powershell in SQL
Schedule for Joes 2 Pros (Vol. 1 to 5)
Course #
Course Contents
Exam #
Exam
Regular Track (days)
Fast Track
(days)
Super Fast Track
(days)
Joes 2 Pros - Vol 1
Beginning SQL
-
-
4
0
0
Joes 2 Pros - Vol 2
SQL Queries
-
-
7
5
3
Joes 2 Pros - Vol 3
SQL Architecture Basics
-
-
6
5
4
Joes 2 Pros - Vol 4
SQL Programming
-
-
5
4
3
Joes 2 Pros - Vol 5
SQL Interoperability
-
-
5
4
4
6232B
Implementing a Microsoft SQL Server 2008 R2 Database
