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:
Multi-subnet Failover Clustering
Review a configuration where each failover cluster node has been connected to a different subnet or different set of subnets.
BI: Business Intelligence and Web Development Environment Improvements
Explore dimensional modeling techniques used in MS SQL Server.
Web-based Visualization
Use SQL Server Reporting Services to provide a web-based visualization of the data and extracts.
File Table Solutions
Access data in a FileTable using a client provided by the instructor.
Contained and Noncontained Databases
Create a database isolated from other databases and the instance of SQL Server that hosts the database.
AlwaysOn Availability
Review the configuration of a standard AlwaysOn instance.
Upgrade Advisor
Instructor to provide guidelines.
Data Quality Services
Demonstrate the DQS Cleansing transformation which provides for an efficient and accurate improvement of data quality.
ColumnStore Indexes
Create a ColumnStore which groups and stores data for each column and then joins all the columns to complete the entire index.
Ad Hoc Query Paging
Implement a configuration which allows ad hoc distributed queries using OPENROWSET and OPENDATASOURCE.
Enhanced EXECUTE Keyword
Use the facilities of SQL Server WITH RECOMPILE option which forces the new plan to be re-compiled.
Adding WITH RECOMPILE to the stored procedure before the AS, instructs SQL to recalculate the plan at each execution instead of cache and reuse a plan for every execution.
Get Metadata
Examining and obtaining insight from the SQL script resultset.
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.
