Tag Archives: Lille

All trainings in Brussels, Training Development

Training Introduction to Agile Testing – 1 day

Leave a comment

Class overview :

Agile software development practices are now so widespread that they are no longer considered ‘extreme’. However, many organisations and agile teams still struggle with how to do successful testing on an agile development project.

Class goals :

On completion of this course you will understand agile projects and how they represent a highly collaborative approach to software development. Through interactive sessions you will have gained practical exposure to the common processes of agile including:

  • Planning Iterations
  • Task Estimation
  • Prioritising tasks by business value
  • Using acceptance tests to drive development

Content of Introduction to Agile Testing

Introduction to Agile Software Development

  • Becoming Agile – Why Agile projects are different
  • A New approach to the project plan
  • The Agile Alliance & ‘Manifesto’
  • Features & characteristics of Agile methods
  • Business imperatives
  • Agile in context – conditions for success
  • Dispelling popular Agile myths
  • Examined: XP and Lean Development
  • Traditional problems, new solutions
  • Key practices

Agile Testing Strategies

  • An agile testing metaphor: hitting a moving target
  • Implications of Agile for testing strategies
  • Aligning the test cycle with the development cycle
  • Automation, automation, automation
  • Test-Driven Development
  • Testing Visibly
  • Defect Management and Triage
  • Exploratory Testing

The Agile Game

  • A fun, interactive session to explore Agile principles

Agile Tools and Techniques – an Overview

  • Test-Driven Development with xUnit
  • Continuous Integration with CruiseControl
  • Acceptance Testing with FIT
Introduction to Agile Testing
Training Introduction to Agile Testing

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
All trainings in Brussels, Training Development

Training Agile Project Management Foundation and Practitioner – 4 days

Leave a comment

Class overview :

This four-day accredited course provides participants with a thorough grounding in the DSDM® Atern® Agile approach and is comprised of three main elements

Class goals :

  • Set up an Agile project
  • Assign roles and responsibilities
  • Create prioritized lists of requirements
  • Define Increments and Timeboxes
  • Manage a Solution Development Team
  • Use Agile techniques
  • Present the benefits of Agile approaches to senior management

Content of Agile Project Management Foundation and Practitioner

What is Agile? Choosing the right agile approach

Agile Project Management – The Basics

Roles and Responsibilities

Preparing for Agile Project Management

Agile Project Management

The Agile Project Management Process and Products

Communication

Prioritization and Timeboxing

Agile Control

Requirements, Estimating

Agile Planning

Explanation of mechanics of Practitioner examination

Examination techniques

Samples of Practitioner questions

Question and answer session

Revision of major topics

Agile Project Management Foundation and Practitioner
Training Agile Project Management Foundation and Practitioner

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
All trainings in Brussels, Training Development

Training Agile Project Management Foundation – 3 days

Leave a comment

Class overview :

This course covers the newly launched certification by APMG and the DSDM Consortium that has been created to sit alongside PRINCE2 as an approach to project management. The course is equally divided between the theory of the new wave of agile project management and the practical experience of the techniques and disciplines involved.

Delegates will receive a copy of the Agile Project Management handbook and will sit the Agile Project Management Foundation exam at the end of the course.

Class goals :

To give delegates a practical understanding of Agile Project Management which is based on the internationally recognised framework of DSDM Atern. This will enable delegates to become immediately productive as a project manager in an agile project environment.

To highlight the difference between simple lightweight agile approaches which typically operate at the solution delivery (or ‘work package’) level and the greater holistic view of how multiple work streams are co-ordinated with the appropriate level of governance and control.

The course will also prepare delegates for the Foundation exam.

Content of Agile Project Management Foundation

The Fundamentals and the Philosophy

The Principles

Preparation

The Lifecycle and Products

Team structures

Roles and Responsibilities

Communication

MoSCoW and Timeboxing

Lifecycle Configuration

Estimation and Measurement

Quality and Maintainability

Planning, Control and Risk

Implementing Agile Project Management

Agile PM Foundation Exam

Agile Project Management Foundation
Training Agile Project Management Foundation

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
All trainings in Brussels, Training Development

Training Oracle SQL Queries / Advanced – 3 days

Leave a comment

Class overview :

This Oracle SQL training class helps students master SQL using an Oracle database and prepares students for a PL/SQL course. Note that this course covers SQL, not PL/SQL.

Class goals :

– Learn to create Users and Schemas.
– Learn to use pseudo-columns and functions.
– Learn to write simple and correlated subqueries.
– Learn to write simple and complex joins.
– Learn to use ROLLUP and CUBE.
– Learn to use SET operators.
– Learn to use character and non-character SQL functions.
– Learn to write INSERT, UPDATE, and DELETE statements.
– Learn to create tables.
– Learn to use keys and constraints to protect data integrity.
– Learn to use views, indexes, sequences, and synonyms.

Content of Training Oracle SQL Queries / Advanced

  1. Users and Schemas
    1. Introduction to Users and Schemas
      1. Definitions and Client Tools
      2. SQL Developer Login
    2. About the HR Schema
      1. Sample Schemas
      2. HR Schema Entities
    3. Creating An Application Schema
    4. Exercise: Create a User
  2. Pseudo Columns & Functions
    1. Using The Dual Table
    2. Functions
    3. Exercise: Use the SYSCONTEXT function
    4. Pseudo-Columns
    5. Using Rowid
    6. Using Rownum
    7. Exercise: Use ROWNUM
  3. Using Subqueries
    1. Simple Subqueries
      1. Definition
      2. Nested Subquery
    2. Inline Views
      1. Subquery in the HAVING clause
    3. Correlated Subqueries
    4. Scalar Subquery
    5. Exercise: Subqueries
  4. Joining Tables
    1. Review of Joins
    2. Equijoins
      1. Inner Joins
      2. Outer Joins
    3. Cross Joins
    4. Reflexive Join
    5. Non-Key Join
    6. Natural Joins
    7. Semijoins and Antijoins
    8. Using Named Subqueries
    9. Exercise: Join Exercises
  5. Rollup & Cube
    1. About Group Processing
    2. EMP_DETAILS_VIEW
    3. Simple GROUP BY
    4. ROLLUP Function
    5. GROUPING Function
    6. Using Cube
    7. Exercise: Practice GROUP BY, ROLLUP and CUBE
  6. Using Set Operators
    1. Set Operators Defined
    2. Relationship to Mathematical Set Theory
    3. Restrictions on Set Operators
    4. Exercise: Set Operators Exercise
  7. Conditional Processing
    1. The DECODE Function
    2. The Case Expression
    3. Exercise: Conditional Processing
  8. SQL Functions (Character)
    1. What Are SQL Functions?
    2. Character Functions
      1. CONCAT
      2. LENGTH
      3. INSTR
      4. REPLACE
      5. UPPER
      6. LOWER
      7. INITICAP
      8. LPAD
      9. RPAD
      10. TRIM
      11. TO_CHAR
      12. SOUNDEX
    3. Regular Expressions
    4. Exercise: Character Functions
  9. SQL Functions (Non-Character)
    1. Numeric Functions
      1. The TO_CHAR Function with numbers
    2. Date/Time Functions
    3. Date Format Functions
    4. Date Arithmetic Functions
    5. Null Value Functions
    6. Exercise: SQL Non-Character Functions
  10. SQL Data Manipulation Language
    1. The INSERT Statement
      1. INSERT Statement Categories
    2. The UPDATE Statement
    3. The DELETE Statement
    4. Transactions
    5. Complex Table References
    6. The MERGE statement
    7. Exercise: Data Manipulation Language (DDL)
Oracle SQL Queries / Advanced
Training Oracle SQL Queries / Advanced

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
All trainings in Brussels, Training Development

Training SQL using Oracle / Introduction – 2 days

Leave a comment

Class overview :

This Oracle training course is designed for students new to writing SQL queries with Oracle. The SQL learned in this course is standard to all modern databases, but Oracle will be used in class and syntax and functionality specific to Oracle will be pointed out.

Class goals :

– Understand how Oracle works
– Learn to use Oracle to output reports
– Learn to write queries getting data from multiple tables.

Content of Training SQL using Oracle / Introduction

  1. Relational Database Basics
    1. Brief History of SQL
    2. Relational Databases
      1. Tables
      2. Rows
      3. Columns
      4. Relationships
      5. Datatypes
      6. Primary Keys
      7. Foreign Keys
      8. Relational Database Management System
    3. Popular Databases
      1. Commercial Databases
      2. Popular Open Source Databases
      3. Valid Object References
    4. SQL Statements
      1. Database Manipulation Language (DML)
      2. Database Definition Language (DDL)
      3. Database Control Language (DCL)
  2. Simple SELECTs
    1. Introduction to the Northwind Database
    2. Some Basics
      1. Comments
      2. Whitespace and Semi-colons
      3. Case Sensitivity
    3. SELECTing All Columns in All Rows
    4. Exploring the Tables
    5. SELECTing Specific Columns
    6. Sorting Records
      1. Sorting By a Single Column
      2. Sorting By Multiple Columns
      3. Sorting By Column Position
      4. Ascending and Descending Sorts
    7. The WHERE Clause and Operator Symbols
      1. Checking for Equality
      2. Checking for Inequality
      3. Checking for Greater or Less Than
      4. Checking for NULL
      5. WHERE and ORDER BY
    8. Using the WHERE clause to check for equality or inequality
    9. Using the WHERE clause to check for greater or less than
    10. Checking for NULL
    11. Using WHERE and ORDER BY Together
    12. The WHERE Clause and Operator Words
      1. The BETWEEN Operator
      2. The IN Operator
      3. The LIKE Operator
      4. The NOT Operator
    13. More SELECTs with WHERE
    14. Checking Multiple Conditions
      1. AND
      2. OR
      3. Order of Evaluation
    15. Writing SELECTs with Multiple Conditions
  3. Advanced SELECTs
    1. Calculated Fields
      1. Concatenation
      2. Mathematical Calculations
      3. Aliases
    2. Calculating Fields
    3. Aggregate Functions and Grouping
      1. Aggregate Functions
      2. Grouping Data
      3. Selecting Distinct Records
    4. Working with Aggregate Functions
    5. Built-in Data Manipulation Functions
      1. Common Math Functions
      2. Common String Functions
      3. Common Date Functions
    6. Data Manipulation Functions
  4. Subqueries, Joins and Unions
    1. Subqueries
    2. Joins
      1. Table Aliases
      2. Multi-table Joins
    3. Using Joins
    4. Outer Joins
    5. Unions
      1. UNION ALL
      2. UNION Rules
    6. Working with Unions
  5. Conditional Processing with CASE
    1. Working with CASE
  6. (If time allows) Challenge lab
    1. Create your own SQL reports from the Northwind database
SQL using Oracle / Introduction
Training SQL using Oracle / Introduction

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
All trainings in Brussels, Training Development

Training Ruby on Rails / Introduction – 5 days

Leave a comment

Class overview :

In this Ruby on Rails training course, students will learn to create database-driven websites using Ruby on Rails. They will learn to install Ruby and Rails, to program in Ruby and use Ajax in their Ruby on Rails applications.

Class goals :

Learn to install and configure Ruby and Rails
Understand the Model-View-Controller framework architecture
Learn to program in Ruby
Learn to build database-driven applications with Ruby on Rails
Learn to work with templates
Learn to use Ajax in Ruby on Rails applications
Learn to test Ruby on Rails applications

Content of Training Ruby on Rails / Introduction

Class Outline

  1. Getting Started with Rails
    1. Installing Rails
    2. Platform requirements
      1. Supported database backends
      2. Ruby installation
      3. InstantRails for Windows
    3. Creating a new application
      1. The ‘rails’ command
      2. Tour of the Rails application layout
    4. Application configuration and bootstrapping
      1. Creating the databases
      2. Configuring database.yml
      3. Setting the default route
    5. Connecting to a Rails application
      1. controller/action/id URL semantics
      2. Dispatcher and routing roadmap
      3. Basic custom route creation
      4. Examining the log files
    6. Rails tools
      1. Managing tasks with rake (Ruby make)
      2. The application console
    7. The Model/View/Controller (MVC) framework architecture
      1. Separation of concerns
      2. MVC in the application directory layout
    8. The Rails philosophy: « Convention over configuration »
  2. Ruby Language Skills and Techniques
    1. Running Ruby
      1. Command-line Ruby
      2. The Interactive Ruby (irb) console
    2. Objects, variables, and methods
      1. Basic object-orientation concepts
      2. Naming conventions
      3. Variable assignment
      4. Local vs. instance variables
      5. Method-calling semantics
      6. Method arguments and return values
    3. Classes and modules
      1. Instantiating classes
      2. Mixing in modules
      3. Modules as namespaces
    4. Built-in classes
      1. String
      2. Array
      3. Hash
      4. Symbol
      5. Numerics
    5. Blocks and iterators
      1. Blocks vs. methods vs. lambdas
      2. Collection iteration
      3. Single-object iteration
  3. Model Design and Database Management
    1. Domain modeling for Rails and Ruby
      1. Describing the « what » of the application
      2. Creating ActiveRecord models with « generate »
    2. Object-relational mapping with ActiveRecord
      1. ActiveRecord models and Ruby classes
      2. ActiveRecord associations
        1. One-to-one, one-to-many
        2. Many-to-many
    3. « Rails-friendly » SQL
      1. Table-naming conventions
      2. Primary and foreign keys
    4. Database maintenance with ActiveRecord Migrations
      1. Default migrations
      2. Customizing migrations
      3. Migrating backwards
  4. Controller Actions and View Templates
    1. Basics of controller/view interaction
      1. Creating controllers and views with « generate »
      2. Default rendering rules
      3. Shared controller/template instance variables
      4. Separating controller logic from view specifics
    2. HTML templating with Embedded Ruby (ERb)
      1. Rules of ERb processing
      2. Layouts
      3. Using master and partial templates
    3. Fine-tuning controllers and view
      1. Controller filters
      2. Redirecting requests
      3. Default and custom view helper methods
    4. Writing and processing HTML forms in Rails
      1. Using form helper methods
      2. « Magic » field initialization from instance variables
      3. Accessing CGI data through the « params » hash
    5. Ajax calls and RJS (Ruby/JavaScript) templates
      1. Basic DOM updating with Ajax
      2. Using RJS for composite Ajax calls
  5. Application Testing
    1. Rails unit tests
      1. The Ruby TestUnit framework
      2. Writing fixtures
      3. Addressing test failures and errors
    2. Functional (controller) tests
      1. Triggering controller requests from tests
      2. Examining controller responses
  6. Ruby and Rails Resources
    1. Mailing lists
    2. Websites
    3. Books
    4. IRC channels
Ruby on Rails / Introduction
Training Ruby on Rails / Introduction

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
All trainings in Brussels, Training Development

Training PHP / Advanced – 3 days

Leave a comment

Class overview :

In this advanced PHP training course, students will learn advanced features of the PHP web programming language. You will learn object-oriented PHP programming and how to use PHP to process XML and build Ajax applications.

Class goals :

Learn how to program in object-oriented PHP.
Learn to process XML with PHP.
Learn to work with PEAR modules.
Learn PHP Security techniques.
Learn to build to an e-commerce application with PHP.

Content of Training PHP / Advanced

Class Outline

  1. Advanced PHP Techniques
    1. Multidimensional Arrays
    2. Advanced Function Definitions
    3. The Heredoc Syntax
    4. Using printf() and sprintf()
  2. Developing Web Applications
    1. Documenting Code
    2. Code Style and Structure
    3. Modularizing a Web Site
    4. Affecting the Browser Cache
  3. Advanced Database Concepts
    1. Storing Sessions in a Database
    2. Working with U.S. Zip Codes
    3. Creating Stored Functions
    4. Displaying Results Horizontally
  4. Security Techniques
    1. Remembering the Basics
    2. Validating Form Data
    3. Using PECL Filter
    4. Authentication with PEAR Auth
    5. Using MCrypt
  5. E-commerce Techniques
    1. E-commerce Concepts
    2. Creating the Database
    3. Creating the Configuration File
    4. Making the Template
    5. Creating the Index Page
    6. Browsing by Category
    7. Showing a Product
    8. Implementing a Shopping Cart
    9. Validating Credit Cards
  6. Basic Object-Oriented Programming
    1. OOP Theory
    2. Defining a Class
    3. Creating an Object
    4. The $this Attribute
    5. Creating Constructors
    6. Creating Destructors
    7. Autoloading Classes
  7. Advanced OOP
    1. Advanced Theories
    2. Inheriting Classes
    3. Inheriting Constructors and Destructors
    4. Overriding Methods
    5. Access Control
    6. Using the Scope Resolution Operator
    7. Creating Static Members
    8. Abstract Classes and Methods
  8. Real-World OOP
    1. Catching Exceptions
    2. Extending the Exception Class
    3. Creating a Shopping Cart Class
    4. Using the Cart Class
  9. Using PEAR
    1. Using Benchmark
    2. Using HTML_QuickForm
    3. Using Mail_Mime
    4. Ajax
    5. Introduction to Ajax
    6. A Simple Example
    7. Full-Fledged Ajax
    8. Debugging Ajax Applications
  10. XML and PHP
    1. What Is XML?
    2. XML Syntax
    3. Attributes, Empty Elements, and Entities
    4. Document Type Definitions
    5. Parsing XML
    6. Creating an RSS Feed
PHP / Advanced
Training PHP / Advanced

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
All trainings in Brussels, Training Development

Training PHP and MySQL – 5 days

Leave a comment

Class overview :

In this PHP training course, students will learn to create database-driven websites using PHP and MySQL or the database of their choice. The class also covers SQL basics.

Class goals :

Learn how PHP works.
Learn the basic syntax of PHP.
Learn to create dynamic interactive pages with PHP.
Learn to manipulate files with PHP.
Learn to work with arrays in PHP.
Learn to validate forms with PHP.
Learn to write functions in PHP.
Learn to manipulate and manage database data with PHP.
Learn to authenticate users with PHP.
Learn to manage sessions with PHP.
Learn to work with the MDB2 package.
Learn advanced form validation with regular expressions.
Learn to send email with PHP.
Understand how MySQL works.
Learn to use SQL to output reports with MySQL.
Learn to modify MySQL data with SQL.

Content of Training PHP and MySQL

Class Outline

  1. PHP Basics
    1. How PHP Works
    2. The php.ini File
    3. Basic PHP Syntax
      1. PHP Tags
      2. PHP Statements and Whitespace
      3. Comments
      4. PHP Functions
      5. Hello World!
    4. Variables
      1. Variable Types
      2. Variable Names (Identifiers
      3. Type Strength
      4. Hello Variables!
      5. Variable Scope
      6. Superglobals
      7. Constants
      8. Variable-Testing and Manipulation Functions
    5. PHP Operators
    6. Creating Dynamic Pages
    7. Single Quotes vs. Double Quotes
    8. Howdy World!
  2. Flow Control
    1. Conditional Processing
      1. If Conditions
    2. Loops
      1. while
      2. do…while
      3. for
      4. break and continue
  3. Arrays
    1. Enumerated Arrays
      1. Initializing Arrays
      2. Appending to an Array
      3. Reading from Arrays
      4. Looping through Arrays
    2. Associative Arrays
      1. Initializing Associative Arrays
      2. Reading from Associative Arrays
      3. Looping through Associative Arrays
      4. Superglobal Arrays
    3. Two-dimensional Arrays
      1. Reading from Two-dimensional Arrays
      2. Looping through Two-dimensional Arrays
    4. Array Manipulation Functions
  4. PHP and HTML Forms
    1. HTML Forms
      1. How HTML Forms Work
      2. A Sample HTML Form
      3. Form Variables
  5. String Manipulation
    1. Formatting Strings
      1. Concatenation
      2. String Manipulation Functions
      3. Examples of String Functions
    2. Magic Quotes
      1. magic_quotes_gpc
      2. magic_quotes_runtime
      3. Recommendation on Magic Quotes
  6. Reusing Code and Writing Functions
    1. Including Files
      1. require
      2. require_once
      3. auto_prepend_file and auto_append_file
    2. User Functions
      1. Defining and Calling Functions
      2. Default Values
      3. Variable Scope
      4. By Reference vs. By Value
    3. Form Processing
      1. Code Organization
  7. Simple SELECTs
    1. Introduction to the Northwind Database
    2. Some Basics
      1. Comments
      2. Whitespace and Semi-colons
      3. Case Sensitivity
    3. SELECTing All Columns in All Rows
    4. SELECTing Specific Columns
    5. Sorting Records
      1. Sorting By a Single Column
      2. Sorting By Multiple Columns
      3. Sorting By Column Position
      4. Ascending and Descending Sorts
    6. The WHERE Clause and Operator Symbols
      1. Checking for Equality
      2. Checking for Inequality
      3. Checking for Greater or Less Than
      4. Checking for NULL
      5. WHERE and ORDER BY
    7. The WHERE Clause and Operator Words
      1. The BETWEEN Operator
      2. The IN Operator
      3. The LIKE Operator
      4. The NOT Operator
    8. Checking Multiple Conditions
      1. AND
      2. OR
      3. Order of Evaluation
  8. Subqueries, Joins and Unions
    1. Subqueries
    2. Joins
      1. Table Aliases
      2. Multi-table Joins
    3. Outer Joins
    4. Unions
      1. UNION ALL
      2. UNION Rules
  9. Inserting, Updating and Deleting Records
    1. INSERT
    2. UPDATE
    3. DELETE
  10. Managing Data
    1. Querying a Database
      1. mysqli() Overview
      2. mysqli Methods and Properties
      3. Inserting and Updating Records
      4. mysqli Prepared Statements
  11. MDB2
    1. Advantages and Disadvantages of MDB2
      1. Why use a database abstraction layer?
      2. When not to use a database abstraction layer?
    2. Using MDB2
  12. Authentication with PHP and SQL
    1. A Database-less Login Form
  13. Regular Expressions
    1. Perl-compatible Regular Expression Functions
      1. preg_match()
      2. preg_replace()
      3. Regular Expression Tester
    2. Regular Expression Syntax
      1. Start and End ( ^ $ )
      2. Number of Occurrences ( ? + * {} )
      3. Common Characters ( . d D w W s S )
      4. Grouping ( [] )
      5. Negation ( ^ )
      6. Subpatterns ( () )
      7. Alternatives ( | )
      8. Escape Character ( )
    3. Form Validation Functions with Regular Expressions
  14. Session Control and Cookies
    1. Sessions
      1. Configuring Sessions
      2. Session Functions
    2. Cookies
  15. Sending Email with PHP
    1. mail()
      1. Shortcomings of mail()
    2. PHPMailer
  16. File System Management
    1. Opening a File
      1. fopen()
    2. Reading from a File
      1. fgets()
    3. Writing to a File
      1. fwrite()
    4. File Locking
      1. flock()
    5. Uploading Files via an HTML Form
    6. Getting File Information
    7. More File Functions
    8. Directory Functions
      1. Getting a Directory Listing
PHP and MySQL
Training PHP and MySQL

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
All trainings in Brussels, Training Development

Training Perl / Advanced – 4 days

Leave a comment

Class overview :

In this Perl training course, students already familiar with Perl will learn advanced programming techniques in Perl.

Class goals :

Learn to debug Perl applications
Learn to efficiently manipulate lists in Perl
Learn to work more effectively with Perl packages
Learn to work with Tied Variables in Perl
Learn to manipulate databases with Perl
Learn to effectively use Perl Modules
Learn to work with Perl/Tk
Learn to extend Perl with C/C++
Learn to embed the Perl Interpreter into a program
Learn to create your own Perl modules

Content of Training Perl / Advanced

Class Outline

  1. Debugging Perl
    1. Warnings
    2. Diagnostic Messages
    3. Carping, Confessing, and Croaking
    4. Strict Checks
    5. Compiler Pragmas
    6. Debugging Flags
    7. Your Perl Configuration
    8. The Devel::Peek Module
    9. The Data::Dumper Module
  2. Expert List Manipulation in Perl
    1. The grep Operator
    2. Lists, Arrays, and List Operators
    3. Context
    4. Context and Subroutines
    5. Initializing Arrays and Hashes
    6. Reference Syntax
    7. Auto-vivification
    8. Defined Values
    9. Other List Operators
    10. Usage of map, grep, and foreach
  3. Blocks and Code References in Perl
    1. Blocks
    2. Subroutines
    3. Subroutine Prototypes
    4. Code Refs and Anonymous Subroutines
    5. Typeglobbing for the Non-Squeamish
    6. Local (Dynamic) Variables
    7. Lexical Variables
    8. Persistent Private Subroutine Variables
    9. Closures
    10. The eval Operator
    11. The Block Form of eval
    12. The String Form of eval
    13. Block Form of eval for Exception Handling
  4. Perl Packages
    1. Review of Packages
    2. BEGIN and END Blocks
    3. Symbol Tables
    4. Package Variables
    5. Calling Package Subroutines
    6. Importing Package Symbols
    7. Exporting Package Symbols
    8. Using the Exporter Package
    9. The use Function
    10. AUTOLOAD and @ISA
    11. AutoLoader and SelfLoader
  5. Objects and Classes in Perl
    1. Object-Oriented Stuff
    2. Making Perl Object-Oriented
    3. References
    4. The bless Function
    5. So, What’s a Blessed Thing Good For?
    6. Calling Class and Object Methods
    7. Object Methods
    8. Writing Classes
    9. Constructors
    10. Inheritance
    11. What Perl Doesn’t Do
  6. Tied Variables in Perl
    1. Why Use tie?
    2. Tying a Scalar
    3. Inside Tied Variables
    4. untie
    5. Another Tied Scalar Example
    6. Tying an Array
    7. A Tied Array Example
    8. Tying Hashes
    9. Tie::Hash and Tie::Array
    10. Tying Filehandles
    11. What Are DBM, NDBM, GDBM, SDBM, etc?
    12. Using the DBM Modules
  7. Installing and Using Perl Modules
    1. Laziness, Impatience, and Hubris
    2. CPAN
    3. Using Modules
    4. Installing a Perl Module
    5. Unpacking the Module Source
    6. The Configuration Step
    7. The Build Step
    8. The Test Step
    9. The Install Step
    10. Using CPAN.pm
    11. Using Module Documentation
  8. Introduction to DBI/DBD in Perl
    1. The Old Way – DBPerls
    2. A Better Way – DBI/DBD
    3. Database Programming
    4. Handles
    5. Connecting to the Database
    6. Creating a SQL Query
    7. Getting the Results
    8. Updating Database Data
    9. Transaction Management
    10. Finishing Up
  9. DBI/DBD SQL Programming
    1. Error Checking in DBI
    2. Getting Connected
    3. Drivers
    4. Using Parameterized Statements
    5. Statement Handle Attributes
    6. Other Handle Attributes
    7. Column Binding
    8. The do Method
    9. BLOBs and LONGs and Such
    10. Installing DBI Drivers
  10. Introduction to Perl/Tk
    1. Tcl, Tk, Tcl/Tk, Tkperl, Perl/Tk, etc.
    2. Perl/Tk
    3. Creating a Perl/Tk Application
    4. GUI Programming Overview
    5. Adding Widgets
    6. Scrolled Widgets
    7. Configuring Widgets
    8. Menus
    9. More Fun with Menus
    10. Using FileSelect
  11. Perl/Tk Programming
    1. Tk::Error and Tk::ErrorDialog
    2. Configuring Widgets
    3. Geometry Management
    4. Geometry Management with grid()
    5. The Frame Widget
    6. Defining Widget Callbacks
    7. Bindings
    8. Nonblocking I/O with fileevent()
    9. Tags
    10. Other Widgets
    11. Other Tk Commands
    12. Getting Tk
  12. Extending Perl with C/C++
    1. Extending the Perl Interpreter
    2. Overview of Perl5 XSUBs
    3. Get Started with h2xs
    4. Set up the Perl Wrapper Class
    5. Write the XS Code
    6. The XS File
    7. Write Some Test Code
    8. What Do You Want?
    9. Returning Values on the Stack
    10. A Walk Through an XSUB
    11. Arguments to XSUBs
    12. Other h2xs Options
  13. Embedding the Perl Interpreter
    1. Why Embed Perl?
    2. Embedding Perl in a C Program
    3. Compiling the Program
    4. perlmain.c
    5. Perl Data Types
    6. Macros and Functions
    7. Manipulating Scalars
    8. Memory Management
    9. Script Space
    10. Evaluating Perl Expressions
    11. Dynamic Loading
    12. Multiple Perl Interpreters
  14. Module Development and Distribution in Perl
    1. Distributing Modules
    2. Get Started with h2xs
    3. Files Created by h2xs
    4. The Build Library (blib) Directory
    5. Unit Testing and test.pl
    6. Versions
    7. Using blib
    8. POD
    9. POD Translators
    10. Cutting a Distribution
    11. Other Niceties
    12. Makefile.PL
  15. Design and Implementation in Perl
    1. Think First
    2. Object-Oriented Design
    3. Object-Oriented Development
    4. Library Modules
    5. Utility Programs
    6. Filters
    7. Performance
    8. Timing with Benchmark
Perl / Advanced
Training Perl / Advanced

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
All trainings in Brussels, Training Development

Training Perl for Unix / Introduction – 5 days

Leave a comment

Class overview :

In this Perl training course, students will learn to program effectively in Perl.

Class goals :

Learn to work with variables, arrays and hashes in Perl
Learn to write flow control statements in Perl
Learn to manipulate files with Perl
Learn to use Perl’s Regular Expressions
Learn to create complex data structures with Perl
Learn to use Perl packages and modules
Learn to work with Perl’s object-oriented features
Learn to write subroutines in Perl

Content of Training Perl for Unix / Introduction

Class Outline

  1. Overview of Perl
    1. What is Perl?
    2. Running Perl Programs
    3. Sample Program
    4. Another Sample Program
    5. Yet Another Example
  2. Perl Variables
    1. Three Data Types
    2. Variable Names and Syntax
    3. Variable Naming
    4. Lists
    5. Scalar and List Contexts
    6. The Repetition Operator
  3. Arrays and Hashes in Perl
    1. Arrays
    2. Array Functions
    3. The foreach Loop
    4. The @ARGV Array
    5. The grep Function
    6. Array Slices
    7. Hashes
    8. Hash Functions
    9. Scalar and List Contexts Revisited
  4. Quoting and Interpolation in Perl
    1. String Literals
    2. Interpolation
    3. Array Substitution and Join
    4. Backslashes and Single Quotes
    5. Quotation Operators
    6. Command Substitution
    7. Here Documents
  5. Perl Operators
    1. Perl Operators
    2. Operators, Functions and Precedence
    3. File Test Operators
    4. Assignment Operator Notations
    5. The Range Operator
  6. Flow Control in Perl
    1. Simple Statements
    2. Simple Statement Modifiers
    3. Compound Statements
    4. The next, last, and redo Statements
    5. The for Loop
    6. The foreach Loop
  7. I/O: Input Operations and File I/O with Perl
    1. Overview of File I/O
    2. The open Function
    3. The Input Operator < >
    4. Default Input Operator
    5. The print Function
    6. Reading Directories
  8. Regular Expressions in Perl
    1. Pattern Matching Overview
    2. The Substitution Operator
    3. Regular Expressions
    4. Special Characters
    5. Quantifiers (*, +, ?, {})
    6. Assertions (^, $, b, B)
  9. Advanced Regular Expressions in Perl
    1. Substrings
    2. Substrings in List Context
    3. RE Special Variables
    4. RE Options
    5. Multi-line REs
    6. Substituting with an Expression
    7. Perl RE Extensions
  10. Subroutines in Perl
    1. Overview of Subroutines
    2. Passing Arguments
    3. Private Variables
    4. Returning Values
  11. References
    1. References
    2. Creating References
    3. Using References
    4. Passing References as Arguments to Subroutines
    5. Anonymous Composers
    6. The Symbol Table
  12. Complex Data Structures in Perl
    1. Two-dimensional Arrays in Perl
    2. Anonymous Arrays and Anonymous Hashes
    3. Arrays of Arrays
    4. Arrays of References
    5. A Hash of Arrays
    6. A Hash of Hashes
    7. And So On…
  13. Perl Packages and Modules
    1. Packages
    2. BEGIN and END Routines
    3. require vs. use
    4. Modules
    5. The bless Function
  14. Introduction to Object-Oriented Programming in Perl
    1. What is Object-Oriented?
    2. Why Use Object-Oriented Programming?
    3. Classes, Objects, and Methods in Perl
    4. Inheritance, the « is-a » Relationship
    5. Containment, the « has-a » Relationship
    6. Overloaded Operators
    7. Destructors
  15. Binary Data Structures in Perl
    1. Variable-Length (Delimited) Fields
    2. Variable vs. Fixed
    3. Handling Binary Data
    4. The pack Function
    5. The unpack Function
    6. The read Function
    7. C Data Structures
  16. Multitasking with Perl
    1. What are Single and Multitasking?
    2. UNIX Multitasking Concepts
    3. Process Creation with fork
    4. Program Loading with exec
    5. File Descriptor Inheritance
    6. How UNIX Opens Files
    7. One-Way Data Flow – Pipes
    8. Example
    9. Final Result – Page Viewing
  17. Sockets Programming in Perl
    1. Clients and Servers
    2. Ports and Services
    3. Berkeley Sockets
    4. Data Structures of the Sockets API
    5. Socket System Calls
    6. Generic Client/Server Models
    7. A Client/ServerExample
    8. A Little Web Server
Perl for Unix / Introduction
Training Perl for Unix / Introduction

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …