|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 - Implementing a Database - Part 1 |
 |
Training
Provided by 123-CBT Computer Based Training
Course Overview
This is the first course in a five part series that will provide students with the knowledge to 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.
Content Emphasis
Skills-Based
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).
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: SQL Server Fundamentals
Duration: 2 - 3 Hour(s)- 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
Duration: 2 - 3 Hour(s)- 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
Duration: 2 Hour(s)- 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.
This is primarily online training 
This is an online eLearning or CBT training program 
This program may be available on CD 
Contact 123-CBT Computer Based Training for more information Training Presented in: English
SQL Server 7 0 - Implementing a Database - Part 1
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
