Computer Training Course Outline for PC Training Experts
Home
About
Contact
Courses
Tutorials
Hot Articles
Blog
Forums
T-SQL 2012 Advanced Querying
(
0.5 days
)
In this advanced course, which builds on skills from the T-SQL: Querying Fundamentals course, you will learn how to take their skills up to the next level. You'll learn how to create subqueries, and the intricacies of updating and deleting records from a table. Discover how to manipulate a table structure, work with views, indices, and also how to harness the power of transactions. This course is recommended for students who already have a working knowledge of SQL and are ready to upgrade their skills for enhanced job performance. **Please note this is Microsoft's "T-"SQL. This is not "MYSQL" or "PL-SQL".
Performance-Based Objectives
Use subqueries to generate query output.
Manipulate table data by inserting and updating records in a table and deleting records from a table.
Manipulate the table structure.
Create views, manipulate data through views, modify the view structure, and drop views.
Create indices on table columns and drop inefficient indices.
Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction.
Course Outline*
Module 1: Using Subqueries to Perform Advanced Querying
Search Based on Unknown Values
Compare a Value with Unknown Values
Search Based on the Existence of Records
Generate Output Using Correlated Subqueries
Filter Grouped Data Within Subqueries
Perform Multiple-Level Subqueries
Module 4: Working with Views
Create a View
Manipulate Data in Views
Create Aliases
Modify and Drop Views
Module 2: Manipulating Table Data
Insert Data
Modify and Delete Data
Module 5: Indexing Data
Create Indices
Drop Indices
Module 3: Manipulating the Table Structure
Create a Table
Create a Table with Constraints
Add and Drop Table Columns
Add and Drop Constraints
Modify the Column Definition
Back Up Tables
Delete Tables
Module 6: Managing Transactions
Create Transactions
Commit Transactions
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