16 training courses found | Help me choose

The SETC certified complete Database course targets database management systems such as MySQL, Oracle, SQL Server, PostgreSQL. This course is designed to be a practical study into the management of a multi-platform database work environment. Though the focus will be on the Oracle platform, the content will be discussed in a platform generic way to allow practical application to SQL Server, MySQL and PostgreSQL environments. Part I of the course focusses on the essentials of the SQL language as it is applied to a variety of database platforms. If you work in a multi-platform environment, this course will provide you with a comprehensive overview of the SQL language as it is defined by the ANSI standard. Custom training course titled The Complete Database Administrator Course Part 1 : Mastering the SQL Language that will allow you to hone your professional skills.

Jan 16 to Jan 19, 2018$2,775/person Feb 13 to Feb 16, 2018$2,775/person Mar 13 to Mar 16, 2018$2,775/person
This intensive SETC certified course provides a comprehensive and detailed exploration of the PL/SQL language and it many nooks and crannies. Starting with the basic concepts of the SQL language, the course quickly accelerates to coverage of advanced SQL techniques and PL/SQL programming fundamentals. This is followed by modules covering the concepts of cursors, triggers, procedures and functions and packages. An no course on PL/SQL would be complete in the absence of object oriented programming, Java integration and XML processing. So we do that too. Finally, we conclude our grand tour of PL/SQL with a look at performance and an introduction to performance tuning concepts. If you want to learn PL/SQL, this is the course for you. Custom training course titled The Complete PL/SQL Programming Course that will allow you to hone your professional skills.

Oct 30 to Nov 3, 2017$2,775/person Jan 23 to Jan 26, 2018$2,775/person Feb 20 to Feb 23, 2018$2,775/person Mar 20 to Mar 23, 2018$2,775/person
This SETC Certified course provides participants with a wealth of knowledge in the area of database development in a .NET environment. The course begins with a look at the System.Data namespace and its many classes, Participants learn to make DSNless connections using connection classes while they learn to execute SQL statements or run stored procedures using specific command classes. Having mastered the basic elements of ADO .NET, the course introduces participants to the LINQ for SQL paradigm for database programming as well as the ORM techniques that are associated with NHibernate. In passing, the power of the Microsoft Enterprise Library is also explored. Custom training course titled Professional Database Programming for .NET: ADO .NET, NHibernate and LINQ for SQL that will allow you to hone your professional skills.

Jan 16 to Jan 19, 2018$2,775/person Feb 13 to Feb 16, 2018$2,775/person Mar 13 to Mar 16, 2018$2,775/person
This SETC certified course explore the power and flexibility of the Qt library. Starting with a solid introduction to the Qt library, experienced C++ developers are given a guided tour of building user interfaces with the Qt library. Developers are taught how to use core classes, dialogs, windows, widgets, MVC and more. The course concludes with an exploration of painting and styling. The Qt Graphics View is covered at the end if time permits. SETC Training – Formation SETC Training provides expert C++ training in Ottawa, Montreal, Toronto, Calgary and Quebec. Custom training course titled Advanced C++ Programming: Mastering the Qt Library that will allow you to hone your professional skills.

Nov 1 to Nov 3, 2017$2,775/person Jan 10 to Jan 12, 2018$2,775/person Feb 7 to Feb 9, 2018$2,775/person Mar 7 to Mar 9, 2018$2,775/person
Custom training course titled Mastering SQL for Data Analysis with Oracle Toad (Beginner Level) that will allow you to hone your professional skills.

Dec 5 to Dec 8, 2017$2,775/person Jan 23 to Jan 26, 2018$2,775/person Feb 20 to Feb 23, 2018$2,775/person Mar 20 to Mar 23, 2018$2,775/person
This SETC certified course introduces programmers to the essentials of object oriented design and implementation. A brief review of the fundamental elements of the C# language is followed by an introduction to the world of object oriented programming. The course continues with an introduction to the design techniques that are associated with an object oriented approach. The focus then switches to implementation and to the development of classes using C#. The topics of objects, inheritance, polymorphism, abstract classes, constructors and destructors are covered in detail. The course concludes with a detailed look at collection classes, generics, files and streams as well as serialization and security. Custom training course titled Mastering Object Oriented Programming with C# .NET that will allow you to hone your professional skills.

Nov 13 to Nov 17, 2017$2,775/person Jan 29 to Feb 2, 2018$2,775/person Feb 26 to Mar 2, 2018$2,775/person Mar 26 to Mar 30, 2018$2,775/person
This SETC Certified course introduces programmers to the essentials of object oriented design and implementation using VB .NET. A brief review of the fundamental elements of the VB .NET language is followed by an introduction to the world of object oriented programming. The course continues with an introduction to the design techniques that are associated with an object oriented approach. The focus then switches to implementation and to the development of classes using VB .NET. The topics of objects, inheritance, polymorphism, abstract classes, constructors and destructors are covered in detail. The course concludes with a detailed look at collection classes, generics, files and streams as well as serialization and security. Custom training course titled Mastering Object Oriented Programming with VB .NET that will allow you to hone your professional skills.

Nov 13 to Nov 17, 2017$2,775/person Jan 9 to Jan 12, 2018$2,775/person Feb 6 to Feb 9, 2018$2,775/person Mar 6 to Mar 9, 2018$2,775/person
This SETC Certified database course introduces the SQL Server relational database management system. Every aspect of SQL Server database administration is covered from the creation of relational databases and their tables to the development of powerful SQL scripts to automate primary administrative tasks. This complete course discusses the various security mechanisms that are provided by the SQL Server database engine. This course also includes coverage of performance optimization, backup and recovery and indexing amongst others. If you want to implement a SQL Server database in your organization, this is the course for you. Custom training course titled SQL Server Core Administration Skills that will allow you to hone your professional skills.

Jan 9 to Jan 12, 2018$2,775/person Feb 6 to Feb 9, 2018$2,775/person Mar 6 to Mar 9, 2018$2,775/person
This SETC certified course covers every aspect of the SQL language. Beginning with database basics like creating databases and tables, we proceed to a thorough investigation of the SQL language. We discuss the basic data manipulation statement of SQL together with the data modification statements of the language. With some basics under our belts, we are freed to look at more advanced topics like string and date time manipulation as well as the use of NULL values in tables and scripts. We also take the time to study joins and aggregated data along the way. It makes for a busy and rewarding 2 days. Custom training course titled Introducing SQL: The Basics of Database Querying that will allow you to hone your professional skills.

Jan 29 to Jan 30, 2018$1,150/person Feb 26 to Feb 27, 2018$1,150/person Mar 26 to Mar 27, 2018$1,150/person
Custom training course titled Mastering SQL for Data Analysis with Oracle Toad (Intermediate-Advanced Level) that will allow you to hone your professional skills.

Nov 7 to Nov 10, 2017$2,775/person Jan 30 to Feb 2, 2018$2,775/person Feb 27 to Mar 2, 2018$2,775/person Mar 27 to Mar 30, 2018$2,775/person
This SETC certified course covers the full range of SSIS concepts from the basics of data sources to advanced data flows and control flows. The course begins with a tour of the BIDS (Business Intelligence Development Studio) environment and its many windows, dialog boxes and features, From there, the student is taken through a comprehensive investigation of basic tasks such as importing data from delimited and positional files, exporting data to external data sources and implementing simple error conditions. Having mastered the basics, the course proceeds to study the intricacies of complex data transformation tasks which require transformations, NULL value handling and encoding changes. This comprehensive learning event concludes with a case study which shows participants how to load a data warehouse using SSIS packages. If you want to use SSIS to manipulate your data, this SETC certified course is the course for you. Custom training course titled Maintaining and Transforming Data with SSIS that will allow you to hone your professional skills.

Jan 17 to Jan 19, 2018$2,250/person Feb 14 to Feb 16, 2018$2,250/person Mar 14 to Mar 16, 2018$2,250/person
This SETC certified course covers every aspect of database administration in a production SQL Server environment. Beginning with the configuration of the underlying operating system, the course explores every aspect of the installation and configuration process in both a dedicated and virtual topology. We then tackle the creation of databases, files and filegroups in complex multi-server environments. This is followed by detailed discussions of data import and export, backup and recovery, SQL Server security, SQL Server monitoring and performance tuning. This course also includes a full discussion of indexes, index types and performance tuning. The course concludes with an extensive hands-on lab that allows participants to practice the skills that they have learned in the course. Custom training course titled SQL Server Administration: The Complete Course that will allow you to hone your professional skills.

Nov 6 to Nov 9, 2017$2,775/person Jan 23 to Jan 26, 2018$2,775/person Feb 20 to Feb 23, 2018$2,775/person Mar 20 to Mar 23, 2018$2,775/person
This SETC certified course provides business participants with the skills they need to organize, analyze, validate and present corporate data using Microsoft Excel. Starting with the essential concepts of data layout in Microsoft Excel, the course introduces participants to the use of both basic and advanced functions. This is following by a detailed discussion of PivotTables, chart development and a comprehensive introduction to Macro development. If you need to use Microsoft Excel to analyze data, this SETC certified course will teach you the skills you need. SETC Training - Formation SETC provides advanced Microsoft Excel training in Ottawa, Montreal, Toronto, Quebec and Calgary. Custom training course titled Intermediate Microsoft Excel for Business Users that will allow you to hone your professional skills.

Nov 30 to Dec 1, 2017$1,150/person
This SETC Certified course allows participants to familiarize themselves with every aspect of ASP .NET MVC based development. We begin with an overview of the architecture and organization of an ASP .NET MVC based web application. With the basics in hand, we move ahead full steam into a detailed exploration of views and actions as well as data and state management. The course concludes with a discussion on performing a migration from a traditional ASP .NET application architecture to a more modern ASP .NET MVC architecture. If you need to become productive fast with ASP .NET MVC, this is the SETC Certified course for you. Custom training course titled The Complete ASP .NET MVC Course: From Design to Implementation that will allow you to hone your professional skills.

Nov 21 to Nov 24, 2017$2,775/person Jan 9 to Jan 12, 2018$2,775/person Feb 6 to Feb 9, 2018$2,775/person Mar 6 to Mar 9, 2018$2,775/person
This SETC Certified System design course provides IT professionals with a good overview of the end to end roles and responsibilities of a software designer in the context of an application development project. The course begins with a discussion of the differences between a waterfall methodology and an iterative methodology as it applies to the systems design role. It is worth noting that the iterative methodology is emphasized and discussed in detail in this course. Having situated systems design within the larger context of the overarching methodology, a thorough discussion of business use cases, system use cases, UML and database design is undertaken. The focus is on the development of high quality functional requirements in support of a particular design activity. This is followed by an implementation workshop which allows participants to see how a given design can be implemented using the object oriented language of their choice. If time permits, the course concludes with an overview of design patterns and of their implementation in the chosen language. Custom training course titled Business Analysis for Software Development: The Rational Unified Process and the Unified Modeling Language in Practice that will allow you to hone your professional skills.

Jan 29 to Feb 2, 2018$2,775/person Feb 26 to Mar 2, 2018$2,775/person Mar 26 to Mar 30, 2018$2,775/person
This SETC Certified System design course provides IT professionals with a good overview of the end to end roles and responsibilities of a software designer in the context of an application development project. The course begins with a discussion of the differences between a waterfall methodology and an iterative methodology as it applies to the systems design role. It is worth noting that the iterative methodology is emphasized and discussed in detail in this course. Having situated systems design within the larger context of the overarching methodology, a thorough discussion of business use cases, system use cases, UML and database design is undertaken. The focus is on the development of high quality functional requirements in support of a particular design activity. This is followed by an implementation workshop which allows participants to see how a given design can be implemented using the object oriented language of their choice. If time permits, the course concludes with an overview of design patterns and of their implementation in the chosen language. Custom training course titled Object Oriented Analysis and Design: Mastering UML that will allow you to hone your professional skills.

Oct 23 to Oct 27, 2017$2,775/person Jan 29 to Feb 2, 2018$2,775/person Feb 26 to Mar 2, 2018$2,775/person Mar 26 to Mar 30, 2018$2,775/person