Instructor Led Transact-SQL Training - 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 Ahana Systems and Solutions (P) Ltd
MS SQL Database Administration
...m in SQL Server.
* Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data.
* Understand the differences between view, stored procedures, triggers, and user-defined functions.
* Perform calculations with Visual Basic and Visual C# code rather than T-SQL.
* Use the new Common Table Expressions for creating hierarchical queries.
* Understand
more...
MS SQL Database Administration
...m in SQL Server.
* Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data.
* Understand the differences between view, stored procedures, triggers, and user-defined functions.
* Perform calculations with Visual Basic and Visual C# code rather than T-SQL.
* Use the new Common Table Expressions for creating hierarchical queries.
* Understand
more...
From Wise Owl Business Solutions Ltd
SQL Programming and Stored Procedures
If you are comfortable creating queries in SQL, maybe it is time to move on to learn more advanced programming topics? This three day course assumes that you know how to use the main SQL keywords SELECT, FROM, WHERE, GROUP BY and ORDER BY, and shows you how to really progam in SQL Server. Learn how to write stored procedures, create 3 different types of function, use subqueries effectively - and
more...
SQL Programming and Stored Procedures
If you are comfortable creating queries in SQL, maybe it is time to move on to learn more advanced programming topics? This three day course assumes that you know how to use the main SQL keywords SELECT, FROM, WHERE, GROUP BY and ORDER BY, and shows you how to really progam in SQL Server. Learn how to write stored procedures, create 3 different types of function, use subqueries effectively - and
more...
Upsizing Access to SQL
Have you got an Access database which is getting unwieldy? Symptoms to watch out for include a database which runs slowly, or one which crashes a lot. If this sounds familiar, maybe it is time to upsize to SQL Server. In theory you could just the Access upsizing wizard, but bitter experience tells us that this will leave a host of issues unsolved. This one-day course tells you what to look out
more...
Writing SQL
You may have a fantastic database, but unless you can extract useful information from it, it may as well not exist! This two-day course shows you how to mine your database, from getting a mailing list of people meeting certain criteria through to compiling summary information for the board. Note that the SQL language varies slightly between different database providers; this course teaches the
more...
SSRS
In the current business environment organisations need to be able to transform data into clear, concise, user-friendly formats. This two-day SQL Server Reporting Services (SSRS) course shows you how to create, execute and manage reports. Using SQL Server 2005 Business Intelligence Studio you will create interactive reports and learn how to deploy and export them in various formats. You will
more...
From Last Minute Training
Querying Microsoft SQL Server 2000 with Transact-SQL MS Certification
The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2000.
more...
Writing Queries Using Microsoft SQL Server 2005 T-SQL - CTE
In this 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.
more...
Querying Microsoft SQL Server 2000 with Transact-SQL
Topics included in this 2-day course: Introduction to Transact-SQL; Using Transact-SQL Querying Tools; Retrieving Data; Grouping and Summarizing Data; Joining Multiple Tables; Working with Subqueries; Modifying Data; Querying Full-Text Indexes & more
more...
Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.
more...
Writing Queries Using Microsoft SQL Server
In this 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.
more...
From Hands On Technology Transfer, Inc.
Microsoft Transact-SQL Programming
...Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft environment. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. The course covers T-SQL programming constructs, predefined data types including XML, deployment of stored procedures and triggers, CLR
more...
...Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft environment. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. The course covers T-SQL programming constructs, predefined data types including XML, deployment of stored procedures and triggers, CLR
more...
From Webucator
Introduction to Microsoft SQL Server Training
This SQL Server training course, which generally targets developers though can be customized for new programmers, teaches students how to effectively design and develop SQL Server databases and to program in Transact-SQL.
more...
This SQL Server training course, which generally targets developers though can be customized for new programmers, teaches students how to effectively design and develop SQL Server databases and to program in Transact-SQL.
more...
From Affinity IT Training, LLC
Structured Query Language SQL Using Sybase
Provides an introduction to all standard SQL statements and constructs.
Treatment of SQL is platform neutral, but will be delivered in the
Sybase environment. Coverage of Sybase ASE provides an introduction
to Transact-SQL, Transaction Managment, Stored Procedures, and Triggers.
Delivery format is a combination of Lectures and Labs.
Audience:Technical developers with a need to implement SQL in a
more...
Provides an introduction to all standard SQL statements and constructs.
Treatment of SQL is platform neutral, but will be delivered in the
Sybase environment. Coverage of Sybase ASE provides an introduction
to Transact-SQL, Transaction Managment, Stored Procedures, and Triggers.
Delivery format is a combination of Lectures and Labs.
Audience:Technical developers with a need to implement SQL in a
more...
Introduction To Sybase Transact-SQL
Introduces Sybase Transact-SQL, the language used to interact with Sybase Adaptive Server.
Audience:Application developers wishing to integrate Sybase Adaptive Server into their IT solutions.
more...
Introduces Sybase Transact-SQL, the language used to interact with Sybase Adaptive Server.
Audience:Application developers wishing to integrate Sybase Adaptive Server into their IT solutions.
more...
SQL Server 2000 Advanced Transact-SQL
Presents advanced Transact-SQL syntax and techniques.
Audience:Experienced SQL Developers, Programmers or System Administrators seeking to deepen their knowledge of SQL Server 2000 Transact SQL.
more...
Presents advanced Transact-SQL syntax and techniques.
Audience:Experienced SQL Developers, Programmers or System Administrators seeking to deepen their knowledge of SQL Server 2000 Transact SQL.
more...
Sybase Advanced Transact-SQL for ASE 12 5 1
In this course you will learn
valuable tips, techniques and topics
beyond what was encountered in the Introduction to ASE 12.5.1
course to help solve and prevent common problems.
This course also emphasizes good coding practices,
report formatting, advanced functions, characteristic functions,
applied case logic, and bcp (bulkcopy),
as well as generalized methods for solving specific information
more...
In this course you will learn
valuable tips, techniques and topics
beyond what was encountered in the Introduction to ASE 12.5.1
course to help solve and prevent common problems.
This course also emphasizes good coding practices,
report formatting, advanced functions, characteristic functions,
applied case logic, and bcp (bulkcopy),
as well as generalized methods for solving specific information
more...
Introduction To Sybase ASE 12 5 1
...ther database objects
using ANSI-standard SQL and Sybases Transact-SQL extensions,
and gain hands-on experience using Adaptive Server databases.
You will also learn the special features and functions of the Adaptive Server,
such as automatic recovery of transactions, stored procedures, triggers, and cursors.
In addition, you will learn to use good programming techniques
and develop strategies
more...
...ther database objects
using ANSI-standard SQL and Sybases Transact-SQL extensions,
and gain hands-on experience using Adaptive Server databases.
You will also learn the special features and functions of the Adaptive Server,
such as automatic recovery of transactions, stored procedures, triggers, and cursors.
In addition, you will learn to use good programming techniques
and develop strategies
more...
SQL Server 2005 Administration
...d create a
database; and how to build basic queries using Transact-SQL.
Learn how to build effective views, stored procedures,
triggers, and user-defined functions, using Transact-SQL.
Learn about the new enhancements to the Transact-SQL
programming language including improved support for error handling
and hierarchical queries, and programmers can now use .NET languages
like C# and Visual
more...
...d create a
database; and how to build basic queries using Transact-SQL.
Learn how to build effective views, stored procedures,
triggers, and user-defined functions, using Transact-SQL.
Learn about the new enhancements to the Transact-SQL
programming language including improved support for error handling
and hierarchical queries, and programmers can now use .NET languages
like C# and Visual
more...
SQL Server 2005 T-SQL
...Transact-SQL, the language of
SQL Server. Learn how to build effective views, stored procedures,
triggers, and user-defined functions using Transact-SQL.
Learn about the new enhancements to the Transact-SQL programming
language including improved support for error handling and
hierarchical queries, and how programmers can now use .NET languages
like C# and Visual Basic to build database
more...
...Transact-SQL, the language of
SQL Server. Learn how to build effective views, stored procedures,
triggers, and user-defined functions using Transact-SQL.
Learn about the new enhancements to the Transact-SQL programming
language including improved support for error handling and
hierarchical queries, and how programmers can now use .NET languages
like C# and Visual Basic to build database
more...
From Aspect Training
SQL Advanced for SQL Server
... course, students will be able to:
a Write and execute Transact-SQL scripts utilizing procedural language statements .
a Turn relational data into well-formed XML. Shred XML data into a relational tables.
a Search Full-Text Indexes using the different Full-Text search functions.
a Add, Edit and Update records in the database
a Design and Create Views.
a Design and Create
more...
From Microcomputing Solutions ltd
Microsoft SQL Server 20052008
The topics covered are as follows:
1 Introduction
a Versions of SQL Server 2005
a Hardware Requirements
a Software Requirements
a SQL Server Components
a Licensing Modes
2 Installing SQL Server
a Pre-installation Planning
a Setting up the Service Accounts
a Authentication Modes
a Performing the Installation
3 Upgrading from Previous Versions
a Supported
more...
From Microsys Technologies and Solutions Pvt. Ltd.,
SQL Server 2008 Database Administration
You Will Learn How To
Administer SQL Server 2008 with SQL Server Management Studio and Transact-
SQL
Build databases and upgrade from prior versions
Secure the server through logins and database permissions management
Implement backup and recovery strategies and manage transaction logs
Automate administrative activities with SQL Server Agent multistep jobs
Perform routine
more...
SQL Server 2005 (Yukon)
.NET CLR Integration
Creating Stored procedures, user-defined functions, triggers using .NET
The SQL Server programming models
.Net user-defined types (UDT)
User Defined Aggregates (UDA)
Security Improvements
New Database Engine Features
New Transact SQL Features
XML Data Types
XQuery
HTTP Endpoints and Web Services
Service Broker
Client Libraries and enhancements
more...
.NET CLR Integration
Creating Stored procedures, user-defined functions, triggers using .NET
The SQL Server programming models
.Net user-defined types (UDT)
User Defined Aggregates (UDA)
Security Improvements
New Database Engine Features
New Transact SQL Features
XML Data Types
XQuery
HTTP Endpoints and Web Services
Service Broker
Client Libraries and enhancements
more...
From Wintrac Inc.
T-SQL 2008
...d create a database, and how to build basic queries using Transact-SQL, the language of SQL Server. Then you will learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You will learn how to use the Transact-SQL programming language for error handling and hierarchical queries, dealing with complex data structures and processes, and how to
more...
MICROSOFT SQL SERVER 2005 CORE
SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. In this course, youa ™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. Youa ™ll learn about the new enhancements to the Transact-SQL programming language
more...
Microsoft SQL Server 2008 for Developers
...ed procedures, triggers, and user-defined functions using Transact-SQL. Learn how to make your databases more scalable through partitioning and how to use .NET languages like Visual C# and Visual Basic to build database objects. SQL Server 2008 includes a rich set of tools that go beyond the basics of querying and manipulating data. You can get a complete list of other Sql server classes at
more...
From IT Centers LLC
Microsoft MCDBA
The Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server2000 credential is the premier certification for professionals who implement and administer Microsoft SQL Server databases. The certification is appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage
more...
The Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server2000 credential is the premier certification for professionals who implement and administer Microsoft SQL Server databases. The certification is appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage
more...
From Boston University Corporate Education Center
Maintaining a Microsoft SQL Server 2005 Database
...stem and its core functionality. Working knowledge of Transact-SQL. Working knowledge of relational databases. Some experience with database design.
In addition, it is recommended, but not required, that students have completed:
Course 2778, Writing Queries Using Microsoft SQL Server Transact-SQL. Course 2779, Implementing a Microsoft SQL Server Database.
Course
more...
...stem and its core functionality. Working knowledge of Transact-SQL. Working knowledge of relational databases. Some experience with database design.
In addition, it is recommended, but not required, that students have completed:
Course 2778, Writing Queries Using Microsoft SQL Server Transact-SQL. Course 2779, Implementing a Microsoft SQL Server Database.
Course
more...
Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
...nd the platform or operating system. Understanding of Transact-SQL syntax and programming logic. Basic knowledge of Microsoft Windows networking. Students should understand how Domain Name Service (DNS) operates and how servers communicate between domains. Familiarity with SQL Server 2005 features, tools, and technologies. Microsoft Certified Technology Specialist:
more...
...nd the platform or operating system. Understanding of Transact-SQL syntax and programming logic. Basic knowledge of Microsoft Windows networking. Students should understand how Domain Name Service (DNS) operates and how servers communicate between domains. Familiarity with SQL Server 2005 features, tools, and technologies. Microsoft Certified Technology Specialist:
more...
Implementing a Microsoft SQL Server 2005 Database
...stem and its core functionality. Working knowledge of Transact-SQL. Working knowledge of relational databases. Some experience with database design.
In addition, it is recommended, but not required, that students have completed:
Course 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL. Course Outline
Module 1: Creating Databases and Database Files
more...
...stem and its core functionality. Working knowledge of Transact-SQL. Working knowledge of relational databases. Some experience with database design.
In addition, it is recommended, but not required, that students have completed:
Course 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL. Course Outline
Module 1: Creating Databases and Database Files
more...
Designing the Data Tier for Microsoft SQL Server 2005
... application developers typically perform. Understand Transact-SQL syntax and programming logic. Be able to design a database to third normal form (3NF) and know the trade offs when backing out of the fully normalized design (denormalization) and designing for performance and business requirements in addition to being familiar with design models, such as Star and Snowflake schemas.
more...
... application developers typically perform. Understand Transact-SQL syntax and programming logic. Be able to design a database to third normal form (3NF) and know the trade offs when backing out of the fully normalized design (denormalization) and designing for performance and business requirements in addition to being familiar with design models, such as Star and Snowflake schemas.
more...
Designing Microsoft SQL Server 2005 Server-Side Solutions
...n statements or business analysis reports. Understand Transact-SQL syntax and programming logic. Understand XML. Specifically, they must be familiar with the syntax of XML, what elements and attributes are, and how to distinguish them. Understand security requirements. Specifically, must understand how unauthorized users can gain access to sensitive information and be able to plan
more...
...n statements or business analysis reports. Understand Transact-SQL syntax and programming logic. Understand XML. Specifically, they must be familiar with the syntax of XML, what elements and attributes are, and how to distinguish them. Understand security requirements. Specifically, must understand how unauthorized users can gain access to sensitive information and be able to plan
more...
From Thinkpath Training LLC
Querying MS-SQL Server 2000 & Programming a MS-SQL Server 2000 Database (Course 2071/2073)
... 2071: Querying a Microsoft SQL Server 2000 Database with Transact-SQL and 2073: Programming a Microsoft SQL Server 2000 Database. New custom practice labs have been generated to provide the student with a linear project in which to experience and partake in the creation of a real-world database solution.
Course Objective: This course provides students with the technical skills required to
more...
... 2071: Querying a Microsoft SQL Server 2000 Database with Transact-SQL and 2073: Programming a Microsoft SQL Server 2000 Database. New custom practice labs have been generated to provide the student with a linear project in which to experience and partake in the creation of a real-world database solution.
Course Objective: This course provides students with the technical skills required to
more...
From American IT
Querying Microsoft SQL Server 2000 with Transact-SQL
The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server™ 2000.
more...
The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server™ 2000.
more...
From The Career Center
SQL Database Design & Implementation
...Transact-SQL language to query and program Microsoft
SQL Server 2000 in a Windows Server Server environment. This course also assists you in preparing
for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator
Exam #70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise
Edition.
Upon successful completion of this course, students
more...
...Transact-SQL language to query and program Microsoft
SQL Server 2000 in a Windows Server Server environment. This course also assists you in preparing
for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator
Exam #70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise
Edition.
Upon successful completion of this course, students
more...
From Boston University Corporate Education Center
Updating Your Database Administration Skills to Microsoft SQL Server 2005
...to manage a server. ? Use the sqlcmd utility to execute Transact-SQL from the command prompt. ? Use SQL Management Objects to script common administrative tasks.
Module 4: Monitoring SQL Server 2005
This module discusses the various tools and techniques you can use to monitor Microsoft? SQL Server? 2005.
Lessons
? Using SQL Profiler ? Using DDL Triggers ? Using Event
more...
...to manage a server. ? Use the sqlcmd utility to execute Transact-SQL from the command prompt. ? Use SQL Management Objects to script common administrative tasks.
Module 4: Monitoring SQL Server 2005
This module discusses the various tools and techniques you can use to monitor Microsoft? SQL Server? 2005.
Lessons
? Using SQL Profiler ? Using DDL Triggers ? Using Event
more...
Updating Your Database Development Skills to Microsoft SQL Server 2005
... Development Tools provided with SQL Server 2005. ? Use Transact-SQL enhancements to perform database development tasks. ? Develop XML-based Solutions using SQL Server 2005. ? Build Message-Based Services with the Service Broker. ? Implement Web Services using Native HTTP Endpoints. ? Build Notification Services Applications. ? Implement Database Functionality with Managed (.NET)
more...
... Development Tools provided with SQL Server 2005. ? Use Transact-SQL enhancements to perform database development tasks. ? Develop XML-based Solutions using SQL Server 2005. ? Build Message-Based Services with the Service Broker. ? Implement Web Services using Native HTTP Endpoints. ? Build Notification Services Applications. ? Implement Database Functionality with Managed (.NET)
more...
Querying Microsoft SQL Server 2000 with Transact-SQL
The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2000.
more...
The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2000.
more...
Administering a Microsoft SQL Server 2000 Database
...ning Data Services and Data Models
Knowledge of basic Transact-SQL syntax (SELECT, INSERT, UPDATE, and DELETE statements).
For students who do not meet these prerequisites, the following course provides students with the necessary knowledge and skills:
Course 2071, Querying Microsoft SQL Server 2000
Familiarity with the role of the database administrator.
Course Outline
more...
...ning Data Services and Data Models
Knowledge of basic Transact-SQL syntax (SELECT, INSERT, UPDATE, and DELETE statements).
For students who do not meet these prerequisites, the following course provides students with the necessary knowledge and skills:
Course 2071, Querying Microsoft SQL Server 2000
Familiarity with the role of the database administrator.
Course Outline
more...
From IT Centers LLC
Microsoft MCITP: Database Developer
Microsoft Certified IT Professional: Database Developer (MCITP: Database Developer) is the premier certification for database designers and developers. This credential demonstrates that you can design a secure, stable, enterprise database solution by using Microsoft SQL Server 2005.
Database developers design and implement relational database models (logical and physical) and database storage
more...
Microsoft Certified IT Professional: Database Developer (MCITP: Database Developer) is the premier certification for database designers and developers. This credential demonstrates that you can design a secure, stable, enterprise database solution by using Microsoft SQL Server 2005.
Database developers design and implement relational database models (logical and physical) and database storage
more...
Microsoft MCITP: Database Administrator
...h the conceptual and logical levels
- Experience writing Transact-SQL queries
- Ability to define high-availability solutions (RAID, replication, mirroring, etc.)
- Experience automating administrative tasks
- Experience defining database security solutions
- Experience monitoring and troubleshooting the database server
- Experience designing and executing database deployments
-
more...
...h the conceptual and logical levels
- Experience writing Transact-SQL queries
- Ability to define high-availability solutions (RAID, replication, mirroring, etc.)
- Experience automating administrative tasks
- Experience defining database security solutions
- Experience monitoring and troubleshooting the database server
- Experience designing and executing database deployments
-
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 |
