-
admin
Business Intelligence with SSAS Training Course
Overview SSAS (SQL Server Analysis Services), is a Microsoft SQL Server transactional processing (OLAP) and data mining tool for analyzing data across multiple databases, tables or files. The semantic data models provided by SSAS are used by client applications such as Power BI, Excel, Reporting Services, and other data visualization tools. In this instructor-led, live […]
-
admin
Introduction to SQL Server 2012 Integration Services (SSIS) Training Course
Requirements Prior experience with SQL Server 2012 Course Outline ETL and SSIS Packages Control Flow Workflow Constraints Data Flows Variables Containers Transactions Errors and Debugging Logging Slowly Changing Dimensions Deploying a Package Security Scripting Best Practices
-
admin
Developing in SQL Server Business Intelligence Training Course
Overview Developers, analysts and business users need to quickly analyse large amounts of data, get insight into that data, retrieve hidden knowledge inside it, and report against various data sources professionally and effectively. This course will enable them to do this with SQL Server Business Intelligence. The 5 day course will cover the SQL Server components […]
-
admin
Administration with Powershell Training Course
Overview This intensive training provides the fundamental knowledge and skills to use Windows PowerShell for automating administration of Windows based computers. The skills taught in this course are applicable to all Microsoft products that use Windows PowerShell for daily administration. Training focuses mainly on using Windows PowerShell as an interactive command line interface however it also […]
-
admin
Database Administration Fundamentals for MS SQL Server Training Course
Overview After completing this course, students will be able to: Understand Core Database Concepts Create Database Objects Manipulate Data Understand Data Storage Administer a Database Requirements Background in Database Concept Course Outline Module 1: Understanding Core Database Concepts •Introduction core database concepts •Define databases •Example of relational database tables •Introduce common database terminology •Relational Concepts […]
-
admin
MS SQL Server 2016 Training Course
Overview As a core of the Microsoft data platform, SQL Server is a leading operational database management system. Course Outline Performanace and Management Enhanced Database Caching Query data store In-Memory OLTP in SQL Server 2016 Development Temporal Database Temporary Table and Variable Table in-memory Native JSON High Availability and Security Enhanced AlwaysOn Always Enrypted Row-level […]
-
admin
Microsoft SQL Server 2008/2012 (MSSQL) Training Course
Overview This course has been created for delegates already acquainted with SQL in Microsoft SQL Server Environment 2008/2012. The course focuses on set-based querying and query tuning, working with indexes and analyzing execution plans. The training also covers table expressions, ranking functions and how to deal with partitioned tables. Requirements Good SQL knowledge in Microsoft […]
-
admin
Administering in Microsoft SQL Server Training Course
Overview The course is designed for administrators, developers and database developers. The objectives of the training: acquire and strengthen the skills to create and manage databases knowledge of the syntax and use SQL to retrieve and modify data apply safety rules in the database the use of advanced elements (replication, automation, BI) the use of […]
-
admin
Redis for High Availability and Performance Training Course Training Course
Overview Redis is an open source (BSD licensed), in-memory data structure store, used as database, cache and message broker. Requirements Participants should be comfortable with basic system administration tasks using linux command line. Some topics require programming or scripting skills. When booking, please list the programming languages that you are familiar with. If there are […]
-
admin
ApsaraCache for Administrators Training Course
Overview ApsaraCache is a fork of Redis, the cloud-based in-memory data structure store that is commonly used as a database, cache and a message broker. ApsaraCache solves stability bottlenecks caused by frequent AOF Rewrite with time-based recovery to precision in seconds. It also solved the syncing problem when there’s a patchy connection. This instructor-led, live […]
