home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » VMwareDatabases, transaction systems and middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence and data warehouseApplication development » Methods and techniques » TOGAF » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
Implementing a SQL Server 2008 database

Intended for

IT Professionals wanting to become skilled on SQL Server 2008 product features and technologies for implementing a database.

Background

Before attending this course, students must have a basic knowledge of the Microsoft Windows operating system and its core functionality. A level of understanding as covered in courses RDBMS concepts and SQL fundamentals is required i.e. the writing of basic SQL statements and having insight in relational systems. You can test yourself to see if you have enough background by printing and filling in the self-tests (PDF file - 57 KB and PDF file - 56 KB).

Training method

Class training alternated with exercises.

Course leader

an ABIS partner.

Duration

5 days.

Schedule

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested ? Please contact ABIS.

Objectives

At the end of the course, students will be able to:

  • create databases and database files;
  • create data types and tables;
  • use XML-related features in Microsoft SQL Server 2008;
  • plan, create, and optimize indexes;
  • implement data integrity in Microsoft SQL Server 2008 databases by using constraints, triggers, and XML schemas;
  • implement views;
  • implement stored procedures and functions;
  • implement managed code in the database;
  • manage transactions and locks;
  • use Service Broker to build a messaging-based solution.

Main topics

  • Creating databases and database files
  • creating databases
  • creating filegroups
  • creating schemas
  • creating database snapshots
  • Creating data types and tables
  • creating data types
  • creating tables
  • creating partitioned tables
  • Creating and tuning indexes
  • planning indexes
  • creating indexes
  • optimizing indexes
  • Implementing data integrity by using constraints and triggers
  • data integrity overview
  • implementing constraints
  • implementing triggers
  • Using XML
  • using the XML datatype
  • retrieving XML by using FOR XML
  • shredding XML by using OPENXML
  • introducing XQuery
  • creating XML indexes
  • implementing XML schemas
  • Implementing views
  • introduction to views
  • creating and managing views
  • optimizing performance by using views
  • Implementing stored procedures
  • using stored procedures
  • creating parameterized stored procedures
  • working with execution plans
  • handling errors
  • Implementing functions
  • creating and using functions
  • working with functions
  • controling execution context
  • Implementing managed code in a database
  • introduction to the SQL Server Common Language Runtime
  • importing and configuring assemblies
  • creating managed database objects
  • Managing transactions and locks
  • overview of transactions and locks
  • managing transactions
  • understanding SQL Server locking architecture
  • Managing Locks
  • Using Service Broker
  • Service Broker overview
  • creating Service Broker objects
  • sending and receiving messages