SQL Server Training

SQL Server Tutorial
Class Name

SQL Server Design and Implementation

This is designed to be a hands on class in developing with SQL Server 2000 Enterprise Edition. Students will design, develop, and implement a database project of their choosing. This course would help prepare the student for a number of IT positions, including database developer, database administrator, IT consultant, and IT manager. People who want to gain an understanding how to develop and maintain SQL Server database would want to attend this class. The course contents is also covered in the some of the industry certification exams.
Outline
Week 1: Introduction to SQL Server
  • Overview of SQL Server
  • Components of SQL Server
  • Overview of SQL Server Architecture
Week 2: Designing a SQL Server Database
  • Introduction to Database Design
  • Planning a SQL Server Database
  • Identifying System Requirements
  • Developing a Logical Data Model
Week 3: Implementing SQL Server Databases and Tables
  • Creating and Maintaining a SQL Server Database
  • Identifying Data Types
  • Creating and Managing Tables
Week 4: Accessing and Modifying Data
  • Accessing Data in a SQL Server Database
  • Using Advanced Queries to Access Data
  • Modifying Data in a SQL Server Database
Week 5: Accessing and Modifying Data
  • Importing and Exporting Data
  • Using Distributed Queries to Access External Data
Week 6: Conclusion
  • Discuss any items of interest relating to SQL Server
Prerequisites
Students should have an understanding of relational databases, and should have some experience with client databases, such as Access.
Requirements
Software and System Requirements: These are the minimum system requirements for installing SQL Server 2000 Enterprise Edition. An evaluation version of SQL Server is available if the student does not have access to a database server running SQL Server.
Class Books
Course Price
  • Member Price: $120.00 US
  • Non-Member Price: $220.00 US
[Register Now]

Additional Information:
This online course is limited to 50 participants. Your place in the course is confirmed by your payment. Introductory courses are intended for students with no experience in the subject matter and are seeking beginner level training.

Refund Policy: Please read our "Terms and Refund Policy" before registering for this course.

Additional Cost: Book and software migh be required for the course. Read the Requirements and Book section for more information. Course fee does not include the book and software cost .

Start Date: Click on the Register Now button to process to the registration page. You will see the start date of the class on that page. To get the start date of other courses, click on Open Class List link on the top navigation bar.

How eClasses Work:The classroom environment is based on Lundeen & Associates Web Crossing technology, a threaded messaging system. Instructors post lectures, reading selections, and hands-on assignments once a week in the online classroom. Students can discuss the assignments with the instructor and amongst themselves in the classroom area. This format has no set meeting time, which allows students to attend class at a time most convenient to them, yet still provides logically organized communication between class participants. Students can apply for the completion certificate after finishing the class. Web Study certificate is also available. Click on the Certificates link on the top navigation bar for more information.

 

Register Now

Before you register for this class, please read carefully the Outline, Prerequisites, Requirements, Books, and Refund Policy sections.


4 Web Study Certificates

 Valid XHTML 1.0!  Valid CSS1!  Level Triple-A conformance icon, W3C-WAI Web Content Accessibility Guidelines 1.0

Main Topics of Our Web Training Program: