HOME
 

Developing in SQL Server

STL
Course summary
Length: 5 days
Language: English
Location: Nationwide
Provider: STL plus
Course type: Company-Specific / In-House

Developing in SQL Server



Courses never cancelled. Last minute rescheduling. 24 month delegate support forum. And more... This course will enable delegates to program a SQL Server 2005 database. This includes developing in Transact-SQL. The course will cover the structure of a SQL Server 2005 database. Delegates will be able to create stored procedures, triggers, functions and views. ; ; The course will cover improving database performance by indexing tables and using SQL Servers inbuilt tools. The course will also look at the new features in SQL Server 2005 that are not available in SQL Server 2000.

Suitability - Who should attend?



This 5 day course is designed for those who are responsible for implementing database objects and programming SQL Server databases by using Transact-SQL.

Training Course Content



SQL Server 2005 Overview

SQL Server 2005 Components and Architecture
SQL Server 2005 Developer Tools
SQL Server 2005 Security Implementation

Language Features

SQL Server Programming Tools
Elements of Transact-SQL
SQL Server Object Names
Additional Language Elements:
1. Local Variables
2. Operators
3. Functions
Ways to Execute Transact-SQL Statements
New Transact-SQL (T-SQL) Features in 2005

Design A Database

Define Entities
Apply Normalisation
Database Objects
System Tables
Defining Databases
Setting Database Options
Managing Data and Log File Growth

Implement Tables

Create Tables
Adding and Dropping a Column
Generating Column Values
Adding Constraints

Access and Modify Data

Selecting Data
Using Sub Queries
Select Queries With Joins
Modifying Data
Importing Data To Tables
Writing And Reading XML

Implement View

Introduction to Views
Advantages of Views
Defining Views
Modifying Data Through Views
Optimizing Performance by Using Views

Implement Functions

What Is a User-defined Function?
Defining User-defined Functions
Types of User-defined Functions:
1. Scalar
2. Inline
3. Multi-statement

Implement Triggers

Introduction to Triggers
Defining Triggers
How Triggers Work
Examples of Triggers
Performance Considerations

Implementing Stored Procedures

What Is A Procedure?
Types Of Stored Procedure
Creating Stored Procedures
Declaring Parameters
Set Return Value In A Stored Procedure

Indexing Tables to Improve Performance

Introduction to Indexes
Index Architecture
How SQL Server Retrieves Stored Data
How SQL Server Maintains Index and Heap Structures
Deciding Which Columns to Index

Managing Transactions and Locks

Introduction to Transactions and Locks
Managing Transactions
SQL Server Locking
Managing Locks

Design and Administer Security Levels

Design security plan
Administer authentication
Administer authorisation
Administer permissions
Administer users, groups and roles

Data Access from Applications

ADO.NET architecture
Creating Windows-based applications that use ADO.NET
Connecting to a database
Creating a query
Using a DataSet object to manage data
Binding a DataGrid object to a data source

Using .NET Code in SQL Server 2005

Writing SQLCLR Code
SQLCLR Code Modules
Managing Code Modules
SQLCLR Security
T-SQL vs. .NET Code

Advanced Query Techniques

Full-Text Search
Storing and Processing XML
Using APPLY
Creating Recursive Queries
Creating Pivot Queries
Executing Dynamic SQL
The XML data type

Analyzing and Tuning Performance

Evaluating Performance
Monitoring with SQL Server Profiler
Tuning Queries
Indexes and Partitions
Using the Database Engine Tuning Advisor
Understanding SQL Server Performance Problems

Programming Replication

Overview of SQL Server Replication
Replication Programming Interfaces
Configuring Replication Synchronizing Data

Using Integration Services

Importing and Exporting Data
Integration Services Tools
Building a Package
Troubleshooting a Package

Introduction to Reporting Services

Understanding Reporting Services
Configuring Reporting Services
Building a Simple Report
Creating, Publishing, and Viewing Reports
Using and Managing Published Reports

Using XML Web Services

Web Service architecture
Web Service protocols
Consuming an XML Web Service
Building an XML Web Service

Expenses



Prices from £1400. Promotional rates often available the further ahead you book. Contact us for quote.

Provider: STL

STL - Microsoft Training

Best in-class training - Be delighted, not just satisfied

We're here to help - from using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch,  to leadership & development programmes. Other services include technical training, Microsoft, Oracle, Cisco, eLearning through to project management, Prince2, ITIL and more....


Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Developing in SQL Server.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for STL

STL

Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number
www.microsofttraining.net

Request information

Find out more about this Developing in SQL Server course - simply fill out your details:

 
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here