"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

In this course delegates will learn to configure and manage a Microsoft Exchange Server 2013 messaging environment. This course will teach delegates guidelines, best practices, and considerations that will help them optimize their Exchange server deployment. Course 20341 is an instructor-led course and will provide you with the knowledge and skills to plan, install, and manage the mailbox role, client access, transport, and Exchange infrastructure. For delegates looking to upgrade an existing Exchange 2010 infrastructure to Exchange 2013, we recommend attendance at our course Target Audience: The primary audience for this course is Information Technology (IT) professionals who are aspiring to be enterprise-level messaging administrators. Others who may take this course include IT generalists and help desk professionals who want to learn about Exchange Server 2013. Administrators coming into the course are expected to have at least 3 years of experience working in the IT field—typically in the areas of network administration, help desk, or system administration. They are not expected to have experience with previous Exchange Server versions. The secondary audience for this course are professionals who are looking to take the exam 70-341: Microsoft Exchange Server 2013, Core Solutions, as a standalone, or as part of the requirement for the MCSE: Microsoft Exchange Server 2013 certification will take this course as preparation material. Please note this course is not suitable for those wishing to learn about Exchange Online as part of an Office 365 deployment, where we recommend our course Administering an Exchange Online (in addition please note this course is not suitable for delegates wishing to learn how to deploy a Hybrid Exchange Environment (On-Premise and Exchange Online integrated).  Prerequisites Minimum of two years of experience administering Windows Server, including Windows Server 2008 R2 or Windows Server 2012. Minimum of two years of experience working with Active Directory Domain Services (AD DS). Minimum of two years of experience working with name resolution, including DNS. Experience working with certificates, including PKI certificates. Delegates will learn how to At the end of this course you will be able to: Plan and perform deployment and management of Microsoft Exchange Server 2013. Plan a Mailbox server deployment and configure the Mailbox server role. Create and manage various recipient objects in Exchange Server 2013. Plan and deploy Client Access servers. Plan and configure client connectivity to Exchange Server 2013 Client Access server. Plan and configure message transport. Plan and implement high availability. Plan and implement disaster recovery for Exchange Server 2013. Plan and configure message security options. Plan and configure administrative security and administrative auditing. Monitor and troubleshoot Exchange Server 2013.

FURTHER DETAILS
hey this is here

Target Audience: This course is intended for Information Technology (IT) Professionals with hands on experience working in a Windows server 2008 or Windows Server 2012 environment who wish to acquire the skills and knowledge necessary to be able to manage and maintain the core infrastructure required for a Windows Server 2012 and Windows Server 2012 R2 environment. The key focus for students is to broaden the initial deployment of Windows Server 2012 services and infrastructure and provide the skills necessary to Manage and Maintain a domain based Windows Server 2012 environment, providing skills in areas such as User and Group management, Network Access and Data Security. Candidates typically interested in attending this course would be Windows Server Administrators experienced in working with Windows Server 2008 or Windows Server 2012 who wish to gain skills necessary to perform daily management and maintenance tasks in a Windows Server 2012 or Windows Server 2012 R2 environment. IT Professionals who are looking to take the 411, Administering Windows Server 2012 exam IT professional wishing to take the Microsoft Certified Solutions Expert (MCSE) exams in DataCenter, Desktop Infrastructure, Messaging, Collaboration and Communications will also be interested in taking this course as they prepare for the Microsoft Certified Solutions Associate (MCSA) exams, which are a pre-requisite for their individual specialties.

FURTHER DETAILS
hey this is here

INTRODUCTION This 2 day course is intended for students who have taken the “Microsoft SQL Server 2016 and 2017 Introduction to Querying” course, or possess equivalent knowledge gained in the workplace or elsewhere. It may also prove beneficial to delegates wanting to refresh their current knowledge of the subject matter. Take your querying skills to a new level with this advanced course. Gain a deeper insight into your data and understand how SQL Server internally handles the data you query. Learn how to manipulate data in new and meaningful ways for the purposes of data analysis and reporting. Learn useful techniques for querying temporal data, such as working with date intervals and data islands. Consider best practices for writing efficient queries and avoid common pitfalls. You will find that this is a comprehensive course for this level, with plenty of illustrated examples and augmented with practical hands-on exercises. PREREQUISITES Students should ideally be familiar with basic programming concepts. They should also understand the fundamental design of relational databases including, but not restricted to, the purpose of primary and foreign keys, entity relationships, and data normalization. These prerequisites can be met by taking the 2 day “Microsoft SQL Server 2016 and 2017 Relational Database Design and Querying Fundamentals” course. Additionally, delegates should have attended the 2 day “Microsoft SQL Server 2016 and 2017 Introduction to Querying” course, or possess equivalent knowledge gained in the workplace or elsewhere.

FURTHER DETAILS
hey this is here

INTRODUCTION This 2 day course is intended for students who are new to querying data stored in either a Microsoft SQL Server 2016 or 2017 database, and who need a measured and relatively gentle introduction to the subject. It could also prove beneficial to delegates wanting to refresh their existing querying skills. You will find that this is a comprehensive course for this level, with plenty of illustrated examples and augmented with practical hands-on exercises. This course is also intended as a prerequisite to the 2 day “Microsoft SQL Server 2016 and 2017 Advanced Querying” course. PREREQUISITES Students should ideally be familiar with basic programming concepts. They should also understand the fundamental design of relational databases including, but not restricted to, the purpose of primary and foreign keys, entity relationships, and data normalization. These prerequisites can be met by taking the 2 day “Microsoft SQL Server 2016 and 2017 Relational Database Design and Querying Fundamentals” course.

FURTHER DETAILS
hey this is here

INTRODUCTION This 5 day course is intended for students new to querying and programming with Microsoft SQL Server products who need a total immersion in the subject on a SQL Server 2016 or 2017 platform. This is a very comprehensive and intensive course with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience. Additionally, with the course structure being fully modularised, customised versions of this course can also be devised and delivered to suit individual requirements. In fact, specific content from this course could also be combined with material from other related courses to produce a bespoke training package – just ask for details. PREREQUISITES Students should be familiar with basic programming concepts and also understand the fundamental design of relational databases including, but not restricted to, the purpose of primary and foreign keys, entity relationships, and data normalization, such as can be found in the following course.

FURTHER DETAILS
hey this is here

INTRODUCTION This 3 day course is intended for students who need to familiarise themselves with the various querying techniques available to retrieve data from a Microsoft SQL Server database in a report authoring environment, whether that be through an implementation of Microsoft SQL Server Reporting Services or similar reporting tool. No previous knowledge of the SQL language is assumed as the course is designed from the ground up, starting with basic queries and advancing to more complex querying methods. The last module (which is optional) will also give students the opportunity to put their SQL skills into practice by creating a simple report. On completion of the course students will be able to retrieve data using the SQL language and write effective queries for reporting purposes. PREREQUISITES Students should ideally be familiar with basic programming concepts. They should also understand the fundamental design of relational databases including, but not restricted to, the purpose of primary and foreign keys, entity relationships, and data normalization. These prerequisites can be met by taking the 2 day “Microsoft SQL Server 2016 and 2017 Relational Database Design and Querying Fundamentals” course.

FURTHER DETAILS
hey this is here

INTRODUCTION This 3 day course is intended for students who need to familiarise themselves with the various querying techniques available to retrieve data from a Microsoft SQL Server database in a report authoring environment, whether that be through an implementation of Microsoft SQL Server Reporting Services or similar reporting tool. No previous knowledge of the SQL language is assumed as the course is designed from the ground up, starting with basic queries and advancing to more complex querying methods. The last module (which is optional) will also give students the opportunity to put their SQL skills into practice by creating a simple report. On completion of the course students will be able to retrieve data using the SQL language and write effective queries for reporting purposes. PREREQUISITES Students should ideally be familiar with basic programming concepts. They should also understand the fundamental design of relational databases including, but not restricted to, the purpose of primary and foreign keys, entity relationships, and data normalization. These prerequisites can be met by taking the 2 day “Microsoft SQL Server 2016 and 2017 Relational Database Design and Querying Fundamentals” course.

FURTHER DETAILS
hey this is here

INTRODUCTION This 2 day course provides a foundation for designing, building and working with relational databases, enabling students to effectively develop and use relational databases in a business environment. The training will focus on the fundamentals of relational database design to facilitate a better understanding of how data is stored, queried, and manipulated. That said, sufficient material will be covered to enable delegates to create meaningful and usable databases in the workplace. The course will be useful to anyone wanting to know the basics of relational database design concepts, and will include coverage of such concepts as primary and foreign keys, constraints, entity relationships, data normalisation, creating databases, creating and managing tables, and native SQL Server datatypes. To facilitate the learning process and augment the theory, students will get the opportunity to design a practical working database, with plenty of hands-on exercises to implement the design. In the latter sections of the course, students will also get the chance to write some basic queries to acquaint them with the foundations of the Structured Query Language (SQL). No previous knowledge of the SQL language is assumed. This course serves as an ideal precursor to any of following courses. • SQL Server 2016 and 2017 Introduction to Querying • SQL Server 2016 and 2017 Programming • SQL Server 2016 and 2017 Querying Data for Report Developers PREREQUISITES Students should be familiar with working in a Microsoft Windows operating system environment. Additionally, knowledge of basic programming concepts would be helpful, but not essential.

FURTHER DETAILS
hey this is here

INTRODUCTION This 4 day course is intended for students who need to learn and understand the full reporting lifecycle of designing, managing, and accessing reports in a Microsoft SQL Server 2016 or 2017 environment. Days 1 and 2 will familiarise attendees with the Reporting Services development tools used to create and author reports, and will enable students to design initially basic, then more complex, reports. All of the data regions utilised in report design are covered here including tables, matrices, lists, and charts. Interactive features such as drilldown and drill-through reports are also covered in this section, as are the implementation and use of report parameters. Day 3 builds upon the knowledge gained over the previous two days by covering advanced report design concepts, such as making reports more dynamic (for example, allowing users to interactively select groups for a matrix using parameters), alternating background colours for table rows, and other handy tips to enable developers to design truly professional reports. We round off the development phase of the reporting lifecycle by considering the implementation of mobile reports and KPIs. Day 4 of the course deals more specifically with the role of the Report Server itself. Here, students will learn how to deploy reports to a Report Server, manage Report Server content, handle subscriptions, and control access to reports. Concise coverage of the subject matter is augmented with plenty of hands-on exercises to facilitate the learning process and to enable students to quickly gain confidence in using Reporting Services. Additionally, with the course structure being fully modularised, customised versions of this course can also be devised and delivered.

FURTHER DETAILS
hey this is here

INTRODUCTION This 3 day course is intended for students who need to learn the essential skills necessary to maintain a Microsoft SQL Server 2016 or 2017 system infrastructure. Being concise and hands-on, it is aimed at quickly getting students familiar with the Microsoft SQL Server administration concepts, tools and utilities. The installation of SQL Server, covered in the first module of the course, is optional and can be omitted to free up time for other topics if desired. The course focuses on managing a single on premise SQL Server Database instance and does not delve into more advanced enterprise features such as high availability and replication. Neither do we consider cloud-based solutions in this course. That said, for delegates looking to get a strong grounding in SQL Server architecture and administration, perhaps before advancing on to more advanced features, this is an ideal course upon which to build. Attendees will gain insight into the infrastructure and architecture of SQL Server, enabling individuals to fully understand the product with which they are dealing. Configuration of server instances and databases is given full treatment, as are database transaction logs, and the creation and maintenance of indexes. Concise treatment is given to managing SQL Server security, including both at the server and database level. The focus then shifts to examining how best to move and protect data, such as when importing or exporting it between heterogeneous data sources, backing it up to external media, and restoring data from a backup. Many tasks involved in the day to day administration of a SQL Server instance can be performed automatically, making an administrators life potentially simpler, and such is the subject matter in the module dealing with SQL Server Automation. The final part of the course looks at monitoring and troubleshooting SQL Server performance and related issues. PREREQUISITES Students should be familiar with working in a Microsoft Windows Server operating system environment. Delegates should also have an understanding of the fundamental design of relational databases including, but not restricted to, the purpose of primary and foreign keys, entity relationships, and data normalization. A good working knowledge of the SQL language will also be assumed.

FURTHER DETAILS
hey this is here

Introduction A brief overview of the course This 4 day course is intended for students who already have some experience with SQL and need to fast-track their querying skills to an advanced level. Effectively, this is the "Microsoft SQL Server 2016 Introduction to Querying" and "Microsoft SQL Server 2016 Advanced Querying" courses combined. This course may also prove beneficial to delegates wanting to refresh their existing querying skills.

FURTHER DETAILS