 |
Please contact us
for GSA pricing.
Contract #
GS-35F-0307T
Recent Training Venues Accelebrate has recently trained for clients in the following cities:
- Huntsville, Alabama
- Montgomery / Birmingham, Alabama
- Anchorage, Alaska
- Edmonton & Calgary, Alberta
- Phoenix, Arizona
- Tucson, Arizona
- Fayetteville / Little Rock, Arkansas
- Amsterdam, The Netherlands / Brussels, Belgium
- Vancouver, British Columbia
- Oakland / San Jose / San Francisco, California
- Sacramento, California
- San Diego, California
- Orange County / Los Angeles, California
- Boulder / Colorado Springs / Denver, Colorado
- Washington, DC
- Wilmington, Delaware
- Manchester / London, England
- Orlando, Florida
- Fort Lauderdale / Miami, Florida
- Jacksonville, Florida
- Saint Petersburg / Tampa, Florida
- Alpharetta & Atlanta, Georgia
- Augusta & Savannah, Georgia
- Boise, Idaho
- Chicago, Illinois
- Indianapolis, Indiana
- Cedar Rapids / Des Moines, Iowa
- Dublin, Ireland
- Wichita, Kansas
- Lexington / Louisville, Kentucky
- Baton Rouge/New Orleans, Louisiana
- Portland, Maine
- Hagerstown & Frederick, Maryland
- Annapolis / Baltimore, Maryland
- Boston / Cambridge, Massachusetts
- Hartford, Connecticut / Springfield, Massachusetts
- Ann Arbor / Detroit, Michigan
- Grand Rapids, Michigan
- Saint Paul / Minneapolis, Minnesota
- Jackson, Mississippi
- St. Louis, Missouri
- Kansas City, Missouri
- Lincoln / Omaha, Nebraska
- Reno and Las Vegas, Nevada
- Fredericton / Moncton / Saint John, New Brunswick
- Albuquerque, New Mexico
- Princeton, New Jersey & Philadelphia, Pennsylvania
- Albany, New York
- Buffalo, New York
- White Plains / New York City, New York
- Charlotte, North Carolina
- Durham / Raleigh, North Carolina
- Canton / Akron, Ohio
- Cincinnati, Ohio
- Cleveland & Columbus, Ohio
- Dayton, Ohio
- Tulsa / Oklahoma City, Oklahoma
- Toronto, Ontario
- Portland, Oregon
- Pittsburgh, Pennsylvania
- San Juan, Puerto Rico
- Providence, Rhode Island
- Saskatoon / Regina, Saskatchewan
- Edinburgh / Glasgow, Scotland
- Columbia & Charleston, South Carolina
- Spartanburg & Greenville, South Carolina
- Knoxville, Tennessee
- Memphis / Nashville, Tennessee
- Houston, Texas
- El Paso, Texas
- San Antonio / Austin, Texas
- Dallas, Texas
- Salt Lake City, Utah
- Fairfax / Dulles / McLean / Herndon / Reston, Virginia
- Richmond / Alexandria / Arlington, Virginia
- Virginia Beach / Norfolk, Virginia
- Tacoma / Seattle, Washington
- Charleston, West Virginia
- Madison / Milwaukee, Wisconsin
|
|
|
SQL Server Training: Introduction to Microsoft SQL Server 2000 Administration |
Course Number: SQL-100
Duration: 5 days
view class outline
Looking for SQL Server 2005 Administration training?
Microsoft SQL Server 2000 Administration Training Overview
Accelebrate's Introduction to SQL Server 2000 training teaches attendees the skills they need to successfully build, administer, and query Microsoft SQL Server 2000 databases.
Accelebrate also offers an Advanced Microsoft SQL Server 2000 training class.
Location and Pricing
Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.
In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=category&page=mssql.
Microsoft SQL Server 2000 Training Prerequisites
No prior experience is presumed.
Hands-on/Lecture Ratio
This class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 10 minutes.
Microsoft SQL Server 2000 Training Materials
All students will receive:
- More than 600 pages of fully-illustrated courseware
- A copy of SQL Server 2000 Unleashed
Software Needed on Each Student PC
- Windows 2000, XP, or Windows 2003 Server with latest service pack(s) installed
- SQL Server 2000 SP4 or later SP (full installation)
Microsoft SQL Server 2000 Training Objectives
All attendees will learn to:
- Use the programming environment in the Query Analyzer and learn the Transact-SQL language.
- Understand the differences between view, stored procedures, triggers, and user-defined functions, and know the advantages and drawbacks of each.
- Design and implement reliable backup and maintenance plans.
- Understand the SQL Server security model; and create logins, users and permissions to protect your data.
- Configure and tune SQL Server, and monitor database activity
|
Microsoft SQL Server 2000 Training Outline (happily customized upon request)
- SQL Server Tour
- SQL Server Editions
- Graphical Tools
- Exploring the Enterprise Manager
- Working with SQL Server Books Online
- Installing SQL Server
- Multiple Instances
- Installing an Instance of SQL Server
- Configuring the Server
- Designing and Creating a Database
- Relational Database Design Principles
- Implementing the Design
- Basic Querying
- Introduction to the Query Analyzer
- Retrieving Data
- Joining Tables
- Action Queries
- Modifying Data
- Inserting Data
- Updating Data
- Deleting Data
- Using the Query Analyzer
- Query Analyzer Features
- The File Menu Items
- The Edit Menu
- Query Menu Items
- Tools Menu Items
- Window Menu Items
- Help Menu Items
- Programming With Transact-SQL
- Overview of Transact-SQL
- Using Built-In Functions
- Programming With Transact-SQL
- Control of Flow
- Error Handling
- Transaction Processing
- Transactions
- Working with Locks
- Monitoring Processes and Locks
- Transaction Isolation
- Blocking and Deadlocks
- Creating Views
- What is a View?
- Creating Views
- Updating Views
- Backups and Maintenance
- Creating a Backup Strategy
- Implementing Backups
- Restoring from a Backup
- The Database Maintenance Plan Wizard
- Stored Procedures and Triggers
- Building Stored Procedures
- Building Triggers
- Using INSTEAD OF Triggers
- User-Defined Functions
- User-Defined Functions in SQL Server 2000
- Scalar Functions
- Inline Table-Valued Functions
- Multi-Statement Table-Valued Functions
- Functions, Views, and Stored Procedures
- Advanced Queries and Linked Servers
- Dynamic SQL
- Transact-SQL Cursors
- Handling Large Data Sets
- Distributed Queries
- Security
- Security Overview
- Authentication
- Understanding Roles
- Assigning Permissions
- Application Roles
- Monitoring, Tuning, and Configuration
- Evaluating Performance
- Monitoring with SQL Server Profiler
- Tuning Queries
- Working with Indexes
- Indexed Views
- Using the Index Tuning Wizard
- Data Caching
- The System Monitor
- Using System Objects
- Exploring System Objects
- DBCC
- Automating Administration with SQL Agent
- Configuring SQL Server Agent
- Operators
- Jobs
- Alerts
- Create an Alert
- Conclusion
|
| |
Java® and all Java-based marks are registered trademarks of the Oracle Corporation in the U.S. and other countries.
|
|
Accelebrate®
Focuses on You! |
|
Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.
Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.
For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.
|
|
|
|
The class exceeded my expectations. 
