Kurs 73480 - Microsoft SQL Server 2000 Designing and Implementing Databases - Part 1: Introduction to SQL Server
Ziele- Identify the features and functions of SQL Server 2000. - Match the components of the client-server communication process with their features. - Identify the features and functions of SQL Server 2000 services. - Match the basic types of statements used in Transact-SQL with their functions. - Match Data Control Language (DCL) statements with their functions. - Identify the functions of Data Definition Language (DDL) statements. - Identify the types of SQL Server 2000 databases. - Identify the features of the SQL Server 2000 object-naming standard. - Identify the methods for retrieving metadata information.
AnforderungenThe Audience for this course includes database designers, database managers, and technical managers. Candidates for Exam 70-229 operate in medium to large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). Students are expected to have experience with using the Microsoft Windows 2000 operating system. Students are also expected to understand database concepts and Transact-SQL syntax. Students should be familiar with the role of the database administrator.
TitelKurs 73480 - Microsoft SQL Server 2000 Designing and Implementing Databases - Part 1: Introduction to SQL Server
InhaltCourse Overview
This is the first course in a five part series that presents students with both theoretical and practical instruction in the areas of an overview to SQL Server, the Transact-SQL language, and SQL Server Databases.
Deployment Options
Self-Study
Accreditation
CEU credits: 0.70 CEUs
Total Learning Time
6 to 8 hours
Objectives
Unit 1: SQL Server 2000 Overview 3 hours
- Match the components of the client-server communication process with their features.
- Identify the features and functions of SQL Server 2000 services.
- Match Microsoft server applications that integrate with SQL Server 2000 with their features.
- Identify the activities associated with administering a SQL Server 2000 database.
- Identify the steps associated with implementing a SQL Server 2000 database.
- Identify the types of application architecture.
Unit 2: Transact-SQL 1 - 2 hours
- Match the basic types of statements used in Transact-SQL with their functions.
- Match Data Control Language (DCL) statements with their functions.
- Identify the functions of Data Definition Language (DDL) statements.
- Identify the considerations for using Data Manipulation Language (DML) statements.
- Identify considerations for naming SQL Server 2000 objects.
- Match the control-of-flow language elements with their functions.
- Identify the three forms of the FOR XML clause used to format result sets for Web pages.
- Identify the characteristics of dynamically constructed SQL statements.
- Identify the characteristics of batches.
- Identify the features of script files.
- Identify the characteristics of the osql utility.
- Identify the guidelines for using the BETWEEN search condition to retrieve rows of data.
- Identify statements used to retrieve specific rows by searching a list of values.
- Identify guidelines for using the ORDER BY clause to sort data.
- Write a statement to include an aggregate function.
- Identify the considerations for using the GROUP BY clause.
- Identify the guidelines for using the HAVING clause with the GROUP BY clause.
- Identify the considerations for using the GROUP BY clause with the ROLLUP operator.
- Identify the considerations for using the GROUP BY clause with the CUBE operator.
- Identify the considerations for using the GROUPING function.
- Identify the considerations for using the COMPUTE clause.
- Identify the considerations for using the COMPUTE BY clause.
- Identify the considerations for using INSERT with the SELECT statement.
- Identify considerations for using the SELECT INTO statement.
- Identify guidelines for inserting partial data.
- Identify considerations for inserting data by using column defaults.
- Identify considerations for using the DELETE statement.
- Identify considerations for using the TRUNCATE TABLE statement.
- Identify considerations for using an additional FROM clause to delete rows.
- Update a specific row of data from a table by using the UPDATE statement.
- Update rows in a table based on other tables by using the UPDATE statement.
Unit 3: Creating and Managing Databases 2 - 3 hours
- Identify the types of SQL Server 2000 databases.
- Identify the features of the SQL Server 2000 object-naming standard.
- Identify the methods for retrieving metadata information.
- Create a database by using Transact-SQL.
- Create a database by using SQL Server Enterprise Manager.
- Match database options with their functions.
- Identify features of filegroups.
- Identify the features of filegroups that are used to improve performance of the overall system.
- Identify the benefits of combining filegroups with hardware-based RAID.
- Identify considerations for data storage.
- Identify guidelines for managing data and log file growth.
- Identify the situations in which transaction logs need to be expanded.
- Manage transaction log file growth.
- Shrink a database or data file by using the DBCC statement.
- Identify the considerations for database deletion.
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