Training Course:SQL Server 2005 Transact SQL (T-SQL)School/Trainer:Software Training Academy
Toronto, Ontario, Canada
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' 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. You’ll 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 Basic to build database objects.
LEARNING OBJECTIVES
· 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.
· Understand the differences between view, stored procedures, triggers, and user-defined functions.
· Use the new Common Table Expressions for creating hierarchical queries.
· Perform calculations with Visual Basic and Visual C# code rather than T-SQL.
Course Duration: 3 days
Prerequisites:
This course is designed for database developers and SQL Server administrators who need to understand Transact-SQL. To get the most out of this 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.
1. A Tour of SQL Server 2005
SQL Server 2005 Editions, Components, and Tools
Using SQL Server Management Studio (SSMS)
Working with Tables and Queries
New Transact-SQL Features
Business Intelligence Services
2. Designing and Creating a Database
Relational Database Design Principles
Implementing the Design
3. Data Selection Queries
Understanding Transact-SQL
The SELECT Statement
The WHERE Clause
Using ORDER BY to Sort Data
The GROUP BY Clause
Joining Tables
4. Modifying Data
Modifying Data
Inserting Data
Updating Data
Deleting Data
Understanding Transaction Isolation
5. Working with SQL Server Management Studio
Getting Started with SSMS
Exploring the Object Explorer
Working with the Query Editor
Using SQL Server Books Online
6. Transact-SQL Programming
Overview of Transact-SQL
Using Built-In Functions
Controlling Flow
Ranking Results
7. Transactions and Error Handling
Transaction Concepts
Applications and Transactions
Creating Explicit Transactions
Using TRY/CATCH Error Handling
8. Creating Views
What Is a View?
Creating Views
Updating Data Using a View
Using Computed Columns
Indexed Views
Partitioned Views
9. Creating Stored Procedures and Triggers
Creating Stored Procedures
Creating Triggers
10. Creating User-Defined Functions
User-Defined Function Overview
Scalar Functions
Inline Table-Valued Functions
Multi-Statement Table-Valued Functions
Using Functions, Views, and Stored Procedures
11. Using .NET Code in SQL Server 2005
Writing SQLCLR Code
SQLCLR Code Modules
Managing Code Modules
SQLCLR Security
T-SQL vs. .NET Code
12. Advanced Query Techniques
Full-Text Search
Generating XML with FOR XML
Using APPLY
Creating Recursive Queries
Creating Pivot Queries
Executing Dynamic SQL
...''
Please go to the school's official website for training price and schedule:
http://www.softwaretrainingacademy.com/
Phone:1-888-896-7852
School Address:
Toronto Star Building
1 Yonge Street, Suite 1801
Downtown Toronto
Ontario, Canada - M5E 1W7
Jobs & Resumes: Toronto
Houses & Roommates: Toronto
Travel Agencies: Toronto
Search other schools for SQL Server 2005 Transact SQL (T-SQL) training resources.
Other training courses offered by Software Training Academy:
Oracle 10g PL/SQL Programming
Oracle Applications Using ADO.NET and C#
J2EE
Visual Basic for Applications (VBA)
Securing Java Web Applications
SQL Server 2005 Additional Topics
SQL Server 2005 Analysis Services (SSAS)
SQL Server 2005
SQL Server 2005 Integration Services (SSIS)
SQL Server 2005 Reporting Services (SSRS)
The Java Message Service
JSP Standard Tag Library
Using and Developing JavaBeans
XML Programming Using C# and .NET
XML Programming Using Java
XML Programming Using Visual Basic and .NET
XML Schema
XSLFO
XSLT
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Facts:
We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa. |
|
|
