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
Conclusion