home 
 
 
 
enfr
 
Home
Over ABIS
Diensten
Cursussen
Resources
Contact
MyABIS
Alle CursussenbalkjeAlgemeen » Introductie HW & SW » TrajectenOperating Systems » MVS - z/OS » UNIX - Linux - AIX » VMwareDatabases, transactiesystemen en 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 en data warehouseApplicatieontwikkeling » Methoden en technieken » TOGAF » PRINCE2 » Programmeertalen » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSysteembeheer » ITILbalkjePraktischInschrijven 
Deze pagina is niet beschikbaar in het Nederlands.
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