Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.
Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials please do not hesitate to contact us for help.
Expert author Mark Long prepares you for the Microsoft Certification Exam 70-228 by describing all the basic to advanced aspects at a very easy pace. This SQL Server tutorial has the aim of helping you learn how to administer, monitor and automate the MS SQL Server in the real world.
Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left
We hope you enjoyed the FREE lessons above. To view the complete contents, including the chapters below, please purchase the CD. CLICK HERE TO BUY THIS CD
General Administrative Responsibilities
Administration in the Real World
Creating Databases
Data Maintenance Explained
Backing up/Restoring Data
Security of Databases
Hardware Requirements
Chapter Overview
HW Compatibility
How to Optimise HW for SQL Server
How to Install SQL Server 2000
SQL Server 2000 Editions
Licensing
Multiple Instances Explained
Selecting a Security Mode
Collation and Sort Selection
Network Libraries Explored
Install Methods
Upgrade to SQL Server 2000
The Default Databases
Installation
Installation Troubleshoot
SQL Server Security
Chapter Overview
Authentication Modes
Roles in Security
Assigning Permissions
Application Roles Explained
System Services
SQL Services Overview
Issues for SQL Services
System Databases
Chapter Overview
Sample Databases
Data Storage
Chapter Overview and how SQL Stores Data
Fillfactor Overview
File and Log Location
Administrative Tools
Chapter Overview
Considerations for the Exam
Enterprise Manager
MS Management Console
Open and Customise the Enterprise Manager
Working with the Enterprise Manager
Query Analyzer
Query Analyzer Explored
How to Issue Queries with the Query Analyzer
Features of the Query Analyzer
Graphical Query Plan Explained
Transact-SQL Select Statement
Utilising a Select Statement
Simple Syntax
Select Options
Select Considerations to Take Note of
Transact-SQL Insert Statement
Utilising an Insert Statement
Simple Syntax
Inserting Options and Further Considerations
Transact-SQL Update Statement
Utilising the Update Statement
Simple Syntax/Options
Important Update Considerations
Transact-SQL Delete Statement
Utilising the Delete Statement
Simple Syntax/Important Considerations
Creating a Database
Utilising the Create Database Statement
Database Properties and Options Described
Considerations for Database Creation
Handling File Growth
How to Shrink Database Files
Sizing the Database - Step by Step
Practicing Good Design
Transaction Logs
Chapter Overview and how they work
What Transactions Look Like
The Importance of Location
Utilising Transaction Logs
Transaction Log Options Explained
Filegroups
Filegroups Explained
Filegroups - the Advantages
Filegroups - the Disadvantages
Microsoft's Recommendation on Filegroups
RAID & SQL
Chapter Overview
SQL and RAID
SQL Profiler
The Function of the SQL Profiler
Open the SQL Profiler
Utilising the SQL Profiler
Operators
Operators Explained
The Creation of an Operator
Using Operators - Considerations
Jobs
How to Automate an SQL Server
Mail Enabling SQL Server 2000
Create a New Job
Schedule a Job
Job Notifications Explained
How to Start and Stop a Job
Multi Server Jobs Explained
View Job History
Alerts
Alerts Explained
Performance and User Defined Alerts
Disabling Alerts
Using Alerts - Important Considerations
Linked Servers
SQL In a Distributed Environment
Refer to SQL Server Objects
How to Set Up a Linked Server Relationship
Database Backups
Backup Strategy Explained
Database Recovery Models Explored
SQL Server Backup Explored
Who, When and Where
System and User Databases - Lesson 1
System and User Databases - Lesson 2
Taking a Backup
Working with Multiple Devices
SQL Backup Statement Explained
Tape Backup - Step by step
Backup Types Explained
Transaction Log Backups
File Backups
Filegroup Backups
Full Backup Strategy
Differential Backup Strategy
Backup Summary
Restoring Data
The Process SQL Server Recovery
Restoring a Database - the Preparation
The SQL Restore Statement
Restore Options
Restoring Transaction Logs and System Databases
Bottom Line on Restoring Data
Maintaining High Availability
How to Determine Requirements
Clustering Explained
Standby Servers
Log Shipping
Data Transformation Services
Importing and Exporting Data
SQL Data Transport Tools Described
DTS Introduction
The Creation of a DTS Package
Further DTS Package Functionality
How to Define Transformation Tasks
Utilising DTS
Monitoring SQL Server 2000
Performance Surrounding Issues
Monitor and Tune - Fundamentals
How to Improve Performance
Common Monitoring Tasks and Tools
What To Monitor
Locks
Replication Basics
Dealing With Distributed Data SQL Server Replication:
• Overview
• Types
• Models
Replication Agents
Web Based Data App.
SQL Server Replication Notes
Course Summary
Value of SQL Server knowledge
MS MCDBA Certification
UK & Europe
Marrutt Software Training
Bellbrook Industrial Estate
Uckfield, East Sussex, TN22 1QL
United Kingdom
UK Tel: +44 (0) 1825 764057
UK Fax: +44 (0) 1825 768841
US & Canada
Marrutt Software Training
1133 Broadway, Suite 706
New York, NY 10010
United States
US Tel: 646-736-7932
US Fax: 646-895-7649
UK & Europe
US & Canada