SQL Server Developer Online Training

Home / SQL Server Developer Online Training

SQL Server Developer Online Training Course

Duration: 5-6 Weeks

A Tour of SQL Server 2008
  • SQL Server 2008 Editions, Components, and Tools
  • Using SQL Server Management Studio (SSMS)
  • Working with Tables and Queries
  • New Transact-SQL Features
  • 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
Data Selection Queries
  • 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
  • Inserting Data
  • Updating Data
  • ·Deleting Data
  • Understanding Transaction Isolation
Working with SQL Server Management Studio
  • Getting Started with SSMS
  • Exploring the Object Explorer
  • Working with the Query Editor
Transact-SQL Programming
  • Overview of Transact-SQL
  • Using Built-In Functions
  • Controlling Flow
  • Ranking Results
Transactions and Error Handling
  • Transaction Concepts
  • Using TRY/CATCH Error Handling
Creating Views, Stored Procedures, Cursors and Triggers
  • What Is a View?
  • Creating Views
  • Creating Stored Procedures
  • Creating Cursors
  • Creating Triggers
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
Advanced Query Techniques
  • Generating XML with FOR XML
  • Using APPLY
  • Creating Recursive Queries
  • Creating Pivot Queries
  • Executing Dynamic SQL
Understanding and Implementing Security
  • Security Overview
  • Authentication
  • Authorization
  • Permissions
Analyzing and Tuning Performance
  • Evaluating Performance
  • Monitoring with SQL Server Profiler
  • Tuning Queries
  • Indexes