Practical SQL Server 2012 Programming
in 7 Days with Full-Motion Video & Audio



Practical SQL Server 2012 Programming
SQL 2008 Grand Slam

 Free Trial Registration
How Did You Hear About Us? 

Best Possible Career Investment
SQL Server 2012 Programming training is now available on memory stick with full-motion video and narration. Learn SQL Server 2012 programming the fun way! Multimedia training is far more effective than boring hard-to-follow textbooks. It simulates the real-world environment for excellent memory retention. Learn from your own computer at a pace that suits you. You can replay the video and audio instructional units as many times as you need to. Save big over expensive classroom training. Learn the new programming features of SQL Server 2012 from SQLUSA, The World Leader in SQL Server & Business Intelligence Training.

Master Microsoft SQL Server 2012
Database Design and Programming are all included in this easy-to-learn video/audio 7 DAYs collection from Silico-Magnetic Intelligence. Whether you are learning SQL Server 2012 Programming for the first time or adding to your professional skills set, you will find that SMI’s Practical Training via full-motion screen video contains thorough, outstanding, well-prepared content that is second to none. Like training one-on-one with an experienced database professional, each unit is presented in full-motion screen image video allowing you to see the steps and hear the explanations.

Instructions by a Top SQL Expert
The instructor is Kalman Toth, MCDBA/MCITP, Senior SQL Server 2000/2005/2008/2012 Architect. By mastering one DAY videos a day, you can become a Microsoft SQL Server 2012 developer in 7 DAYs. Naturally, you can also proceed at your own pace, be it 21 days or 8 weeks. The comprehensive 7 DAYs video course is focused on practical solutions to real-world database, client and server design and programming problems. Full-motion screen video and rich audio make the subject matter understandable, and reusable as reference material in the future.

Audience for SQL Server 2012 Programming
C#, VB, .Net, Cold Fusion, Web, Java, C++ and database developers, systems analysts, and software engineers who need to know more about database design and programming of SQL Server 2012.

Prerequisites for SQL Server 2012 Training
SQL Server 2012 learners must have a solid working knowledge of the Windows environment, and any programming experience is a huge plus. This is the most extensive, practical and the best Microsoft SQL Server Database Design & Programming multimedia training currently available in North America, or anywhere in the world.

Objective: Excellence in SQL Server Related Professions
The 7 DAYs narrated screen video based course will allow learners to design, create and manage database objects, use the SELECT statement, insert/update/delete data, and program in Transact-SQL. There is strong emphasis on practical applications and real life examples. Familiarize with SQL Server sample databases: pubs, Northwind, AdventureWorks, AdventureWorks2008, AdventureWorks2012 and AdventureWorksDW2012. Discover the most important principles of relational database design: logical and physical data modeling, primary keys and foreign keys and 3NF design guidelines. Explore inner join, left join, right join, self join and cross join. Learn about the all important GROUP BY clause and aggregate functions like sum, avg and count. Investigate ways to create sophisticated crosstab (matrix) reports with single or multi-dimension. Learn how to modify data in the database with insert, update and delete statements. Work with the MERGE statement which does a combination of insert, update and delete in a single statement. Understand data integrity checks: entity, domain and referential integrity enforcement. Learn about business rules enforcement in the enterprise. Explore stored procedure, user-defined function, view and trigger design. Create structure SQL queries with Common Table Expressions (CTEs). Work with T-SQL transactions, locks, isolation levels and deadlocks. Master debugging T-SQL scripts, stored procedures, triggers and functions (UDFs). Explore query optimization using the Database Engine Tuning Advisor and the visual query execution plan tool. (See full list below)

About the Industry Expert Trainer
Kalman Toth, MCDBA/MCITP, is a designer of over 60 databases worldwide with 17 years of database/BI administration and development experience on SQL server 4.2, 6.5, 7.0, SQL Server 2000/2005/2008/2012 and Sybase. His clients include: Citibank, Bank of Sweden, Deloitte-Touche, Swiss Bank, Lehman Brothers, Salomon Brothers, Merrill Lynch, Reuters, IBM and major ecommerce website companies. He holds an M.Phil. degrees in Physics and Computing Science from Columbia University, where he taught Computer Science courses.

Bonus Book: SQL Programming & Database Design Using Microsoft SQL Server 2012
Microsoft SQL Server 2012 changes how you develop applications for SQL Server. With this comprehensive resource, in an 820 pages book, SQL Server authority Kalman Toth presents the fundamentals of database design and SQL concepts, and then shows you how to apply these concepts using the latest version of SQL Server. SQL Programming & Database Design Using Microsoft SQL Server 2012 begins with a quick overview of SELECT query basics, SQL Server 2012 installation & Management Studio overview and then quickly proceeds to show you how to implement database design & programming concepts of Microsoft SQL Server 2012. You'll explore the new programming features, including conditional action constructs, enhanced controls for results paging, application integration with Excel, and development of BI applications. •Covers new filetable design for binary objects deployment, brief introduction to SQL Azure for cloud computing, and data warehouse performance improvements •Addresses essential topics including managing index & JOIN keys, writing scripts, and working with store procedures •Shares helpful techniques for creating and changing tables, programming with XML, using the SSIS Import/Export Wizard and brief overview of SSAS & SSRS.

What you’ll learn: Install and manage SQL Server & client tools on your system. Create and modify tables. Store, modify and query data; use indexes & other techniques to improve query performance. Run procedural code inside your database in the form of Transact–SQL stored procedures and triggers. Design views, indexed views and user-defined functions.

7 DAYs Videos Equivalent to 3 Years of Job Experience
SMI's video-based SQL Server 2012 training is like training one-on-one with an international SQL/BI industry expert -- full motion screen video allows you to see the steps, hear the explanations, and perform the critical tasks. This is complete training solution for passing related certification exams, excelling on an interview and performing well in the workplace. It is convenient, giving you the freedom to learn at your own pace, wherever and whenever it suits your schedule. Videos are easy to use, with streamlined interface featuring one-click navigation. 100% guaranteed.

Multimedia Microsoft SQL Server 2012 Programming training in 7 Days full-motion screen image video and rich audio memory stick $695.


Practical SQL Server 2012
Programming in 7 Days

DAY 1 - SAMPLE DATABASES (2 hours 47 minutes)
1. Installing SQL Server Sample Databases
2. Conceptual Diagram of AdventureWorks Entity Model
3. Visio Diagram of AdventureWorks OLTP Database
4. Primary Key and Foreign Key; RDBMS Basics
5. 1NF, 2NF & 3NF Normal Forms in AdventureWorks
6. AdventureWorks2012; Bike Manufacturer Database
7. AW Business Scenarios & AW Data Dictionary
8. Advance Review of AdventureWorks2012
9. AdventureWorksDW2012 Data Warehouse Database
10. HierarchyID Based Trees in AdventureWorks2012
11. Creating, Saving & Emailing Database Diagrams
12. pubs Book Publishing Sample Database Overview
13. Northwind Food & Drink Supplier Sample DB
14. Advanced Review of pubs Database
15. Advanced Review of Northwind Database
16. Accounting DB Review; GL, AP, AR & Inventory

DAY 2 - DATABASE DESIGN (2 hours 54 minutes)
1. Understanding Logical Data Modelling
2. Working with Table Column Data Types
3. DATE, DATETIME & Other Temporal Data Types
4. CREATE TABLE by Script & by GUI Interface
5. Primary Key and Foreign Key Constraints
6. Database Diagram Design in SSMS Object Explorer
7. Logical Database Modelling with Visio
8. Relational Database Design with Visio
9. Reverse Engineering a Database with Visio
10. Script Existing Tables; Sequence Objects
11. Designing FileTable, Compressed Table & Index
12. Partitioned Table, Partition Function and Scheme
13. Create Partition & Manage Partition Wizards
14. Manage Data in Sliding Window Scenario
15. Columnstore Index; Lookup Table Design
16. Database Design & Programming Standards

DAY 3 - SELECT STATEMENT (3 hours 1 minute)
1. New Programming Features in SQL Server 2012
2. INNER JOIN, Self Join, Outer Join and Cross Join
3. Basic SQL SELECT and SELECT INTO Statements
4. Sorting SELECT Query Results with ORDER BY
5. Exploring CTEs, Nested & Correlated Subqueries
7. Date & Time, String and Math System Functions
8. Configuration & System Statistical Functions
9. Dynamic SQL Query Building & Execution
10. The GROUP BY Clause & Aggregate Functions
11. Working with Hierarchy ID & Metadata Functions
12. OVER Clause; Ranking, Aggregate & Analytic Fns
13. Review of Recursive Queries & Tree Processing
14. TOP; Split Comma Delimited String with XML
15. Crosstab Queries Using PIVOT & CASE
16. Date Conversion to String & Vice Versa

DAY 4 - MODIFY DATA (3 hours 2 minutes)
1. INSERT INTO Statement with VALUES Clause
2. Using INSERT with SELECT Subquery
4. Data Removal with DELETE & TRUNCATE
5. Data Modification with UPDATE & MERGE
7. Synchronizing Two Tables with MERGE
8. Modifying Data with Cursors, Subqueries & JOINs
9. Logged and Minimally-Logged Operations
10. Creating Audit Trail with the OUTPUT Clause
11. Combining INSERT with CTE and OUTPUT
13. Deleting Duplicate Rows with CTE
14. Updating Binary Mask and CSV List Columns
15. Using UPDATE with the FROM Clause
16. UPDATE with GROUP BY Aggregate Subquery

DAY 5 - DATA INTEGRITY (3 hours)
1. Data Integrity Constraints in AdventureWorks2012
2. Surrogate Key Architecture, Natural Key & GUID
3. PK, FK, UNIQUE & CHECK Constraints; Defaults
4. Data Integrity Enforcement with Triggers
5. Integrity Templates; PK, FK, UQ, UIX & CHECK
6. Stored Procedure vs. Ad-hoc SQL Script
7. Entity, Domain and Referential Database Integrity
8. Entity Integrity Definition Using SSMS
9. Listing and Scripting Data Integrity Objects
10. Understanding Domain Integrity Enforcement
11. Implementing Referential Integrity Constraints
12. Creating User Defined Integrity Objects
13. Table-Level & UDF CHECK Constraints
14. Enterprise-Level Business Rules Enforcement
15. Transactions for Data Integrity Maintenance
16. Comparing and Synchronizing Databases

DAY 6 - PROGRAMMABILITY (3 hours 4 minutes)
1. Stored Procedure Design and Programming
2. Exploring Table-Valued, XML & OUTPUT Parameters
3. Stored Procedures in AdventureWorks2012 Database
4. DML - Data Manipulation Language Triggers
5. Trigger Examples with DELETED & INSERTED Tables
6. Discovering INSTEAD OF Triggers & AFTER Triggers
7. DDL - Data Definition Language Triggers
8. Designing & Creating Views - Modifying Data
9. Table-Valued, Scalar-Valued & Inline Functions
10. Understanding Plan Guides for Top Performance
11. Temporary Tables, Table Variables & tempdb
12. EXECUTE AS for Execution Context Definition
13. Multiple, Nested, Recursive & VIEW CTE-s
14. Grouping Sets for Multiple Groupings Definition
15. Spatial Data Types; Geography & Geometry
16. Debugging Stored Procedures Manually

DAY 7 - TRANSACT-SQL (3 hours 1 minutes)
1. TRANSACT-SQL, Batch, and Scripts
3. Using TRY…CATCH Blocks for Exception Handling
4. Locks, Isolation Levels and Deadlocks
5. Snapshot Isolation for OLTP Concurrency
6. Programming Statements in Transact-SQL
7. User Defined & System Stored Procedures
8. Working with Linked Servers & 4-part Reference
9. Exploring CROSS APPLY & OUTER APPLY Operators
10. DBA Script Generation & Dynamic SQL
11. Discovering Undocumented T-SQL Features
12. Dynamic PIVOT - Matrix - Crosstab Scripts
13. INTERSECT and EXCEPT Set Operators
14. FILESTREAM Data & SPARSE Columns
15. Optimizing with Database Engine Tuning Advisor
16. Debugging with the Transact-SQL Debugger

DAY 1 T-SQL Scripts
DAY 2 T-SQL Scripts
DAY 3 T-SQL Scripts
DAY 4 T-SQL Scripts
DAY 5 T-SQL Scripts
DAY 6 T-SQL Scripts
DAY 7 T-SQL Scripts


Availability: the product usually ships on the next business day.
Shipping World Wide via UPS Air 3-5 Business Days.


The future is just a click away! Your future!

  Copyright 2012, SMI Corp. All Rights Reserved.  
  Microsoft is a trademark of Microsoft Corporation.
SQL Server 2012 is a program product of Microsoft Corporation.