|
|
|
Microsoft SQL Server is a Relational Database Management System (RDBMS) designed to run on platforms ranging from laptops to large multiprocessor servers. SQL Server is commonly used as the backend system for websites and corporate CRMs and can support thousands of concurrent users.
SQL Server comes with a number of tools to help you with your database administration and programming tasks.
SQL Server is much more robust and scalable than a desktop database management system such as Microsoft Access. Anyone who has ever tried using Access as a backend to a website will probably be familiar with the errors that were generated when too many users tried to access the database.
Although SQL Server can also be run as a desktop database system, it is most commonly used as a server database system.
 Microsoft SQL Server is an application used to create computer databases for the Microsoft Windows family of server operating systems. Microsoft SQL Server provides an environment used to generate databases that can be accessed from workstations, the Internet, or other media such as a personal digital assistant (PDA).
SQL Server 2008 Training Objectives :
- Write and tune sophisticated T-SQL queries
- Work with SQL Server Management Studio
- Use T-SQL's programming features such as functions and control flow
- Implement transactions and error-handling
- Build stored procedures and triggers
- Embed .NET code in their databases using SQL CLR
- Use advanced query techniques such as recursive queries, pivot queries, and full text search
SQL Server 2008 Training Outline :
|
|
 An Introduction of SQL Server 2008
|
 SQL Server 2008 Editions, Components, and Tools
Using SQL Server Management Studio (SSMS)
Working with Tables, Queries, and Views
Business Intelligence Services
|
|
|
|
Designing and Creating a Database
|
Relational Database Design Principles
Implementing the Design
|
|
|
|
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
Controlling Flow
Ranking Results
|
|
|
|
Transactions and Error Handling
|
Transaction Concepts
Applications and Transactions
Creating Explicit Transactions
Using TRY/CATCH Error Handling |
|
|
|
Data Selection Queries
|
Understanding Transact-SQL
The SELECT Statement
The WHERE Clause
Using ORDER BY to Sort Data
The GROUP BY Clause
Joining Tables |
|
|
|
Advanced Data Types
|
Introduction
The HierarchyID Data Type
Sparse Columns and Column Sets
Filestream Storage
Spatial Data |
|
|
|
Complex Querying
|
Working with NULL Values
Ranking Grouped Data
Writing Correlated Sub-Queries
Using Common Table Expressions
|
|
|
|
Modifying Data
|
Modifying Data with Transact-SQL
Inserting Data
Updating Data
Deleting Data
Understanding Transaction Isolation |
|
|
|
Working with XML
|
The XML Data Type
XML Schema Collections
Querying XML
Best Practices |
|
|
|
Creating Views
|
What Is a View?
Creating Views
Updating Data Using a View
Using Computed Columns
Indexed Views
Partitioned Views |
|
|
|
Implementing SQL Server Partitions
|
Overview of Table-Based Partitions
Creating Partitioned Tables
Querying Partitions
Managing Partitions |
|
|
|
Creating User-Defined Functions
|
User-Defined Function Overview
Scalar Functions
Inline Table-Valued Functions
Multi-Statement Table-Valued Functions
Using Functions, Views, and Stored Procedures |
|
|
|
Creating Stored Procedures and Triggers
|
Creating Stored Procedures
Creating Triggers |
|
|
|
Advanced Query Techniques
|
Full-Text Search
Advanced T-SQL Techniques
Executing Dynamic SQL
|
|
|
|
Advanced Techniques
|
Complex Data and Structures
Writing More Efficient Queries
Working with Complex Queries
Maintaining Query Files |
|
|
|
|
| |
|
|
|
|