SQL Server

at school(s) in Vancouver or delivered online/live/on-site/by e-learning

Querying Microsoft SQL Server 2005 with Transact-SQL (Certificate)
Course Format: Classroom
School/Trainer: UBC Continuing Studies [All Courses]
Training Center(s)/Venue(s): Vancouver, British Columbia, Canada
Jobs & Resumes: Vancouver
Houses & Roommates: Vancouver

Intended for users who access and manipulate data in Microsoft SQL Server 2005 and other sources, this course introduces the Transact-SQL query language. Learn to write and troubleshoot basic SELECT queries, group data and construct subqueries, join multiple tables, retrieve and modify data and use transactions and heterogeneous data sources. Concepts focus on Microsoft SQL Server 2005 but appl......

Course description>>
 

Learn to install and configure SQL Server 2005; create tables and indexes, define columns, and implement constraints, functions, stored procedures and triggers by using Transact-SQL; work with relational and XML data; monitor, troubleshoot and tune queries; maintain database availability with log shipping, database mirroring and replication, as well as restore a database and prepare a backup st......

Course description>>
 

Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 Business Intelligence are trained to possess an in-depth knowledge of Microsoft SQL Server 2005 Business Intelligence Development. These professionals have an understanding in database schemas, debugging, monitoring, and troubleshooting Business Intelligence solutions, and working with the Microsoft .NET Framework. Thes......

Course description>>
 

To achieve the MCTS (Microsoft Certified Technology Specialist ): SQL Server 2005 certification, candidates must demonstrate in-depth knowledge of SQL Server 2005 and understand how to use the SQL Server 2005 client tools to administer databases and create database applications; administer the database engine; use SQL Server Integration Services (SSIS) to import, export, and transform data; and......

Course description>>
 

Students Will Learn:Generating Reports Customizing Reports Rendering Reports Automating Reports Creating UDMs Mining for Hidden Patterns in Data Creating ETL Packages Managing One-time Data Migration Managing Security Description: This hands on SQL Server 2005 course presents the Business Intelligence tools included in SQL Server 2005. Topics include the use of Business Inte......

Course description>>
 

Students Will Learn:Rendering Reports in Multiple Formats Managing Security of Reports and Report Models Automating the Creation and Delivery of Reports Generating Reports Creating Report Models Customizing Reports Description: This three-day hands-on course thoroughly covers Microsoft’s SQL Server 2005 Reporting Services utility. It begins with an overview of the Reporting S......

Course description>>
 

Pages:- 1 2 3 4 5 6 7 8 9 10 11 ...
[ Workshops ] [ Online Courses ] [ Corporate Training ] [ Topics ] [ Locations ] [ Schools ] [ Job Seekers ]

Dear Visitor: You are strongly recommended to bookmark this page and come back later, since new course may be available anytime. Click to Proceed>>