Jump to course:
iact

SQL Server 2008 – Development

Overview

This course teaches programmers how to create databases with Microsoft SQL Server to design and construct tables, create indexes and monitor the performance of database queries, and to programme stored procedures, triggers and user defined functions. Course participants are provided with a manual containing fully worked examples and explanations of the techniques covered in this course.

Overview
Introduction to SQL Server 2008. Overview of the SQL Server Management Studio. Overview of other tools and online help. Overview of Installation.

Creating SQL Server Databases
Creating a new database. Using file groups. Expanding and shrinking a database. Size and place of the transaction log.

Tables
Creating tables using the Management Studio and in Script. Creating a database diagram. Data types explained. Using the XML Data Type in tables.

Indexes, Constraints and Relationships
Creating and managing constraints and relationships. Indexes – Clustered and Non-clustered. How SQL Server optimises queries using indexes.

Querying Data
The SELECT statement. Column aliases and computed columns. ORDER BY and WHERE clause. Inner and outer joins, Unions. DISTINCT, GROUP BY and HAVING clauses. APPLY and PIVOT operators. Using XQuery and XPath when querying XML data.

Views
Creating, using, altering and managing views.

Using and Creating Functions
Understanding and using Built-in Functions. Scalar and table-valued functions. Using user-defined functions. Handling and Converting return types.

Stored Procedures
Creating and managing Stored Procedures. Declaring variables and parameters. Returning data and raising errors. By Value and By Reference Semantics in Stored Procedures.

Manipulating Data
Using INSERT, UPDATE and DELETE statements. Using functions to modify data. Using XML DML for changing data in XML data columns.
The Transact SQL (T-SQL) Language Operators. Comments. Functions (date and time, mathematical, aggregate string and system). Declaring variables. Conditional processing and looping. The CASE command. Comments and code structuring.

Triggers
Triggers explained, and guidelines their use. Update, insert and delete triggers. AFTER and INSTEAD OF triggers. DDL triggers.

Questions and Answers

An exposure to basic programming concepts such as variables, datatypes and conditional processing/looping is advantageous, as is a basic grasp of database terms such as tables, columns, rows. No prior exposure to database programming is required.
Course participants are provided with a manual containing fully worked examples and explanations of the techniques covered in this course.
Learn how to use DDL statements to CREATE, ALTER and DROP structural elements such as databases, tables, views, stored procedures, functions and triggers. Learn how to use DML statements to query, add, merge, alter, or delete data from tables. Learn advanced querying tips and tricks including built-in functions and more advanced T-SQL programming functionality.
Create and work with databases and data, with a large focus on querying and programming data access.

 3 Days

 

Course Testimonials

“The trainer’s knowledge of the subject matter was impeccable and this, matched with the very relevant course materials, ensured the course was a big success. We would certainly use Software Paths again for training in the future.”

Kainos

 
 

Start Dates

Looking for course dates? Find dates for your course here.


Find a Date