| This highly recommended Microsoft
SQL Server 2000 Database Programming tutorial is disigned to offer fast
learning of how to use SQL Server 2000 in the real world and to help you
prepare for the Microsoft Certification core Exam 70-229, a necessary
exam to achieve MCDBA certification. Mark Long, a Microsoft certified
instructor, begins the course be introducing you to SQL Server 2000 and
some of the new features you will find, including data transformation
service enhancements, failover clustering improvements, and XML support.
The course is based on the criteria needed for the Microsoft exam, and
he takes you step by step over the material you must know, including creating
a database and tables. You will learn about data integrity, including
primary and foreign keys and constraints, using Transact SQL to retrieve
and modify data, how to import and export data, and how to link servers
together. Once you have that down, move onto programming business logic
and topics such as creating, executing, and altering stored procedures.
Mark Long finishes the course by teaching you how to optimize access to
your data with indexes, query optimizer, and SQL profiler. Find out more
by watching our Microsoft SQL Server tutorials online.
This training course is designed for fast learning and covers all the
fundamental points of the application, all cds work on a mac or pc and
no application is needed.
The links below are free Microsoft SQL Server
2000 Database Programming tutorials. The entire contents may be purchased
either on CD or watched via the Online University
A Few Words About SQL Server
 What
Is SQL Server?
SQL
Server Mystique
Transact
SQL
SQL
Server History
Overview
Overview
of Course
General Database Information
Main
Purpose of a Database
What
Makes Up a Database
Two
Main Types of Databases
Normalization
Denormalization
Database
Relationships
Indexes
Proper
Design
General Administrative Responsibilities
Real World Administration
Designing/Building Databases
Data Maintenance/Transfer
Backup/Restore of Data
Security
Hardware Requirements
Minimum Hardware Requirements
Hardware Compatibility
Optimizing Hardware for SQL Server
Installing SQL Server 2000
SQL Server 2000 Editions
Licensing
Multiple Instances
Choosing a Security Mode
Collation and Sort Selection
Network Libraries
Installation Methods
Upgrading to SQL Server 2000
Default Databases
Installation
Troubleshooting an Installation
SQL Server Security
Security Overview
Authentication Modes
Roles
Assigning Permissions
Application Roles
System Services
SQL Services
SQL Services Issues
System Databases
System Databases
Sample Databases
Data Storage
How SQL Stores Data
Fillfactor
File and Log Location/Management
Administrative Tools
Overview of Admin Tools
Exam Considerations
Enterprise Manager
Microsoft Management Console
Opening & Customizing the Enterprise Mgr
Using the Enterprise Manager
Query Analyzer
Opening and Exploring the QA
Issuing Queries Using the QA
Query Analyzer Features
Graphical Query Plan
Transact-SQL Select Statement
Using a Select Statement
Basic Syntax
Select Options
Important Select Considerations
Transact-SQL Insert Statement
Using an Insert Statement
Basic Syntax
Insert Options/Considerations
Transact-SQL Update Statement
Using the Update Statement
Basic Syntax/Options
Important Update Considerations
Transact-SQL Delete Statement
Using the Delete Statement
Basic Syntax/Important Considerations
Creating a Database
Using the Create Database Statement
Database Properties and Options
Database Creation Considerations
Managing File Growth
Shrinking Database Files
Sizing the Database
Importance of Good Design
Transaction Logs
How Transaction Logs Work
What Transactions Look Like
Location / Location / Location
Advantages of Using Transaction Logs
Transaction Log Options
Filegroups
What Are Filegroups?
Advantages of Filegroups
Disadvantages of Filegroups
Microsoft's Recommendation on Filegroups
RAID & SQL
RAID Basics
SQL and RAID
SQL Profiler
What SQL Profiler Does
Opening SQL Profiler
Using SQL Profiler
Operators
What are Operators?
Creating an Operator
Considerations When Using Operators
Jobs
Automating SQL Server
Mail Enabling SQL Server 2000
Creating a New Job
Scheduling a Job
Job Notifications
Starting/Stopping a Job
Multi Server Jobs
Viewing Job History
Alerts
What are Alerts
Performance Alerts
User Defined Alerts
Disabling Alerts
Considerations When Using Alerts
Linked Servers
Using SQL In a Distributed Environment
Referring to SQL Server Objects
Setting Up a Linked Server Relationship
Database Backups
Backup Strategy
Database Recovery Models
SQL Server Backup
Who When and Where
System Databases
User Databases
Performing a Backup
Using Multiple Devices
SQL Backup Statement
Tape Backup
Backup Types
Transaction Log Backups
File and Filegroup Backups
Full Backup Strategy
Differential Backup Strategy
Backup Review
Restoring Data
SQL Server Recovery Process
Preparing to Restore a Database
The SQL Restore Statement
Restore Options
Restoring Transaction Logs
Restoring System Databases
Bottom Line on Restoring Data
Maintaining High Availability
Determining Requirements
Clustering
Standby Servers
Log Shipping
Data Transformation Services
Importing and Exporting Data
SQL Data Transport Tools
DTS Overview
Creating a DTS Package
More DTS Package Functionality
Defining Transformation Tasks Creating
Using DTS in Various Ways
Monitoring SQL Server 2000
Performance Issues
Monitoring and Tuning Basics
Improving Performance
Common Monitoring Tasks and Tools
What To Monitor
Locks
Replication Basics
Dealing With Distributed Data
SQL Server Replication
SQL Server Replication Types
SQL Server Replication Models
Replication Agents
Web Based Data Applications
SQL Server Replication Notes
Course Wrap-Up
Value of SQL Server knowledge
Microsoft's MCDBA Certification
|
