Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Order CD-ROMs   Order Videos 
Microsoft SQL Server 2008: Installing, Querying, and Security
with Don Kiely


View the Course Outline

In this course, you'll learn about the components that make up the comprehensive SQL Server 2008 product and the various editions that Microsoft makes available, so that you can select the right one.

Course includes 30+ hours of total training time...

  • 10 modules of training
  • Over 10 hours of media run time
  • Over 450 pages of printable courseware
  • Step-by-step hands-on-labs
  • Sample code
Format Sessions Retail Price
SQL Server 2008: Installing, Querying and Security
CD-ROM

 10 CD-ROMs

$495.00  
CD-ROM & Books

 10 CD-ROMs + Printed Books

$615.00  
DVD-ROM

 1 DVD-ROM

$495.00  
DVD-ROM & Books

 1DVD-ROM + Printed Books

$615.00  
Read about Don Kiely. .
Course Outline (Outlines are subject to change.)
Microsoft SQL Server 2008: Installing, Querying, and Security

Sessions Run Time Pages
10 10 hours 450

In this course, you'll learn about the components that make up the comprehensive SQL Server 2008 product and the various editions that Microsoft makes available, so that you can select the right one. You'll learn about installation and upgrade issues, about some of the many configuration choices available to customize it to your needs and environment, as well as how to tweak it after installation. Then you'll learn how to work with database objects and data, using Management Studio and other tools, as well as Transact SQL (T-SQL), the programming language of SQL server. You'll learn about the features in T-SQL for querying, inserting, updating, and deleting data, as well as the rich support in T-SQL for various data-based operations. The course finishes up with a comprehensive look at security, both to help you secure your server and data from unauthorized use as well as to avoid security hurdles as you administer and develop applications that use the server and its data.

In this course you will learn...
  • Understand the differences between the available editions of SQL Server 2008.
  • Prepare for a SQL Server 2008 installation.
  • Upgrade from an earlier version of SQL Server to SQL Server 2008.
  • Configure the server after installation..
  • Create a SQL Server database based on sound design principles.
  • Build tables using the SQL Server Management Studio designers.
  • Create constraints, triggers, and indexes.
  • Create a Database Diagram to enforce referential integrity.
  • Use Transact-SQL INSERT, UPDATE and DELETE statements.
  • Apply transaction isolation levels to affect performance and concurrency.
  • Configure and use SQL Server Management Studio (SSMS).
  • Use Transact-SQL with data types, delimiters and variables.
  • Understand potential data threats and how SQL Server is designed to protect against them.

A Tour of SQL Server 2008

  • SQL Server 2008 Editions, Components, and Tools
  • Using SQL Server Management Studio (SSMS)
  • Working with Tables, Queries, Views
  • Business Intelligence Services
Installing SQL Server 2008
  • Preparing for Installation
  • Upgrading an Earlier Version
  • Installation Steps
  • Configuring the Server
Designing and Creating a Database
  • Relational Database Design Principles
  • Implementing the Design
  • Create a SQL Server Database
  • Create SQL Server Tables
  • Creating Relationships Using a Database Diagram
Data Selection
  • Understanding Transact-SQL
  • The SELECT Statement
  • The WHERE Clause
  • Using ORDER BY to Sort Data
  • The GROUP BY Clause
  • Joining Tables
Modifying Data
  • Modifying Data with Transact-SQL
  • Inserting Data
  • Updating Data
  • Understanding Transaction Isolation
Working with SQL Server Management Studio
  • Getting Started with Management Studio
  • Exploring the Object Explorer
  • Working with the Query Editor
  • Using SQL Server Books Online
Transact-SQL Programming
  • Overview of Transact-SQL
  • Using Built-In Functions
  • Using Control of Flow Constructs
Understanding and Implementing Security
  • Security Overview
  • Authentication
  • Authorization
  • Data Encryption
  • Security Epilog

back to top


Your Instructor

Don Kiely has been using and programming computers since the mid-1970s, when he first punched IBM punch cards for batch processing to solve engineering problems. Now Don is a nationally recognized author, instructor and consultant who travels the country sharing his expertise in SQL Server and security. He has written business software using assembly, C/C++, dBASE, Nantucket Clipper, RPG II, C#, and Visual Basic for a variety of industries, and has taught software and business administration courses at community colleges. Now Don is an author and a consultant for a variety of companies that develop distributed applications for public and private organizations. Don is also the author or coauthor of several programming books, and a featured speaker at SQL Server conferences.

back to top


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy