Tag Archives: advanced

Training Oracle SQL Queries / Advanced – 3 days

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

Training PHP / Advanced – 3 days

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

Training Perl / Advanced – 4 days

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

Training Google AdWords / Advanced – 1 day

Class overview :

This Advanced Google AdWords Training Course expands on the topics covered in our Introduction to Google AdWords class. In the Advanced Google AdWords course, we take a deeper dive into understanding and optimizing search engine marketing campaigns. The course covers optimization of keywords, campaigns and ads, and other advanced features of Google AdWords.

Class goals :

Learn how to optimize your keywords list.
Learn how to leverage dynamic keyword insertion in Google AdWords.
Learn how to optimize your Ad campaigns by using geo-targeting.
Learn how to advertise on Google’s Content Network.
Learn how to optimize your Ads using advanced settings in Google AdWords.
Learn how to set up conversion tracking in Google AdWords.
Learn how to integrate and leverage Google Analytics with Google AdWords.

Content of Training Google AdWords / Advanced

Class Outline

  1. Advertising on Google’s Content Network
    1. Understanding How Content Network Works
    2. CPM vs. CPC
    3. How to Leverage Content Network in Google AdWords
      1. Automatic Placement
      2. Targeted Placement
      3. Exploring the Networks Tab within Google AdWords
  2. Introduction to Google Places
    1. Overview of Location-Based Ad Services
    2. How to Leverage Google Places
  3. Optimizing Your Keywords Strategy for AdWords
    1. Understanding Types of Keywords
      1. Long Tail vs. Short Tail Keywords
      2. Using Broad Match Modifier
    2. Google Analytics for Keyword Optimization
      1. Identifying Keywords Using Internal Site Search
      2. Identifying Favorable and Unfavorable Keywords
      3. Using Keyword Positions Report
    3. Strengthening Your Keyword Research
      1. Keyword Diagnosis in AdWords
      2. Google’s Search-Based Keyword Tool
      3. Leveraging Google Trends
      4. Leveraging Google Sets
      5. Leveraging Google Insights for Search
    4. Competitive Keyword Analysis
      1. Leveraging Third-Party Tools for Competitive Keyword Analysis
    5. Implementing Dynamic Keyword Insertion
  4. Optimizing AdWords Campaigns
    1. Using Campaign Organization Options
      1. Geo-targeting (Inclusion, Exclusion)
      2. Using Location-Sensitive Keywords
    2. Leveraging AdWords Campaign Experiments (ACE)
      1. Overview of How ACE Works
      2. Different Methods to Use ACE
    3. Leveraging Analyze Competition Feature
      1. Benchmarking AdWords Campaign Performance
  5. Optimizing Ads
    1. Controlling Your Ad Delivery in Google AdWords
      1. Selecting Networks and Devices
      2. Using IP Exclusion
      3. Position Preference
      4. Delivery Preference
      5. Using Ad Rotation
      6. Ad Scheduling
      7. Frequency Capping
    2. Leveraging the Ad Site Links in AdWords Ads
  6. Conversation Tracking in Google AdWord
    1. Understanding How Conversion Tracking Works in Google AdWords
    2. Implementing Conversation Tracking in Google AdWords
    3. Measuring Conversions
  7. Leveraging AdWords Report in Google Analytics
    1. Measuring Campaigns Performance
    2. Day Parts Report
    3. Destination URLs Report
    4. Placement Report
  8. Introduction to Website Optimizer
Google AdWords / Advanced
Training Google AdWords / 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, …

Training Google Analytics / Advanced – 1 day

Class overview :

This fast-paced, one-day, advanced Google Analytics training class covers some of the more advanced features of Google Analytics, including RegEx, advanced segmentation, intelligence alerts, custom reporting, event tracking, virtual page views, Ecommerce tracking, and custom variables.

Class goals :

Learn to set up intelligence alerts.
Learn the difference between advanced segments and filters.
Learn to create advanced segments.
Learn to build custom reports.
Learn the difference between virtual page views and event tracking.
Learn to generate virtual pageviews.
Learn to set up event tracking.
Learn about custom variables.
Learn the best practices for using custom variables.
Learn about subdomain and cross-domain tracking.
Learn about Ecommerce tracking.

Content of Training Google Analytics / Advanced

Class Outline

  1. Intelligence Events
    1. Introduction to Intelligence Events
    2. Automatic Alerts
    3. Custom Alerts
  2. Advanced Segmentation
    1. Introduction to Advanced Segmentation
    2. Leveraging Default Advanced Segments
    3. Customizing Advanced Segments
    4. Managing Advanced Segments
    5. Application of RegEx in Advanced Segmentation
  3. Custom Reporting
    1. Introduction of Custom Reporting
    2. Valid Pairs of Dimensions and Metrics
    3. Designing Your Custom Report
    4. Building Your Custom Report
  4. Ecommerce Tracking and Reporting
    1. Enabling Ecommerce Tracking
    2. Implementing Ecommerce Methods
    3. Ecommerce Overview Report
    4. Product Performance Report
    5. Sales Performance Report
    6. Transaction Report
    7. Time to Purchase Report
    8. Multi-Channel Reports
    9. Assisted Conversions Report
    10. Top Conversions Report
    11. Time Lag Report
    12. Path Length Report
  5. Virtual Pageviews
    1. Introduction to Virtual Pageviews
    2. Virtual Pageviews and Dynamic URLs
    3. Virtual Pageviews for Tracking File Downloads
    4. Virtual Pageviews and Tracking Outbound Links
  6. Event Tracking
    1. Introduction to Event Tracking
    2. Understanding _trackEvent Method
    3. Implementing Event Tracking
    4. Event Tracking Reports
  7. Multiple Domain Tracking
    1. Introduction to Multiple Domain Tracking
    2. Implementing Subdomain Tracking
    3. Implement Cross-domain Tracking
  8. Custom Variables
    1. Introduction to Custom Variables
    2. Architecture of Custom Variables
    3. Implementing Custom Variables
Google Analytics / Advanced
Training Google Analytics / 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, …

Training Google Web Toolkit / Advanced – 3 days

Class overview :

In this GWT training class, students learn develop their GWT skills by learning to use advanced widgets and panels, to work with client-server communication, to build JavaScript bridges and much more.

Class goals :

Learn to create and use modules in GWT, own or external.
Learn to use advanced panels, more widgets, trees in GWT.
Learn to use RichTextArea for styled editing in GWT.
Learn to use CSS styling of GWT Widgets.
Learn to develop own composite widgets.
Learn to develop and execute tests and benchmarks in GWT.
Discover the GWT’s Java Emulator, its capabilities and limitations.
Learn to use GWT’s DOM management.
Learn to use JSON within GWT.
Learn to retrieve and show external URLs in GWT forms.
Learn the mechanics of integrating Javascript with Java.
Learn advanced connectivity mechanisms, polling and related concepts.
Learn some best practices on performance and avoiding pit falls.

Content of Training Google Web Toolkit / Advanced

Class Outline

  1. Using Modules in GWT
    1. GWT Modules
    2. Using External Modules
    3. Modularizing An Application
    4. Deferred Binding
    5. Multiple-Module Applications
    6. Code Splitting
  2. More on GWT User Interfaces
    1. Using ToggleButton and PushButton
    2. Using DecoratorPanel
    3. Using AbsolutePanel
    4. Using HTMLPanel
    5. Using FocusPanel
    6. Using HorizontalSplitPanel and VerticalSplitPanel
    7. Using StackPanel
    8. Using TabPanel
    9. The DeckPanel
    10. Using TabPanel
    11. Using Menus via a MenuBar
    12. Using a Tree Widget
    13. Using SuggestBox
    14. GWT RichTextArea Editing
    15. FormPanel
    16. Using DeferredCommand
  3. GWT UiBinder and SafeHtml
    1. What is UiBinder?
    2. UiBinder Benefits
    3. UiBinder Templates
    4. Creating a UiBinder in Eclipse
    5. What Is SafeHtml?
  4. Styling with CSS in GWT
    1. Syling with CSS in GWT
    2. GWT Visual Themes
    3. Styling Widgets in GWT
    4. Associating CSS Files with a Module
    5. Dependent Style in Widgets
    6. More ClientBundle Elements: CSS Resources, Data Resources, and External Resources
  5. Creating Composite GWT Widgets
    1. Custom GWT Widgets
    2. Composite GWT Widgets
    3. Developing Composite Widgets
    4. Using Composite Widgets
  6. Testing and Debugging GWT Modules in GWT
    1. Testing and Debugging GWT Modules
    2. Unit Testing Concepts
    3. The JUnit Test Framework
    4. Writing a JUnit Test Case
    5. GWT Unit Testing with GWTTestCase
    6. Running junitCreator
    7. Testing Asynchronous Code
    8. GWT System Testing
    9. GWT User Interface Testing
  7. More Server Integration Options in GWT
    1. More Server Integration Options in GWT
    2. Using HTTP Requests
    3. Manipulating an XML DOM
    4. Integrating Using JSON
  8. GWT JavaScript Native Interface
    1. GWT JavaScript Native Interface
    2. Defining JSNI Methods
    3. Sharing Data between JavaScript and Java
    4. Talking to the Browser via JSNI
    5. Using External JavaScript
    6. Using a JavaScriptObject in GWT
    7. Java Callbacks from External JavaScript
    8. Using External Libraries
  9. Advanced GWT Connectivity
    1. Stateful and Stateless Servers
    2. Using Stateful Servers
    3. Handling Exceptions
  10. Client-Side RPC Architecture in GWT
    1. Client-Side RPC Architecture
    2. Client-Side Pull versus Push
    3. Polling Protocols
  11. GWT Best Practices
    1. Security Issues
    2. Performance Concerns
    3. Internationalization in GWT
    4. GWT Pitfalls and Issues
    5. Testing Practices for GWT
    6. Bandwidth-Sensitive Applications
Google Web Toolkit / Advanced
Training Google Web Toolkit / 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, …

Training ASP.NET MVC 3 Framework – 3 days

Class overview :

This ASP.NET MVC 3 Framework training provides a practical hands-on introduction to developing Web applications using ASP.NET MVC 3 and C#. This new Web development framework from Microsoft emphasizes separation of concerns in the architecture and testability of applications.

Class goals :

Gain a thorough understanding of the philosophy and architecture of Web applications using ASP.NET MVC.
Acquire a working knowledge of Web application development using ASP.NET MVC and Visual Studio 2010.
Learn to access databases using ADO.NET, LINQ, and Entity Framework 4.1.
Learn to perform automated testing of Web applications created using ASP.NET MVC.
Learn to implement security in ASP.NET MVC applications.
Learn to combine ASP.NET MVC and Web Forms when appropriate.
Learn to deploy ASP.NET MVC applications.

Content of Training ASP.NET MVC 3 Framework

Class Outline

  1. Introduction to ASP.NET MVC
    1. Review of ASP.NET Web Forms
    2. Advantages and Disadvantages of Web Forms
    3. Model-View-Controller Pattern
    4. ASP.NET MVC
    5. Advantages and Disadvantages of ASP.NET MVC
    6. Unit Testing
  2. Getting Started with ASP.NET MVC
    1. Installing ASP.NET MVC
    2. Using Visual Studio
    3. Hello World for ASP.NET MVC
    4. Rendering Views
    5. Dynamic Output
  3. ASP.NET MVC Architecture
    1. The Controller in ASP.NET MVC
    2. The View in ASP.NET MVC
    3. The Model in ASP.NET MVC
    4. Helper Methods for HTML
    5. Form Submission
    6. Model Binding
    7. Input Validation
  4. The Model
    1. Microsoft Technologies for the Model
    2. ADO.NET
    3. LINQ
    4. ADO.NET Entity Framework 4.1
    5. NuGet Package Manager
    6. Using MvcScaffolding
    7. Code First Data Modeling
  5. The Controller
    1. IController Interface
    2. Controller Base Class
    3. Actions
    4. Retrieving Data from a Request
    5. Action Results
    6. Action Attributes
    7. Filters
    8. Asynchronous Controllers
  6. The View
    1. View Responsibility
    2. Using ViewData
    3. Loosely-Typed Views
    4. Strongly-Typed Views
    5. Using Dynamic Objects
    6. Html Helpers
    7. Razor View Engine
    8. Using ViewBag
    9. Validation Attributes
    10. HTML 5 Project Templates
  7. Routing
    1. Routing in ASP.NET MVC
    2. Properties of Routes
    3. Registering Routes
    4. Debugging Routes
    5. Areas
  8. Unit Testing
    1. Test-Driven Development
    2. Test Automation
    3. Refactoring
    4. NUnit
    5. Test Cases
    6. Test Classes
    7. Test Runners
    8. Testing ASP.NET MVC Applications
    9. Dependency Injection
    10. Mocking Frameworks
    11. Inversion of Control Containers
  9. Security
    1. Input Forgery
    2. Cross-Site Scripting
    3. Session Hijacking
    4. Cross-site Request Forgery
    5. SQL Injection
    6. Using the MVC Framework Securely
  10. Combining ASP.NET MVC and Web Forms
    1. Using Web Forms in an MVC Application
    2. Using MVC in a Web Forms Application
  11. Deployment
    1. Server Requirements
    2. Continuous Integration
    3. Environment Configurations
    4. XCOPY
    5. Web Deploy
ASP.NET MVC 3 Framework
Training ASP.NET MVC 3 Framework

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

Training ASP / Advanced – 2 days

Class overview :

In this advanced ASP training course, students will learn to use sophisticated programming strategies and advanced features to add polish, speed and efficiency to Active Server Pages Web applications. In this ASP training course, students will work more thoroughly with ASP components for Web-to-database integration and use the server’s file system to add features and functionality to a website.

Class goals :

Learn to implement advanced drill-downs
Learn to debug ASP code
Learn to work with stored procedures
Learn to use batch updating
Learn to work with 3rd-party vendor components
Learn to work with the file system of the server

Content of Training ASP / Advanced

Class Outline

  1. File Conventions
    1. Connection Pooling
    2. Dynamic Connection Strings
    3. Default METHOD and ACTION Values
  2. Advanced Data Drill-Downs
    1. Passing Data via the Query String
    2. Using Drill-Downs to Reformat Data
    3. Creating Sortable Tables
  3. Displaying Variables
    1. Creating an Include to Display Variable Values for Debugging
  4. Displaying a Portion of a Recordset
    1. Displaying the Next n Records
    2. How the Process Works
  5. Password Protection with Session Variables
    1. Adding Password Protection to Pages
  6. Stored Procedures in ASP
    1. Creating a Stored Procedure in the Database
    2. Advantage of Stored Procedures
    3. Calling a Stored Procedure
    4. Using Stored Procedures to Insert and Update Data
  7. Working with the File System in ASP
    1. The FileSystemObject
    2. Creating or Opening a Text File
    3. Methods of the TextStream Object
    4. Storing Text to a File
    5. The File Object
    6. The Folder Object
    7. Working with Files and Directories
  8. Processing File Uploads
    1. Obtaining a Component for Processing File Uploads
    2. The AspUpload Component
    3. Building an HTML Form that Supports File Uploads
    4. Processing the File on the Server with AspUpload
    5. Processing Files and Entered Text
    6. SetMaxSize
    7. Manipulating Files via AspUpload
    8. Creating an New Directory
    9. Restricting Your Upload to Certain File Extensions
    10. Building a Resume Submission Interface
  9. Batch Updating
    1. Opening a Recordset for Batch Updating
    2. Editing the Records Row by Row
    3. Updating the Batch
    4. Benefits of Batches
    5. Some Useful VBScript Functions
  10. Using rs.Update Instead of INSERT
    1. rs.Update
  11. Form Validation with Server-Side JScript
    1. Server-Side Form Validation with JScript
  12. Transactions in ASP
    1. Transactions
    2. Handling Errors
    3. Catching Database Errors
  13. Creating Message Boards
    1. The HTML Files
    2. The Database
    3. The Interface
  14. Regular Expressions
    1. Creating and Executing Regular Expressions with exec()
    2. Special Characters for Pattern Matching
    3. Escape Sequences for Special Characters
    4. Specifying Ranges in Patterns
    5. Matching a Specified Number of Occurrences
    6. Character-Range Escape Sequences
    7. Matching at the Beginning or End of a String with ^ and $
ASP / Advanced
Training ASP / 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, …

Training Ajax with PHP – 3 days

Class overview :

In this Ajax training course, students learn to make calls to the server with JavaScript and to manipulate XML content returned from the server. Ajax opens the door to creating sophisticated web-based applications with much more of the logic (and therefore code) is handled on the client.

Class goals :

Learn how Ajax works.
Learn to write cross-browser Ajax code.
Learn to use Ajax to make a call to the server without a page refresh.
Learn to modify content blocks on a page without refreshing the whole page.
Learn to use server-side form validation with Ajax.
Learn to move elements around the page with Dynamic HTML.
Learn to show and hide elements.
Learn to manipulate XML documents with JavaScript using the DOM.
Learn to manipulate XML documents with JavaScript using XSLT.
Learn to program in JavaScript using Object-Oriented techniques.
Learn to work with various JavaScript/Ajax libraries, such as Prototype, Scriptaculous, and Sarissa.

Content of Training Ajax with PHP

Class Outline

  1. Ajax Basics
    1. The Purpose of Ajax
      1. Traditional Web Application
      2. An Ajax Web Application
    2. The XMLHttpRequest Object
      1. Creating an XMLHttpRequest Object
      2. Using an XMLHttpRequest Object
      3. Handling the Response
    3. Conclusion
  2. Ajax Frameworks
    1. The Purpose of Frameworks
      1. Choosing a Framework
    2. Dojo
      1. Downloading Dojo
      2. Using Dojo for Ajax
    3. Prototype
      1. Downloading Prototype
      2. Using Prototype for Ajax
    4. Other Popular Frameworks
      1. Direct Web Remoting (DWR)
      2. AjaxAnywhere
      3. Simple Ajax (SAJAX)
      4. Sarissa
      5. Other Frameworks
    5. Conclusion
  3. The HTML Document Object Model
    1. Accessing Nodes
      1. Accessing Element Nodes
      2. Accessing Attribute Nodes
      3. getAttribute
      4. attributes[]
      5. Accessing Nodes by Type, Name or Value
      6. Accessing Nodes by Class Name
    2. Removing Nodes from the DOM
      1. DOM Differences: The Whitespace Problem
    3. Creating New Nodes
    4. Conclusion
  4. XML and Ajax
    1. Creating a DOM Document with JavaScript
    2. Accessing, Creating and Modifying XML Nodes
      1. Creating an AddChild() Function
    3. Receiving XML Responses
    4. Conclusion
  5. Ajax Applications
    1. Login Form
    2. Quick Lookup Form
    3. Preloaded Data
      1. Ajax Slideshow
      2. Navigable Tables
    4. Conclusion
  6. OO JavaScript and Refactoring Ajax
    1. Illustrating the Problem
    2. Object-Oriented JavaScript
      1. JavaScript Classes
      2. Prototypes
      3. Extending Built-in Objects
    3. Refactoring the Ajax Request Code
    4. Conclusion
  7. JavaScript Object Notation (JSON)
    1. Object Literals
      1. Arrays
      2. Objects
      3. Arrays in Objects
      4. Objects in Arrays
    2. JSON
      1. JSON Syntax
      2. JSON Parsers
        1. PHP JSON Extension (added in PHP 5.2)
        2. PEAR JSON
        3. ZEND JSON
      3. JSON Advantages and Disadvantages
    3. Conclusion
  8. XSLT Transformations with JavaScript
    1. XSLT
      1. Basic XSLT
    2. XSLT in the Browser
      1. XSLT in Internet Explorer
      2. XSLT in Mozilla
    3. Sarissa
      1. Advantages and Disadvantages of XSLT in Ajax Applications
    4. Conclusion
  9. Drag and Drop
    1. Drag and Drop Basics
    2. script.aculo.us
      1. Draggables
      2. Droppables
      3. A More Interesting Example
    3. Conclusion
  10. More Ajax Applications
    1. Inline Editing
    2. Detailed Information on Demand
    3. Autologout
    4. Autocompletion
    5. Conclusion
Ajax with PHP
Training Ajax with PHP

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

Training Adobe ActionScript 3 Advanced Techniques – 3 days

Class overview :

This 3 day advanced ActionScript course is for people who want to push their Actionscript 3 skills further and learn advanced techniques in order to create and control effects with MovieClips, bitmaps, colour, audio, video, and 3D assets.

Class goals :

Additionally you we will cover some great open source class libraries that will help you in creating your effects and flash sites, and generally learn to take your ActionScript 3 skills to the next level.

Content of Adobe ActionScript 3 Advanced Techniques

Drawing

  • Drawing API
  • Triangles (and UVT)
  • Bitmap fills

3D transformations

  • rotationX/Y/Z transformations
  • scaleX/Y/Z transformations
  • x/y/z translations
  • Simple 3D drawing

Collision Detection

  • Hit tests
  • Using Bitmaps for detection

Tweening

  • Tween class
  • Applying tweens
  • Creating effects with tweens
  • Other tweening libraries

Transitions and the Transition Manager

  • Blinds
  • Fade
  • Fly
  • Iris
  • Squeeze
  • Wipe
  • Others

Colour

  • Manipulating colours with AS3
  • ColorTransform class

Transformations

  • Matrix class
  • Matrix3D class
  • Transform
  • Others

Video Effects

  • Bitmaps
  • Cameras
  • Movies

Sound effects

  • Loading sounds
  • Controlling sounds
  • Visualisation – waveforms and frequencies
  • Microphones

Image Effects

  • Bitmaps and BitmapData
  • Filters and Blend modes
  • PerlinNoise

Open source Classes

  • Papervision3D
  • Tweener
  • TweenMax
  • Minimal Components
  • Others

Open source frameworks

  • Gaia

Augmented Reality

  • FLARToolkit
  • Adding Papervision3D

Object Orientated Programming

  • Creating your own class
  • Creating methods
  • Creating getters/setters
  • Using your custom class
  • Creating Document classes

Flash and Flash Builder (Flex Builder)

  • Importing Flash work into Flash Builder
  • Setting up your classes in Flash Builder
  • Embedding Flash work as assets in your classes
  • Using Flash Builder with php and mysql

Components and Data

  • Components
    • Button
    • Checkbox
    • ColourPicker
    • Combobox
    • Datagrid
    • etc

Working with data

  • Database Integration
    • Setting up a server and database
    • Testing server/flash/db integration
    • Ways to connect Flash and data – AMFPHP
  • XML
  • DataProvider
Adobe ActionScript 3 Advanced Techniques
Training Adobe ActionScript 3 Advanced Techniques

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