|
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
Week 2: Understanding Tables and Databases
Week 3: Indexes and Views
Week 4: Database Diagrams, The Query Analyzer and SQL Basics
Week 5: Stored Procedures, Triggers and Replication
Week 6: Data Transformation Services (DTS), Back Ups/Restores, Users, Roles, Logins and Analysis Manager
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
|
|
|||||||||||||||||||||||||||||||||||||||
Introduction to SQL Server
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.
Testimonials
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
