Career Vision Training
 

courses / products

IT CERTIFICATION
A+ with Free Network+
Exchange Server 2010 MCITP
MCPD: ASP.NET 3.5 Bundle
MCSE 2003 with MCITP 2008
VMware Bootcamp vSphere 4.1

View Complete List...

SECURITY & NETWORKING
EC Council - CEH v7.1
EC Council - CHFI v4
Cisco CCNA (640-802)
Cisco CCNP Bundle
CISSP Training Suite

View Complete List...

DESKTOP & OFFICE
Acrobat X Pro Essentials
ECDL Syllabus 5.0
Excel 2010 Training
Office 2010 Training Bundle
Office 2007 Training Bundle

View Complete List...

CAD & 3D
AutoCAD 2012 Training
AutoCAD Architecture 2012 Training
AutoCAD Map 3D 2012
Inventor 2011
Revit Structure 2012

View Complete List...

DATABASES
MCITP Dbase Admin SQL 2008
MCITP Dbase Dev SQL 2008
MCITP BI Dev SQL 2008
Oracle 11g OCA
FileMaker Server 11

View Complete List...

PROJECT MANAGEMENT
Project 2010 Training
Project 2007
PRINCE2 Foundation CBT
Managing Project Teams
ITIL v3 Foundation

View Complete List...

GRAPHICS & LAYOUT
CS5: Master Bundle
InDesign CS5: Essentials
Photoshop CS5 Advanced
Photoshop Elements 9
Total Training Online Courses

View Complete List...

WEB DESIGN & INTERNET
CS5 Web Essentials Bundle
Dreamweaver CS5: Essentials
Facebook App Development
Flash CS5 Essentials
WordPress 3.0 Essentials

View Complete List...

MULTIMEDIA & ANIMATION
After Effects CS5 Essentials
Cinema 4D R11.5 Essentials
CS5 Production Bundle
Pro Tools 9 Essentials
Premiere Pro CS5 Essentials

View Complete List...

SOFT SKILLS TRAINING
Excellence in Supervision
How to Get Things Done
Team Leadership
Assertiveness
Communication Series

View Complete List...

PROGRAMMING
ASP.Net 3.5 Training Bundle
Delphi 6
Java 6
Oracle Certified Java Associate (CX-310-019)
Visual Studio 2010

View Complete List...

OPERATING SYSTEMS
Mac OSX 10.6 Snow Leopard
MCTS: Windows 7 Configuration
Windows 7
Windows Vista for End Users

View Complete List...

COURSES BY EXAM NUMBER
A+ Essentials 2009 Training

View Complete List...
SUBSCRIBE
Subscribe to Receive Special Offers & New Release Updates
100% Satisfaction Guaranteed

CareerVision is committed to providing our customers with the best service and products available.

We back our training products with a 100% Satisfaction or Your Money Back Guarantee, so you can buy worry free. More....



FAST UK DELIVERY
Order Today, Learn Tomorrow!

Pay as You Learn

SECURE PAYMENT
PROCESSING

We Accept All Major Credit Cards, PayPal and Google Checkout

Credit Cards Accepted
PayPal Accepted



Follow us on Facebook
* A-Z COURSE LIST * WHAT'S NEW * FREE DEMOS * SPECIAL OFFERS * ONLINE TRAINING *

SQL Server 2005 Development

 
Bookmark and Share
SQL Server 2005 Development Training DVD-ROMs
Save 20% on Total Training
All Access Online Subscriptions
12 Months - Only £127
6 Months - Only £79
SQL Server 2005 Development
Set of 2 DVDs £66.00 + VAT
Buy Now
 


PACKAGE INCLUDES

 •  Format - DVD-ROM
 •  Duration - 8 Hours of Beginner to Advanced Training
 •  Author - Paul Nielsen
 •  Platform - Windows
 •  Project Files - Included

 

COURSE INTRODUCTION

Total Training for Microsoft SQL Server Development takes you inside the latest, coolest, and most powerful database software platform, Microsoft's SQL Server 2005. The tutorials focus on key elements in a logical sequence. You can easily find what you need-including all the SQL Server 2005 basics, best practices, dozens of targeted examples, and sample code. If you design or develop SQL Server 2005 databases, this video series is what you need to succeed!


Highlights

 •  Master the fundamentals of SQL Server technology.
 •  Learn how to write better queries to return the exact data required.
 •  Avoid slow iterative code by refactoring cursors into queries using user-defined
        functions and case expressions.
 •  Develop stored procedures using T-SQL.
 •  Understand how transactions affect performance, how to detect blocking
        transactions, and how to minimize the impact of locking and blocking.
 •  Create triggers to build custom audit trails and enforce database rules.

Introducing Total Training Online


 

COURSE OUTLINE

PART 1: Introduction to SQL Server 2005

Lesson 1: SQL SERVER OVERVIEW (32 min)
1. Understanding Client Server Architecture
2. Introducing the Tools
3. Selecting an Addition
4. Creating Sample Databases

Lesson 2: USING MANAGEMENT STUDIO (23 min)
1. Arranging the Workspace
2. Registering Servers
3. Explaining Items in the Object Explorer
4. Explaining the Database Properties Dialog
5. Explaining the Columns Properties Dialog
6. Continuing with Object Explorer Items
7. Using the Query Editor

Lesson 3: DESIGNING RELATIONAL DATABASES (35 min)
1. Understanding Normalization
2. Discovering Patterns
3. Avoiding Over Complexity
4. Managing Optional Data
5. Creating Physical Keys
6. Using the Database Diagrammer Tool
7. Final Comments

Part 2: Selecting Data

Lesson 1: WORKING WITH SINGLE TABLE QUERIES (42 min)
1. Understanding Query Flow
2. Filtering Data with the Where Clause
3. Columns, Expressions & Scalar Functions
4. Using Case Expressions
5. Working with Nulls & Coalesce
6. Selecting Environment Functions
7. Working with Dates & Times
8. Parsing Strings
9. Converting Data
10. Sorting Data
11. Topping Off the Query with Predicates

Lesson 2: MERGING DATA WITH JOINS & UNIONS (25 min)
1. Working with Inner Joins
2. Using Left Outer Joins
3. Multiplying Data with Cross Joins
4. Referencing Self-Joins
5. Working with Complex Joins
6. Finding the Set Difference
7. Stacking Data with Unions

Lesson 3: WORKING WITH SUBQUERIES (19 min)
1. Using Subqueries as Expressions
2. Including Subqueries as Lists
3. Adding Subqueries as Derived Tables
4. Working with Correlated Subqueries
5. Solving for X with Relations Division

Lesson 4: AGGREGATING DATA (35 min)
1. Using the New Windowing Functions
2. Using Aggregate Functions
3. Grouping a Data Set
4. Nesting Aggregations
5. Filtering Groups & Adding Grand Totals
6. Generating Cross Tab Tables (Pivot)
7. Calculating Cumulative Sums

Lesson 5: USING FULL-TEXT SEARCH (14 min)
1. Creating a Full-Text Index
2. Searching for Words
3. Using a Fuzzy Search to Search for Phrases

Lesson 6: SELECTING DATA THROUGH VIEWS (11 min)
1. Creating Views
2. Preventing Disappearing Rows
3. Protecting from Schema Changes
4. Nesting Views

Lesson 7: DISTRIBUTED QUERIES (18 min)
1. Linking to External Data Sources
2. Executing Distributed Queries
3. Looking at Where the Work Takes Place
4. Using Pass Through Queries
5. Controlling Distributed Transactions

Lesson 8: MODIFYING DATA (29 min)
1. Inserting Data
2. Updating Data
3. Deleting Data
4. Using the Output Clause
5. Final Comments & Credits

PART 3: Developing Solutions

Lesson 1: T-SQL & STORED PROCEDURES (68 min)
1. Introducing T-SQL
2. Working with Variables
3. Controlling Procedural Flow
4. Examining SQL Server with Code
5. Using Temp Tables
6. Developing Dynamic SQL
7. Introducing Stored Procedures
8. Passing Parameters
9. Returning Parameters
10. Working with a Cursor
11. Handling Errors
12. Explaining the Raise Error
13. Controlling Transactions

Lesson 2: TRIGGERS & AUDIT TRAILS (31 min)
1. Introducing After Triggers
2. Using "Instead of" Trigger
3. Disabling Triggers
4. Using the Update ( ) Function
5. Selecting Transaction Data
6. Nesting & Recursion
7. Enforcing Complex RI
8. Auditing Data Changes

Lesson 3: USER-DEFINED FUNCTIONS (27 min)
1. Creating Scalar Functions
2. Working with Inline Table-Valued Functions
3. Using Multi-Statement Table-Valued UDFs
4. Navigating a Hierarchy
5. Having Fun with Apply
6. Exploring Functions in Nordic

Lesson 4: INDEXING FOR PERFORMANCE (31 min)
1. Introducing Indexes
2. Creating Indexes
3. Examinging Query Execution Plans, Pt. 1
4. Examinging Query Execution Plans, Pt. 2

Lesson 5: TRANSACTIONS, LOCKING & BLOCKING (33 min)
1. Introducing ACID
2. Understanding Transactional Faults
3. Stepping through a Transaction
4. Exploring Locks
5. Working with Locks
6. Viewing Deadlocks
7. Using Snapshot Isolation

Lesson 6: INTRODUCTION TO OPTIMIZATION THEORY (21 min)
1. Deconstructing the Database System
2. Walking through Optimization Theory
3. Optimization Theory Continued
4. Final Comments & Credits
 
 
Print Image Printer friendly version   
Top of page
A-Z COURSE LIST   PROVIDERS   CBT TRAINING  CVISION NEWS  CONTACT US   SITEMAP  

MCITP Training Courses  MCPD Training Courses  MCTS Training Courses
MCITP Database Developer Training Courses  MCITP Database Administrator Training Courses
Flash Tutorials & Training Courses  MCSE CBT Training Adobe Photoshop Tutorials & CBT Training Microsoft Certification Training

CareerVision
61 Caroline Street, Birmingham, B3 1UF, UK
Tel: 0121 248 2400, Fax: 0121248 2800,
Email: sales@cvision.co.uk |Web: www.cvision.co.uk
red arrow Website design by Aimpro UK red arrow Terms