|
|
|
Module 1: SQL Server Overview
- What is Microsoft SQL Server?
- SQL Server architecture
- SQL Server components
Skills
- Describe SQL Server 7.0 and its supported operating system platforms.
- Describe SQL Server architecture.
- Describe SQL Server components.
Top |
|
Module 2: Installing and Configuring SQL Server
- Hardware and software requirements
- Understanding Microsoft SQL Server installation options
- Running the setup program
- Verifying the installation
- Configuring SQL Server
- Lab: Installing and configuring SQL Server
Skills
- Determine hardware and software requirements for SQL Server 7.0 and the SQL Server management tools.
- Determine the installation options that are appropriate for your system.
- Install SQL Server and SQL Server management tools using the setup program. top <sql7ov.html>
- Verify the installation and configure SQL Server.
Top |
|
|
Module 3: Building a Database
- Database considerations
- Creating databases
- Managing databases
- Creating tables
- Using constraints
- Implementing indexes
- Triggers
- Lab: Creating a database, tables, and constraints
- Lab: Creating indexes using Index Wizard
Skills
- Evaluate database considerations.
- Create and manage databases and transaction logs.
- Create, alter, and drop a table.
- Define and determine when to use constraints.
- Determine when indexes are useful and decide the types of indexes to create.
- Create clustered and non-clustered indexes with unique or composite characteristics.
- Define and determine when to use a trigger.
Top |
|
Module 4: Managing Data
- Data transfer methods
- Using Transact-SQL
- Implementing joins
- Introduction to stored procedures
- Microsoft SQL Server and the World Wide Web
- Lab: Using Data Transformation Service Wizard
- Lab: Performing basic queries
- Lab: Creating stored procedures
- Lab: Publishing data on the Web
Skills
- Describe the process of, and methods for, transferring data into SQL Server.
- Transfer data, schema, and objects using Data Transformation Services.
- Describe the basic elements of Transact-SQL, and how to execute the program.
- List data definition statements, data manipulation statements, and data control statements.
- Perform queries on databases using the SELECT statement.
- Describe how a stored procedure is processed.
- Create, execute, modify, and drop a stored procedure.
- Combine data from two or more tables using joins.
- Create and view a Web page using SQL Server Web Assistant.
Top |
|
|
Module 5: Database Administration
- Introduction to security
- Preventing data loss
- Automating tasks
- Lab: Using Database Maintenance Wizard
Skills
- Distinguish between Windows NT and mixed security authentication modes.
- Determine which type of security account to use.
- Assign security accounts to fixed roles.
- Create and assign security accounts to database and application roles.
- Assign permissions to security accounts.
- Create backup files.
- Automate administrative tasks within a multiserver environment.
Top |
|
|
|
|
Exams:
-
There are no exams directly associated with this course
|
|
Price Options ex VAT:
Classroom Training
? |
Distance Learning
? |
eLearning Options
? |
Book Learning
? |
£
395
(€561)
|
£
199.00
(€283)
|
- |
No Books Supported for Course at present
|
|
|
Call Free on 0800 169 1890
Print 2 Page Flyer
Last Modified 01 May 2008
|
|
