SQL Server

Στόχος του προγράμματος είναι η επαφή των συμμετεχόντων με τον Microsoft SQL Server και η χρήση των βασικών δυνατοτήτων του.

ΥΛΗ ΣΕΜΙΝΑΡΙΟΥ

Module 1: Creating Databases
and Database Files
Lessons
Creating Databases.
Creating Filegroups.
Creating Schemas.
Creating Database Snapshots.
Lab 1: Creating a Database
Creating a Database.
Creating Schemas.
Module 2: Creating Data Types
and Tables
Lessons
Creating Data Types.
Creating Tables.
Creating Partitioned Tables.
Lab 2: Creating Data Types and
Tables
Creating Data Types.
Creating Tables.
Creating Partitioned Tables.
Module 3: Using XML
Lessons
Retrieving XML with FOR XML.
Shredding XML with OPENXML.
Using the xml Data Type.
Lab 3: Working with XML
Mapping Relational Data and XML.
Storing XML Natively in the Database.
Module 4: Creating and Tuning
Indexes
Lessons
Planning Indexes.
Creating Indexes.
Optimizing Indexes.
Creating XML Indexes.
Lab 4: Creating Indexes
Creating Indexes.
Tuning Indexes.
Creating XML Indexes.
Module 5: Implementing Data
Integrity
Lessons
Data Integrity Overview.
Implementing Constraints.
Implementing Triggers.
Implementing XML Schemas.
Lab 5: Implementing Data Integrity
Creating Constraints.
Creating Triggers.
Implementing XML Schemas.
Module 6: Creating Views
Lessons
Introduction to Views.
Creating and Managing Views.
Optimizing Performance with Views.
Lab 6: Creating Views
Creating Views.
Creating Indexed Views.
Creating Partitioned Views.
Module 7: Creating Stored
Procedures and Functions
Lessons
Implementing Stored Procedures.
Creating Parameterized Stored
Procedures.
Creating Functions.
Handling Errors.
Controlling Execution Context.
Lab 7: Creating Stored Procedures
and Functions
Creating Stored Procedures.
Creating Functions.
Module 8: Implementing
Managed Code in the Database
Lessons
Introduction to the SQL Server
Common Language Runtime.
Importing and Configuring Assemblies.
Creating Managed Database Objects.
Lab 8: Implementing Managed Code
in the Database
Importing an Assembly. Creating Managed Database Objects.
Module 9: Using Service Broker
Lessons
Service Broker Overview.
Creating Service Broker Objects.
Sending and Receiving Messages.
Lab 9: Using Service Broker
Creating Service Broker Objects.
Implementing the Initiating Service.
Implementing the Target Service.

Κόστος 290€