"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 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
hey this is here

INTRODUCTION This 2 day course is intended for students who are already competent at querying data in a Microsoft SQL Server database, and need to take their skills to the next level. This course would be suitable for anyone who wants to more clearly understand the inner workings of Microsoft SQL Server from a performance perspective. After taking this course, students will be able to analyse the performance of their queries, and the database engine, and be able to rectify various performance related problems. You will find that this is a comprehensive course for this level, with plenty of illustrated examples and augmented with practical hands-on exercises.

FURTHER DETAILS
hey this is here

Course objectives: In this training day we look at the more advanced features of this diagramming and vector graphics software application such as how to work with multiple pages, backgrounds, styles, master shapes, shape sheets, layers and templates. Target Audience: Candidates who wish to use Visio for creating workflows and other diagrams and who wish to use Visio to create complex graphics and illustrations. Prerequisites: Delegates should be familiar with the Windows operating system. Attendance on Visio (L1) training or equivalent working knowledge.

FURTHER DETAILS
hey this is here

Course objectives: Microsoft Visio is a diagramming tool that can be used to visually communicate representations of ideas, processes, concepts, structures, layouts, software models etc. In this 1 day training we cover the fundamentals and show how using Microsoft Visio removes the tedious process of creating diagrams by providing the tools to create complex diagrams in a user friendly manner. Target Audience: This course is designed for new Visio users, or users that are self-taught. Prerequisites: No previous experience on Visio is required to attend the course.

FURTHER DETAILS