|
SQL
Server 2000 Database Implementation
Price:
US $1,995, UK £1,499 + VAT | Duration: 5 days
Learn
how to deliver powerful database solutions-and prepare for the
Microsoft®
Certified Professional (MCP) exam. Work through the modular system
of lessons and hands-on exercises, with the help of an expert
instructor,
to gain practical experience designing and implementing data-driven
business applications using SQL Server™ 2000 Enterprise Edition.
As you build these real-world design skills, you're also preparing
for MCP Exam 70-229 - a core exam for MCDBA certification and a
key elective on the MCSE and MCSD tracks.
Experience using
the Microsoft Windows NT® Server network operating system. It
is recommended delegates have one year's experience with relational
databases, three to six months of SQL Server experience together
with an understanding of basic ANSI SQL statements.
This course provides
delegates with technical skills required to implement a database
solution with the Microsoft SQL Server relational database management
system. The course provides extensive hands-on practical experience
covering all the main topics including creating databases, creating
indexes, performing advanced queries and summarizing data.
-
Plan for a SQL Server
installation
- Install SQL
Server
- Configure
SQL Server, manage files and databases
- Choose a
login security method
- Configure
login security
- Plan and
implement database permissions
- Back up databases
- Restore databases
- Automate
administrative tasks using SQL Server Agent
- Import, export
and transform data
- Monitor and
maintain SQL Server performance
- Replicate
data from one SQL Server to another
Introduction
to Microsoft SQL Server 2000
Overview of SQL Server 2000 | Components of SQL Server 2000 | Overview
of SQL Server 2000 Architecture
Using Transact-SQL
on a SQL Server Database
SQL Server Programming Tools | Introduction to Transact-SQL | Transact-SQL
Syntax Elements | Executing Transact-SQL Statements
Designing
a SQL Server Database
Introduction to Database Design | Planning a SQL Server Database
| Identifying: System Requirements | Developing a Logical Data Model
Implementing
SQL Server Databases & Tables
Creating and Managing a SQL Server Database| Identifying Data |
Creating and Managing Tables
Implementing
Data Integrity
Introduction to Data | Implementing Integrity
Accessing
and Modifying Data 205
Accessing Data in a SQL Server Database | Using SELECT Statements
to Access Data | Modifying Data in a SQL Server Database Exercise
Managing
and Manipulating Data
Importing and Exporting Data | Using Distributed Queries to Access
External Data | Using Cursors to Retrieve Data | Retrieving XML
Data
Implementing
Stored Procedures
Introduction to Stored Procedures | Creating, Modifying, & Deleting
Stored Procedures | Programming Stored Procedures
Implementing
Triggers
Introduction to Triggers | Creating and Managing Triggers | Programming
Triggers
Implementing
Views
Introduction to Views | Creating, Modifying, and Deleting Views
| Accessing Data through Views
Implementing
Indexes
Index Architecture | Index Creation & Administration
Managing
SQL Server Transactions & Locks
Transaction & Locking Architecture | Managing SQL Server | Managing
SQL Server Locking
Designing
& Administering SQL Server 2000 Security
Overview of SQL Server 2000 Security | Designing a Database Security
Plan | Database Security Implementation & Administration
SQL Server
Monitoring & Tuning
Monitoring Databases with SQL Profiler | Index Tuning & Database
Partitioning
- Create &
Manage Tables in a SQL Server
- Identify
the Properties Used to Ensure Data Integrity
- Add Constraints
to Existing Tables
- Use SELECT
Statements to Access Data
- Use Advanced
Query Techniques to Retrieve Data
- Modify Data
in a SQL Server Database
- Import &
Export Data
- Use Distributed
Queries to Access External Data
- Create a
Cursor to Retrieve Data
- Create &
Modify a View
- Use the AuthorsBooks
View to Access
- Access &
Modify the Transaction Log
- Configure
Transaction Properties
|
SQL Server
Training Courses
