Online Transact Sql Part 1 eLearning - Training Resources

SQL Server 2000 Querying with Transact SQL Part 2 Working with Queries Course Overview This course will teach students how to work with queries. The course will also introduce views, stored procedures, triggers, and user-defined functions. Learn To Identify advantages of using aliases for table names. Identify the guidelines for using joins. Identify the considerations for using inner joins. Identify considerations for using subqueries. Create a derived  more...

SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data Course Overview This course presents students with both theoretical and practical instruction in the subject of manipulating data with Transact-SQL. Learn To Identify the basic types of statements used in Transact-Structured Query Language (SQL). Identify the functions of Data Definition Language (DDL) statements. Identify the functions of Data Control Language (DCL) statements.  more...

SQL Server 2000 Querying with Transact SQL Curriculum The MS SQL Server 2000 Querying with Transact SQL Curriculum includes the following courses: MS SQL Server 2000: Querying with Transact SQL Part 1(Manipulating Data) MS SQL Server 2000: Querying with Transact SQL Part 2(Working with Queries) To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

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 Database Admin Part 5 Maint SQL Server 2000 Course Overview This is the last course in a five part series that deals with managing, monitoring, and troubleshooting SQL Server 2000. Learn To Identify guidelines for configuring SQL Server Agent. Identify guidelines for using SQLAgentMail and SQL Mail. Configure a Microsoft Outlook Exchange profile for your administrative account. Identify the goals of SQL Server 2000 monitoring.  more...

SQL Server 2000 Database Admin Part 4 Managing Data Course Overview This course deals with transferring data, managing replication services, and maintaining high availability. Learn To Identify guidelines for importing and exporting data. Match SQL Server 2000 tools used to import and export data with their functions. Identify the features and functions of the Data Transformation Services (DTS) process. Identify the features of  more...

SQL Server 2000 Database Admin Part 3 Security Data Recovery Course Overview This is the third course in a five part series that deals with the backup and restore strategies for SQL Server 2000 and with managing security and permissions with SQL Server 2000. Learn To Identify how login accounts are processed. Identify the characteristics of the two authentication modes. Sequence the steps to implement an authentication mode. Identify the  more...

SQL Server 2000 Database Admin Part 2 Manag Databases Course Overview This is the second course in a five part series that will teach students how to plan for managing databases with SQL Server 2000. This course also includes both theoretical and practical instruction in the creation and management of objects. Learn To Identify the database option categories. Identify features of the tools used to view database properties. View database  more...

SQL Server 2000 Database Admin Part 1 Install SQL Server 2000 This is the first course in a five part series that presents the students with both theoretical and practical instruction in the subject of installing SQL Server 2000. Learn To Identify the features and functions of SQL Server. Identify the components involved in the client-server communication process. Identify the steps in the client-server communication process. Identify the minimum  more...

SQL Server 7 0 - Implementing a Database - Part 1 Course Overview This is the first course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Identify the components of SQL Server 7.0. Identify the characteristics of Transact-SQL and its processing. Perform the skills to construct and manage databases. C ontent Emphasis  more...

SQL Server 7 0 System Administration - Part 2 Course Overview This is the second course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Work with Microsoft SQL Server is and Work with Microsoft SQL Server 7.0, its architecture, security, and database structure. Understand the basics of SQL Server databases and how to  more...

SQL Server 7 0 System Administration - Part 3 Course Overview This is the third course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Identify the concepts, interfaces and fixed roles involved in performing backups. Gain a working knowledge of database, transaction log and filegroup backups and perform these backups as  more...

SQL Server 7 0 - Implementing a Database - Part 3 Course Overview This is the third course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0. L earn To: Query multiple tables using Transact-SQL statements. Retrieve and modify data using advanced query techniques. C ontent Emphasis Skills-Based A udience This course is designed for IT  more...

SQL Server 7 0 - Implementing a Database - Part 5 Course Overview This is the final course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0. L earn To: Access data by using the Stored Procedure model. Access data using triggers. Set up a distributed environment to access, modify and manage remote data. C ontent Emphasis Skills-Based A  more...