SQL Server 2005

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 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. 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.

SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. You’ll learn how to take advantage of the new, user-friendly management console that integrates both authoring and administrative tasks. You’ll learn how to take advantage of SQL Server’s tools for analyzing and tuning your databases. You’ll also learn about integration services, implementing security, and Microsoft’s new Business Intelligence (BI) suite.



LEARNING OBJECTIVES



· Install and configure Microsoft SQL Server 2005.

· 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.

· Perform calculations with Visual Basic and Visual C# code rather than T-SQL.

· Use the new Common Table Expressions for creating hierarchical queries.

· Understand the SQL Server security model.

· Configure and tune SQL Server, and monitor database activity.

· Support distributed users by implementing SQL Server Replication.

· Publish data to the Web, and take advantage of SQL Server’s rich support for XML.

· Understand Business Intelligence to add reporting and analysis capabilities.



Course Duration: 5 days

...''

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 training resources.

JDBC
Oracle 10g Advanced SQL
Oracle 10g Introduction to SQL
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 Integration Services (SSIS)
SQL Server 2005 Reporting Services (SSRS)
SQL Server 2005 Transact SQL (T-SQL)
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

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.
 

Tips: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.