 |
 |
 |
|
"An excellent class! The right level of detail at the right time. I now fully understand everything that, heretofore, I've muddled through in my application development activities at work."
"It was fantastic! Best class I've ever gone to and I've attended my share with other training companies."
"Jim is excellent at maintaining class attention throughout the highly informative sessions."
|
|
|
 |
|
 |
|
 |
 |
 |
|
|
|
SS2300: Implementing SQL Server 2008
|
|
|
Registration: Click here to register for this class.
Duration: 4 Days
Prerequisites: The person taking this course should have some knowledge of database systems including relational database design.
In this hands-on, instructor-led course attendees learn how to implement an SQL Server 2008 database. This course is excellent for an Access or FoxPro programmer who wants to learn how to use a database server. Also ideal for a mainframe programmer who needs to downsize to a PC client/server topology and needs to learn how to use a relational database management system. Visual Basic programmers will learn how to upsize from an Access database to a professional database server.
Relational Database Systems
Relational Algebra
Terms and Concepts
Structured Query Language overview
Normalizing a Database
What is normalization
Steps you take to normalization
Advantages and Disadvantages
SQL Server Overview
What is SQL Server
Hardware & OS support
Features of SQL Server
Additional Tools in SQL Server
Creating a SQL Server Database
Creating databases
Transaction logs
Using file groups
Capacity planning
Creating Tables
SQL Server field types
Creating tables
Creating defaults
Adding data to tables
Creating Constraints and Indexes
Creating Constraints
CHECK
Primary Key
Foreign Key
Defaults
Using the Database Diagram tool
Creating Indexes
Data Retrieval
ANSI SQL 92 standard
Using the SQL Query Analyzer
SELECT statement
WHERE clause
DISTINCT
Calculated columns
Null
Sorting data with ORDER BY
Advanced Queries
Group By Having
Top N percent
CUBE
ROLLUP
Distributed queries
Joining Tables
Joins in SQL Server
Equi-join
Inner Join
Left (Outer) Join
Right (Outer) Join
Subqueries
Self-Joins
Union
Data Modification
Inserting data
Updating data
Deleting data
Subqueries
System Functions & Variables
Aggregate functions
Date functions
Mathmatical functions
String functions
System functions
Convert function
User Defined Functions
System Variables
Stored Procedures
Creating stored procedures
Executing stored procedures
Using parameters with stored procs
Returning values from stored procs
Business rules in stored procs
Using Cursors
Triggers and Views
Creating triggers
Triggers for referential integrity
Triggers to update calculated fields
Creating views
Updating through views
Indexed Views
Locking issues
Optimistic and Pessimistic locking
Automatic locks
Isolation levels
Locking hints
Transactions
What is a transaction
BEGIN TRANS
COMMIT TRANS
ROLLBACK TRANS
Nesting transactions
Transactions and locking
Data Transfers
Bulk copy procedure (BCP)
BULK INSERT
Data Transformation Services (DTS)
Full Text Searches
Setting options to full text search
Creating full text indexes
Administering the indexes
Performing searches
Using XML in SQL Server
Why Use XML?
Setting up a Virtual Root
Retrieving XML Documents
Modifying Data in SQL Server
Retrieving XML from SQL Server
Optimization
Hardware
Memory
Query Optimization
Indexes
I/O Statistics
SHOWPLAN
Tuning tempdb
SQL Server Profiler
DBCC SHOWCONTIG
SHOWPLAN (TEXT and ALL)
Updating Statistics
Tips and Tricks
Proper Index usage
Proper primary key usage
Proper field usage
Normalization tricks
Database naming standards |
|
|
 |
|
 |
|
|