Showing posts with label workshop MS SQL 2008. Show all posts
Showing posts with label workshop MS SQL 2008. Show all posts

MS SQL for developer

About this Workshop
This workshop provides participants with the knowledge and skills how to use SQL Server 2008 product features and tools related to database design and implementation.

Duration
5 days

Upon Completion
· 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.
· Implement data integrity in Microsoft SQL Server 2008 databases by using triggers.
· Implement views.
· Implement stored procedures.
· Implement functions.
· Implement managed code in the database.
· Manage transactions and locks.
· Use Service Broker to build a messaging-based solution

Workshop Agenda

1: Creating Databases and Database Files
· Creating Databases
· Creating Filegroups
· Creating Schemas
· Creating Database Snapshots

2: Creating Data Types and Tables
· Creating Data Types
· Creating Tables
· Creating Partitioned Tables

3: Creating and Tuning Indexes
· Planning Indexes
· Creating Indexes
· Optimizing Indexes

4: Implementing Data Integrity by Using Constraints and Triggers
· Data Integrity Overview
· Implementing Constraints
· Implementing Triggers

5: Using XML
· Using the XML Data Type
· Retrieving XML by Using FOR XML
· Shredding XML by Using OPENXML
· Introducing XQuery
· Creating XML Indexes
· Implementing XML Schemas

6: Implementing Views
· Introduction to Views
· Creating and Managing Views
· Optimizing Performance by Using Views

7: Implementing Stored Procedures
· Using Stored Procedures
· Creating Parameterized Stored Procedures
· Working With Execution Plans
· Handling Exceptions

8: Implementing Functions
· Introducing Functions
· Working with Functions
· Controlling Execution Context

9: Implementing Managed Code in the Database
· Introduction to the SQL Server Common Language Runtime
· Importing and Configuring Assemblies
· Creating Managed Database Objects

10: Managing Transactions and Locks
· Overview of Transactions and Locks
· Managing Transactions
· Understanding SQL Server Locking Architecture
· Managing Locks

11: Using Service Broker
· Service Broker Overview
· Creating Service Broker Objects
· Sending and Receiving Messages

MS SQL for administrator

About this Workshop
This workshop provides participants with the knowledge and skills how to use SQL Server 2008 product features and tools related to database administration.

Duration
5 days

Upon Completion
Participants will be able to:
· Install and configure SQL Server 2008.
· Manage database files.
· Backup and restore databases.
· Manage security.
· Transfer data into and out of SQL Server.
· Automate administrative tasks.
· Replicate data between SQL Server instances.
· Maintain high availability.
· Monitor SQL Server.

Workshop Agenda

1: Installing and Configuring SQL
· Preparing to Install SQL Server
· Installing SQL Server
· Configuring a SQL Server Installation

2: Managing Databases and Files
· Planning Databases
· Creating Databases
· Using Policy-Based Management

3: Disaster Recovery
· Planning a Database Backup Strategy
· Backing Up a User Database
· Restoring User Databases
· Performing Online Restore Operations
· Recovering Data from Database Snapshots
· System Databases and Disaster Recovery

4: Managing Security
· Overview of SQL Server Security
· Protecting the Server Scope
· Protecting the Database Scope
· Managing Keys and Certificates
· Auditing Security

5: Transferring Data
· Overview of Data Transfer
· Introduction to SQL Server Integration Services

6: Automating Administrative Tasks
· Automating Administrative Tasks in SQL Server
· Using SQL Server Agent
· Creating Maintenance Plans
· Implementing Alerts
· Managing Multiple Servers
· Managing SQL Server Agent Security

7: Implementing Replication
· Overview of Replication
· Managing Publications and Subscriptions
· Configuring Replication in Some Common Scenarios

8: Maintaining High Availability
· Introduction to High Availability
· Implementing Log Shipping
· Implementing Database Mirroring
· Implementing Server Clustering
· Using Distributed High Availability Solutions

9: Monitoring SQL Server
· Viewing Current Activity
· Using SQL Server Profiler
· Monitoring with DDL Triggers
· Using Event Notifications

10: Troubleshooting and Performance Tuning
· Troubleshooting SQL Server
· Performance Tuning in SQL Server
· Using Resource Governor
· Using Data Collector

MS SQL Reporting Service

About this Workshop
This workshop provides participants with the knowledge and skills how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.

Duration
3 days

Upon Completion
· Create a Reporting Services report.
· Enhance a Reporting Services report.
· Create and manipulate data sets.
· Use report models to implement reporting for business users.
· Configure report publishing and execution settings.
· Implement subscriptions for reports.
· Administer Reporting Services.
· Implement custom Reporting Services applications

Workshop Agenda

1: Introduction to Microsoft SQL Server Reporting Services
· Overview of SQL Server Reporting Services
· Installing Reporting Services
· Reporting Services Tools

2: Authoring Basic Reports
· Creating a Basic Table Report
· Formatting Report Pages
· Calculating Values

3: Enhancing Basic Reports
· Interactive Navigation
· Displaying Data

4: Manipulating Data Sets
· Defining Report Data
· Using Parameters and Filters
· Using Parameter Lists

5: Using Report Models
· Creating Report Models
· Using Report Builder

6: Publishing and Executing Reports
· Publishing Reports
· Executing Reports
· Creating Cached Instances
· Creating Snapshots and Report History

7: Using Subscriptions to Distribute Reports
· Introduction to Report Subscriptions
· Creating Report Subscriptions
· Managing Report Subscriptions

8: Administering Reporting Services
· Reporting Server Administration
· Performance and Reliability Monitoring
· Administering Report Server Databases
· Security Administration
· Upgrading to Reporting Services 2008

9: Programming Reporting Services
· Querying for Server Information Using a Web Service
· Automating Report Management
· Rendering Reports
· Creating Custom Code

MS SQL Analysis Service

About this Workshop
This workshop provides participants with the knowledge and skills how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.

Duration
3 days

Upon Completion
· Create multidimensional analysis solutions with SQL Server Analysis Services.
· Implement dimensions and cubes in an Analysis Services solution.
· Implement measures and measure groups in an Analysis Services solution.
· Query a multidimensional Analysis Services solution.
· Customize an Analysis Services cube.
· Deploy and secure an Analysis Services database.
· Maintain a multidimensional Analysis Services solution.
· Implement a Data Mining solution

Workshop Agenda

1: Introduction to Microsoft SQL Server Analysis Services
· Overview of Data Analysis Solutions
· Overview of SQL Server Analysis Services
· Installing SQL Server Analysis Services

2: Creating Multidimensional Analysis Solutions
· Developing Analysis Services Solutions
· Creating Data Sources and Data Source Views
· Creating a Cube

3: Working with Cubes and Dimensions
· Configuring Dimensions
· Defining Attribute Hierarchies
· Sorting and Grouping Attributes

4: Working with Measures and Measure Groups
· Working With Measures
· Working with Measure Groups

5: Querying Multidimensional Analysis Solutions
· MDX Fundamentals
· Adding Calculations to a Cube

6: Customizing Cube Functionality
· Implementing Key Performance Indicators
· Implementing Actions
· Implementing Perspectives
· Implementing Translations

7: Deploying and Securing an Analysis Services Database
· Deploying an Analysis Services Database
· Securing an Analysis Services Database

8: Maintaining a Multidimensional Solution
· Configuring Processing
· Logging, Monitoring, and Optimizing an Analysis Services Solution
· Backing Up and Restoring an Analysis Services Database
· Controlling Execution Context

9: Introduction to Data Mining
· Overview of Data Mining
· Creating a Data Mining Solution
· Validating Data Mining Models

Our past activities

K365Labs on Facebook