Introduction to SQL Server 2008 for Developers and Query Writers

Introduction to SQL Server 2008 for Developers and Query Writers

 

Bascom Bridge’s SQL Server 2008 training: Introduction to SQL Server 2008 for Developers and Query Writers training course teaches attendees the skills they need to successfully build, query, and interact with Microsoft SQL Server 2008. Note: This course can also be taught using SQL Server 2008 R2.

 

SQL SERVER 2008 TRAINING OBJECTIVES

  • Use the programming environment in SQL Server Management Studio and learn the Transact-SQL language
  • Understand the differences between view, stored procedures, triggers, and user-defined functions, and know the advantages and drawbacks of each
  • Implement the SQL Server 2008 security model; and create logins, users and permissions to protect your data
  • Utilize the fundamentals of Reporting Services, Analysis Services, Integration Services and the Service Broker
  • Configure and tune SQL Server 2008 and monitor database activity

SQL SERVER 2008 TRAINING PREREQUISITES

No prior experience is presumed.

SQL SERVER 2008 TRAINING MATERIALS

SOFTWARE NEEDED FOR EACH PC:

  • Windows XP or later, or Windows Server 2003 or later, with the latest service pack updates and at least 3 GB RAM
  • SQL Server 2008 installed (we will provide detailed installation instructions)
  • Visual Studio 2008
  • Related databases and lab files – please contact us for details
  • For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.

SQL SERVER 2008 TRAINING OUTLINE

  • Introducing SQL Server 2008
    • What’s New in SQL Server?
    • SQL Server Editions
    • Installing SQL Server
  • Basics of Database Design
    • Normalization
    • Denormalization
    • Tools for Normalization in SQL Server
    • Introducing SQL Server Management Studio
    • Creating a Database
    • Adding Tables
    • Creating Indexes and Constraints
    • Building Relations
  • T-SQL Basics
    • What is T-SQL?
    • Syntax Conventions
    • Introducing AdventureWorks2008
    • Executing SQL Statements
    • Identifiers
    • Creating Data Types
    • Operators
    • Variables
    • Functions
    • Using T-SQL to Build and Alter Objects
  • SELECT Queries
    • The SELECT Clause
    • The FROM Clause
    • The WHERE Clause
    • The ORDER BY Clause
    • Using GROUP BY and HAVING
    • Using TOP N and TOP N PERCENT
    • UNION Queries
    • Full-Text Search
  • Action Queries
    • SELECT INTO queries
    • DELETE queries
    • TRUNCATE TABLE queries
    • INSERT queries
    • UPDATE queries
    • MERGE queries
  • Locking and Execution Plans
    • What is Locking?
    • Monitoring Locks
    • Tuning Locking
    • Deadlocks
    • Tuning Queries
    • Management Data Warehouse
    • Performance Studio
  • Views, Stored Procedures, and Functions
    • Using Views
    • Using Stored Procedures
    • Using Functions
  • Advanced Transact-SQL
    • Transactions
    • Rowset Functions
    • Ranking Functions
    • Cursors
    • Structured Error Handling
  • XML and SQL Server
    • XML Columns and Indexes
    • Querying and Modifying XML Data
    • Using OPENXML
    • Using FOR XML
  • Triggers
    • Creating DML Triggers
    • Altering DML Triggers
    • Using the Inserted and Deleted Tables
    • Checking Updated Columns
    • Recursive and Nested Triggers
    • Creating DDL Triggers
  • .NET inside of SQL Server
    • Creating CLR User-Defined Functions
    • Creating CLR Stored Procedures
    • Using the Sql Namespace
    • Creating CLR Triggers
    • Creating CLR User-Defined Types
    • Choosing When To Use CLR Objects
  • SMO and RMO Programming
    • Retrieving Server Information
    • Working With Database Objects
    • Generating Scripts
    • Viewing and Modifying Server Configuration
    • Understanding RMO
  • Data Protection/Tracking
    • Understanding Change Data Capture
    • Data Capture Schema and Tables
    • Transparent Data Encryption
  • SQL Server 2008 Analysis Services
    • Understanding Analysis Services
    • Introducing Business Intelligence Development Studio
    • Creating a Data Cube
    • Exploring a Data Cube
  • SQL Server 2008 Integration Services
    • The Import and Export Wizard
    • Creating a Package
    • Working with Connection Managers
    • Building Control Flows
    • Building Data Flows
    • Creating Event Handlers
    • Saving and Running Packages
  • SQL Server 2008 Reporting Services
    • The Reporting Services Architecture
    • Using Report Designer
    • Publishing a Report
    • Using Report Builder
    • Using Report Manager
  • Service Broker
    • Service Broker Terminology
    • Creating a Service Broker Application
    • Processing Messages with Stored Procedures
    • Using Service Broker Across Servers
  • Security and SQL Server
    • Choosing Service Accounts
    • Authentication Modes
    • Roles and Users
    • Permissions
    • Object Ownership
  • Conclusion

Send a Comment

Your email address will not be published.

CONTACT US

+91 9376007676  

INQUIRY NOW


,

Introduction to SQL Server 2008 for Developers and Query Writers

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
  • Course No : SQL-200
  •  Theory : 40%
  •  Lab : 60%
  • Duration : 30 hours
Scroll Up
Skip to toolbar