Introduction to Microsoft SQL Server 2000: Level 1 & 2
View Chapters
Price: $2195
Description:
Level 1 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. 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. This introductory course teaches you the fundamentals and gives you a taste of the potential of Microsoft SQL Server 2000.
In Level 1 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.
Level 2 assumes that you already know how to create a well-designed database and how to write simple SQL queries for retrieving and manipulating data. The course shows you how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL (T-SQL), the programming language of SQL Server. You'll also learn how to take advantage of SQL Server's tools for maintaining, securing, and tuning your databases.
In Level 2 you will learn...
Use the programming environment in the Query Analyzer and learn the Transact-SQL language.
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
Prerequisites:
To get the most out of the Introduction to Microsoft SQL Server 2000 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.
