• Course
  • Vendor

Gain the skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008 in this course, that incorporates material form the Official Microsoft Learning Product (OMLP) 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.

  • Course Start Date: 2019-06-10
  • Time: 08:30:00 - 16:30:00
  • Duration: 3 days 08:30 AM - 04:30 PM
  • Location: Toronto
  • Delivery Methods(s): Instructor Led
$1,795.50
REGULAR PRICE $1,995.00 Save $199.50
2 discount seats left!
or make an offer

Course Outline

Pre-Requisites

- Knowledge of data integrity concepts - Core Windows Server skills - Relational database design skills - Programming skills

Lessons

Description

Learn how to use and execute the Transact-SQL language.

Gain the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008 in this course that incorporates material form the Official Microsoft Learning Product (OMLP) 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.

What You'll Learn
  • Uses of and ways to execute the Transact-SQL language
  • Use querying tools
  • Write SELECT queries to retrieve data
  • Group and summarize data by using Transact-SQL
  • Join data from multiple tables
  • Write queries that retrieve and modify data by using subqueries
  • Modify data in tables
  • Query text fields with full-text search
  • Create programming objects
  • Use various techniques when working with complex queries
Who Needs to Attend
  • SQL Server database administrators
  • Implementers
  • System Engineers
  • Developers who are responsible for writing queries
Course Outline

1. Getting Started with Databases and Transact-SQL in SQL Server 2008

  • Overview of SQL Server 2008
  • Overview of SQL Server Databases
  • Overview and Syntax Elements of T-SQL
  • Working with T-SQL Scripts
  • Using T-SQL Querying Tools
2. Querying and Filtering Data
  • Using the SELECT Statement
  • Filtering Data
  • Working with NULL Values
  • Formatting Result Sets
  • Performance Considerations for Writing Queries
3. Grouping and Summarizing Data
  • Summarizing Data by Using Aggregate Functions
  • Summarizing Grouped Data
  • Ranking Grouped Data
  • Creating Crosstab Queries
4. Joining Data from Multiple Tables
  • Querying Multiple Tables by Using Joins
  • Applying Joins for Typical Reporting Needs
  • Combining and Limiting Result Set
5. Working with Subqueries
  • Writing Basic Subqueries
  • Writing Correlated Subqueries
  • Comparing Subqueries with Joins and Temporary Tables
  • Using Common Table Expressions
6. Modifying Data in Tables
  • Inserting Data into Tables
  • Deleting Data from Tables
  • Updating Data in Tables
  • Overview of Transactions
7. Querying Metadata, XML, and Full-Text Indexes
  • Querying Metadata
  • Overview of XML
  • Querying XML Data
  • Overview of Full-Text Indexes
  • Querying Full-Text Indexes
8. Using Programming Objects for Data Retrieval
  • Overview of Views
  • Overview of User-Defined Functions
  • Overview of Stored Procedures
  • Overview of Triggers
  • Writing Distributed Queries
9. Using Advanced Querying Techniques
  • Considerations for Querying Complex Data
  • Working with Data Types
  • Cursors and Set-Based Queries
  • Dynamic SQL
  • Maintaining Query Files
Labs

Lab 1: Getting Started with Databases and Transact-SQL in SQL Server 2008

  • Exploring the Components and Executing Queries in SQL Server Management Studio
  • Starting and Using SQLCMD
  • Generating a Report from a SQL Server Database Using Microsoft Office Excel
Lab 2: Querying and Filtering Data
  • Retrieving Data by Using the SELECT Statement
  • Filtering Data by Using Search Conditions
  • Using Functions to Work with NULL Values
  • Formatting Result Sets
Lab 3: Grouping and Summarizing Data
  • Summarizing Data by Using Aggregate Functions
  • Summarizing Grouped Data
  • Ranking Grouped Data
  • Creating Crosstab Queries
Lab 4: Joining Data from Multiple Tables
  • Querying Multiple Tables by Using Joins
  • Applying Joins for Typical Reporting Needs
  • Combining and Limiting Result Sets
Lab 5: Working with Subqueries
  • Writing Basic Subqueries
  • Writing Correlated Subqueries
  • Comparing Subqueries with Joins and Temporary Tables
  • Using Common Table Expressions
Lab 6: Modifying Data in Tables
  • Inserting Data into Tables
  • Deleting Data from Tables
  • Updating Data in Tables
  • Working with Transactions
Lab 7: Querying Metadata, XML, and Full-Text Indexes
  • Querying Metadata
  • Querying XML Data
  • Creating and Querying Full-Text Indexes
Lab 8: Using Programming Objects for Data Retrieval
  • Creating Views
  • Creating User-Defined Functions
  • Creating Stored Procedures
  • Writing Distributed Queries
Lab 9: Using Advanced Querying Techniques
  • Using Execution Plans
  • Converting Data Types
  • Implementing a Hierarchy
  • Using Cursors and Set-Based Queries

Cancellation Policy

We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted. Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.

Training Location

GK at ctc Toronto
595 Bay Street

Toronto, ON
Canada   

About Global Knowledge

x

Global Knowledge is the world's leading learning services and professional development solutions provider. We deliver learning solutions to support customers as they adapt to key business transformations and technological advancements that drive the way that organizations around the world differentiate themselves and thrive. Our learning programs, whether designed for a global organization or an individual professional, help businesses close skills gaps and foster an environment of continuous talent development.

Training Provider Rating

This vendor has an overall average rating of 4.38 out of 5 based on 421 reviews.

No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
Wasn’t as advanced as I thought it would be. There was an issue when the day my course was the first time they used a new platfo ... Read more
x

Wasn’t as advanced as I thought it would be. There was an issue when the day my course was the first time they used a new platform.. from adobe to something called zoom; I had to call support line cause it stated our instructor wasn’t present. Thankfully I called cause everyone online was in the adobe virtual classroom waiting for what looked like a teacher who didn’t show up for class (IT didn’t get anything resolved until 10mins after start time). I felt like he was really getting hung up on very basic knowledge for the first half of the course (talking about how to create tabs and drag formulas as an example). I completed files a few times before he was done explaining. There was a scheduled fire drill for them (roughly 30mins)that also cut into our time, which wasn’t deducted from the hour lunch break or the two, fifteen min breaks. I also really wish he touched base more on the automating workbook functions portion which we barely did. I'm happy there were/are those study guides (learning videos) and exams to take on my own time that I hope after I've had the class are still available for me to learn from.

No comment
No comment
No comment
No comment
It was difficult to practice on my PC while trying to watch the presentation online.
No comment
David was excellent!! I am very for having this course!!
No comment
Everything was great, but the instructor wasted a lot of time talking about unrelated subjects (like demo-ing different programs, ... Read more
x

Everything was great, but the instructor wasted a lot of time talking about unrelated subjects (like demo-ing different programs, talking about other classes, and talks about how Excel/technology has changed) took up way too much time. The course could have been condensed or better focus would have been great

Did not actually receive the course materials yet (and the course has concluded). Ratings assume that I will receive the course m ... Read more
x

Did not actually receive the course materials yet (and the course has concluded). Ratings assume that I will receive the course materials as soon as possible.

Course Reviews

No Reviews Yet