Microsoft SQL Server 7.0: Implementing a Database- Part 1 CBT Training CD

Rating:
Summary: Microsoft SQL Server 7.0: Implementing a Database- Part 1 CB
Review: Course Overview
This is the first course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.

Learn To

Identify the components of SQL Server 7.0.
Identify the characteristics of Transact-SQL and its processing.
Perform the skills to construct and manage databases.

Audience
This course is designed for IT professionals responsible for implementing a database solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL Server 7.0: System Administration (Course Series 72470 - 72474).

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
Japanese, US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: SQL Server Fundamentals 2 - 3 hours

Select the operating systems that are used to create and execute applications using SQL Server.
Identify the components of Windows NT that integrate with SQL Server 7.0.
Match the Microsoft BackOffice applications with their descriptions.
Select the features of SQL Server services.
Match SQL Server client software with its corresponding function.
Identify SQL Server communication architecture and its components.
Identify the types of database interfaces supported by SQL Server.
Select the SQL Server management tools used to automate routine administrative tasks.
Match roles with their security permissions.
Sequence the steps for validating permissions.
Match SQL Server databases with their descriptions.
Match the database components with their descriptions.
Select the characteristics of SQL Server objects.
Match commonly used system tables with their functions.
Identify methods for retrieving metadata from system tables.
Sequence the steps for implementing a SQL Server database.
Identify administrative duties associated with a SQL Server database.

Unit 2: Working with Transact-SQL 2 - 3 hours

Select features of the SQL Server Query Analyzer.
Select the SQL Server programming tool that is used to enter Transact-SQL statements, system procedures and script files using ODBC.
Select uses of Data Control Language statements.
Select uses of Data Definition Language statements.
Select SQL Server naming conventions for object identifiers.
Select uses of Data Manipulation Language statements.
Select when to use local variables.
Select global variable uses.
Sequence operators from their highest to lowest precedence.
Select language elements that control the flow of logic within a statement.
Perform the steps to create an in-line comment for a statement.
Perform the steps to create a block comment for a statement.
Perform the steps to create a dynamically constructed statement.
Select the purposes used for submitting Transact-SQL statements in batches.
Select the purpose for using scripts to submit Transact-SQL statements.
Select the purpose for using transactions to submit Transact-SQL statements.
Sequence the steps for processing cached queries.
Select the mechanisms that save query definitions automatically.
Select the mechanisms that save specified query definitions.

Unit 3: Constructing Databases 2 hours

Select the description of how SQL Server stores data.
Sequence the steps of the transaction logging process.
Perform the steps to create a database.
Match frequently used database options with their descriptions.
Perform the steps to expand the size of the log file.
Select circumstances under which it is necessary to expand the transaction log.
Perform the steps to shrink a database.
Perform the steps to shrink a data file.
Perform the action to drop a database.
Perform the steps to create a filegroup.
Match common types of data with SQL Server system-supplied data types.
Perform the steps to create a user-defined data type.
Perform the action to drop a user-defined data type.
Perform the steps to create a table.
Perform the action to drop a table.
Perform the steps too add a column to a table.
Perform the steps to drop a column in a table.
Select the methods that are used to generate column values.
Select common purposes for generating a schema as a Transact-SQL script.
Select different types of schemas that can be made into scripts.