Introduction to SQL Server Course

This course details the basics of Microsoft SQL Server. Topics include: learning how to create and manipulate database objects such as tables, indexes, views, and triggers. Students will be introduced to the basics of using SQL Server on the Web.

Outline

Week 1: SQL Server Basics

Client-Server database architecture and SQL Server architecture
Tables, relational databases, SQL and database objects
Design and develop MS SQL Server databases and tables
Referencing objects in SQL Server databases
Obtaining information from database tables
SQL Server security

Week 2: Understanding Tables and Databases

Creating databases manually
Creating databases with database wizard
Defining a maintenance plan wizard
Databases using Transact-SQL
Database manipulation: characteristics and deletions
Working with tables

Week 3: Indexes and Views

The basics of index structures
Creating and working with indexes
Indexes and table architecture
Creating views (including using view manager)
Working with views
Indexed views

Week 4: Database Diagrams, The Query Analyzer and SQL Basics

Working with diagrams
Diagramming for pubs database
Server connectivity and Sscreen management
Working with queries
SQL essentials (select, create table, insert, delete, update)

Week 5: Stored Procedures, Triggers and Replication

Components of stored procedures
Creating and working with stored procedures/system stored procedures
Components of triggers
Creating and working with triggers
Replication model and types of replication
Merge replication

Week 6: Data Transformation Services (DTS), Back Ups/Restores, Users, Roles, Logins and Analysis Manager

Creating, importing and exporting DTS
Creating, scheduling backups and restores
Authentication types, users, roles, security plans
Configuring DSN, loading analysis manager and working with cubes
Work on a final project

Prerequisites

None

Requirements

MS SQL Server 2005 installed on a Windows computer. Download free SQL Server 2005 express edition at http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx

Books:
Required Book	Microsoft SQL Server 2005 Unleashed
Additional information:
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 might be required for the course. Read the Requirements and Book section for more information. Course fee does not include the book and software cost . How eClasses Work:Instructors post lectures (text-based, no video or audio), 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.

Price:

$220.00

IWA-HWG Price:

$120.00

Course No.:

MS331

Instructor:

Michael Crawley

Co-instructor/TA:

CEUs:

Duration:

6 weeks

Open Courses:

Start Date: Sep 13, 2010

Testimonials

Instructor's Profile:

Michael L. Crawley has over 25 years of information technology experience. He has mastered mainframe, client-server and mid-range systems computing and Relational Database Management Systems (RDBMs) throughout his career. He has worked with eCommerce RDBMs since the evolution of eCommerce. Michael is currently the President of Jenai Communications, a technology services, consulting and training company. He has the honor of being a member of the first Compaq Computer/Microsoft Corporation Designated Master Accredited Systems Engineer SQL Server team to achieve this distinct certification in the United States. Michael has a passion for reading, learning and teaching. Michael has been an instructor with ITT Technical Institute for several years.

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

Ratings

"A great class - i've picked up what i need to become more valuable at work. i'm now participating in conversations that meant little to me before, making my QA work more valuable to the company. Mike is an extremely positive person - i found that every time i logged in i found myself grinning. a relentlessly positive attitude was nice to be in contact with! Thanks Mike!" - Aaron Fineshriber

"Michael was dedicated throughout this course ensuring students understood the basic concepts of creating and manipulating database objects such as tables, indexes, views, and triggers using Microsoft SQL Server. He had numerous links to external resources within his lesson plans that helped to grasp an all around understanding of the chapters discussed. He answered questions in a timely manner and was encouraging throughout the course. I would recommend taking a class with Michael Crawley to other students. He's in the business of helping students succeed and reach their goals. I can't say the same for all of the classes I've taken here." - Mylene Daniels

"I've learned things that I am able to apply directly on my job--saving thousands in outside consulting fees. The assignments were difficult to fit into my busy schedule, but well worth the time." - Ronnie Streff

"I enjoyed the class, and Mike C, the instructor, was very helpful and of course, knowledgeable. The weekly assignments were effective and challenging; the structure of the course provided a good framework for me to work through the subject. An excellent intro to SQL." - Merle Mason

"The lecture notes/discussion were well structured and the assignments meshed well with the lecture/notes discussion. The book was more useful as a reference to facilitate the learning from the lecture notes/discussion rather than a sole source of course material. The instructor was enthusiastic and very knowledgeable of the subject matter. He did a very good job. It was a good class!" - Howard Liberman