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
Users and Schemas
Introduction to Users and Schemas
Definitions and Client Tools
SQL Developer Login
About the HR Schema
Sample Schemas
HR Schema Entities
Creating An Application Schema
Exercise: Create a User
Pseudo Columns & Functions
Using The Dual Table
Functions
Exercise: Use the SYSCONTEXT function
Pseudo-Columns
Using Rowid
Using Rownum
Exercise: Use ROWNUM
Using Subqueries
Simple Subqueries
Definition
Nested Subquery
Inline Views
Subquery in the HAVING clause
Correlated Subqueries
Scalar Subquery
Exercise: Subqueries
Joining Tables
Review of Joins
Equijoins
Inner Joins
Outer Joins
Cross Joins
Reflexive Join
Non-Key Join
Natural Joins
Semijoins and Antijoins
Using Named Subqueries
Exercise: Join Exercises
Rollup & Cube
About Group Processing
EMP_DETAILS_VIEW
Simple GROUP BY
ROLLUP Function
GROUPING Function
Using Cube
Exercise: Practice GROUP BY, ROLLUP and CUBE
Using Set Operators
Set Operators Defined
Relationship to Mathematical Set Theory
Restrictions on Set Operators
Exercise: Set Operators Exercise
Conditional Processing
The DECODE Function
The Case Expression
Exercise: Conditional Processing
SQL Functions (Character)
What Are SQL Functions?
Character Functions
CONCAT
LENGTH
INSTR
REPLACE
UPPER
LOWER
INITICAP
LPAD
RPAD
TRIM
TO_CHAR
SOUNDEX
Regular Expressions
Exercise: Character Functions
SQL Functions (Non-Character)
Numeric Functions
The TO_CHAR Function with numbers
Date/Time Functions
Date Format Functions
Date Arithmetic Functions
Null Value Functions
Exercise: SQL Non-Character Functions
SQL Data Manipulation Language
The INSERT Statement
INSERT Statement Categories
The UPDATE Statement
The DELETE Statement
Transactions
Complex Table References
The MERGE statement
Exercise: Data Manipulation Language (DDL)
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, …
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
Advanced PHP Techniques
Multidimensional Arrays
Advanced Function Definitions
The Heredoc Syntax
Using printf() and sprintf()
Developing Web Applications
Documenting Code
Code Style and Structure
Modularizing a Web Site
Affecting the Browser Cache
Advanced Database Concepts
Storing Sessions in a Database
Working with U.S. Zip Codes
Creating Stored Functions
Displaying Results Horizontally
Security Techniques
Remembering the Basics
Validating Form Data
Using PECL Filter
Authentication with PEAR Auth
Using MCrypt
E-commerce Techniques
E-commerce Concepts
Creating the Database
Creating the Configuration File
Making the Template
Creating the Index Page
Browsing by Category
Showing a Product
Implementing a Shopping Cart
Validating Credit Cards
Basic Object-Oriented Programming
OOP Theory
Defining a Class
Creating an Object
The $this Attribute
Creating Constructors
Creating Destructors
Autoloading Classes
Advanced OOP
Advanced Theories
Inheriting Classes
Inheriting Constructors and Destructors
Overriding Methods
Access Control
Using the Scope Resolution Operator
Creating Static Members
Abstract Classes and Methods
Real-World OOP
Catching Exceptions
Extending the Exception Class
Creating a Shopping Cart Class
Using the Cart Class
Using PEAR
Using Benchmark
Using HTML_QuickForm
Using Mail_Mime
Ajax
Introduction to Ajax
A Simple Example
Full-Fledged Ajax
Debugging Ajax Applications
XML and PHP
What Is XML?
XML Syntax
Attributes, Empty Elements, and Entities
Document Type Definitions
Parsing XML
Creating an RSS Feed
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, …
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
Debugging Perl
Warnings
Diagnostic Messages
Carping, Confessing, and Croaking
Strict Checks
Compiler Pragmas
Debugging Flags
Your Perl Configuration
The Devel::Peek Module
The Data::Dumper Module
Expert List Manipulation in Perl
The grep Operator
Lists, Arrays, and List Operators
Context
Context and Subroutines
Initializing Arrays and Hashes
Reference Syntax
Auto-vivification
Defined Values
Other List Operators
Usage of map, grep, and foreach
Blocks and Code References in Perl
Blocks
Subroutines
Subroutine Prototypes
Code Refs and Anonymous Subroutines
Typeglobbing for the Non-Squeamish
Local (Dynamic) Variables
Lexical Variables
Persistent Private Subroutine Variables
Closures
The eval Operator
The Block Form of eval
The String Form of eval
Block Form of eval for Exception Handling
Perl Packages
Review of Packages
BEGIN and END Blocks
Symbol Tables
Package Variables
Calling Package Subroutines
Importing Package Symbols
Exporting Package Symbols
Using the Exporter Package
The use Function
AUTOLOAD and @ISA
AutoLoader and SelfLoader
Objects and Classes in Perl
Object-Oriented Stuff
Making Perl Object-Oriented
References
The bless Function
So, What’s a Blessed Thing Good For?
Calling Class and Object Methods
Object Methods
Writing Classes
Constructors
Inheritance
What Perl Doesn’t Do
Tied Variables in Perl
Why Use tie?
Tying a Scalar
Inside Tied Variables
untie
Another Tied Scalar Example
Tying an Array
A Tied Array Example
Tying Hashes
Tie::Hash and Tie::Array
Tying Filehandles
What Are DBM, NDBM, GDBM, SDBM, etc?
Using the DBM Modules
Installing and Using Perl Modules
Laziness, Impatience, and Hubris
CPAN
Using Modules
Installing a Perl Module
Unpacking the Module Source
The Configuration Step
The Build Step
The Test Step
The Install Step
Using CPAN.pm
Using Module Documentation
Introduction to DBI/DBD in Perl
The Old Way – DBPerls
A Better Way – DBI/DBD
Database Programming
Handles
Connecting to the Database
Creating a SQL Query
Getting the Results
Updating Database Data
Transaction Management
Finishing Up
DBI/DBD SQL Programming
Error Checking in DBI
Getting Connected
Drivers
Using Parameterized Statements
Statement Handle Attributes
Other Handle Attributes
Column Binding
The do Method
BLOBs and LONGs and Such
Installing DBI Drivers
Introduction to Perl/Tk
Tcl, Tk, Tcl/Tk, Tkperl, Perl/Tk, etc.
Perl/Tk
Creating a Perl/Tk Application
GUI Programming Overview
Adding Widgets
Scrolled Widgets
Configuring Widgets
Menus
More Fun with Menus
Using FileSelect
Perl/Tk Programming
Tk::Error and Tk::ErrorDialog
Configuring Widgets
Geometry Management
Geometry Management with grid()
The Frame Widget
Defining Widget Callbacks
Bindings
Nonblocking I/O with fileevent()
Tags
Other Widgets
Other Tk Commands
Getting Tk
Extending Perl with C/C++
Extending the Perl Interpreter
Overview of Perl5 XSUBs
Get Started with h2xs
Set up the Perl Wrapper Class
Write the XS Code
The XS File
Write Some Test Code
What Do You Want?
Returning Values on the Stack
A Walk Through an XSUB
Arguments to XSUBs
Other h2xs Options
Embedding the Perl Interpreter
Why Embed Perl?
Embedding Perl in a C Program
Compiling the Program
perlmain.c
Perl Data Types
Macros and Functions
Manipulating Scalars
Memory Management
Script Space
Evaluating Perl Expressions
Dynamic Loading
Multiple Perl Interpreters
Module Development and Distribution in Perl
Distributing Modules
Get Started with h2xs
Files Created by h2xs
The Build Library (blib) Directory
Unit Testing and test.pl
Versions
Using blib
POD
POD Translators
Cutting a Distribution
Other Niceties
Makefile.PL
Design and Implementation in Perl
Think First
Object-Oriented Design
Object-Oriented Development
Library Modules
Utility Programs
Filters
Performance
Timing with Benchmark
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, …
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
Advertising on Google’s Content Network
Understanding How Content Network Works
CPM vs. CPC
How to Leverage Content Network in Google AdWords
Automatic Placement
Targeted Placement
Exploring the Networks Tab within Google AdWords
Introduction to Google Places
Overview of Location-Based Ad Services
How to Leverage Google Places
Optimizing Your Keywords Strategy for AdWords
Understanding Types of Keywords
Long Tail vs. Short Tail Keywords
Using Broad Match Modifier
Google Analytics for Keyword Optimization
Identifying Keywords Using Internal Site Search
Identifying Favorable and Unfavorable Keywords
Using Keyword Positions Report
Strengthening Your Keyword Research
Keyword Diagnosis in AdWords
Google’s Search-Based Keyword Tool
Leveraging Google Trends
Leveraging Google Sets
Leveraging Google Insights for Search
Competitive Keyword Analysis
Leveraging Third-Party Tools for Competitive Keyword Analysis
Implementing Dynamic Keyword Insertion
Optimizing AdWords Campaigns
Using Campaign Organization Options
Geo-targeting (Inclusion, Exclusion)
Using Location-Sensitive Keywords
Leveraging AdWords Campaign Experiments (ACE)
Overview of How ACE Works
Different Methods to Use ACE
Leveraging Analyze Competition Feature
Benchmarking AdWords Campaign Performance
Optimizing Ads
Controlling Your Ad Delivery in Google AdWords
Selecting Networks and Devices
Using IP Exclusion
Position Preference
Delivery Preference
Using Ad Rotation
Ad Scheduling
Frequency Capping
Leveraging the Ad Site Links in AdWords Ads
Conversation Tracking in Google AdWord
Understanding How Conversion Tracking Works in Google AdWords
Implementing Conversation Tracking in Google AdWords
Measuring Conversions
Leveraging AdWords Report in Google Analytics
Measuring Campaigns Performance
Day Parts Report
Destination URLs Report
Placement Report
Introduction to Website Optimizer
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, …
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
Intelligence Events
Introduction to Intelligence Events
Automatic Alerts
Custom Alerts
Advanced Segmentation
Introduction to Advanced Segmentation
Leveraging Default Advanced Segments
Customizing Advanced Segments
Managing Advanced Segments
Application of RegEx in Advanced Segmentation
Custom Reporting
Introduction of Custom Reporting
Valid Pairs of Dimensions and Metrics
Designing Your Custom Report
Building Your Custom Report
Ecommerce Tracking and Reporting
Enabling Ecommerce Tracking
Implementing Ecommerce Methods
Ecommerce Overview Report
Product Performance Report
Sales Performance Report
Transaction Report
Time to Purchase Report
Multi-Channel Reports
Assisted Conversions Report
Top Conversions Report
Time Lag Report
Path Length Report
Virtual Pageviews
Introduction to Virtual Pageviews
Virtual Pageviews and Dynamic URLs
Virtual Pageviews for Tracking File Downloads
Virtual Pageviews and Tracking Outbound Links
Event Tracking
Introduction to Event Tracking
Understanding _trackEvent Method
Implementing Event Tracking
Event Tracking Reports
Multiple Domain Tracking
Introduction to Multiple Domain Tracking
Implementing Subdomain Tracking
Implement Cross-domain Tracking
Custom Variables
Introduction to Custom Variables
Architecture of Custom Variables
Implementing Custom Variables
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, …
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
Using Modules in GWT
GWT Modules
Using External Modules
Modularizing An Application
Deferred Binding
Multiple-Module Applications
Code Splitting
More on GWT User Interfaces
Using ToggleButton and PushButton
Using DecoratorPanel
Using AbsolutePanel
Using HTMLPanel
Using FocusPanel
Using HorizontalSplitPanel and VerticalSplitPanel
Using StackPanel
Using TabPanel
The DeckPanel
Using TabPanel
Using Menus via a MenuBar
Using a Tree Widget
Using SuggestBox
GWT RichTextArea Editing
FormPanel
Using DeferredCommand
GWT UiBinder and SafeHtml
What is UiBinder?
UiBinder Benefits
UiBinder Templates
Creating a UiBinder in Eclipse
What Is SafeHtml?
Styling with CSS in GWT
Syling with CSS in GWT
GWT Visual Themes
Styling Widgets in GWT
Associating CSS Files with a Module
Dependent Style in Widgets
More ClientBundle Elements: CSS Resources, Data Resources, and External Resources
Creating Composite GWT Widgets
Custom GWT Widgets
Composite GWT Widgets
Developing Composite Widgets
Using Composite Widgets
Testing and Debugging GWT Modules in GWT
Testing and Debugging GWT Modules
Unit Testing Concepts
The JUnit Test Framework
Writing a JUnit Test Case
GWT Unit Testing with GWTTestCase
Running junitCreator
Testing Asynchronous Code
GWT System Testing
GWT User Interface Testing
More Server Integration Options in GWT
More Server Integration Options in GWT
Using HTTP Requests
Manipulating an XML DOM
Integrating Using JSON
GWT JavaScript Native Interface
GWT JavaScript Native Interface
Defining JSNI Methods
Sharing Data between JavaScript and Java
Talking to the Browser via JSNI
Using External JavaScript
Using a JavaScriptObject in GWT
Java Callbacks from External JavaScript
Using External Libraries
Advanced GWT Connectivity
Stateful and Stateless Servers
Using Stateful Servers
Handling Exceptions
Client-Side RPC Architecture in GWT
Client-Side RPC Architecture
Client-Side Pull versus Push
Polling Protocols
GWT Best Practices
Security Issues
Performance Concerns
Internationalization in GWT
GWT Pitfalls and Issues
Testing Practices for GWT
Bandwidth-Sensitive Applications
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, …
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
Introduction to ASP.NET MVC
Review of ASP.NET Web Forms
Advantages and Disadvantages of Web Forms
Model-View-Controller Pattern
ASP.NET MVC
Advantages and Disadvantages of ASP.NET MVC
Unit Testing
Getting Started with ASP.NET MVC
Installing ASP.NET MVC
Using Visual Studio
Hello World for ASP.NET MVC
Rendering Views
Dynamic Output
ASP.NET MVC Architecture
The Controller in ASP.NET MVC
The View in ASP.NET MVC
The Model in ASP.NET MVC
Helper Methods for HTML
Form Submission
Model Binding
Input Validation
The Model
Microsoft Technologies for the Model
ADO.NET
LINQ
ADO.NET Entity Framework 4.1
NuGet Package Manager
Using MvcScaffolding
Code First Data Modeling
The Controller
IController Interface
Controller Base Class
Actions
Retrieving Data from a Request
Action Results
Action Attributes
Filters
Asynchronous Controllers
The View
View Responsibility
Using ViewData
Loosely-Typed Views
Strongly-Typed Views
Using Dynamic Objects
Html Helpers
Razor View Engine
Using ViewBag
Validation Attributes
HTML 5 Project Templates
Routing
Routing in ASP.NET MVC
Properties of Routes
Registering Routes
Debugging Routes
Areas
Unit Testing
Test-Driven Development
Test Automation
Refactoring
NUnit
Test Cases
Test Classes
Test Runners
Testing ASP.NET MVC Applications
Dependency Injection
Mocking Frameworks
Inversion of Control Containers
Security
Input Forgery
Cross-Site Scripting
Session Hijacking
Cross-site Request Forgery
SQL Injection
Using the MVC Framework Securely
Combining ASP.NET MVC and Web Forms
Using Web Forms in an MVC Application
Using MVC in a Web Forms Application
Deployment
Server Requirements
Continuous Integration
Environment Configurations
XCOPY
Web Deploy
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, …
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
File Conventions
Connection Pooling
Dynamic Connection Strings
Default METHOD and ACTION Values
Advanced Data Drill-Downs
Passing Data via the Query String
Using Drill-Downs to Reformat Data
Creating Sortable Tables
Displaying Variables
Creating an Include to Display Variable Values for Debugging
Displaying a Portion of a Recordset
Displaying the Next n Records
How the Process Works
Password Protection with Session Variables
Adding Password Protection to Pages
Stored Procedures in ASP
Creating a Stored Procedure in the Database
Advantage of Stored Procedures
Calling a Stored Procedure
Using Stored Procedures to Insert and Update Data
Working with the File System in ASP
The FileSystemObject
Creating or Opening a Text File
Methods of the TextStream Object
Storing Text to a File
The File Object
The Folder Object
Working with Files and Directories
Processing File Uploads
Obtaining a Component for Processing File Uploads
The AspUpload Component
Building an HTML Form that Supports File Uploads
Processing the File on the Server with AspUpload
Processing Files and Entered Text
SetMaxSize
Manipulating Files via AspUpload
Creating an New Directory
Restricting Your Upload to Certain File Extensions
Building a Resume Submission Interface
Batch Updating
Opening a Recordset for Batch Updating
Editing the Records Row by Row
Updating the Batch
Benefits of Batches
Some Useful VBScript Functions
Using rs.Update Instead of INSERT
rs.Update
Form Validation with Server-Side JScript
Server-Side Form Validation with JScript
Transactions in ASP
Transactions
Handling Errors
Catching Database Errors
Creating Message Boards
The HTML Files
The Database
The Interface
Regular Expressions
Creating and Executing Regular Expressions with exec()
Special Characters for Pattern Matching
Escape Sequences for Special Characters
Specifying Ranges in Patterns
Matching a Specified Number of Occurrences
Character-Range Escape Sequences
Matching at the Beginning or End of a String with ^ and $
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, …
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
Ajax Basics
The Purpose of Ajax
Traditional Web Application
An Ajax Web Application
The XMLHttpRequest Object
Creating an XMLHttpRequest Object
Using an XMLHttpRequest Object
Handling the Response
Conclusion
Ajax Frameworks
The Purpose of Frameworks
Choosing a Framework
Dojo
Downloading Dojo
Using Dojo for Ajax
Prototype
Downloading Prototype
Using Prototype for Ajax
Other Popular Frameworks
Direct Web Remoting (DWR)
AjaxAnywhere
Simple Ajax (SAJAX)
Sarissa
Other Frameworks
Conclusion
The HTML Document Object Model
Accessing Nodes
Accessing Element Nodes
Accessing Attribute Nodes
getAttribute
attributes[]
Accessing Nodes by Type, Name or Value
Accessing Nodes by Class Name
Removing Nodes from the DOM
DOM Differences: The Whitespace Problem
Creating New Nodes
Conclusion
XML and Ajax
Creating a DOM Document with JavaScript
Accessing, Creating and Modifying XML Nodes
Creating an AddChild() Function
Receiving XML Responses
Conclusion
Ajax Applications
Login Form
Quick Lookup Form
Preloaded Data
Ajax Slideshow
Navigable Tables
Conclusion
OO JavaScript and Refactoring Ajax
Illustrating the Problem
Object-Oriented JavaScript
JavaScript Classes
Prototypes
Extending Built-in Objects
Refactoring the Ajax Request Code
Conclusion
JavaScript Object Notation (JSON)
Object Literals
Arrays
Objects
Arrays in Objects
Objects in Arrays
JSON
JSON Syntax
JSON Parsers
PHP JSON Extension (added in PHP 5.2)
PEAR JSON
ZEND JSON
JSON Advantages and Disadvantages
Conclusion
XSLT Transformations with JavaScript
XSLT
Basic XSLT
XSLT in the Browser
XSLT in Internet Explorer
XSLT in Mozilla
Sarissa
Advantages and Disadvantages of XSLT in Ajax Applications
Conclusion
Drag and Drop
Drag and Drop Basics
script.aculo.us
Draggables
Droppables
A More Interesting Example
Conclusion
More Ajax Applications
Inline Editing
Detailed Information on Demand
Autologout
Autocompletion
Conclusion
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, …
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
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, …