PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
AUDIENCE:
Support Personnel
Programmer
Database Administrator
System Designer
System Analyst
IT Professional
DATES:
CONTENT AND OBJECTIVES:
Developer Tools
Use SQL Server tools to display and navigate a schema.
Use SQL Server Management Studio for coding and debugging a T-SQL program.
Use the command prompt utilities for running programs.
Retrieving Data
Perform basic retrieval: filtering, grouping, and sorting.
Create and use derived columns in conjunction with derived columns.
Retrieve the identity value when adding a record into a SQL Server table with an identity field.
Perform selection from summarized data.
Multitable Queries
Code FULL OUTER, and LEFT, RIGHT, FULL INNER joins.
Code UNION queries with filtering.
Constructing Complex Statements
Code multi-level subqueries using various tables and views.
Debug the queries provided by the instructor; alternatives approaches will be explored.
Executing FULL_TEXT Searches
Search a table for 1- One or more specific words or phrases. 2- A word or a phrase where the words begin with specified text 3- A word or phrase close to another word or phrase. 4- Synonyms of a specific word.
Managing Data and Concurrency
Code SQL which demonstrates proficiency with cursor concurrency using: READ_ONLY, OPTIMISTIC WITH VALUES, OPTIMISTIC WITH ROW VERSIONING and SCROLL LOCKS.
Server-side Code
Develop, code, and test a Data Access Layer on the server.
Stored Procedures
Utilize system level stored procedures.
Code stored procedures that pass data into and receive data from the code.
Invoke and test the stored procedures from another stored procedure.
Advanced TRANSACT_SQL Constructs
Create and use local and global temporary tables.
Create and run SQL dynamically using cursors.
Create USER_DEFINED Functions
Code a scalar UDF and a table UDF.
Formulating Triggers
Code an AFTER trigger and use the inserted and deleted special tables.
Identify the number of effected rows.
Performance Tuning
Identify issues with a profiler.
Perform EXPLAINS on queries and interpret the results.
Optimizing Queries
Use the EXPLAIN and other tools for measuring and reducing the cost of running the queries.
The queries will be provided by the instructor.
Integrate XML with Transact SQL
Use XQUERY to navigate an XML hierarchy.
Use XML serialized objects in a database.
Virtual Classroom
Blended Learning
↓
Synchronous Instruction
Asynchronous Instruction
Effective February 27, 2012, the course dates listed on the CETi schedules only will be available based upon approved and authorized user ID.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. CETi makes no representation regarding ownership in any of the software products that we train on.
CETi courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the CETi course and that the employer has a licensed version of the software.
Certain courses only should be taught by the source software company training company and open source purveyor.
