Home > Kurse - Seminare > Microsoft > Online > Kurs 73470 - Microsoft SQL Server 2000 Querying with Transact-SQL Part 1: Manipulating Data - Online

Kurs 73470 - Microsoft SQL Server 2000 Querying with Transact-SQL Part 1: Manipulating Data - Online

Unverbindlich in kontakt treten Zentraler Informatikdienst

Um die Anfrage zu senden, müssen sie die Datenschutzpolitik akzeptieren

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.

Ähnliche Angebote die in Bezug zu Ihrer Anfrage "Microsoft" stehen

Diese Webseite verwendet Cookies. Wenn Sie weiterhin navigieren, verstehen wir das Sie der Nutzung einverstanden sind. Vehr sehen  |