SQL Server Development

SQL Server Development


    SQL Server Development Course Content:

    1.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

    2.Installing SQL Server 2008

    • Preparing for Installation
    • Upgrading an Earlier Version
    • Installation Steps
    • Configuring the Server

    3.Designing and Creating a Database

    • Relational Database Design Principles
    • Implementing the Design

    4.Data Selection Queries

    • Understanding Transact-SQL
    • The SELECT Statement
    • The WHERE Clause
    • Using ORDER BY to Sort Data
    • The GROUP BY Clause
    • Joining Tables

    5.Modifying Data

    • Modifying Data
    • Inserting Data
    • Updating Data
    • Deleting Data
    • Understanding Transaction Isolation

    6.Working with SQL Server Management Studio

    • Getting Started with SSMS
    • Exploring the Object Explorer
    • Working with the Query Editor

    7.Transact-SQL Programming

    • Overview of Transact-SQL
    • Using Built-In Functions
    • Controlling Flow
    • Ranking Results

    8.Transactions and Error Handling

    • Transaction Concepts
    • Using TRY/CATCH Error Handling

    9.Creating Views, Stored Procedures, Cursors and Triggers

    • What Is a View?
    • Creating Views
    • Creating Stored Procedures
    • Creating Cursors
    • Creating Triggers

    10.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

    11.Advanced Query Techniques

    • Generating XML with FOR XML
    • Using APPLY
    • Creating Recursive Queries
    • Creating Pivot Queries
    • Executing Dynamic SQL

    12.Understanding and Implementing Security

    • Security Overview
    • Authentication
    • Authorization
    • Permissions

    13.Analyzing and Tuning Performance

    • Evaluating Performance
    • Monitoring with SQL Server Profiler
    • Tuning Queries
    • Indexes

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • 1 month
    Contact Us

    +1 475-212-0075

    Drop us a query

    Error: Contact form not found.

    Job Support

    Error: Contact form not found.

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies