BlastThroughLearning.com: SQL Server 2005 Phase VI
SQL Server 2005 Phase VI
1.0 Using VB.NET to Design SQL Stored Procedures
1.1 Stored Procedure Written in VB.NET
1.2 Variables in Stored Procedures
1.3 Determining the Logic Flow Within a Stored Procedure
1.4 Input and Output Parameters
1.5 Insert, Update, and Delte Data
2.0 VB.NET Special Topics
2.1 Using Temporary Tables
2.2 Error Handling in a VB.NET Stored PRocedure
2.3 Using Transactions
1.0 Using C# to Work With Stored Procedures
1.1 Using C# to Desing SQL Server Stored Procedures
1.2 C# Special Topics
1.3 Debugging Stored Procedures
BlastThroughLearning.com: SQL Server 2005 Complete
Renowned professionals Alison Balter, Bruce Jones, and Alan Sugano deliver power-packed instruction in this hot new learning set. You’ll learn the intricacies of database design implementation, tables, views, stored procedures and advanced topics like database mirroring, hardware sizing, visibility, and server mirroring.
Approximately 10 hours of in-depth training, this course teaches over 112 SQL programming topics, including:
* Stored Procedures
* T-SQL Functions
* ADO.NET
* Server Mirroring
BlastThroughLearning.com: SQL Server 2005 Phase VIII
SQL Server 2005 Phase VIII
1.0 SQL Server Authentication
1.1 SQL Server Security
1.2 SQL Server Authentication
1.3 Creating SQL Server Logins
1.4 Roles and Permissions
1.5 Understanding Ownership
2.0 SQL Server Permissions Validation
2.1 Types of Permissions
2.2 Using Rights for a Table
2.3 Permissions for a View
2.4 Column-Level Permissions
3.0 The Basics of Configuring & Maintaining SQL
3.1 SQL Server Hardware
3.2 Configuring SQL
3.3 Database Maintenance
4.0 Performance Monitoring
4.1 Executing a Query
4.2 Analyzing a Query
4.3 Using the Execution Plan and Client Statistics Tabs
4.4 Using Options to Queries Process
SPECIAL TOPICS Database Mirroring – Led by Alan Sugano
1.0 Database Mirroring
1.1 SQL Server Witness
1.2 Database Mirroring Steps
1.3 Database Mirror Wizard and Failover Test
SPECIAL TOPICS Hardware Sizing – Led by Alan Sugano
1.0 SQL 2005 Hardware Sizing
1.1 Hardware Sizing
SPECIAL TOPICS High Visibility – Led by Alan Sugano
1.0 SQL 2005 High Visibility
1.1 SQL Server 2005 High Availability
1.2 Log Shipping
1.3 Database Mirroring and Clustering
1.4 SAN Types, Active/Passive and Active/Active Clustering
1.5 Online Restore and Indexing
1.6 Fast Recovery, Snapshot and Mirroring
SPECIAL TOPICS Database Mirroring – Led by Alan Sugano
1.0 Neverfail Server Mirroring
1.1 Neverfail Modules, Ordering and Installation Summary
1.2 Neverfail Scope and Obtaining Neverfail License Keys
1.3 Neverfail Prerquisites and Anti-Virus Software
1.4 Neverfail Installation on the Primary Server
1.5 Neverfail Installation on the Secondary Server
1.6 Switchover and Switchback
BlastThroughLearning.com: SQL Server 2005 Phase VII SQL Server 2005 Phase VII
1.0 Using C# to Work With Stored Procedures
1.1 Using C# to Desing SQL Server Stored Procedures
1.2 C# Special Topics
1.3 Debugging Stored Procedures
BlastThroughLearning.com: SQL Server 2005 Phase IV SQL Server 2005 Phase IV
1.0 Using T-SQL to Design SQL Stored Procedures
1.1 Intro to Creating Stored Procedures in SQL Server
1.2 Using Declare
1.3 Using Constructs
2.0 Import Stored Procedure Techniques
2.1 The SET NOCOUNT ON Statement
2.2 The @@ Functions
2.3 Input and Output Parameters
2.4 Using Stored Procedures to Insert, Update, and Delete Data
2.5 Handling Errors in Stored Procedures
2.6 Using Transaction Statements
3.0 Stored Procedure Special Topics
3.1 Creating and Using a Temporary Table
3.2 Stored Procedures and Security
3.3 User-Defined Functions
3.4 Using Triggers
http://hotfile.com/dl/53034213/86bac03/Phase6.part1.rar.html
http://hotfile.com/dl/53034494/b0c5594/Phase6.part2.rar.html
http://hotfile.com/dl/53034596/e855938/Phase6.part3.rar.html
http://hotfile.com/dl/53034814/ccea6ec/Phase6.part4.rar.html
http://hotfile.com/dl/52870030/bc40525/Blast.Through.Learning.SQL.Server.2005.part1.rar.html
http://hotfile.com/dl/52870033/5b1de7d/Blast.Through.Learning.SQL.Server.2005.part2.rar.html
http://hotfile.com/dl/52870710/3c77327/Blast.Through.Learning.SQL.Server.2005.part3.rar.html
http://hotfile.com/dl/52870727/99cc7b4/Blast.Through.Learning.SQL.Server.2005.part4.rar.html
http://hotfile.com/dl/52871323/4662cc4/Blast.Through.Learning.SQL.Server.2005.part5.rar.html
http://hotfile.com/dl/52871339/dcbdc87/Blast.Through.Learning.SQL.Server.2005.part6.rar.html
http://hotfile.com/dl/53035574/902427b/Phase8.part1.rar.html
http://hotfile.com/dl/53036018/fefad73/Phase8.part2.rar.html
http://hotfile.com/dl/53036258/9d35480/Phase8.part3.rar.html
http://hotfile.com/dl/53036470/ba6781a/Phase8.part4.rar.html
http://hotfile.com/dl/53034928/f62522d/Phase7.part1.rar.html
http://hotfile.com/dl/53034995/6be588b/Phase7.part2.rar.html
http://hotfile.com/dl/53035504/203780d/Phase7.part3.rar.html
http://hotfile.com/dl/53032879/27d7ef9/Phase4.part1.rar.html
http://hotfile.com/dl/53032880/24616ea/Phase4.part2.rar.html
http://hotfile.com/dl/53033413/8182dd3/Phase4.part3.rar.html
http://hotfile.com/dl/53033420/c79f451/Phase4.part4.rar.html
http://hotfile.com/dl/53033809/230fc2f/Phase4.part5.rar.html
http://hotfile.com/dl/53033814/25bf46d/Phase4.part6.rar.html