Видеоуроки AppDev Microsoft SQL Server 2005(20 CD-ROMs)
Видеоуроки AppDev Microsoft SQL Server 2005(20 CD-ROMs)
Производитель: AppDev
Год выпуска: 2005
Язык: английский
Продолжительность: Курс содержит свыше 90 часов обучающего видео. 20 CD-ROMs
Видео кодек: Windows Media
Видео: Windows Media Video 9 800x600 15.00fps 401Kbps
Аудио: Windows Media Audio 44100Hz stereo 192Kbps
Содержание курса:
CD 1 A Tour of SQL Server 2005
SQL Server 2005 Editions, Components, and Tools
Using SQL Server Management Studio (SSMS)
Working with Tables and Queries
New Transact-SQL Features
Business Intelligence Services
CD 2 Installing SQL Server 2005
Preparing for Installation
Upgrading an Earlier Version
Installation Steps
Configuring the Server
CD 3 Designing and Creating a Database
Relational Database Design Principles
Implementing the Design
CD 4 Data Selection Queries
Understanding Transact-SQL
The SELECT Statement
The WHERE Clause
Using ORDER BY to Sort Data
The GROUP BY Clause
Joining Tables
CD 5 Modifying Data
Modifying Data
Inserting Data
Updating Data
Deleting Data
Understanding Transaction Isolation
CD 6 Working with SQL Server Management Studio
Getting Started with SSMS
Exploring the Object Explorer
Working with the Query Editor
Using SQL Server Books Online
CD 7 Transact-SQL Programming
Overview of Transact-SQL
Using Built-In Functions
Controlling Flow
Ranking Results
CD 8 Transactions and Error Handling
Transaction Concepts
Applications and Transactions
Creating Explicit Transactions
Using TRY/CATCH Error Handling
CD 9 Creating Views
What Is a View?
Creating Views
Updating Data Using a View
Using Computed Columns
Indexed Views
Partitioned Views
CD 10 Creating Stored Procedures and Triggers
Creating Stored Procedures
Creating Triggers
CD 11 Creating User-Defined Functions
User-Defined Function Overview
Scalar Functions
Inline Table-Valued Functions
Multi-Statement Table-Valued Functions
Using Functions, Views, and Stored Procedures
CD 12 Using .NET Code in SQL Server 2005
Writing SQLCLR Code
SQLCLR Code Modules
Managing Code Modules
SQLCLR Security
T-SQL vs. .NET Code
CD 13 Advanced Query Techniques
Full-Text Search
Generating XML with FOR XML
Using APPLY
Creating Recursive Queries
Creating Pivot Queries
Executing Dynamic SQL
CD 14 Understanding and Implementing Security
Security Overview
Authentication
Authorization
Permissions
Data Encryption
Security Epilog
CD 15 Analyzing and Tuning Performance
Evaluating Performance
Monitoring with SQL Server Profiler
Tuning Queries
Indexes and Partitions
Using the Database Engine Tuning Advisor
Understanding SQL Server Performance Problems
CD 16 Automating Administrative Tasks
SQL Server Agent
Maintenance Plans
SQL Management Objects (SMO)
CD 17 Programming Replication
Overview of SQL Server Replication
Replication Programming Interfaces
Configuring Replication
Synchronizing Data
CD 18 Using Integration Services
Importing and Exporting Data
Integration Services Tools
Building a Package
Troubleshooting a Package
CD 19 Analysis Services
Understanding Analysis Services
Creating a Unified Dimensional Model
Data Mining
CD 20 Introduction to Reporting Services
Understanding Reporting Services
Configuring Reporting Services
Building a Simple Report
Creating, Publishing, and Viewing Reports
Using and Managing Published Reports
Скачать AppDev Microsoft SQL Server 2005
Скачать
Скачать|Download part1 vip-file.com
Скачать|Download part2 vip-file.com
Скачать|Download part3 vip-file.com
Зеркало
Скачать|Download part1 sms4file.com
Скачать|Download part2 sms4file.com
Скачать|Download part3 sms4file.com
Зеркало
Скачать|Download part 1 letitbit.net
Скачать|Download part 2 letitbit.net
Скачать|Download part 3 letitbit.net
RapidShare.com
http://rapidshare.com/files/164185125/AppDev_Microsoft_SQL_Server.part01.rar
http://rapidshare.com/files/164185355/AppDev_Microsoft_SQL_Server.part02.rar
http://rapidshare.com/files/164194686/AppDev_Microsoft_SQL_Server.part03.rar
http://rapidshare.com/files/164194886/AppDev_Microsoft_SQL_Server.part04.rar
http://rapidshare.com/files/164195221/AppDev_Microsoft_SQL_Server.part05.rar
http://rapidshare.com/files/164195387/AppDev_Microsoft_SQL_Server.part06.rar
http://rapidshare.com/files/164195702/AppDev_Microsoft_SQL_Server.part07.rar
http://rapidshare.com/files/164195889/AppDev_Microsoft_SQL_Server.part08.rar
http://rapidshare.com/files/164196207/AppDev_Microsoft_SQL_Server.part09.rar
http://rapidshare.com/files/164196360/AppDev_Microsoft_SQL_Server.part10.rar
http://rapidshare.com/files/164196529/AppDev_Microsoft_SQL_Server.part11.rar
http://rapidshare.com/files/164196867/AppDev_Microsoft_SQL_Server.part12.rar
http://rapidshare.com/files/164197018/AppDev_Microsoft_SQL_Server.part13.rar
http://rapidshare.com/files/164197342/AppDev_Microsoft_SQL_Server.part14.rar
http://rapidshare.com/files/164197533/AppDev_Microsoft_SQL_Server.part15.rar
http://rapidshare.com/files/164197916/AppDev_Microsoft_SQL_Server.part16.rar
http://rapidshare.com/files/164198118/AppDev_Microsoft_SQL_Server.part17.rar
http://rapidshare.com/files/164198419/AppDev_Microsoft_SQL_Server.part18.rar
http://rapidshare.com/files/164198549/AppDev_Microsoft_SQL_Server.part19.rar
http://rapidshare.com/files/164198916/AppDev_Microsoft_SQL_Server.part20.rar
http://rapidshare.com/files/164199407/AppDev_Microsoft_SQL_Server.part21.rar
http://rapidshare.com/files/164199726/AppDev_Microsoft_SQL_Server.part22.rar
http://rapidshare.com/files/164200034/AppDev_Microsoft_SQL_Server.part23.rar
http://rapidshare.com/files/164200360/AppDev_Microsoft_SQL_Server.part24.rar
http://rapidshare.com/files/164200710/AppDev_Microsoft_SQL_Server.part25.rar
http://rapidshare.com/files/164200908/AppDev_Microsoft_SQL_Server.part26.rar
http://rapidshare.com/files/164201206/AppDev_Microsoft_SQL_Server.part27.rar
http://rapidshare.com/files/164201368/AppDev_Microsoft_SQL_Server.part28.rar
http://rapidshare.com/files/164201637/AppDev_Microsoft_SQL_Server.part29.rar
http://rapidshare.com/files/164201904/AppDev_Microsoft_SQL_Server.part30.rar
http://rapidshare.com/files/164202226/AppDev_Microsoft_SQL_Server.part31.rar
http://rapidshare.com/files/164202377/AppDev_Microsoft_SQL_Server.part32.rar
http://rapidshare.com/files/164202671/AppDev_Microsoft_SQL_Server.part33.rar
http://rapidshare.com/files/164203018/AppDev_Microsoft_SQL_Server.part34.rar
http://rapidshare.com/files/164203322/AppDev_Microsoft_SQL_Server.part35.rar
http://rapidshare.com/files/164203640/AppDev_Microsoft_SQL_Server.part36.rar
http://rapidshare.com/files/164203972/AppDev_Microsoft_SQL_Server.part37.rar
http://rapidshare.com/files/164204137/AppDev_Microsoft_SQL_Server.part38.rar
http://rapidshare.com/files/164204273/AppDev_Microsoft_SQL_Server.part39.rar
http://rapidshare.com/files/164204398/AppDev_Microsoft_SQL_Server.part40.rar
http://rapidshare.com/files/164204758/AppDev_Microsoft_SQL_Server.part41.rar
http://rapidshare.com/files/164204891/AppDev_Microsoft_SQL_Server.part42.rar
http://rapidshare.com/files/164205053/AppDev_Microsoft_SQL_Server.part43.rar
http://rapidshare.com/files/164205348/AppDev_Microsoft_SQL_Server.part44.rar
http://rapidshare.com/files/164205490/AppDev_Microsoft_SQL_Server.part45.rar
http://rapidshare.com/files/164205786/AppDev_Microsoft_SQL_Server.part46.rar
http://rapidshare.com/files/164206081/AppDev_Microsoft_SQL_Server.part47.rar
http://rapidshare.com/files/164206243/AppDev_Microsoft_SQL_Server.part48.rar
http://rapidshare.com/files/164206527/AppDev_Microsoft_SQL_Server.part49.rar
http://rapidshare.com/files/164206663/AppDev_Microsoft_SQL_Server.part50.rar
http://rapidshare.com/files/164206940/AppDev_Microsoft_SQL_Server.part51.rar
http://rapidshare.com/files/164207125/AppDev_Microsoft_SQL_Server.part52.rar
http://rapidshare.com/files/164207269/AppDev_Microsoft_SQL_Server.part53.rar
http://rapidshare.com/files/164207417/AppDev_Microsoft_SQL_Server.part54.rar
http://rapidshare.com/files/164207566/AppDev_Microsoft_SQL_Server.part55.rar
http://rapidshare.com/files/164207723/AppDev_Microsoft_SQL_Server.part56.rar
http://rapidshare.com/files/164207958/AppDev_Microsoft_SQL_Server.part57.rar
http://rapidshare.com/files/164208108/AppDev_Microsoft_SQL_Server.part58.rar
http://rapidshare.com/files/164208258/AppDev_Microsoft_SQL_Server.part59.rar
http://rapidshare.com/files/164208544/AppDev_Microsoft_SQL_Server.part60.rar
http://rapidshare.com/files/164208806/AppDev_Microsoft_SQL_Server.part61.rar
http://rapidshare.com/files/164209083/AppDev_Microsoft_SQL_Server.part62.rar
FILEFACTORY.COM
http://www.filefactory.com/file/9de906
http://www.filefactory.com/file/ad79a5
http://www.filefactory.com/file/347cca
http://www.filefactory.com/file/1e3748
http://www.filefactory.com/file/b511b8
http://www.filefactory.com/file/6dea6c
http://www.filefactory.com/file/6b9249
http://www.filefactory.com/file/3eeb70
http://www.filefactory.com/file/83ce69
http://www.filefactory.com/file/ac45c0
http://www.filefactory.com/file/20ecad
http://www.filefactory.com/file/d94b8b
http://www.filefactory.com/file/f289aa
http://www.filefactory.com/file/718176
http://www.filefactory.com/file/8013be
http://www.filefactory.com/file/64d55b
http://www.filefactory.com/file/be234e
http://www.filefactory.com/file/c1a67c
http://www.filefactory.com/file/094109
http://www.filefactory.com/file/c59ae1
http://www.filefactory.com/file/f5800e
http://www.filefactory.com/file/347ccf
http://www.filefactory.com/file/19bb11
http://www.filefactory.com/file/5bcd56
http://www.filefactory.com/file/f19f29
http://www.filefactory.com/file/eeaa42
http://www.filefactory.com/file/d94ba7
http://www.filefactory.com/file/979a2f
http://www.filefactory.com/file/157220
http://www.filefactory.com/file/8013bf
http://www.filefactory.com/file/ec7839
http://www.filefactory.com/file/1d5b42
http://www.filefactory.com/file/2a169a
http://www.filefactory.com/file/27b966
http://www.filefactory.com/file/b03618
http://www.filefactory.com/file/ac45d3
http://www.filefactory.com/file/fafd5b
http://www.filefactory.com/file/caf93c
http://www.filefactory.com/file/dc47df
http://www.filefactory.com/file/dda05c
http://www.filefactory.com/file/f82b59
http://www.filefactory.com/file/fe2b73
http://www.filefactory.com/file/807eec
http://www.filefactory.com/file/9de907
http://www.filefactory.com/file/c71707
http://www.filefactory.com/file/6e5bce
http://www.filefactory.com/file/ffbd77
http://www.filefactory.com/file/076a1a
http://www.filefactory.com/file/d94bab
http://www.filefactory.com/file/4aa8aa
http://www.filefactory.com/file/ac45df
http://www.filefactory.com/file/db141e
http://www.filefactory.com/file/7d0309
http://www.filefactory.com/file/d94bb3
http://www.filefactory.com/file/85a1fe
http://www.filefactory.com/file/87a4e3
http://www.filefactory.com/file/1d5b48
http://www.filefactory.com/file/53bec7
http://www.filefactory.com/file/64d562
http://www.filefactory.com/file/0a4671
http://www.filefactory.com/file/b1a34d
http://www.filefactory.com/file/0dc17e
