Live Instructor-Led Training
The course Performance Tuning & Optimization (SQL Server Training) explores SQL Server performance. The training includes a general discussion of SQL Server architecture & configuration as it related to tuning activities. The course covers clustered & non-clustered indexes, SQL execution plans, join strategies & data storage considerations. Further, the training includes a discussion of the relative performance characteristics of stored procedures, joins, sub-queries, correlated sub-queries, covering indexes & more in a SQL Server environment.
Jan 21 - 24, 2025$3,750.00Feb 18 - 21, 2025$3,750.00Mar 18 - 21, 2025$3,750.00Apr 22 - 25, 2025$3,750.00May 20 - 23, 2025$3,750.00Jun 17 - 20, 2025$3,750.00Jul 22 - 25, 2025$3,750.00
SQL Server Storage Architecture
Understanding Pages and Extents
How SQL Server Allocates Pages and Extents
Exploring Data and Index Placement with Filegroups
About Data Types, Row Size and Page Usage
Determining the Space Requirements of a Table
Working with Standard Data Types
Working with Text Data: Unicode and Non-Unicode
Working with Image Data
About Fragmentation: Data and Indexes
Using TSQL to Display Table and Index Space Usage
Using TSQL to Display Table and Index Fragmentation
Tuning SQL Statements
Understanding Query Parsing and Compilation
Using and Understanding Statistics Time and Statistics IO
Displaying and Understanding Graphical Execution Plans
How SQL Server uses Table Scans
How SQL Server Processes Range and Point Queries
Understanding SQL Server Join Strategies
Using Execution Plans to Write Good SQL Statements
Using the Query Optimizer
Implementing the Query Optimizer’s Recommendations
Indexes and SQL
About Indexes: Clustered and Non-Clustered
Understanding Index Architecture and Storage
The Essential Role of Covering Indexes
Understanding the Role of Fill Factor and Pad Index
About Indexes and Data
About Indexes and Insert/Update Operations
About Indexes and Delete Operations
About Indexes and Views
About Indexes and Indexed Views
Implementing Sparse Indexes
Creating Indexes: Guidelines and Usage
Matching Indexes with Queries: Point and Range Queries
Creating Indexes to Support Point Queries
Creating Indexes to Support Range Queries
Creating Indexes to Support Join Operations
Creating Indexes to Support Ordering Operations
Creating Indexes to Support Aggregate Calculations
Maintaining Indexes
How SQL Server uses Statistics
How to Update Statistics
Displaying Fragmentation Statistics
Rebuilding Indexes
Altering Indexes
Automated Index Maintenance
SQL Server Memory Management
Understanding the SQL Server Memory Architecture
Understanding the Buffer Pool and the Buffer Manager
The Importance of the Buffer Cache Hit Ratio
Understanding Log Operations
Working with and Tuning for Checkpoints and the Lazy Writer
Working with Log Writer
Managing Transactions
About Lock Granularity: Table, Page, Extent and Row
SQL Server Lock Types and their Compatibility: Shared, Exclusive and More
Understanding Lock Types in the Context of Transaction Isolation
Common Locking Conditions: Deadlocks, Livelocks and More
Detecting and Avoiding Deadlocks
Detecting and Avoiding Livelocks
Common Mistakes and How to Avoid Them
When Nothing Else Works: De-normalization and Other Strategies
Comparing OLTP and OLAP Databases
Separating Query Data from Transactional Data
The Need for De-Normalization
Implementing Redundant Data: Triggers and Functions
Implementing Surrogate Keys
Implementing Partitioned Tables
Implementing Partitioned Views
SQL Server Training: Mastering Always-On Technologies
The course Mastering Always-On Technologies (SQL Server Training) allows database professionals to design, implement and monitor a robust database infrastructure that can serve clients 24/7. The training introduces the concepts of always on infrastructure design with SQL Server and discusses the full implementation & maintenance of the design with SQL Server. The course includes topology design, installation & configuration in a SQL Server Always-On context.
Training course titled SQL Server Training: Mastering Always-On Technologies that will allow you to hone your professional skills.
Jan 28 - 31, 2025$3,750.00Feb 25 - 28, 2025$3,750.00Mar 25 - 28, 2025$3,750.00Apr 29 - May 2, 2025$3,750.00May 27 - 30, 2025$3,750.00Jun 24 - 27, 2025$3,750.00Jul 29 - Aug 1, 2025$3,750.00
SQL Server Training: The Complete TSQL Programming Course
The course The Complete TSQL Programming Course (SQL Server Training) covers every aspect of the TSQL development language. Beginning with database basics like creating databases and tables, we proceed to a thorough investigation of the TSQL language. We discuss variable declaration, conditional and looping expressions and the use of native SQL functions. You learn advanced topics such as string and date time manipulation, the use of NULL values in tables and scripts and the use of stored procedures and BLOB data. This is a busy and rewarding week.
Training course titled SQL Server Training: The Complete TSQL Programming Course that will allow you to hone your professional skills.
Jan 21 - 24, 2025$3,750.00Feb 18 - 21, 2025$3,750.00Mar 18 - 21, 2025$3,750.00Apr 22 - 25, 2025$3,750.00May 20 - 23, 2025$3,750.00Jun 17 - 20, 2025$3,750.00Jul 22 - 25, 2025$3,750.00
Oracle Training: Replication, Clustering & High Availability
The course Replication, Clustering & High Availability (Oracle Training) is an exploration of clustering & high availability with MySQL. The training includes clustering basic concepts and discusses the hardware, topology & software requirements of a clustered MySQL implementation. The course covers MySQL cluster design, installation, configuration & implementation. This MySQL course also includes a full discussion on MySQL cluster monitoring, troubleshooting & optimization.
Training course titled Oracle Training: Replication, Clustering & High Availability that will allow you to hone your professional skills.
Jan 28 - 31, 2025$3,750.00Feb 25 - 28, 2025$3,750.00Mar 25 - 28, 2025$3,750.00Apr 29 - May 2, 2025$3,750.00May 27 - 30, 2025$3,750.00Jun 24 - 27, 2025$3,750.00Jul 29 - Aug 1, 2025$3,750.00
SQL Server Training: Database Querying
The course Database Querying (SQL Server Training) covers every aspect of the SQL language. The training begins with a detailed discussion of creating databases & tables. The course studies every element of the SQL language with SQL Server. The training includes SQL data manipulation & modification statements, string & date time manipulation and the use of NULL values in SQL Server tables and TSQL scripts. The course also discusses advanced joins, filtering & sorting & aggregate data calculations with TSQL on SQL Server.
Training course titled SQL Server Training: Database Querying that will allow you to hone your professional skills.
Jan 6 - 7, 2025$1,500.00Feb 3 - 4, 2025$1,500.00Mar 3 - 4, 2025$1,500.00Apr 7 - 8, 2025$1,500.00May 5 - 6, 2025$1,500.00Jun 2 - 3, 2025$1,500.00Jul 7 - 8, 2025$1,500.00
SQL Server Training: SQL Server Administration
The course SQL Server Administration (SharePoint Training) covers database administration from A to Z on SQL Server. The training explores the installation & configuration of SQL Server as well as the design & creation of SQL Server data & log files using files & filegroups. The course also discusses data import & export, backup & recovery, SQL Server security, and SQL Server performance tuning & monitoring. The training concludes with a detailed discussion of indexes, index types & data storage optimization.
Training course titled SQL Server Training: SQL Server Administration that will allow you to hone your professional skills.
Jan 21 - 24, 2025$3,750.00Feb 18 - 21, 2025$3,750.00Mar 18 - 21, 2025$3,750.00Apr 22 - 25, 2025$3,750.00May 20 - 23, 2025$3,750.00Jun 17 - 20, 2025$3,750.00Jul 22 - 25, 2025$3,750.00
SQL Server Training: Transforming Data with SSIS
The course Transforming Data with SSIS (SQL Server Training) covers the full range of SSIS concepts from the basics of data sources to advanced data flows and control flows. The course begins with a tour of Visual Studio .NET and its many windows, dialog boxes and features. From there, you learn to import data from delimited & positional files, to export data to external data sources and to implement simple error conditions. The training includes how to implement complex data transformation tasks and how to handle NULL values & encoding changes. The course also discusses data load operations that are common to SQL Server data warehouses that make use of a Star schema.
Training course titled SQL Server Training: Transforming Data with SSIS that will allow you to hone your professional skills.
Jan 22 - 24, 2025$3,350.00Feb 19 - 21, 2025$3,350.00Mar 19 - 21, 2025$3,350.00Apr 23 - 25, 2025$3,350.00May 21 - 23, 2025$3,350.00Jun 18 - 20, 2025$3,350.00Jul 23 - 25, 2025$3,350.00