Appdev Microsoft SQL Server 2000| 20 hours Runtime | 14 (CDs Set) | 2.6 GB
This course is for developers coming from Microsoft Access, Visual Basic, Active Server Pages or other development backgrounds who want to learn to build successful databases solutions with SQL Server. Even developers who've already used Oracle, Sybase, DB2 or other relational database management systems will find this course useful for getting up to speed on SQL Server 2000. 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 also learn how to take advantage of SQL Server's tools for maintaining your databases.
SQL Server 2000 includes a rich set of tools that go beyond the basics of querying and manipulating data. Microsoft added many very useful capabilities in SQL Server that most developers never discover. You'll learn how to take advantage of SQL Server's tools for securing and tuning your databases. You'll also learn about the advanced features available to you for maintaining, analyzing, searching and distributing your data. Integrate your data safely with Internet and cross-platform applications.
In this course you will learn…
* Learn to install and configure Microsoft SQL Server 2000.
* 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.
* Use the programming environment in the Query Analyzer.
* Understand the differences between view, stored procedures, triggers, and user-defined functions, and know the advantages and drawbacks of each.
* Design and implement reliable backup and maintenance plans.
* Understand the SQL Server security model; and create logins, users and permissions to protect your data.
* Configure and tune SQL Server, and monitor database activity.
* Use Data Transformation Services (DTS) to import and export data, or to move it between external data sources, handling data mapping and conversion when necessary.
* Support distributed users by implementing SQL Server Replication, and understand which replication options are appropriate for which requirements.
* Publish data to the Web, and take advantage of SQL Server 2000’s rich support for Extensible Markup Language (XML).
* Use Analysis Services to create online analytical processing (OLAP) solutions and to mine your data for hidden patterns.
Prerequisites: To get the most out of this 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 60+ hours of total training time…
* 14 modules of training
* Over 20 hours of media run time
* Over 1000 pages of printable courseware
* Step-by-step hands-on-labs
* Sample code