Live Instructor-Led Training
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.
Sep 25 - 27, 2024$3,350.00Oct 23 - 25, 2024$3,350.00Nov 20 - 22, 2024$3,350.00
SSIS Overview
SQL Server Core Services
SSIS Architecture
The .NET Framework Runtime
About .NET Namespaces
Using BI Development Studio
Creating a SSIS Project
Debugging a SSIS Package
SSIS Essentials
About the Integration Services Template
Understanding Data Sources and Data Source Views
About Packages and the Package Explorer
Creating Packages
About Control Flow and Data Flow
About Event Handlers
SSIS Data Sources
The Need for a Data Connection
Establishing a Connection using a Provider
About SQL Server and Oracle Connections
Creating a Data Source
Using Data Source Views
SSIS Control Flow
Creating a Package
About Package Templates
The Need for Data to Process Separation
Distinguishing between the Control Flow and the Data Flow
About the Control Flow Designer
Implementing Structure with Containers
Implementing Functionality with Tasks
Implementing Precedence with Precedence Constraints
SSIS Data Flow
Understanding the Need for Data Flows
About the Data Flow Designer
Implementing Inputs with Data Sources
Implementing Outputs with Data Destinations
Modifying and Aggregating Data with Tranformations
Connecting Inputs and Outputs with Data Paths
Handling Errors
Implementing Event Handlers
Common Tasks
Using SSIS to Import and Transform Data
Using SSIS to Export and Transform Data
Using SSIS to Transfer Data between Servers
Using SSIS to Load a Data Warehouse
Using SSIS to implement a Complex Business Process
Loading a Data Warehouse with SSIS
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.
Oct 1 - 4, 2024$3,000.00Oct 29 - Nov 1, 2024$3,000.00Nov 26 - 29, 2024$3,000.00
SQL Server Training: Performance Tuning & Optimization
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.
Training course titled SQL Server Training: Performance Tuning & Optimization that will allow you to hone your professional skills.
Sep 24 - 27, 2024$3,750.00Oct 22 - 25, 2024$3,750.00Nov 19 - 22, 2024$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.
Sep 24 - 27, 2024$3,750.00Oct 22 - 25, 2024$3,750.00Nov 19 - 22, 2024$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.
Oct 1 - 4, 2024$3,350.00Oct 29 - Nov 1, 2024$3,350.00Nov 26 - 29, 2024$3,350.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.
Oct 7 - 8, 2024$1,500.00Nov 4 - 5, 2024$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.
Sep 24 - 27, 2024$3,750.00Oct 22 - 25, 2024$3,750.00Nov 19 - 22, 2024$3,750.00