Online Implement Databases Part eLearning Training

SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking. Learn To: o Identify  more...

SQL Server 2000 Design Implement Databases Part 4 Managing Indexes Course Overview This is the fourth course in a five part series that will teach students how to work with SQL Server indexes. Students will learn how to plan for index creation, how to create and manage indexes, as well as learn how to optimize query performance and how to analyze queries. Learn To Identify the features of clustered indexes. Identify the features of nonclustered  more...

SQL Server 2000 Design Implement Databases Part 3 Managing Objects Course Overview This is the third course in a five part series that will teach students how to work with SQL Server data objects. Students will learn how to create and manage view, stored procedures, user-defined functions, and triggers. Learn To Identify the features of views. Identify the considerations for creating views. Create a view by using Transact-SQL. Match the different  more...

SQL Server 2000 Design Implement Databases Part 2 Managing Data Course Overview This is the second course in a five part series that will teach students how to work with SQL Server data. Learn To Identify the SQL Server 2000 system-supplied data types. Add a user defined data type. Match the parts of a data row with their features. Identify characteristics of entity modeling. Identify features of attributes. Identify requirements for logical  more...

SQL Server 2000 Design Implement Databases Part 1 Intro to SQL Server Course Overview This is the first course in a five part series that presents students with both theoretical and practical instruction in the areas of an overview to SQL Server, the Transact-SQL language, and SQL Server Databases. Learn To Identify the features and functions of SQL Server 2000. Match the components of the client-server communication process with their features. Identify  more...

SQL Server 2000 Designing Implementing Databases Curriculum ...es the following courses: MS SQL Server 2000: Design & Implement Databases Part 1(Intro. to SQL Server) MS SQL Server 2000: Design & Implement Databases Part 2 (Managing Data) MS SQL Server 2000: Design & Implement Databases Part 3(Managing Objects) MS SQL Server 2000: Design & Implement Databases Part 4(Managing Indexes) MS SQL Server 2000: Design & Implement Databases Part 5(Dist. Data  more...