Web Design Training by IWA-HWG

Introduction to SQL Server

Introduction to SQL Server online course
Introduction to SQL Server Web Design Courses Web Certification Classes Home   

 

 

Class Name

Introduction to SQL Server

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.

Applicable Job Roles: web programmers, web application developers, and database administrator.

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 2008, or previous version, installed on a Windows computer. Download a free copy of Microsoft SQL Server 2008 R2 Express at http://www.microsoft.com/sqlserver/en/us/editions/express.aspx
Class Books

Required Book Microsoft SQL Server 2008 R2 Unleashed [
]
Course Price
  • Member Price: $120 US
  • Non-Member Price: $220.00 US
[Register Now]

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 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.

How eClasses Work: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

  • Member Price: $120 US
  • Non-Member Price: $220.00 US
  • Web Course No: MS331
  • Instructor: Michael Crawley
  • Co-instructor/TA:
  • CEUs: 3
  • Duration: 6 weeks
  • Session Open for Registration
Before you register for this class, please read carefully the Outline, Prerequisites, Requirements, Books, and Refund Policy sections.


4 Web Study Certificates
Privacy Policy | Classes Refund Terms| Help-FAQ | Introduction to SQL Server | Web Design Association | Webmaster Association | Web Design Courses
© 1994-2012 by the HTML Writers Guild
Headquarters: 119 E. Union St., Suite F, Pasadena, California.
MS331 course by IWA-HWG

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

Intro to DreamweaverAdvanced DreamweaverAdvanced Adobe Flash
Web Animation with Flash (Introductory)Adobe FireworksIntermediate Flash
Web VideographyContracting Your ServicesIntro to Apache Administration
Blog and Article WritingWeb Content WritingIntro to DNS
Intro to UNIXIntro to Web AnalyticsWordPress Theme Design
Intro to WordPressIntro to DrupalProject Management
Intro to Joomla!Intermediate Joomla!Logo Design
Website Project ManagementLegal Issues for Web Designers and Content ManagersSearch Engine Optimization
Web Site PromotionEmail Marketing and StrategiesIntro to Designing Accessible Websites
Design ConceptsIntro to Web DesignMobile Application UI Design
Photoshop Level 1Photoshop for the WebAdobe Illustrator
Adobe Illustrator Level 2Intro to HTMLHTML Level 2
Mobile Web DesignHTML5 IntroIntro to Cascading Style Sheets
Intermediate CSS WorkshopCSS 2.1 in DepthIntro to CSS3
Intro to XHTMLIntro to Database DesignIntro to SQL (Using Access)
Intro to SQL (Using MySQL)MySQLIntro to SQL Server
Intro to Programming ConceptsIntro to PHPShopping Cart Using PHP and MySQL
Intro to JSPIntro to ColdFusion Web DevelopmentIntermediate ColdFusion
Intro to JavaScriptIntermediate JavaScriptIntro to AJAX
Intro to jQueryJava for Non-ProgrammersProgramming in Java - Intro
Intermediate Java ProgrammingIntro to PerlIntro to C#
Intro to ASP.NET Web Development with C#Intro to Visual Basic.NETIntro to ASP
Intermediate ASPIntro to Web SecurityIntro to XML
Intermediate XMLIntro to Android App DevelopmentIntro to Game Production
Intro to Game Design and DevelopmentIntro to Flash Game ProgrammingIntro to C++ Using Games
Intro to Windows Game Programming Using C++3D Game Programming Using DirectX