Information Technologies Trainings

IT Training Taxo Menu

 

N° 20464 : Developing Microsoft SQL Server Databases

This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course.

QlikView Designer

The course is a mixture of demonstrations and hands-on exercises which include user interface layout, design fundamentals, how to create a QlikView application with sheets as well as best practices in design...

QlikView Developer

Knowledge of the data model, creation of the proper data connections and scripting fundamentals are critical to creating QlikView documents that provide your organization with powerful business discovery tools. QlikView Developer provides you with an opportunity to learn by doing through a series of lectures and hands-on exercises focused on developing QlikView documents...

N° 20461 : Querying Microsoft SQL Server

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.

N° 20462 : Administering Microsoft SQL Server Databases

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

N° 20463 : Implementing a Data Warehouse with Microsoft SQL Server

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

N° 20465 : Designing Database Solutions for Microsoft SQL Server 2012

This course describes how to design and monitor high performance, highly available data solutions with SQL Server 2012. This course focuses on creating plans and designs for database structure, storage, objects, and servers. Students will have the opportunity to practices hands-on skills and design tasks in a virtual lab environment and will learn about topics such as data compression, high availability, data migration, security, and scalability.

This course maps to skills and knowledge measured by Microsoft Exam 70-465, and in conjunction with on-the-job experience, can help prepare your for the exam.

New

Microsoft SQL Server 2016

This five-day instructor-led course teaches students how to use the enhancements and new features that have been added to SQL Server and the Microsoft data platform since the release of SQL Server 2008. The course focuses on teaching individuals how to use SQL Server 2016 product features and other Microsoft data platform components.

New

N° 10986 : Updating Your Skills to SQL Server 2016

This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.

New

N° 10990 : Analyzing Data with SQL Server Reporting Services

This three-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

Pages