|
 |
 |
Ready to Order? Order
online, call
1-800-578-2062
or
+44(0)1903 740 624 in Europe (UK). |
 |
|
 | Microsoft SQL Server 2008: Installing, Querying, and Security with Don Kiely
|
| View Course Outline | Print Course Outline (.PDF) 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.
More...
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
| SPECIAL OFFER: BUY 1 GET 1 FREE TRAINING! Details...
Hurry, offer ends 9/30/2010. Not valid on printed books. | | Format | Modules | Retail Price | | SQL Server 2008: Installing, Querying and Security | | CD-ROM | 10 CD-ROMs
ZS8C-CD-50 | | CD-ROM & Books | 10 CD-ROMs + Printed Books
KS8C-CD-50 | | DVD-ROM | 1 DVD-ROM
ZS8C-DV-50 | | DVD-ROM & Books | 1 DVD-ROM + Printed Books
KS8C-DV-50 | | Multi-User License | Need to train multiple users? Call 800-578-2062 to purchase additional user licenses for your AppDev Product. | | 100% Satisfaction Guaranteed. Details... |
| |
| | Course Outline (Outlines are subject to change.) |
| Microsoft SQL Server 2008: Installing, Querying, and Security | | Modules | 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 how to…
- 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 presenter for AppDev, 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
|
|
|
