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.

AUDIENSE

√		Software Process Architects		√		QA/Test Managers		√		Development Managers
√		Business Analysts		√		QA User Testers		√		Software Developers
√		Project Managers		√		QA Code Testers		X		User Education Specialist

prerequisites

»

Basic knowledge of software engineering

course materials

A comprehensive workbook with knowledge material, examples, case studies, lab exercises, and references.

Course outline

• Introduction to SQL Server

  Outline
  Lesson 1: SQL Server Basics
  • Client-Server database architecture and SQL Server architecture
  • Tables, relational databases, SQL and database objects
  Lesson 2: Understanding Tables and Databases
  • Creating databases manually
  • Creating databases with database wizard
  Lesson3: Indexes and Views
  • The basics of index structures
  • Creating and working with indexes
  • Indexes and table architecture
  Lesson 4: Database Diagrams, The Query Analyzer and SQL Basics
  • Working with diagrams
  • Diagramming for pubs database
  • Server connectivity and Sscreen management
  Lesson 5: Stored Procedures, Triggers and Replication
  • Components of stored procedures
  • Creating and working with stored procedures/system stored procedures
  Lesson 6: Data Transformation Services (DTS), Back Ups/Restores, Users, Roles, Logins and Analysis Manager
  • Creating, importing and exporting DTS
  • Creating, scheduling backups and restores
  Prerequisites
  None

  Certification
  
  Participants receive an industry recognized New Image College of Design and Technology Certificate after completing the course.
  
  Tuition
  
  Introduction to SQL Server
  Course duration 6 hours .
  Course Start: November-December, 2014
  
  Price: $559 CAD +  $72.67 HST                 
  Total: $631.67 CAD
  
  You pay $ 250.00 CAD to reserve your spot.
  
  
  up>>
  

 

 

 

 

 

 

 

 

 

 

 

"Avoiding a bug is more cost-effective rather finding it later and fixing"

 

"Quality is never an accident; it is always the result of intelligent effort." -- John Ruskin

Bill Gates recently said of Microsoft "We have as many testers as we have developers. And developers spend half their time testing. We're more of a testing organization than we're a software organization."

*IMPORTANT NOTE:
These short-term courses do not constitute comprehensive IT training leading to proficiency, which takes several months to accomplish. They are regarded as continuing computer education; they serve to update your current computer and IT technology knowledge.