Tag Archives: Brussels

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, …
All trainings in Brussels, Training Development

Training Developing Java Web Applications – 5 days

Leave a comment

Class overview :

Gives the experienced Java programmer a firm understanding of web application development in the Java Enterprise environment. Students learn the Servlets, JSP, and JSTL standards and how to mesh them into an effective methodology for building maintainable model/view/controller web applications. Students also work with relational databases and are exposed to practicalities of using both JDBC- and JPA-based persistence tiers.

Class goals :

Understand the value of web applications to an IT enterprise, and the importance of the Java EE platform in enabling web development.
Build servlets to respond to HTTP requests.
Build JavaServer Pages to define HTTP responses.
Combine servlets and JSPs in a model/view/controller architecture to maximize efficiency and maintainability of application code.
Define HTML forms and process form input.
Store and retrieve information at request, session, and application scope.
Make effective use of HTTP sessions as managed by the Java EE web container.
Use the JSP Standard Tag Library to implement appropriate presentation logic in a JSP.
Take full advantage of the relationship of servlets and JSPs to the Java EE web container using configuration, context, and lifecycle techniques.
Manage persistent data from web applications by working with persistence tiers, JDBC, and/or JPA.
Implement and configure servlet filters.
Declare security policies for web applications, and use programmatic authorization where appropriate.

Content of Training Developing Java Web Applications

Class Outline

  1. Overview of Java EE Web Applications
    1. The World Wide Web
    2. HTTP
    3. HTML and XML
    4. CSS
    5. Dynamic Web Applications
    6. The Java EE Platform
    7. Java EE Servers and Portability
    8. Servlets
    9. JavaServer Pages
    10. JSTL
    11. Web Archives and Enterprise Archives
    12. Model/View/Controller
    13. Forms
    14. Sessions
    15. Context and Lifecycle
    16. Databases
    17. Security
    18. Filters
    19. JavaServer Faces
  2. Servlets
    1. The HTTP Message Model
    2. The Servlets API « Kernel »
    3. HttpServlet
    4. Request and Response Objects
    5. Mapping URLs
    6. Attributes and Scopes
    7. Forwarding and Redirecting
  3. JavaServer Pages
    1. Dynamic Web Pages
    2. Relationship to Servlets
    3. Directives
    4. The Unified Expression Language
    5. Page Scope
    6. Implicit Objects
    7. <jsp:useBean> and « Model 1″
    8. MVC and « Model 2″
    9. JSP Documents
  4. Working with Forms
    1. HTML Forms
    2. Submit Method: GET vs. POST
    3. Reading Single-Value Components
    4. Reading Multi-Value Components
    5. Reading Button Input
    6. Input Validation
  5. Sessions
    1. Sessions over HTTP
    2. HttpSession
    3. Session Scope
    4. Session Pitfalls
  6. The JSP Standard Tag Library
    1. Custom Tags
    2. The JSTL Libraries
    3. The Core Library
    4. Iterating Over Collections
    5. The Formatting Library
    6. Formatting Dates and Numbers
    7. Working with Maps
    8. Conditionals
    9. Loops
    10. Variables
    11. Importing Documents
  7. Custom Tags
    1. Custom Tag Libraries
    2. Tag Library Architecture
    3. Implementing in Java or JSP
    4. Correct Use of Scopes
    5. Invoking Presentation Logic
    6. Reusing Presentation Fragments
    7. Classic Tag Handlers
    8. Simple Tag Handlers
    9. Tag Files
  8. Context and Lifecycle
    1. Containers and Components
    2. Context and Lifecycle Interfaces
    3. Initialization and Context Parameters
    4. Loading Resources
    5. Lifecycle Methods
    6. Lifecycle Annotations
    7. Context Listeners
    8. JNDI and the Component Environment
    9. Dependency Injection
  9. Working with Databases
    1. Persistence Challenges
    2. Persistence Strategies
    3. JDBC
    4. DriverManager
    5. DataSource
    6. Data Access Objects
    7. JNDI Quirks and Portability Issues
    8. JPA
    9. Entity Annotations
    10. Entity Managers
    11. Persistence Units
    12. Working with Persistent Data
    13. Processing Tables
    14. Limiting Query Scope
  10. Filters
    1. Servlet Filters
    2. Uses for Filters
    3. Implementation
    4. Deployment
    5. Configuration and Context
  11. Security
    1. Threats to Enterprise IT
    2. Web Applications as Prime Targets
    3. Container Services
    4. Authentication for Web Applications
    5. Authorization
    6. HTTP BASIC Authentication
    7. HTTP DIGEST Authentication
    8. Declaring Security Constraints
    9. Abstract Roles, Concrete Realms
    10. Configuring User Realms
    11. Custom Error Pages
    12. Frustrations with BASIC and DIGEST
    13. Doing It Yourself
    14. FORM Authentication
    15. Programmatic Security
    16. Beyond Container-Based Security
    17. OWASP and the Top 10
Developing Java Web Applications
Training Developing Java Web Applications

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 JSP / Comprehensive – 4 days

Leave a comment

Class overview :

This four-day course develops skills in JavaServer Pages, or JSP, which is the standard means of authoring dynamic content for Web applications under the Java Enterprise platform. It treats JSP 2.0, including older features such as scriptlets but focusing on newer features and techniques, including JSP expressions and the JSTL.

Class goals :

Explain the fundamentals of HTML and HTTP in the World Wide Web.
Describe the CGI and its role in implementing interactive Web applications.
Describe JavaServer Pages and their relationship to servlets and J2EE generally.
Describe how a JSP is translated into a servlet and processed at runtime.
Explain the use of directives on JSPs and outline the principal directives.
Implement simple JSPs that use Java code in declarations, expressions and scriptlets.
Enumerate and use the implicit objects available to scripting elements.
Explain the use of HTML forms in Web applications.
Implement an interactive Web application using JSP.
Use Java exception handling and JSP error pages to handle errors in JSP applications.
Implement session management for a JSP application.
Manage cookies to store client-specific information at various scopes and durations.
Explain the use of JavaBeans in JSP and their role in enhancing the separation of business logic from page design.
Use Beans to implement effective interactive JSP applications.
Describe the use of the JSP expression language in simplifying dynamic page output.
Write JSP expressions and implement JSPs that use them in favor of scripts.
Describe the role of the JSP Standard Tag Library in JSP development.
Implement JSPs that use basic JSTL actions to simplify presentation logic.
Describe custom tags in JSP and explain how they are implemented, both using Java and JSP itself, and how they are used.
Discuss threading issues in JSP and describe the use of directives to control how threading is handled.
Describe the various uses of XML in JSP applications.
Deploy a logical Web application to a Web server in a WAR file.
Describe the use of the JSP expression language to simplify dynamic page output.
Write JSP expressions and implement JSPs that use them in favor of scripts.
Implement JSPs that use basic JSTL actions to simplify presentation logic.
Decompose a JSP application design into fine-grained, reusable elements including JavaBeans, custom tag handlers and tag files that use JSTL.
Use core JSTL actions to complement standard actions, custom actions, and JSP expressions for seamless, script-free page logic.
Direct conditional and iterative processing of page content by looping through ranges of numbers, over elements in a collection, or over tokens in a master string.
Import external resources by URL for processing, or redirect the JSP container to an external resource to handle the current request.
Set locale and time zone information in JSPs, and use them to correctly format numbers, dates and times for all clients.
Use resource bundles to manage application strings, and produce the appropriate strings at runtime for a particular client locale.
Locate a data source, query for relational data, and parse result sets.
Perform updates, inserts and deletes on relational data using SQL actions.
Manage queries and updates in transaction contexts.
Parse XML content from a variety of sources.
Derive information from parsed XML content using XPath expressions.
Implement conditional processing and loops based on XML information.
Apply XSLT transformations to XML content.
Implement a simple Web service that reads and writes SOAP.

Content of Training JSP / Comprehensive

Class Outline

  1. Web Applications
    1. The World Wide Web
    2. HTML
    3. Web Servers
    4. HTTP
    5. Dynamic Web Pages
    6. CGI
    7. Java Web Technologies
    8. Servlets
    9. JSP
  2. JSP Architecture
    1. JSP Containers
    2. Servlet Architecture
    3. Page Translation
    4. Types of JSP Content
    5. Directives
    6. Content Type
    7. Buffering
    8. Scripting Elements
    9. JSP Expressions
    10. Standard Actions
    11. Custom Actions and JSTL
    12. Objects and Scopes
    13. Implicit Objects
    14. JSP Lifecycle
  3. Scripting Elements
    1. Translation of Template Content
    2. Scriptlets
    3. Expressions
    4. Declarations
    5. Dos and Don’ts
    6. Implicit Objects for Scriptlets
    7. The request Object
    8. The response Object
    9. The out Object
  4. Interactive JSP Applications
    1. HTML Forms
    2. Reading CGI Parameters
    3. JSPs and Java Classes
    4. Error Handling
    5. Session Management
    6. The Session API
    7. Cookies and JSP
  5. Using JavaBeans
    1. Separating Presentation and Business Logic
    2. JSP Actions
    3. JavaBeans
    4. Working with Properties
    5. <jsp:useBean>
    6. <jsp:getProperty> and <jsp:setProperty>
    7. Using Form Parameters with Beans
    8. Objects and Scopes
    9. Working with Vectors
  6. The Expression Language and the JSTL
    1. Going Scriptless
    2. The JSP Expression Language
    3. EL Syntax
    4. Type Coercion
    5. Error Handling
    6. Implicit Objects for EL
    7. The JSP Standard Tag Library
    8. Role of JSTL
    9. The Core Actions
    10. Using Beans with JSTL
    11. The Formatting Actions
    12. Scripts vs. EL/JSTL
  7. Advanced JSP Features
    1. Web Components
    2. Forwarding
    3. Inclusion
    4. Passing Parameters
    5. Custom Tag Libraries
    6. Tag Library Architecture
    7. Implementing in Java or JSP
    8. Threads
    9. Strategies for Thread Safety
    10. XML and JSP
    11. JSP for Web Services
  8. JSTL Overview
    1. The JSP Standard Tag Library
    2. The JSP Expression Language
    3. EL Syntax
    4. Type Coercion
    5. Error Handling
    6. Implicit Objects for EL
    7. JSTL Namespaces
    8. Using JSTL in a Page
    9. The Core Actions
    10. Going Scriptless
    11. Object Instantiation
    12. Sharing Objects
    13. Decomposition
    14. Parameterization
  9. The Core Actions
    1. The JSTL Core Library
    2. <c:out>
    3. <c:set>
    4. Gotchas
    5. Conditional Processing
    6. Iterative Processing
    7. Iterating Over Maps
    8. Tokenizing Strings
    9. Catching Exceptions
    10. Resource Access
  10. The Formatting and i18n Actions
    1. The JSTL Formatting Library
    2. Locales
    3. Determining Locale
    4. Time Zones
    5. Setting Locale and Time Zone
    6. Formatting and Parsing Dates
    7. Formatting and Parsing Numbers
    8. Internationalization
    9. Working with Resource Bundles
    10. Supporting Multiple Languages
  11. The SQL Actions
    1. The JSTL SQL Library
    2. Using Relational Data
    3. Connecting with a DriverManager
    4. Connecting via a DataSource
    5. The Result Interface
    6. Making a Query
    7. Inserts, Updates and Deletes
    8. Parameterized SQL
    9. Transactions
  12. The XML Actions
    1. The JSTL XML Library
    2. Using XML
    3. XML Data Sources
    4. Parsing and Addressing
    5. Using XPath in JSTL
    6. XPath vs. EL
    7. XPath Context
    8. Implicit Objects for XPath
    9. Conditional Processing
    10. Iterative Processing
    11. Changing XPath Context
    12. Working with XML Namespaces
    13. Using XSLT
    14. Chaining Transformations
    15. Reading XML from the Request Body
    16. XML and SOAP Web Services
JSP / Comprehensive
Training JSP / Comprehensive

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 Web Development using Grails – 1 day

Leave a comment

Class overview :

This Groovy on Grails training course teaches experienced web developers how to use the Grails framework to rapidly create sophisticated web applications.

Class goals :

Learn to develop model-view-controller web applications using Grails.
Learn to access relational databases from Grails.
Learn to work with existing Java classes and libraries.
Learn to build unit and functional tests for web applications.

Content of Training Web Development using Grails

Class Outline

  1. Groovy Fundamentals
    1. Differences between Groovy and Java
    2. Declaring classes
    3. Using assertions
    4. Groovy Strings
    5. Closures
    6. Lists and Maps
    7. Expando Objects
    8. Ranges
    9. Metaprogramming
    10. Builders
  2. Grails Project Structure
    1. Overview of a Grails project
    2. Directories for model classes, controllers, and views
    3. Data source configuration
    4. Logging
    5. Command line utilities
    6. IDE integration
  3. Application Entities
    1. Object-Relational Mapping with GORM
    2. Optional properties
    3. Constraints and validation
    4. Modeling relationships
    5. Performing CRUD operations
    6. Dynamic queries
    7. Connection to Hibernate
  4. Scaffolding
    1. Dynamic scaffolding
    2. Working with the dynamic operations
    3. Static scaffolding
    4. Generating controllers
    5. Generating views
  5. Grails Controllers
    1. Setting the default action
    2. Accessing request attributes
    3. Flash scope
    4. Data binding and type conversion
    5. Rendering a response
    6. Using action interception
  6. Groovy Server Pages
    1. Groovy scriptlets
    2. Built-in Grails tags
    3. Dynamic tags
    4. Layouts and templates
    5. Pagination
    6. Creating custom tags
  7. Adding Ajax Support
    1. Basics of Ajax
    2. Handling events
    3. Ajax-supporting tags
  8. Services and Jobs
    1. Transactions
    2. Services and dependency injection
  9. Java Integration
    1. ORM integration with Hibernate
    2. Dependency injection with Spring
    3. Working with legacy databases
Web Development using Grails
Training Web Development using Grails

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, …

This Groovy on Grails training course teaches experienced web developers how to use the Grails framework to rapidly create sophisticated web applications.

All trainings in Brussels, Training Development

Training Google Website Optimizer – 1 day

Leave a comment

Class overview :

The Google Website Optimizer training will introduce you to the world of website testing and familiarize you with the Google Website Optimizer tool. The course first covers the basics of the online conversion process and the importance of usability testing, and then covers testing and experimenting in Google Website Optimizer and understanding Reports in Google Website Optimizer.

Class goals :

Learn the concept of conversion life cycle for online websites.
Learn the importance of landing page optimization and significance of usability testing.
Learn the concepts of website testing and about the elements you should test in an online environment.
Learn how Google Website Optimizer works.
Learn different testing mechanisms available in Google Website Optimizer (e.g. a/b testing and multivariate testing).
Learn how to setup an account and configure experiments in Google Website Optimizer.
Learn how to tag your web pages for carrying out experiments in Google Website Optimizer.
Learn how to manage your experiments and control traffic.
Learn about sample size and how long you should run your experiment.
Learn the different metrics used in the report interface in Google Website Optimizer.
Learn how to generate and analyze various reports in Google Website Optimizer.
Learn how to leverage Google Analytics and Google AdWords.

Content of Training Google Website Optimizer

Class Outline

  1. Online Conversion Process
    1. Understanding conversion life cycle
    2. Understanding importance of landing pages
    3. Understanding importance of « usability » in conversion process
  2. Testing and Experimenting
    1. Understanding importance of conversion testing
    2. What should I test and why?
    3. Understanding post-click optimization
    4. Business case for testing: test driven culture and data driven decision making
  3. Introduction to Google Website Optimizer
    1. Understanding how Google Website Optimizer works
    2. Setting up Google Website Optimizer account
    3. Understanding different tests available within Google Website Optimizer
    4. Understanding features available in Google Website Optimizer and their limitations
  4. Testing and experimenting in Google Website Optimizer
    1. How to design an experiment in Google Website Optimizer
    2. Understanding sampling size and its importance in testing
    3. Setting up a/b testing in Google Website Optimizer
    4. Setting up multivariate testing in Google Website Optimizer
    5. Understanding how to tag your test pages
    6. How to funnel your traffic for test purposes
    7. Lab Session: Setting up Google Website Optimizer Tests
  5. Understanding Reports in Google Website Optimizer
    1. Understanding report navigation
    2. Understanding different metrics and terminologies
    3. Understanding combination report
    4. Understanding page section report
    5. Sample reports for a/b testing
    6. Sample reports for multivariate testing
  6. Advanced Features
    1. Integrating Google Website Optimizer with Google AdWords
    2. Integrating Google Website Optimizer with Google Analytics
  7. Website Design Best Practices and Tips
Google Website Optimizer
Training Google Website Optimizer

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, …