X
ODT

Introduction to T-SQL On-Demand Training

Starting At: $495.00
On-Demand Training
Call Us At: (904) 413-1911

Pragmatic Works On-Demand Training gives you the ability to learn from industry experts at your own pace. Our courses cover a variety of topics including Business Intelligence, Business Analytics, Big Data, SQL Server Optimization and more.

Introduction To T-SQL
$495
Per User Per Year
SQL Server Administration Pack
$795
Per User Per Year
Unlimited Elite Pack
$1295
Per User Per Year
Free Trial
3:13
3:13
2:00

Thanks for reporting a problem. We'll attach technical data about this session to help us figure out the issue. Which of these best describes the problem?

Any other details or context?

Cancel
message

Course Details

This course is designed to get you developing with T-SQL very quickly. First, you will learn the structure of a SQL Server database, then you will dive into how to query the tables. Next, we will cover sorting and filtering the results.

What Will You Learn?

  • How to write queries that involve multiple tables and summary queries
  • How to modify data and understand the logical programming aspects of T-SQL

Prerequisites


Previous SQL Server knowledge is not required. Ideally, students should be proficient using the Windows operating system and performing typical tasks like uploading or zipping files.

System Requirements


  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014
  • AdventureWorks2008R2 or AdventureWorks2012 databases installed on the instance

  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance

Curriculum For This Course

Image

Mitchell Pearson

BI Consultant and Trainer

As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.



Related Courses

Course Info
14 Comprehensive Modules
14 Effective Quizzes
Access on Mobile and TV
Certificate of Completion
Duration:
5h 50m
Download Syllabus
Enrollment Price:
$495/Year

Share this course with your friends