Scribd
Upload
44 views

Introduction To T SQL

This intensive course is designed to quickly teach developers how to write queries in T-SQL. The course first covers database structure and querying basics. It then teaches how to sort, filter, and modify query results, as well as more complex queries using joins, subqueries, and aggregates. No prior SQL experience is required, though students should be proficient with Windows. The course requires a Windows PC with SQL Server, SQL Server Management Studio, and sample databases installed.

Uploaded by

NIHAL AMARAYYANMATH
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
44 views

Introduction To T SQL

This intensive course is designed to quickly teach developers how to write queries in T-SQL. The course first covers database structure and querying basics. It then teaches how to sort, filter, and modify query results, as well as more complex queries using joins, subqueries, and aggregates. No prior SQL experience is required, though students should be proficient with Windows. The course requires a Windows PC with SQL Server, SQL Server Management Studio, and sample databases installed.

Uploaded by

NIHAL AMARAYYANMATH
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

ON-DEMAND TRAINING

Introduction to T-SQL

COURSE OVERVIEW
COURSE TOPICS This is an intensive course that is designed to get you developing with T-SQL
very quickly. You will first learn about the structure of a SQL Server database,
• Writing Queries to Return Data then you dive right in learning how to query the tables. Next, we will cover how
• SQL Server Management Studio (SSMS) to sort and filter the results.

• The SELECT Statement Course Goals


• Learn how to write queries that involve multiple tables and summary
• Expressions
queries
• Indexes • Learn how to modify data and about the logical programming aspects
of T-SQL
• The WHERE Clause

• Complex WHERE Clauses PREREQUISITES


This class is targeted for business analysts, report writers, developers or database
• Using a Sub-Query to Filter Data administrators who need to write queries against SQL Server databases. Previous
SQL Server knowledge is not required. Ideally, students should be proficient
• Joining Tables
using the Windows operating system and performing typical tasks like uploading
• Outer Joins or zipping files.

• Other Query Patterns


SYSTEM REQUIREMENTS
• Aggregate Queries • Microsoft Windows XP Professional, Microsoft Windows Server 2003,
Microsoft Vista, Windows 7 or Windows 8
• Modifying Data • 1 GHz or faster CPU
• T-SQL Programming • 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
• SQL Server Database Engine
• SQL Server Management Studio
• AdventureWorks2008R2 or AdventureWorks2012 databases installed on
the instance
• AdventureWorksDW2008R2 or AdventureWorksDW2012 databases
installed on the instance

www.pragmaticworks.com

You might also like