���������óװ����������ȫ��ó�˶�Ь����ó����ַ����������QQ������԰������ó֮�����ﰲ����԰������ó�Ż�����С������Ьҵ Microsoft Transact-SQL Course Summary
  Friday, November 24, 2017
  Register  Login  
MediaCityUK BBC North Mark Whitfield NonStop Portal MediaCityUK BBC North Salford Quays Timeline & Worsley Park Golf Course
    

Mark Whitfield

  Querying Microsoft SQL Server 2000 with Transact-SQL Course Summary :

Microsoft Official Course :

M2071 Querying Microsoft SQL Server 2000 with Transact-SQL - 
Course Tutor - Michael Howell
March 12th-13th 2009

Overview

This course provides delegates with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2000. It is intended for Microsoft SQL Server database administrators, implementers, system engineers and developers.

Please note : whilst this course utilizes SQL Server 2000, it would be valuable for those who need to learn TSQL for use in a SQL 2005 environment.

Leads to examination

  • 70-229 – Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

Prerequisites

Delegates should have experience of using a Microsoft Windows operating system and have an understanding of relational database concepts including:

  • Logical and physical database design.
  • Data integrity concepts.
  • Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).
  • How data is stored in tables (rows and columns).
  • Familiarity with the role of the database administrator

Delegates completely new to SQL or with little experience of SQL (especially the writing of SQL queries) should consider attending our SQLINT or DBSQLLG-2 courses prior to attending this course which assumes basic SQL knowledge. 

Both of the SQLINT and DBSQLLG-2 courses assume little or no SQL expertise, start at a more basic level and provide more rigorous practice in writing basic SQL statements

Delegates will learn how to

  • Use querying tools
  • Write SELECT queries to retrieve data
  • Write queries that retrieve and modify data by using subqueries
  • Describe the uses of and ways to execute the Transact-SQL language
  • Query text fields with full-text search
  • Modify data in tables
  • Group and summarise data by using Transact-SQL
  • Join data from multiple tables
  • Describe how to create programming objects

Outline

  • Module 1: Introduction to Transact-SQL
  • Module 2: Using Transact-SQL Querying Tools
  • Module 3: Retrieving Data
  • Module 4: Grouping and Summarizing Data
  • Module 5: Joining Multiple Tables
  • Module 6: Working with Subqueries
  • Module 7: Modifying Data
  • Module 8: Querying Full-Text Indexes
  • Module 9: Introduction to Programming Objects
      

  Querying Microsoft SQL Server 2000 with Transact-SQL Course Cover :

Querying Microsoft SQL Server 2000 with Transact-SQL

      

  Querying Microsoft SQL Server 2000 with Transact-SQL Course Certificate :

Querying Microsoft SQL Server 2000 with Transact-SQL Course Certificate

      

Home  |  Blog  |  Calendar  |  Forum  |  About  |  Guestbook  |  Location  |  Contact  |  Site Map
Copyright 2016-2017 : Mark A. Whitfield : Senior Project Manager - Capgemini UK