Computer Training Course Outline for PC Training Experts
Home
About
Contact
Courses
Tutorials
Hot Articles
Blog
Forums
T-SQL 2012 Fundamentals of Querying
(
0.5 days
)
In this power-packed session, you will compose Microsoft T-SQL queries to retrieve desired information from a database. Learn the fundamentals of querying, how to properly setup your data structure, the basics of SQL syntax, how to perform calculations on your data, and how to generate reports, and much more in this intensive training. This is a must-attend for anyone wanting to upgrade their skills and knowledge in Microsoft's leading query language. **Please note this is Microsoft's "T-"SQL. This is not "MYSQL" or "PL-SQL".
Performance-Based Objectives
Connect to the SQL Server database and execute a simple query.
Include a search condition in a simple query.
Use various functions to perform calculations on data.
Organize data obtained from a query before it is displayed on-screen.
Retrieve data from tables.
Format an output, save a result, and generate a report.
Course Outline*
Module 1: Executing a Simple Query
Connect to the SQL Database
Query a Database
Save a Query
Modify a Query
Execute a Saved Query
Module 4: Organizing Data
Sort Data
Rank Data
Group Data
Filter Grouped Data
Summarize Grouped Data
Use PIVOT and UNPIVOT Operators
Module 2: Performing a Conditional Search
Search Using a Simple Condition
Compare Column Values
Search Using Multiple Conditions
earch for a Range of Values and Null Values
Retrieve Data Based on Patterns
Module 5: Retrieving Data from Tables
Combine Results of Two Queries
Compare the Results of Two Queries
Retrieve Data by Joining Tables
Check for Unmatched Records
Retrieve Information from a Single Table Using Joins
Module 3: Working with Functions
Perform Date Calculations
Calculate Data Using Aggregate Functions
Manipulate String Values
Module 6: Presenting Query Results
Save the Query Result
Generate an XML Report
Register
Dates Offered
Email
Print Friendly
Show All
*Note: webinar courses cover only essential topics due to time constraints. Please discuss topics with your instructor prior to webinars to ensure your necessary topics are covered.
Dates Offered
Email Me
this Outline
Print Friendly
Version
Tuition
Live, In-Person:
$697.00
Live, Webinar:
$397.00
Home
|
About
|
Contact
|
Schedule Training
|
Course Catalog
|
Blog
|
Terms of Use
|
Privacy Statement
Copyright © 2011 Mike Phillips