Informationen über Kurs 73470 - Microsoft SQL Server 2000 Querying with Transact-SQL Part 1: Manipulating Data - Online
-
Ziele
- Identify the basic types of statements used in Transact-Structured Query Language (SQL). - Identify the functions of Data Definition Language (DDL) statements. - Identify the functions of Data Control Language (DCL) statements. - Identify the guidelines for selecting columns within a table. - Identify the guidelines for using the WHERE clause to retrieve rows in a table. - Retrieve specific columns from a table. - Identify the characteristics of aggregate functions. - Identify the considerations for using the GROUP BY clause. - Identify the guidelines for using the GROUP BY clause with the HAVING clause.
-
Anforderungen
Candidates for this course operate in medium to very large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. The general categories include: system administrators, database administrators, application developers, system analysts, and software engineers. Students are expected to have an understanding of basic relational database concepts and should be familiar with the role of the database administrator.
-
Titel
Kurs 73470 - Microsoft SQL Server 2000 Querying with Transact-SQL Part 1: Manipulating Data
-
Inhalt
Course Overview
This course presents students with both theoretical and practical instruction in the subject of manipulating data with Transact-SQL.
Deployment Options
Self-Study
Accreditation
CEU credits: 0.70 CEUs
Total Learning Time
6 to 8 hours
Objectives
Unit 1: Introduction to Transact-SQL 2 - 3 hours
- Identify the functions of Data Definition Language (DDL) statements.
- Identify the functions of Data Control Language (DCL) statements.
- Identify the considerations for using Data Manipulation Language (DML) statements.
- Identify the rules for naming SQL Server object identifiers.
- Identify Transact-SQL base data types.
- Identify the functions of SQL operators.
- Identify the characteristics of expressions.
- Identify the functions of language elements that control the flow of logic within an SQL statement.
- Identify the features of the SQL Query Analyzer tool.
- Identify the functions of the Object Browser tool within SQL Query Analyzer.
- Identify the functions of templates in SQL Query Analyzer.
- Identify the uses of the object-oriented Structured Query Language (osql) utility.
- Identify the characteristics of dynamically constructed SQL statements.
- Identify the characteristics of batch usage.
- Write basic SELECT statements.
- Identify the features of script files.
Unit 2: Data Management 2 - 3 hours
- Identify the guidelines for selecting columns within a table.
- Identify the guidelines for using the WHERE clause to retrieve rows in a table.
- Retrieve specific columns from a table.
- Select rows by using a comparison operator.
- Identify the features of logical operators.
Unit 3: Data Grouping 2 hours
- Identify the characteristics of aggregate functions.
- Identify the considerations for using the GROUP BY clause.
- Identify the guidelines for using the GROUP BY clause with the HAVING clause.
- Create a GROUP BY clause with a HAVING clause.
- Identify the guidelines for using the GROUP BY clause with the ROLLUP operator.
- Identify the guidelines for using the GROUP BY clause with the CUBE operator.
- Identify features of the GROUPING function.
- Identify the considerations for using the COMPUTE clause.
- Identify the considerations for using the COMPUTE BY clause.73470 - Microsoft SQL Server 2000
- Querying with Transact-SQL Part 1: Manipulating Data
Course Access
Each student has access to the course for a period of 6 months from the day of enrollment in the course.
