AtHand Logo

 

COURSE LOGIN
Username:
Password:   
FEATURED CUSTOMERS
FEATURED SOLUTION
AtHand Learning System
Total E-Learning Solution


Built-In LMS
Learning Management
Testing Solutions that address the issues you face now.

SQL 2005 - Querying Microsoft SQL Server 2005 Database with Transact-SQL

Print Version

Learn about the Transact-SQL programming language, what it is and how to query Microsoft SQL Server 2005. Then move on to how to use Transact-SQL query tools to retrieve data, format results, grouping and summarizing data. And then learn how to join multiple tables, work with subqueries, modify data in existing tables, and use programming objects.

3 levels - 49 training modules

 

Available Options

Querying Microsoft SQL Server 2005 Database with Transact-SQL - Set of 3 (Individual License)
Makau Course Cover - Box Shot  
CD-ROMs, e-Study Guides$239.00Add To Cart
Querying Microsoft SQL Server 2005 Database with Transact-SQL - Set of 3 (Library License)
Makau Course Cover - Box Shot  
CD-ROMs, e-Study Guides$478.00Add To Cart
Querying Microsoft SQL Server 2005 Database with Transact-SQL - Set of 3 (1 Year Access)
Makau Course Cover - Box Shot  
1 YR ONLINE$239.00Add To Cart

Course Instructor: Kevin Wolford

Kevin Wolford started his computer career in 1983. He has been a technical writer, network administrator, and trainer. Kevin spent many years with Novell and is a CNI and Master CNE. In 1998 Kevin founded Tech Training, giving him a chance to test his training concepts on live labs. He is also an MCSE, MCT, and is certified in SMS, SQL Server, TCP/IP, NT Workstation, NT Server, Exchange Server, Windows 9x and 2000. Kevin has authored Microsoft certification books for New Riders and Sybex. He also owns a consulting company dedicated to teaching complex technical topics in a simple way.

Course Outline

Level 1

1.0 Introduction to Transact-SQL
  • 1.1 The Transact-SQL Programming Language
  • 1.2 Using SQL Server Books Online
  • 1.3 Types of Transact-SQL Statements
  • 1.4 Transact-SQL Syntax Elements
  • 1.5 Summary
2.0 Using Transact-SQL Querying Tools
  • 2.1 SQL Server Management Studio
  • 2.2 Using Object Explorer
  • 2.3 Executing Transact-SQL Queries
  • 2.4 Creating and Executing Transact-SQL Scripts
  • 2.5 Using the sqlcmd Utility
  • 2.6 Summary
Level 2

1.0 Retrieving Data
  • 1.1 Retrieving Data Using the SELECT Statement
  • 1.2 Filtering Data
  • 1.3 Formatting Result Sets
  • 1.4 How Queries Are Processed
  • 1.5 Performance Considerations
  • 1.6 Summary
2.0 Grouping and Summarizing Data
  • 2.1 Listing the TOP n Values
  • 2.2 Using Aggregate Functions
  • 2.3 GROUP BY Fundamentals
  • 2.4 Generating Aggregate Values within Result Sets
  • 2.5 Using the COMPUTE and COMPUTE BY Clauses
  • 2.6 Summary
Level 3

1.0 Joining Multiple Tables
  • 1.1 Using Aliases for Table Names
  • 1.2 Combining Data from Multiple Tables
  • 1.3 Combining Multiple Result Sets
  • 1.4 Summary
2.0 Working With Subqueries
  • 2.1 Using a Subquery as a Derived Table
  • 2.2 Using a Subquery as an Expression
  • 2.3 Using a Subquery to Correlate Data
  • 2.4 Using the EXISTS and NOT EXISTS Clauses
  • 2.5 Summary
3.0 Modifying Data
  • 3.1 Using Transactions
  • 3.2 Inserting Data
  • 3.3 Deleting Data
  • 3.4 Updating Data
  • 3.5 Performance Considerations
  • 3.6 Summary
4.0 Introduction to Programming Objects
  • 4.1 Introduction to Views
  • 4.2 Other Objects
  • 4.3 Summary