AppDev Microsoft SQL Server 2005 (20 CD - $2,495)

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.

Download Link:


Part 1 | Part 2 | Part 3 | Part 4 | Part 5 | Part 6 | Part 7 | Part 8 | Part 9 | Part 10 | Part 11 | Part 12 | Part 13 | Part 14 | Part 15 | Part 16 | Part 17 | Part 18 | Part 19 | Part 20 | Part 21 | Part 22 | Part 23 | Part 24 | Part 25 | Part 26 | Part 27 | Part 28 | Part 29 | Part 30 | Part 31 | Part 32 | Part 33 | Part 34 | Part 35 | Part 36 | Part 37 | Part 38 | Part 39 | Part 40 | Part 41 | Part 42 | Part 43 | Part 44 | Part 45 | Part 46 | Part 47 | Part 48 | Part 49 | Part 50 | Part 51 | Part 52 | Part 53 | Part 54 | Part 55 | Part 56 | Part 57 | Part 58 | Part 59 | Part 60 |