Microsoft SQL Server 2005 Video Training

AppDev Microsoft SQL Server 2005, 20 CD

Description:
this course, You'll learn about the features that are available in SQL Server; how to design and create a database; and how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You'll learn about the new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and programmers can now use .NET languages like C# and Visual Basic to build database objects.

SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. You'll learn how to take advantage of the new, user-friendly management console that integrates both authoring and administrative tasks. You'll learn how to take advantage of SQL Server's tools for analyzing and tuning your databases. You'll also learn about integration services, implementing security, and Microsoft's new Business Intelligence (BI) suite.

In this course, you will learn:
-Install and configure Microsoft SQL Server 2005.
-Understand basic database design principles and how to implement them in SQL Server.
-Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data.
-Understand the differences between view, stored procedures, triggers, and user-defined functions.
-Perform calculations with Visual Basic and Visual C# code rather than T-SQL.
-Use the new Common Table Expressions for creating hierarchical queries.
-Understand the SQL Server security model.
-Configure and tune SQL Server, and monitor database activity.
-Support distributed users by implementing SQL Server Replication.
-Publish data to the Web, and take advantage of SQL Server�s rich support for XML.
-Understand Business Intelligence to add reporting and analysis capabilities.

Prerequisites: To get the most out of the Microsoft SQL Server 2005 course, you should have a solid understanding of relational databases. No particular programming experience is required, but the course is taught from a developer's perspective.

Course includes 90+ hours of total training time...
-20 modules of training
-Over 30 hours of media run time
-Over 1100 pages of printable courseware
-Step-by-step hands-on-labs
-Sample code

Disks 1-4[/bđ

Kod:

http://www.megaupload.com/?d=X9VT4KWA
http://www.megaupload.com/?d=A46VJXWB
http://www.megaupload.com/?d=LWZKPB25
http://www.megaupload.com/?d=SY1V3QWD
http://www.megaupload.com/?d=N5IERKT1
http://www.megaupload.com/?d=GLVFCJZ0
http://www.megaupload.com/?d=L3VMODUT
http://www.megaupload.com/?d=LWFELOOI
http://www.megaupload.com/?d=5HO4JKMN
http://www.megaupload.com/?d=6HGD9WGK
http://www.megaupload.com/?d=UPZI3RTW
http://www.megaupload.com/?d=L514CCNC

[b]Disks 5-8

Kod:

http://www.megaupload.com/?d=BOTREJ3Z
http://www.megaupload.com/?d=BFA7VJEL
http://www.megaupload.com/?d=8Q5C963L
http://www.megaupload.com/?d=S3Q9BIXD
http://www.megaupload.com/?d=SEI12LWA
http://www.megaupload.com/?d=8JVGC53A
http://www.megaupload.com/?d=702MI7GN
http://www.megaupload.com/?d=489WO7NO
http://www.megaupload.com/?d=0P77C4MB
http://www.megaupload.com/?d=7L3SRIPU
http://www.megaupload.com/?d=SBXCZBGN
http://www.megaupload.com/?d=49C9S2ZA

Disks 9-12

Kod:

http://www.megaupload.com/?d=BTFP7C5I
http://www.megaupload.com/?d=NU2KG8QS
http://www.megaupload.com/?d=UUQ2A8H5
http://www.megaupload.com/?d=SZ8YBOGZ
http://www.megaupload.com/?d=69IV2V4R
http://www.megaupload.com/?d=75OMB9EI
http://www.megaupload.com/?d=8Y1HA15Y
http://www.megaupload.com/?d=9KYC8K6Z
http://www.megaupload.com/?d=S6TN37MX
http://www.megaupload.com/?d=F03O3IJ5
http://www.megaupload.com/?d=NX5W0FYN

Disks 13-16

Kod:

http://www.megaupload.com/?d=9W8L1WB0
http://www.megaupload.com/?d=5YD97223
http://www.megaupload.com/?d=IT162YWF
http://www.megaupload.com/?d=N1LV2OK7
http://www.megaupload.com/?d=1RFFPR72
http://www.megaupload.com/?d=A5SD9W4E
http://www.megaupload.com/?d=AD0B9YIG
http://www.megaupload.com/?d=8V63DN4C
http://www.megaupload.com/?d=4STII9ZX
http://www.megaupload.com/?d=D63LBJR8
http://www.megaupload.com/?d=GG5BGYO8
http://www.megaupload.com/?d=IPWNLWEG
http://www.megaupload.com/?d=G4MVA5J9

Disks 17-20

Kod:

http://www.megaupload.com/?d=958WCNT6
http://www.megaupload.com/?d=7YMEDCTH
http://www.megaupload.com/?d=SCDJM6ET
http://www.megaupload.com/?d=CKABRJ19
http://www.megaupload.com/?d=5TTNCCPR
http://www.megaupload.com/?d=2S1A7F4J
http://www.megaupload.com/?d=EJF33KIL
http://www.megaupload.com/?d=J31R8TQ0
http://www.megaupload.com/?d=FFYGAA7T
http://www.megaupload.com/?d=CZPAPOPX
http://www.megaupload.com/?d=OP2CNPZQ
http://www.megaupload.com/?d=NPX2L8B4

PASS

Kod:

[You must be registered and logged in to see this link.]