Course Title: Microsoft SQL Server 2000 Admin
Virtual Training CompanyÕs Microsoft SQL Server 2000 Admin tutorial is just what you need to learn how to administer SQL Server in the real world and to help you prepare for the Microsoft Certification Exam 70-228. Mark Long, a Microsoft certified instructor, will teach you installation and building and backing up databases. He begins with general information about databases and general administrative responsibilities. He will then instruct you on the specifics of the administration of SQL Server 2000, such as installation, data storage, and file groups. You will learn the two main administrative tools, enterprise manager and query analyzer, through real-life examples. In this tutorial, you will also learn how to automate the administration and how to monitor the SQL server. To start learning right away, click on one of the movie topics below.
Course Author/Expert: Mark Long / Certified Instructor
Language: english
Full Online Training Available: Yes
Number of Course Movies: 154
Course Duration: 10 hours
Never has it been so easy to learn Microsoft SQL Server 2000 Admin.
No expensive classroom training courses.
No boring hard to follow books to read.
Learn from your own desk at a pace that suits you.
High quality affordable training that is easy to use and follow.
Use unique training methods, it makes learning easy no matter what your learning style.
Course Outline:
The FIRST THREE chapters of this online training course can be viewed right now!
Click Here Now To View the First Three Chapters of Microsoft SQL Server 2000 Admin Online Training For Free
If you then need all the lessons or complete access to over seven hundred different courses then join the online university for as long as you need them and even get an online university certificate.
01 A Few Words About SQL Server
0101 What Is SQL Server?
0102 SQL Server Mystique
0103 Transact SQL
0104 SQL Server History
02 Overview
0201 Overview of Course
03 General Database Information
0301 Main Purpose of a Database
0302 What Makes Up a Database
0303 Two Main Types of Databases
0304 Normalization
0305 Denormalization
0306 Database Relationships
0307 Indexes
0308 Proper Design
04 General Administrative Responsibilities
0401 Real World Administration
0402 Designing/Building Databases
0403 Data Maintenance/Transfer
0404 Backup/Restore of Data
0405 Security
05 Hardware Requirements
0501 Minimum Hardware Requirements
0502 Hardware Compatibility
0503 Optimizing Hardware for SQL Server
06 Installing SQL Server 2000
0601 SQL Server 2000 Editions
0602 Licensing
0603 Multiple Instances
0604 Choosing a Security Mode
0605 Collation and Sort Selection
0606 Network Libraries
0607 Installation Methods
0608 Upgrading to SQL Server 2000
0609 Default Databases
0610 Installation
0611 Troubleshooting an Installation
07 SQL Server Security
0701 Security Overview
0702 Authentication Modes
0703 Roles
0704 Assigning Permissions
0705 Application Roles
08 System Services
0801 SQL Services
0802 SQL Services Issues
09 System Databases
0901 System Databases
0902 Sample Databases
10 Data Storage
1001 How SQL Stores Data
1002 Fillfactor
1003 File and Log Location/Management
11 Administrative Tools
1101 Overview of Admin Tools
1102 Exam Considerations
12 Enterprise Manager
1201 Microsoft Management Console
1202 Opening & Customizing the Enterprise Mgr
1203 Using the Enterprise Manager
13 Query Analyzer
1301 Opening and Exploring the QA
1302 Issuing Queries Using the QA
1303 Query Analyzer Features
1304 Graphical Query Plan
14 Transact-SQL Select Statement
1401 Using a Select Statement
1402 Basic Syntax
1403 Select Options
1404 Important Select Considerations
15 Transact-SQL Insert Statement
1501 Using an Insert Statement
1502 Basic Syntax
1503 Insert Options/Considerations
16 Transact-SQL Update Statement
1601 Using the Update Statement
1602 Basic Syntax/Options
1603 Important Update Considerations
17 Transact-SQL Delete Statement
1701 Using the Delete Statement
1702 Basic Syntax/Important Considerations
18 Creating a Database
1801 Using the Create Database Statement
1802 Database Properties and Options
1803 Database Creation Considerations
1804 Managing File Growth
1805 Shrinking Database Files
1806 Sizing the Database
1807 Importance of Good Design
19 Transaction Logs
1901 How Transaction Logs Work
1902 What Transactions Look Like
1903 Location / Location / Location
1904 Advantages of Using Transaction Logs
1905 Transaction Log Options
20 Filegroups
2001 What Are Filegroups?
2002 Advantages of Filegroups
2003 Disadvantages of Filegroups
2004 Microsofts Recommendation on Filegroups
21 RAID & SQL
2101 RAID Basics
2102 SQL and RAID
22 SQL Profiler
2201 What SQL Profiler Does
2202 Opening SQL Profiler
2203 Using SQL Profiler
23 Operators
2301 What are Operators?
2302 Creating an Operator
2303 Considerations When Using Operators
24 Jobs
2401 Automating SQL Server
2402 Mail Enabling SQL Server 2000
2403 Creating a New Job
2404 Scheduling a Job
2405 Job Notifications
2406 Starting/Stopping a Job
2407 Multi Server Jobs
2408 Viewing Job History
25 Alerts
2501 What are Alerts
2502 Performance Alerts
2503 User Defined Alerts
2504 Disabling Alerts
2505 Considerations When Using Alerts
26 Linked Servers
2601 Using SQL In a Distributed Environment
2602 Referring to SQL Server Objects
2603 Setting Up a Linked Server Relationship
27 Database Backups
2701 Backup Strategy
2702 Database Recovery Models
2703 SQL Server Backup
2704 Who When and Where
2705 System Databases
2706 User Databases
2707 Performing a Backup
2708 Using Multiple Devices
2709 SQL Backup Statement
2710 Tape Backup
2711 Backup Types
2712 Transaction Log Backups
2713 File and Filegroup Backups
2714 Full Backup Strategy
2715 Differential Backup Strategy
2716 Backup Review
28 Restoring Data
2801 SQL Server Recovery Process
2802 Preparing to Restore a Database
2803 The SQL Restore Statement
2804 Restore Options
2805 Restoring Transaction Logs
2806 Restoring System Databases
2807 Bottom Line on Restoring Data
29 Maintaining High Availability
2901 Determining Requirements
2902 Clustering
2903 Standby Servers
2904 Log Shipping
30 Data Transformation Services
3001 Importing and Exporting Data
3002 SQL Data Transport Tools
3003 DTS Overview
3004 Creating a DTS Package
3005 More DTS Package Functionality
3006 Defining Transformation Tasks Creating
3007 Using DTS in Various Ways
31 Monitoring SQL Server 2000
3101 Performance Issues
3102 Monitoring and Tuning Basics
3103 Improving Performance
3104 Common Monitoring Tasks and Tools
3105 What To Monitor
3106 Locks
32 Replication Basics
3201 Dealing With Distributed Data
3202 SQL Server Replication
3203 SQL Server Replication Types
3204 SQL Server Replication Models
3205 Replication Agents
3206 Web Based Data Applications
3207 SQL Server Replication Notes
33 Course Wrap-Up
3301 Value of SQL Server knowledge
3302 Microsofts MCDBA Certification
To continue your learning, Click Here for the Online University and get access to all of the training courses, that's over 550 software programmes including 60,000 tutorial videos, for editing, image manipulation and graphics programmes. All for just $30 (approx £16) month. Unlimited access for as long as you need, cancel when you're finished, no contract, no minimum period, no hassle.
or
Click Here and we'll send you the training CD itself for Microsoft SQL Server 2000 Admin at £79.95
|
|
Add latest courses to Google Toolbar