| Sign in | Sitemap | Feedback
Go To AppexTech

SQL Server 2005

1 Hour Daily

Duration:- ... Months

Appextech Introduction to SQL Server 2005 training teaches attendees the skills they need to successfully build, administer, and query Microsoft SQL Server 2005 databases.

Microsoft SQL Server 2005 Training Objectives

All attendees will learn to:

  1. Use the programming environment in the Query Analyzer and learn the Transact-SQL language
  2. Understand the differences between view, stored procedures, triggers, and user-defined functions, and know the advantages and drawbacks of each
  3. Design and implement reliable backup and maintenance plans
  4. Understand the SQL Server 2005 security model; and create logins, users and permissions to protect your data
  5. Utilize the fundamentals of Reporting Services, Notification Services, and the Service Broker.
  6. Configure and tune SQL Server 2005, and monitor database activity

Microsoft SQL Server 2005 Training Outline

  1. Introducing SQL Server
    1. Major features
    2. Limits
    3. Editions
    4. Installing SQL Server
  2. Basics of Database Design
    1. Normalization
    2. Denormalization
    3. Tools for Normalization in SQL Server
  3. Building a Database
    1. Introducing SQL Server Management Studio
    2. Databases
    3. Tables
    4. Indexes
    5. Relations
    6. Using T-SQL to build and alter objects
  4. T-SQL Basics
    1. What is SQL?
    2. Reading syntax diagrams
    3. Identifiers
    4. Datatypes
    5. Operators
    6. Wild cards
    7. Variables
    8. Functions
    9. Using sqlcmd
  5. SELECT Queries
    1. The SELECT clause
    2. The FROM clause
    3. The WHERE clause
    4. Using Joins
    5. ORDER BY
    6. GROUP BY and HAVING
    7. TOP N and TOP N%
    8. OVER
    9. Full-text search
  6. Action Queries
    1. DELETE
    2. TRUNCATE TABLE
    3. UPDATE
    4. INSERT
    5. SELECT INTO
  7. Locking and ShowPlan
    1. What is Locking?
    2. Monitoring and tuning Locking
    3. Deadlocks
    4. Application Locks
    5. Tuning Queries with ShowPlan
  8. Views, Stored Procedures, and Functions
    1. Partitioning and Joining Tables with Views
    2. Updateable views
    3. Indexed Views
    4. Information Schema Views
    5. Catalog Views
    6. Stored Procedures
    7. Functions
  9. Advanced Transact-SQL
    1. Transactions
    2. Distributed Transactions
    3. Rowset Functions
    4. Ranking Functions
    5. Cursors
    6. Structured Error Handling
  10. XML and SQL Server
    1. Using FOR XML
    2. Using XQuery
    3. HTTP SOAP access to data
  11. Triggers
    1. INSERT triggers
    2. DELETE triggers
    3. UPDATE triggers
    4. INSTEAD OF triggers
    5. Recursive triggers
    6. DDL triggers
  12. Replication
    1. Replication Models
    2. Setting up Replication
    3. Snapshot publishing
    4. Transaction publishing
    5. Merge publications
    6. Monitoring replication
    7. Heterogeneous replication
  13. .NET inside of SQL Server
    1. Understanding .NET and the CLR
    2. Using CLR objects in SQL Server
    3. Using the Sql namespace
  14. SMO and RMO Programming
    1. What is SMO?
    2. The SMO Object Model
    3. Sample SMO tasks
    4. Sample RMO tasks
  15. Analysis Services
    1. Understanding Analysis Services
    2. Introducing BIDS
    3. Creating a Data Cube
    4. Exploring a Data Cube
  16. SQL Server Integration Services
    1. SSIS Architecture
    2. SSIS Tasks
    3. SSIS in action
  17. Notification Services
    1. The Notification Services Architecture
    2. Using Notification Services
  18. Reporting Services
    1. The Reporting Services Architecture
    2. Building Reports
    3. Managing Reporting Services
  19. Service Broker
    1. The Service Broker Architecture
    2. Using Service Broker
  20. Security and SQL Server
    1. Security modes and authentication
    2. Fixed server roles
    3. Database user accounts
    4. Permissions
    5. Database roles
    6. Ownership chains

Database Training