"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com

Courses


hey this is here

INTRODUCTION This 4 day course is intended for IT professionals, business analysts, and developers who need to implement data transfer, or ETL (Extract, Transform, and Load), solutions by using Microsoft SQL Server 2016 or 2017 Integration Services. Students will learn about the SQL Server Data Tools (SSDT) development environment to create SSIS projects and packages, work with Control Flow Tasks, and design Data Flows using a variety of transformations and data sources/destinations (including SQL Server databases, flat files, and Excel). Delegates will also learn about SSIS project and package management, deployment, debugging, error handling, and logging techniques. The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises. With the course structure being fully modularised, customised versions of this course can also be devised and delivered. For example, clients interested in only the essentials of SSIS could attend just the first 3 days of the course, omitting the Advanced SSIS Concepts ordinarily covered on day 4. PREREQUISITES No prior knowledge of the subject matter is assumed. However, students should ideally be familiar with basic programming concepts, and understand the fundamental design of relational databases and data normalization. Some prior working knowledge of SQL Server 2017 (or earlier), and the use of SQL Server Management Studio, is assumed. Attendees should additionally be familiar with the SQL query language, in particular the SELECT, UPDATE, INSERT, and DELETE statements.

FURTHER DETAILS
hey this is here

INTRODUCTION: This course is aimed at existing users of Power BI, Excel Power Pivot, or SQL Server Analysis Services (SSAS) Tabular, who need to take their data analysis skills to the next level. COURSE AIMS: You will learn how to mine and expose hidden information with the DAX (Data Analysis eXpressions) language. Common business scenarios are covered, highlighting useful DAX patterns that can be implemented and adapted to solve a variety of simple and complex calculations. The theory behind the concepts of DAX will be emphasised through practical examples.

FURTHER DETAILS
hey this is here

This five-day course will teach you how to plan, configure, and manage the advanced features in a SharePoint 2016 environment. The special areas of focus for this course include implementing high availability, disaster recovery, service application architecture, and Microsoft Business Connectivity Services. This course also focuses on social computing features, productivity, and collaboration platforms and features. Students also will learn about business intelligence solutions, Enterprise Content Management, web content management infrastructure, solutions, and apps. This course also covers how to develop and implement a governance plan, and how to perform an upgrade or a migration to SharePoint 2016. This is the second in a sequence of two courses for IT Professionals and is aligned with the SharePoint 2016 IT Pro certification.

FURTHER DETAILS
hey this is here

This course is comprised of the following Microsoft Official Curriculum modules: MS-300T01 Managing Office 365 Content Services MS-300T02 Managing SharePoint Online

FURTHER DETAILS
hey this is here

This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement, and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using KeyVault and Managed Identities. Students will also learn how to connect to and consume Azure services and third-party services and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions.

FURTHER DETAILS
hey this is here

This course provides students with the knowledge and skills required to install and configure Windows 10 desktops and devices in a corporate Windows Server domain environment. The skills that this course details include learning how to install and customize Windows 10 operating systems and apps, and configure local and remote network connectivity and storage. Students also will learn how to configure security for data, devices, and networks, and maintain, update, and recover Windows 10.

FURTHER DETAILS
hey this is here

Installing and Configuring Windows 10. This course is designed to provide students with the knowledge and skills required to install and configure Windows 10 desktops and devices in a Windows Server domain corporate environment. These skills include learning how to install and customize Windows 10 operating systems and apps, and configure local and remote network connectivity and storage. Students will also learn how to configure data security, device security, and network security, and maintain, update, and recover Windows 10. Audience Profile

FURTHER DETAILS
hey this is here

This course is intended for IT professionals who are interested in: Expanding their knowledge base and technical skills about Windows 7 Client. Acquiring deep technical knowledge of Windows 7. Learning the details of Windows 7 technologies. Focusing on the 'how to' associated with Windows 7 technologies.

FURTHER DETAILS
hey this is here

Objectives: Tutor led hands on training day covering Excel Formulae. In this course we concentrate on Excel Formulae from a basic level through to advanced – the exercises used through this training are designed to help the candidate master financial modelling whist showing shortcuts and tips to assist with effective use of this spreadsheet software. Who should attend? This course is beneficial for candidates who need a good understanding of formulas and functions.

FURTHER DETAILS
hey this is here

This course offers a good grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level. Target student: People who intend to design databases from scratch or improve existing Access database skills. Introduction

FURTHER DETAILS
hey this is here

Course Objective To give an introduction to database design concepts. This course offers grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level. Target student People who intend to design databases from scratch or improve existing Access databases also covers conversion of databases made in other applications and spreadsheet (flat file) databases. The training also cover the Conversion of databases made in other applications and spreadsheet (flat file) databases. Prerequisites This course assumes no previous experience of database design. However, delegates with some experience in database design will find this course beneficial if they do not know Access.

FURTHER DETAILS
hey this is here

During this intermediate/advanced training day we concentrate on Macros, Database Utilities, Security, and create a Switchboard. Prerequisites: Candidates should have ideally attended Access Level 1 & Level 2 training or have equivalent working knowledge before attending this Access intermediate/advanced training day.

FURTHER DETAILS