Online Transact-SQL eLearning - Training Resources
Transact-SQL Training Provider? - Tell us about your Training!
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From 123-CBT Computer Based Training
Using T-SQL in SQL Server 2000
To discuss Transact-SQL and its elements and view and define data using Transact-SQL statements
more...
Using T-SQL in SQL Server 2000
To discuss Transact-SQL and its elements and view and define data using Transact-SQL statements
more...
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...
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
...ical 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. Identify the guidelines for selecting columns within a table. Identify the
more...
...ical 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. Identify the guidelines for selecting columns within a table. Identify the
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...
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
...iderations for using transactions and locks. o Create a Transact-SQL script to define a transaction. o Create a Transact-SQL script to rollback a transaction. Audience The target audience for this course includes database designers, database managers, and technical managers. Candidates for Exam 70-229 operate in medium to large computing environments that use SQL Server 2000, Windows
more...
...iderations for using transactions and locks. o Create a Transact-SQL script to define a transaction. o Create a Transact-SQL script to rollback a transaction. Audience The target audience for this course includes database designers, database managers, and technical managers. Candidates for Exam 70-229 operate in medium to large computing environments that use SQL Server 2000, Windows
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...
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
...onsiderations for creating views. Create a view by using Transact-SQL. Match the different user-defined functions with their characteristics. Create a user-defined function by using Transact-SQL. Identify characteristics of schema binding. Identify the features of stored procedures. Identify the considerations for creating stored procedures. Identify the features of encrypting stored
more...
...onsiderations for creating views. Create a view by using Transact-SQL. Match the different user-defined functions with their characteristics. Create a user-defined function by using Transact-SQL. Identify characteristics of schema binding. Identify the features of stored procedures. Identify the considerations for creating stored procedures. Identify the features of encrypting stored
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...
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
...nstruction 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 the features and functions of SQL Server 2000 services. Match the basic types of statements used in Transact-SQL with
more...
...nstruction 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 the features and functions of SQL Server 2000 services. Match the basic types of statements used in Transact-SQL with
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...
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...
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...
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...
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...
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
...ents 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 Skills-Based A udience This course is designed for IT professionals responsible for implementing a database solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL Server 7.0: System
more...
...ents 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 Skills-Based A udience This course is designed for IT professionals responsible for implementing a database solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL Server 7.0: System
more...
SQL Server 7 0 System Administration - Part 2
...r.
Perform the steps for adding a SQL Server login using Transact-SQL.
Perform the steps to assign a login to a user account in SQL Server using Enterprise Manager.
Identify the two types of default user accounts.
Match each server role with the permission.
Perform the steps for assigning logins to Fixed Server Roles using Transact-SQL.
Match each database role with the permission.
more...
...r.
Perform the steps for adding a SQL Server login using Transact-SQL.
Perform the steps to assign a login to a user account in SQL Server using Enterprise Manager.
Identify the two types of default user accounts.
Match each server role with the permission.
Perform the steps for assigning logins to Fixed Server Roles using Transact-SQL.
Match each database role with the permission.
more...
SQL Server 7 0 System Administration - Part 3
...abase backup necessary.
Identify the situations in which Transact-SQL must be used to perform a function.
Identify the available media for database backup.
Identify activities that cannot be performed while a backup operation is in process.
Match the three primary backup devices with their features.
Perform the steps necessary to create a temporary backup file.
Perform the steps necessary
more...
...abase backup necessary.
Identify the situations in which Transact-SQL must be used to perform a function.
Identify the available media for database backup.
Identify activities that cannot be performed while a backup operation is in process.
Match the three primary backup devices with their features.
Perform the steps necessary to create a temporary backup file.
Perform the steps necessary
more...
SQL Server 7 0 - Implementing a Database - Part 3
...ver 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 professionals responsible for implementing a database solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL Server 7.0: System
more...
...ver 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 professionals responsible for implementing a database solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL Server 7.0: System
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...
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...
From Serebra Learning Corporation
SQL Server 7.0 Management Part I
...Server 7.0 contains two powerful tools for managing data: Transact-SQL at the command-line level and SQL Server Wizard features. This course presents a comprehensive view of the database development process by outlining the processes of creating the database managing elements and data and building retrieval features. Students begin with an overview of elemental database objectives. The student
more...
...Server 7.0 contains two powerful tools for managing data: Transact-SQL at the command-line level and SQL Server Wizard features. This course presents a comprehensive view of the database development process by outlining the processes of creating the database managing elements and data and building retrieval features. Students begin with an overview of elemental database objectives. The student
more...
SQL Server 7.0 Management Part II
This course provides the skills to database administrators managers and users so that they may take full advantage of SQL Server 7.0 features. It explains how to use the fundamental elements of Transact-SQL how to use the SELECT statement and how to monitor database performance. It also examines stored procedures and joins. Related Exam: Prepares users for both Microsoft Exams #070-028
more...
This course provides the skills to database administrators managers and users so that they may take full advantage of SQL Server 7.0 features. It explains how to use the fundamental elements of Transact-SQL how to use the SELECT statement and how to monitor database performance. It also examines stored procedures and joins. Related Exam: Prepares users for both Microsoft Exams #070-028
more...
SQL Server 7.0 Advanced Features Part I
...course topics outline the syntax and function of advanced Transact-SQL OSQL and and ODS-based queries methods of managing SQL Server failover support distributed transaction fundamentals Office 2000 integration and Visual Studio integration. The student will learn to create heterogeneous distributed queries and fundamentals of managing the server arrays that require advanced query techniques.
more...
...course topics outline the syntax and function of advanced Transact-SQL OSQL and and ODS-based queries methods of managing SQL Server failover support distributed transaction fundamentals Office 2000 integration and Visual Studio integration. The student will learn to create heterogeneous distributed queries and fundamentals of managing the server arrays that require advanced query techniques.
more...
SQL Server 7.0 Advanced Features Part II
...course topics outline the syntax and function of advances Transact-SQL and ODS-based queries methods of managing SQL Server failover support distributed transaction fundamentals Office 2000 integration and Visual Studio integration. The student will learn to create heterogeneous distributed queries and fundamentals of managing the server arrays that require advanced query techniques. The course
more...
...course topics outline the syntax and function of advances Transact-SQL and ODS-based queries methods of managing SQL Server failover support distributed transaction fundamentals Office 2000 integration and Visual Studio integration. The student will learn to create heterogeneous distributed queries and fundamentals of managing the server arrays that require advanced query techniques. The course
more...
MS SQL Server 2000: Design and Implementation Part 1: Introduction to SQL Server
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.
more...
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.
more...
Microsoft SQL Server 2000 Querying with Transact-SQL Part 1: Manipulating Data
This course presents students with both theoretical and practical instruction in the subject of manipulating data with Transact-SQL.
more...
This course presents students with both theoretical and practical instruction in the subject of manipulating data with Transact-SQL.
more...
Microsoft SQL Server 2000 Querying with Transact-SQL Part 2: Working with Queries
This course will teach students how to work with queries. The course will also introduce views stored procedures triggers and user-defined functions.
more...
This course will teach students how to work with queries. The course will also introduce views stored procedures triggers and user-defined functions.
more...
MS SQL Server 2000: Design and Implementation Part 1: Introduction to SQL Server
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.
more...
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.
more...
From Software Training Academy, Inc
SQL Server 2005 Transact SQL T-SQL
...his course, you ll learn 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
more...
...his course, you ll learn 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
more...
SQL Server 2005 Transact SQL T-SQL with Additional Topics
...sign and create a database and how to build 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 how programmers
more...
...sign and create a database and how to build 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 how programmers
more...
SQL Server 2005
...d 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
more...
...d 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
more...
From ProTrain Online
MCTS .NET Framework
...ledge of the product, understand how to use the tools and Transact-SQL language, and know how to explore the user interface. Additionally, MCTS Certification holders will typically pursue careers as database administrators, database developers, or business intelligence developers. They may also be developers and systems administrators who do not work with SQL Server daily but who want to show
more...
...ledge of the product, understand how to use the tools and Transact-SQL language, and know how to explore the user interface. Additionally, MCTS Certification holders will typically pursue careers as database administrators, database developers, or business intelligence developers. They may also be developers and systems administrators who do not work with SQL Server daily but who want to show
more...
From Teach Me IT
Getting Started with SQL Server 2000
The Getting Started with SQL Server 2000 course is the first course in the SQL Server 2000 Database Implementation curriculum. This course introduces the features and components of SQL Server 2000. It describes the architecture of SQL Server 2000 and the various programming tools that are used to work with Transact SQL statements. It also teaches the various methods to create and manage databases
more...
The Getting Started with SQL Server 2000 course is the first course in the SQL Server 2000 Database Implementation curriculum. This course introduces the features and components of SQL Server 2000. It describes the architecture of SQL Server 2000 and the various programming tools that are used to work with Transact SQL statements. It also teaches the various methods to create and manage databases
more...
From Skillspride Online Training
Microsoft SQL Server 6.5 Introduction
At the end of the course, readers will be able to install and configure SQL Server version 6.5; manage the storage requirements of a database and perform day-to-day operations including backing up and restoring a database, recovering from a system disaster, scheduling tasks, setting alerts, monitoring, and tuning. The basics of Transact SQL are also covered.
more...
At the end of the course, readers will be able to install and configure SQL Server version 6.5; manage the storage requirements of a database and perform day-to-day operations including backing up and restoring a database, recovering from a system disaster, scheduling tasks, setting alerts, monitoring, and tuning. The basics of Transact SQL are also covered.
more...
online course |
instructor-led class |
learn at home |
group study |
self-directed study |
cd-based training |
DVD video training |
printed book |
e-book digital book |
workshop seminar |
train the trainer |
computer-based learning |
discount pricing |
online tutorial |
