Trang Chính
Latest images
Tìm kiếm
Đăng ký
Đăng Nhập
Liên hệ
Blast.Through.Learning.SQL.Server.2005.Complete
Trang 1 trong tổng số 1 trang
Blast.Through.Learning.SQL.Server.2005.Complete
by Admin Sun 22 Aug 2010, 9:44 am
Blast.Through.Learning.SQL.Server.2005.Complete-HELL
DATE: 28 Apr 2010
TYPE: 3d TUT
DISKS: 1 DVD
RELEASE INFO:
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
Course Includes:
* 8 CD's-Main Topics
* 4 CD's-Special Topics
* 5-user License
SQL Server 2005 Phase I
1.0 Introduction to SQL Server
1.1 Basic Relational Database Design
1.2 SQL Server Basics
1.3 Getting to Know the SQL Server Management Studio
1.4 Creating SQL Server Databases
SQL Server 2005 Phase II
1.0 SQL Server Tables
1.1 Introduction to Basic Relational Database Design
1.2 Primary Key Constraints
1.3 Identity Columns
1.4 Computed Columns
1.5 User-Defined Data Type
1.6 Using Indexes
2.0 Working with Relationships
2.1 SQL Server Basics
2.2 Viewing Foreign Key Relationships
2.3 Tables and Columns
2.4 Relationship Name and Description
2.5 Establishing Referential Integrity
2.6 Deleting and Updating Rules
3.0 Getting to Know the SELECT Statement
3.1 Introduction to T-SQL
3.2 SELECT Statement
3.3 The FROM Clause
3.4 The WHERE Clause
3.5 The ORDER BY Clause
3.6 The DISTINCT Keyword
3.7 The FOR XML Clause
3.8 The TOP Clause
4.0 Building SQL Statements Based on Multiple Tables
4.1 Exploring Join Types
4.2 How the GROUP BY Clause Works
4.3 Using Aggregate Functions
4.4 The HAVING Clause
4.5 The UNION Queries
4.6 Working With Subqueries
SQL Server 2005 Phase III
1.0 Modifying Data with Action Queries
1.1 The Five Types of Action Queries
2.0 Getting to Know the T-SQL Functions
2.1 The T-SQL Language
2.2 String Functions
2.3 Date and Time Functions
2.4 Working with NULLS
3.0 Working with SQL Server Views
3.1 Working with Views
3.2 Creating Views Using SQL Server Management Studio
3.3 Using T-SQL to Create a View
4.0 More About Views
4.1 Creating Views Based on Data from Multiple Tables
4.2 Working with Subquery of a View
4.3 Working with Outer Joins
4.4 The Top Syntax
4.5 Sorting Results of a View
4.6 User-Defined Functions
4.7 Security Benefit of a View
4.8 Updateability of View Results
4.9 Modifying a View
4.10 Renaming a View
4.11 Deleting a SQL Server View
4.12 Indexed Views
4.13 How to Design Your Indexes Efficiently
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
SQL Server 2005 Phase V
1.0 The Basics of ADO.NET
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
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
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
DATE: 28 Apr 2010
TYPE: 3d TUT
DISKS: 1 DVD
RELEASE INFO:
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
Course Includes:
* 8 CD's-Main Topics
* 4 CD's-Special Topics
* 5-user License
SQL Server 2005 Phase I
1.0 Introduction to SQL Server
1.1 Basic Relational Database Design
1.2 SQL Server Basics
1.3 Getting to Know the SQL Server Management Studio
1.4 Creating SQL Server Databases
SQL Server 2005 Phase II
1.0 SQL Server Tables
1.1 Introduction to Basic Relational Database Design
1.2 Primary Key Constraints
1.3 Identity Columns
1.4 Computed Columns
1.5 User-Defined Data Type
1.6 Using Indexes
2.0 Working with Relationships
2.1 SQL Server Basics
2.2 Viewing Foreign Key Relationships
2.3 Tables and Columns
2.4 Relationship Name and Description
2.5 Establishing Referential Integrity
2.6 Deleting and Updating Rules
3.0 Getting to Know the SELECT Statement
3.1 Introduction to T-SQL
3.2 SELECT Statement
3.3 The FROM Clause
3.4 The WHERE Clause
3.5 The ORDER BY Clause
3.6 The DISTINCT Keyword
3.7 The FOR XML Clause
3.8 The TOP Clause
4.0 Building SQL Statements Based on Multiple Tables
4.1 Exploring Join Types
4.2 How the GROUP BY Clause Works
4.3 Using Aggregate Functions
4.4 The HAVING Clause
4.5 The UNION Queries
4.6 Working With Subqueries
SQL Server 2005 Phase III
1.0 Modifying Data with Action Queries
1.1 The Five Types of Action Queries
2.0 Getting to Know the T-SQL Functions
2.1 The T-SQL Language
2.2 String Functions
2.3 Date and Time Functions
2.4 Working with NULLS
3.0 Working with SQL Server Views
3.1 Working with Views
3.2 Creating Views Using SQL Server Management Studio
3.3 Using T-SQL to Create a View
4.0 More About Views
4.1 Creating Views Based on Data from Multiple Tables
4.2 Working with Subquery of a View
4.3 Working with Outer Joins
4.4 The Top Syntax
4.5 Sorting Results of a View
4.6 User-Defined Functions
4.7 Security Benefit of a View
4.8 Updateability of View Results
4.9 Modifying a View
4.10 Renaming a View
4.11 Deleting a SQL Server View
4.12 Indexed Views
4.13 How to Design Your Indexes Efficiently
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
SQL Server 2005 Phase V
1.0 The Basics of ADO.NET
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
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
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
- Code:
http://rapidshare.com/files/383916478/Blast_Through_Learning_SQL_Server_2005_Complete.part01.rar
http://rapidshare.com/files/383916513/Blast_Through_Learning_SQL_Server_2005_Complete.part02.rar
http://rapidshare.com/files/383916462/Blast_Through_Learning_SQL_Server_2005_Complete.part03.rar
http://rapidshare.com/files/383916730/Blast_Through_Learning_SQL_Server_2005_Complete.part04.rar
http://rapidshare.com/files/383916363/Blast_Through_Learning_SQL_Server_2005_Complete.part05.rar
http://rapidshare.com/files/383916527/Blast_Through_Learning_SQL_Server_2005_Complete.part06.rar
http://rapidshare.com/files/383916505/Blast_Through_Learning_SQL_Server_2005_Complete.part07.rar
http://rapidshare.com/files/383916532/Blast_Through_Learning_SQL_Server_2005_Complete.part08.rar
http://rapidshare.com/files/383918531/Blast_Through_Learning_SQL_Server_2005_Complete.part09.rar
http://rapidshare.com/files/383918594/Blast_Through_Learning_SQL_Server_2005_Complete.part10.rar
http://rapidshare.com/files/383918451/Blast_Through_Learning_SQL_Server_2005_Complete.part11.rar
http://rapidshare.com/files/383918586/Blast_Through_Learning_SQL_Server_2005_Complete.part12.rar
http://rapidshare.com/files/383918587/Blast_Through_Learning_SQL_Server_2005_Complete.part13.rar
http://rapidshare.com/files/383918632/Blast_Through_Learning_SQL_Server_2005_Complete.part14.rar
http://rapidshare.com/files/383918575/Blast_Through_Learning_SQL_Server_2005_Complete.part15.rar
http://rapidshare.com/files/383918675/Blast_Through_Learning_SQL_Server_2005_Complete.part16.rar
http://rapidshare.com/files/383920405/Blast_Through_Learning_SQL_Server_2005_Complete.part17.rar
http://rapidshare.com/files/383920642/Blast_Through_Learning_SQL_Server_2005_Complete.part18.rar
http://rapidshare.com/files/383920799/Blast_Through_Learning_SQL_Server_2005_Complete.part19.rar
http://rapidshare.com/files/383920764/Blast_Through_Learning_SQL_Server_2005_Complete.part20.rar
http://rapidshare.com/files/383920546/Blast_Through_Learning_SQL_Server_2005_Complete.part21.rar
http://rapidshare.com/files/383920774/Blast_Through_Learning_SQL_Server_2005_Complete.part22.rar
http://rapidshare.com/files/383920636/Blast_Through_Learning_SQL_Server_2005_Complete.part23.rar
http://rapidshare.com/files/383920649/Blast_Through_Learning_SQL_Server_2005_Complete.part24.rar
http://rapidshare.com/files/383922394/Blast_Through_Learning_SQL_Server_2005_Complete.part25.rar
http://rapidshare.com/files/383922676/Blast_Through_Learning_SQL_Server_2005_Complete.part26.rar
http://rapidshare.com/files/383922695/Blast_Through_Learning_SQL_Server_2005_Complete.part27.rar
http://rapidshare.com/files/383922701/Blast_Through_Learning_SQL_Server_2005_Complete.part28.rar
http://rapidshare.com/files/383922673/Blast_Through_Learning_SQL_Server_2005_Complete.part29.rar
http://rapidshare.com/files/383922827/Blast_Through_Learning_SQL_Server_2005_Complete.part30.rar
http://rapidshare.com/files/383922738/Blast_Through_Learning_SQL_Server_2005_Complete.part31.rar
http://rapidshare.com/files/383922893/Blast_Through_Learning_SQL_Server_2005_Complete.part32.rar
http://rapidshare.com/files/383922755/Blast_Through_Learning_SQL_Server_2005_Complete.part33.rar
Admin- Admin
- Đánh giá tốt! : 7
Tổng số bài gửi : 10417
Birthday : 09/10/1979
Tuổi : 44
Địa chỉ: : Phú Yên
Điện thoại: : Mobile: (84) 0985 017 089
Điểm : 61290
Ngày đăng ký : 13/10/2007 -
Similar topics» How to install SQL SERVER 2005
» BlastThroughLearning.com: SQL Server 2005 Phase I
» AppDev - Microsoft SQL Server 2005
» BlastThroughLearning.com: SQL Server 2005 Phase I
» AppDev - Microsoft SQL Server 2005
Trang 1 trong tổng số 1 trang
Permissions in this forum:
Bạn không có quyền trả lời bài viết
» Hộp đựng đa năng trong phòng tắm và các đồ dụng tiện llợi khác
» gel bôi trơn ấm áp warm lovin
» màng film tránh thai vcf dành cho chị em
» màng film tránh thai vcf dành cho chị em
» stud 100 khẳng định đẳng cấp phái mạnh
» Lover aider máy mát xa dành cho nữ
» cung cấp máy ép dĩa chất lượng
» Máy in hình lên ly
» Máy in hình lên áo
» trang trí cây thông noel ở vinh,cho thuê cây thông noel ở vinh,chuyển quà noel ở vinh
» Máy in hạn sử dụng DMJ-B chính hãng, giá sốc
» Dạy cắm hoa chuyên nghiệp,dạy cắm hoa nghệ thuật,dạy cắt tỉa của quả ở T.p Vinh Nghệ An
» công ty Yên Phát chuyên phân phối, lắp đặt camera chính hãng giá rẻ nhất miền Bắc.
» HOT! Chung cư mini Xuân Đỉnh ở ngay giá chỉ từ 690 triệu 1 căn