30 training courses found | Help me choose

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 database course introduces the MySQL Relational Database Management System. Every aspect of MySQL 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 MySQL database engine. This course also includes coverage of performance optimization, backup and recovery and indexing amongst others. If you want to implement a MySQL database in your organization, this is the course for you. Custom training course titled MySQL Core Administration Skills that will allow you to hone your professional skills.

Nov 21 to Nov 24, 2017$3,350/person Jan 30 to Feb 2, 2018$3,350/person Feb 27 to Mar 2, 2018$3,350/person Mar 27 to Mar 30, 2018$3,350/person
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 II of the course focusses on the components of a production environment that allow database professionals to excel in their mission critical responsibilities. Custom training course titled The Complete Database Administrator Course Part II : Mastering MySQL and Oracle Administration that will allow you to hone your professional skills.

Nov 27 to Dec 1, 2017$2,775/person Jan 8 to Jan 12, 2018$2,775/person Feb 5 to Feb 9, 2018$2,775/person Mar 5 to Mar 9, 2018$2,775/person
This SETC certified course introduces programmers database connectivity using the Java programming language and JDBC. Custom training course titled A Bit of JDBC that will allow you to hone your professional skills.

Jan 15 to Jan 16, 2018$1,150/person Feb 12 to Feb 13, 2018$1,150/person Mar 12 to Mar 13, 2018$1,150/person
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 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 intensive SETC certified course provides a comprehensive and detailed exploration of Oracle database administration. Starting with the basic tools of the trade, the course quickly accelerates to coverage of installation, configuration, databases, tablespaces, files and more. This is followed by modules covering enterprise manager, fault tolerance, high availability, security, partitioning, and flashback management amongst others. And no course on Oracle administration course would be complete in the absence of indexing. So we do that too. Fine tune your Oracle database administration skills with this exceptionally effective SETC certified course. Custom training course titled Professional Oracle Administration that will allow you to hone your professional skills.

Nov 20 to Nov 24, 2017$2,775/person Jan 15 to Jan 19, 2018$2,775/person Feb 12 to Feb 16, 2018$2,775/person Mar 12 to Mar 16, 2018$2,775/person
This intensive SETC certified course provides a comprehensive and detailed exploration of Oracle database performance tuning and optimization. Starting with the basic tools of the trade, the course quickly accelerates to coverage of structural SQL optimization techniques and PL/SQL optimization. This is followed by modules covering the concepts of indexing as well as server and memory optimization techniques. And no course on Oracle tuning would be complete in the absence of a comprehensive performance tuning lab. So we do that too. Fine tune your Oracle database with this exceptionally effective SETC certified course. Custom training course titled Professional Oracle Database Tuning and Optimization that will allow you to hone your professional skills.

Nov 27 to Dec 1, 2017$2,275/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 covers every aspect of the TSQL development language. Beginning with database basics like creating databases and tables, we proceed to a thorough investigation of the TSQL language. We discuss variable declaration, conditional and looping expressions and the use of native functions. 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 consider the use of stored procedures and BLOB data. It makes for a busy and rewarding week. Custom training course titled The Complete TSQL Programming Course that will allow you to hone your professional skills.

Dec 18 to Dec 21, 2017$2,775/person 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 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 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
This SETC Certified course focuses on the many aspects of UNIX based security and hacking principles. Beginning with a complete discussion of UNIX security, the course proceeds quickly to the anatomy of an attack on UNIX based systems. Every part of the UNIX OS is included in the discussion including databases, web servers and many other UNIX system components. If you need to protect a UNIX-based system, this is the course for you. Custom training course titled UNIX Security and Hacking: A Complete Course that will allow you to hone your professional skills.

Oct 30 to Nov 3, 2017$2,775/person Jan 15 to Jan 19, 2018$2,775/person Feb 12 to Feb 16, 2018$2,775/person Mar 12 to Mar 16, 2018$2,775/person
This SETC certified course covers the essentials skills that are necessary to design. implement and troubleshoot Oracle Forms and Reports in an Oracle 11g environment. Whether you need to build a report that highlights sales in the last quarter or build a form that allows sales to be entered into an Oracle database, this is the couese for you. Come learn how to leverage the power and flexibility of Oracle Forms and Reports with this informative and fast-paced SETC certified course. Custom training course titled A Complete Introduction to Forms and Reports that will allow you to hone your professional skills.

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 focuses on the art, function and application of the testing discipline using a full lifecycle approach with HP QuickTest Pro. Every aspect of the testing activity is discussed including testing fundamentals, test recording, advanced features, database integration, test automation and exception handling. The course ends with a full practical lab that allows participants to apply the skills they have learned to a real-world practical scenario. Custom training course titled Mastering HP Quick Test Pro that will allow you to hone your professional skills.

Jan 9 to Jan 12, 2018$3,350/person Feb 6 to Feb 9, 2018$3,350/person Mar 6 to Mar 9, 2018$3,350/person
Hibernate is the gold standard of Object Relational Mapping (ORM) technology. This SETC certified course introduces programmers to Hibernate, starting from the basics followed by object mapping and HQL. The students are given hands-on exercice allowing them to develop an ORM solution against a database. Custom training course titled Professional Hibernate Development that will allow you to hone your professional skills.

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 provides a comprehensive exploration of the installation, configuration and maintenance of a production Oracle environment on a UNIX-LINUX platform. Topics covered include an overview of the different architectures, performance optimization through caching/tuning, backup and recovery and security. This comprehensive course discusses every aspect of Oracle database administration Custom training course titled Oracle Core Administration Skills that will allow you to hone your professional skills.

Jan 8 to Jan 12, 2018$2,775/person Feb 5 to Feb 9, 2018$2,775/person Mar 5 to Mar 9, 2018$2,775/person
This SETC Certified course focuses on the art, functionality and application of Data Mining and Data Warehousing as performed within an Oracle OLAP database environment. Beginning with the definitions of facts and dimensions, the course discusses every aspect of the Data Warehouse creation process from data loading to data mining. Implementing a data warehouse has never been this intuitive. Custom training course titled Building a Data Warehouse with Oracle that will allow you to hone your professional skills.

Jan 22 to Jan 26, 2018$3,350/person Feb 19 to Feb 23, 2018$3,350/person Mar 19 to Mar 23, 2018$3,350/person
This SETC Certified course provides seasoned PERL programmers with skills that allow them to perfect their scripts. Included is coverage of modules, references, advanced regular expressions and text manipulation and a few other tips and tricks. In addition, the course discusses the use of PERL in connecting to networks and relational databases. This is the PERL course for those people who live and breathe PERL. Custom training course titled Advanced Perl Programming that will allow you to hone your professional skills.

Jan 23 to Jan 26, 2018$2,500/person Feb 20 to Feb 23, 2018$2,500/person Mar 20 to Mar 23, 2018$2,500/person
This SETC certified course is an introduction to the Perl programming language. The course provides an overview of the benefits of using Perl starting with the basics and moving to command structure, operators, scalars, flow control, sub-routines, collections and lists. Students get hands-on experience working with regular expressions as well as reading and modifying files using Perl scripts. A brief overview of database programming is also provided. Custom training course titled Perl Scripting Essentials that will allow you to hone your professional skills.

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 provides a comprehensive introduction to the PHP programming language. This course covers everything from variable declarations to database programming. If you need to master PHP, this is place to start. Custom training course titled PHP Professional Development 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 provides developers with a comprehensive overview of the powerful and flexible development language of PL/SQL. Beginning with the creation of database tables, the course presents a variety of PL/SQL language features in a logical and sequential order beginning with SQL syntax and ending with packages and functions. If you need to work with PL/SQL, this course will get you started in the right direction. Custom training course titled An Introduction to PL/SQL Development for Professional Developers that will allow you to hone your professional skills.

Dec 6 to Dec 8, 2017$2,250/person Jan 10 to Jan 12, 2018$2,250/person Feb 7 to Feb 9, 2018$2,250/person Mar 7 to Mar 9, 2018$2,250/person
This SETC Certified course covers the essential elements of the PL/SQL language. This course includes the creation and deletion of tables and the use of SQL to display, insert, delete and modify relational data. Having covered the basics of relational database manipulation, the course introduces participants to the more formal elements of the PL/SQL language including blocks, data types, variables and program flows. The course concludes with a preliminary exploration of procedures and functions in the context of PL/SQL packages. Custom training course titled Mastering Relational Database Programming with PL/SQL that will allow you to hone your professional skills.

Nov 6 to Nov 9, 2017$2,775/person 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 covers the advanced elements of the PL/SQL language. Beginning with procedures and functions, the exploration includes database triggers, PL/SQL records, PL/SQL collections, PL/SQL error handling and object oriented programming in PL/SQL. And if that was not enough, the course concludes with a detailed study of XML processing, Java integration and performance tuning and optimization. Now that is a full learning week. Custom training course titled PL/SQL and Objects: Objects, Libraries, XML, Exceptions and More that will allow you to hone your professional skills.

Jan 24 to Jan 26, 2018$1,675/person Feb 21 to Feb 23, 2018$1,675/person Mar 21 to Mar 23, 2018$1,675/person
This SETC Certified course focuses on the art, function and application of the testing discipline using a full lifecycle approach with HP QuickTest Pro. Every aspect of the testing activity is discussed including testing fundamentals, test recording, advanced features, database integration, test automation and exception handling. The course ends with a full practical lab that allows participants to apply the skills they have learned to a real-world practical scenario. Custom training course titled A Comprehensive Introduction to HP Quick Test Pro that will allow you to hone your professional skills.

Jan 16 to Jan 19, 2018$3,350/person Feb 13 to Feb 16, 2018$3,350/person Mar 13 to Mar 16, 2018$3,350/person
Team Foundation Server is a fully integrated management tool for application development. Microsoft Team Foundation Server allows code development organizations to store their code in a version control database while managing every aspect of their application development projects from requirements to bug tracking to wotk item tracking to reporting. In its full expression, Microsoft Team Foundation Server provides full support for iterative software development activities. This SETC certified course provides participants with a comprehensive overview of the Team Foundation Server environment including creating projects, managing code as well as planning and implementing daily builds. The course also covers SharePoint and SQL Server Reporting Services integration. Project Server integration can also be added as per participant requirements. Custom training course titled Implementing Microsoft Team Foundation Server 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 provides participants with a detailed exploration of the .NET development environment in the context of Windows forms based development. We begin with the architecture of a Windows based application and of windows forms. The course then looks at the use of controls to implement a bilingual interface. Concepts such as data validation and user navigation are also studied to ensure complete coverage of the subject matter. Having mastered the basics of windows forms development, the course devotes much of the last part of the course to more advanced topics. These topics include globalization, database access, multi-threaded programming and messaging amongst others. If you need to develop a traditional Windows based application, this SETC certified course if for you. Custom training course titled Creating Professional Multilingual Windows .NET Applications that will allow you to hone your professional skills.

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 provides participants with a detailed exploration of the ASP .NET web development environment. We begin with the architecture of an ASP .NET web application and of web forms. The course then looks at the use of controls to implement a bilingual interface. Concepts such as data validation and user navigation are also studied to ensure complete coverage of the subject matter. Having mastered the basics of web site development in an ASP .NET environment, the course devotes much of the last part of the course to more advanced topics. These topics include globalization, database access, state management and messaging amongst others. If you need to develop a traditional ASP .NET web application, this SETC certified course if for you. Custom training course titled Creating Professional Multilingual Web Applications with ASP .NET that will allow you to hone your professional skills.

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 introduces programmers to the essentials of object oriented design and implementation. The course begins with an introduction to the principles of iterative application development as defined by the Rational Unified Process (RUP). This is followed by an introduction to the practices of object oriented analysis and design as they are applied in an iterative methodology. Having completed our discussion of the analysis and design phases of the software development lifecycle, the implementation of object oriented principles in a .NET environment begins. This includes the development of classes as well as the use inheritance, polymorphism, abstract classes, constructors and destructors. This is followed by an exploration of key .NET programming concepts such as collections, generics, files and streams and multi-threaded programming. The course concludes with a look at web application development with ASP .NET and database development with ADO .NET. Custom training course titled The Complete .NET Development Course that will allow you to hone your professional skills.

Jan 8 to Jan 16, 2018$6,600/person Feb 5 to Feb 13, 2018$6,600/person Mar 5 to Mar 13, 2018$6,600/person
This SETC certified course provides business participants with the skills they need to automate almost any business task using Microsoft Excel. Starting with a review of essential concepts in data analysis using Microsoft Excel, the course quickly proceeds to a complete and in depth study of macros and VBA development. The course covers every aspect of VBA development including the Excel object model, looping, functions, conditional logic and database access amongst others. If you need to use Microsoft Excel to automate your business tasks, 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 Advanced Microsoft Excel: Mastering Task Automation that will allow you to hone your professional skills.

Contact us for delivery$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