This Microsoft ASP.NET training class provides web developers with the knowledge and skills to develop Web applications by using Microsoft Visual Studio 2010.
This ASP.NET class is intended for Web developers who know HTML and have at least some knowledge of a scripting language such as JScript/JavaScript or VBScript.
Class goals :
Explore ASP.NET Web applications in Microsoft Visual Studio 2010.
Learn to create Web applications by using Microsoft Visual Studio 2010 and Microsoft .NET based languages.
Learn to create a Microsoft ASP.NET Web Form.
Learn to add functionality to a Microsoft ASP.NET Web Form.
Learn to implement master pages and user controls.
Learn to validate user input.
Learn to debug Microsoft ASP.NET Web applications.
Learn to manage data in an ASP.NET 3.5 Web application.
Learn to manage data access tasks by using LINQ.
Learn to manage data by using ASP.NET Dynamic Data.
Learn to create a Microsoft ASP.NET AJAX application.
Learn to consume and Windows Communication Foundation (WCF) services.
Learn to manage state in Web applications.
Learn to configure and deploy a Microsoft ASP.NET Web application.
Learn to secure a Microsoft ASP.NET Web application.
Learn to implement new technologies supported by Visual Studio 2010 for Web development.
Content of Training Visual Studio 2010 / Introduction
Class Outline
Exploring Microsoft ASP.NET Web Applications in Microsoft Visual Studio 2010
Introduction to the .NET Framework
Overview of ASP.NET
Overview of the Lab Application
Lab : There are no labs for this module
Creating Web Applications by Using Microsoft Visual Studio 2010 and Microsoft .NET Based Languages
Choosing a Programming Language
Overview of Visual Studio 2010
Creating a Simple Web Application
Lab : Creating Web Applications by Using Microsoft Visual Studio 2010 and Microsoft .NET Based Languages
Exercise 1: Creating an ASP.NET Web Site
Exercise 2: Adding and Configuring Server Controls in Web Forms
Exercise 3: Building and Deploying an ASP.NET Web Application
Creating a Microsoft ASP.NET Web Form
Creating Web Forms
Adding and Configuring Server Controls in a Web Form
Lab : Creating a Microsoft ASP.NET Web Form
Exercise 1: Creating a Web Form
Exercise 2: Adding and Configuring Server Controls in a Web Form
Adding Functionality to a Microsoft ASP.NET Web Form
Working with Code-Behind Files
Handling Server Control Events
Creating Classes and Components by Using Visual Studio 2010
Handling Page Events
Lab : Adding Functionality to a Microsoft ASP.NET Web Form
Exercise 1: Implementing Code in a Web Application
Exercise 2: Creating Event Procedures
Exercise 3: Creating an Entity Component
Exercise 4: Handling Page and Control Events
Implementing Master Pages and User Controls
Creating Master Pages
Adding User Controls to an ASP.NET Web Form
Lab : Implementing Master Pages and User Controls
Exercise 1: Adding and Applying a Master Page
Exercise 2: Converting Web Forms to Content Pages and User Controls
Validating User Input
Overview of User Input Validation
ASP.NET Validation Controls
Validating Web Forms
Lab : Validating User Input
Exercise 1: Adding Validation Controls
Exercise 2: Configuring Validation Controls
Exercise 3: Adding Server-Side Validation
Troubleshooting Microsoft ASP.NET Web Applications
Debugging in ASP.NET
Tracing in ASP.NET
Lab : Debugging Microsoft ASP.NET Web Applications
Exercise 1: Debugging a Web Application
Exercise 2: Tracing a Web Application
Managing Data in an Microsoft ASP.NET 4.0 Web Application
Overview of ADO.NET
Connecting to a Database
Managing Data
Lab : Managing Data in an ASP.NET 4.0 Web Application
Exercise 1: Connecting to a Data Source
Exercise 2: Binding a Server Control to a Data Source
Exercise 3: Modifying a Data Source
Managing Data Access Tasks by Using LINQ
Overview of LINQ
Managing XML Data by Using LINQ to XML
Managing SQL Data by Using LINQ to SQL and LINQ to Entities
Lab : Managing Data Access Tasks by Using LINQ
Exercise 1: Loading Data by Using the XmlDataSource Control
Exercise 2: Displaying Data by Using LINQ to XML
Exercise 3: Saving Data by Using LINQ to Entities
Managing Data by Using Microsoft ASP.NET Dynamic Data
Overview of ASP.NET Dynamic Data
Applying ASP.NET Dynamic Data
Customizing ASP.NET Dynamic Data Applications
Lab : Managing Data by Using ASP.NET Dynamic Data
Exercise 1: Adding Dynamic Data to an Existing Web Site
Exercise 2: Registering LINQ to Entities by Using Dynamic Data
Exercise 3: Map, Clean and Test Solution
Creating a Microsoft ASP.NET Ajax-enabled Web Forms Application
Introduction to Ajax
Creating an ASP.NET Ajax Application by Using the Ajax Features for ASP.NET
Extending an ASP.NET Web Forms Application by Using the Ajax Control Toolkit
Lab : Creating a Microsoft ASP.NET Ajax-Enabled Web Forms Application
Exercise 1: Creating a Modal About Box
Exercise 2: Customizing Dynamic Data Field Templates with Ajax Server Controls
Exercise 3: Adding the Country Import Progress Indicator
Consuming Microsoft Windows Communication Foundation Services
Overview of Windows Communication Foundation Services
Calling Windows Communication Foundation Services
Working with WCF Data Services
Lab : Consuming Windows Communication Foundation Services
Exercise 1: Creating a WCF Service Reference Proxy
Exercise 2: Calling a WCF Service Method from a Web Form
Exercise 3: Implementing WCF Data Services
Managing State in Web Applications
State Management
ASP.NET Profiles
ASP.NET Caching
Lab : Managing State in Web Applications
Exercise 1: Examining the View State
Exercise 2: Caching Countries
Exercise 3: Displaying Visitors Counter on Default Page
Configuring and Deploying a Microsoft ASP.NET Web Application
Configuring an ASP.NET Web Application
Deploying an ASP.NET Web Application
Lab : Configuring and Deploying a Microsoft ASP.NET Web Application
Configuring the List View Page Size and Enabling the Save Countries Button
Configuring the Visitor Counter
Deploying the Web Application
Securing a Microsoft ASP.NET Web Application
Overview of Web Application Security
Declaratively Configuring Authentication and Authorization
Working Programmatically with Authentication and Authorization
Lab : Securing a Microsoft ASP.NET Web Application
Exercise 1: Enabling Forms Authentication
Exercise 2: Implementing Authorization
Exercise 3: Protecting Configuration File
Implementing Advanced Technologies Supported by Microsoft Visual Studio 2010 for Web Development
Working with the ASP.NET MVC 2 Framework
Working with Silverlight 4
Lab : Implementing Advanced Technologies Supported by Microsoft Visual Studio 2010 for Web Development
Exercise: Implementing a Silverlight Application
Training Visual Studio 2010 / 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, …
This hands on Perl programming course provides a thorough introduction to the Perl programming language, teaching attendees how to develop and maintain portable scripts useful for system management, data manipulation, and Web CGI programming.
Class goals :
Extensive hands on exercises provide practice in report creation, pattern matching, string manipulation, file I/O, command line processing, and debugging. Students are shown how to extend Perl’s basic functionality with packages and loadable modules. The final day encompasses CGI scripting with Perl as well as database access using the DBI module. Attendees are shown how to validate form data, how to perform robust database access, and how to generate HTML output in order to create a dynamic web site.
Content of Perl Programming and CGI Scripting
Perl Fundamentals
Running Perl on UNIX and Windows
Using Scalar Variables
Using Arrays
Operators, Expressions and Precedence
Arithmetic and String Operators
Relational and Logical Operators
Using the Conditional Operator
Understanding File Test Functions
Conditional Constructs
Looping Constructs
Using Subroutines
Global vs. Local Variables and Scoping
Debugger Concepts
Using Perl Script Arguments
Using Regular Expressions
Reading and Writing Files
Understanding Scope
Understanding Modules
Writing to Files and Using Multiple Named Formats
The Common Gateway Interface
Configuring a Web Server for CGI
The Apache httpd.conf File
Aliasing CGI-Enabled Directories in Apache
Relationship Between HTML and CGI
The CGI Output Stream
Specifying MIME Types
Printing Dynamic Content
Working with Form Data
Using the Perl CGI.pm Module
Creating Forms with CGI.pm
Form Processing with CGI.pm
Setting Cookies
Using Relational Databases with Perl CGI
Connecting to a Database
Procedural and Object Oriented Programming
Training Perl Programming and CGI Scripting
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 hands on Perl programming course provides a thorough introduction to the Perl programming language, teaching attendees how to develop and maintain portable scripts useful for system management, data manipulation, and Web CGI programming.
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, …
Until now, you have used Crystal Reports to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, you will create complex reports and data sources using Crystal Reports’ tools. You will not only create more sophisticated reports including subreports and cross-tabs, but you will also increase the speed and efficiency of your reports by using SQL queries.
Class goals :
After completing this course, students should be able to:
Create automatic and manual running totals
Work with cross-tab reports
Add subreports
Create drill-downs in a report
Use SQL statements in report processing
Create complex formulas
Add charts to reports
Enhance report functionality
Content of
Lesson 1: Creating Running Totals
Lesson 2: Working with Cross-Tabs
Lesson 3: Adding Subreports
Lesson 4: Creating Drill-Downs in a Report
Lesson 5: Using SQL Statements in Report Processing
Lesson 6: Creating Complex Formulas
Lesson 7: Adding Charts to Reports
Lesson 8: Enhancing Report Functionality
Appendix A: Managing Reports
Appendix B: Processing Data on the Server
Appendix C: Detecting and Fixing Problems
Training Crystal Reports 2008 Level 2
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, …
Organisations use reporting tools to access data sources and generate customised reports. Crystal Reports 2008 enhances report building and report processing techniques with a slew of features that add value to your presentation. In this course, you will create a basic report by connecting to a database and modifying its presentation.
Class goals :
After completing this course, students should be able to:
Explore the Crystal Reports interface
Create a basic report and modify it
Use formulas for filtering data
Build a parameterized report
Group report data
Enhance a report
Create a report using data sourced from an Excel database
Distribute data
Content of Crystal Reports 2008 Level 1
Lesson 1: Exploring the Crystal Reports 2008 Interface
Lesson 2: Working with Reports
Lesson 3: Using Formulas in Reports
Lesson 4: Building Parameterized Reports
Lesson 5: Grouping Report Data
Lesson 6: Enhancing a Report
Lesson 7: Creating a Report from Excel Data
Lesson 8: Distributing Data
Appendix A: Up and Configuring Data Sources
Appendix B: Using Report Processing Techniques
Appendix C: Using Functions in Formulas
Training Crystal Reports 2008 Level 1
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, …
Now that you have completed the first course, or are familiar with the basics of building and modifying reports, you’re ready to move ahead to create complex reports and data sources using Crystal Reports’ tools. In this course, you’ll not only learn how to create more sophisticated reports including subreports and cross-tabs, but you’ll also learn how to increase the speed and efficiency of your reports by using SQL queries.
Class goals :
After completing this course, students should be able to:
Create running totals in a report
Build cross-tabs in your report
Add subreports to a report
Design a report that uses a drill-down
Improve processing speed in your reports
Chart single and multiple data series
Report from Excel data
Implement report prompts
Enhance report functionality
Content of Crystal Reports Version 11 Advanced
Creating Running Totals
Create a Running Total Field
Modify a Running Total Field
Create a Manual Running Total on Detail Data
Create a Manual Running Total on Summary Data
Building Cross-tabs in Your Report
Create a Cross-tab
Create a Specified Group Order
Filter a Cross-tab by Group
Change the Cross-tab Format
Conditionally Format Rows and Columns
Keep Groups Together
Adding Subreports
Insert a Subreport
Link a Subreport to a Primary Report
Edit a Subreport’s Structure
Format a Subreport Using the Format Editor
Share Variables Between Subreports and Primary Reports
Create an On-demand Subreport
Creating Drill-downs
Create a Drill-down
Create Separate Headings for Drill-down Data
Enhancing Report Processing by Writing SQL Statements
Create a Report Using SQL Queries
Summarize Report Data Using SQL Aggregate Functions
Create Joins Using SQL
Create Subqueries
Create a SQL Expression Field
Charting Data
Create a Bar Chart
Modify a Chart
Format a Chart
Create a Chart Template
Create a Top N Chart
Create a Cross-tab Chart
Reporting on Excel Data with Crystal Reports
Create a Report Based on Excel Data
Modify a Report Generated from Excel Data
Update Data in a Report Based on Excel Data
Working with Prompts
Create a Static Prompt
Create a Dynamic Prompt
Enhancing Report Functionality
Group Data Hierarchically
Create a Dynamic Image
Create a Report Alert
Create a Geographic Map
Training Crystal Reports Version 11 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, …
Crystal Reports 11 Level 1 is the first course in the Crystal Reports 11 series. In this course, you will build basic list and group reports that work with almost any database.
Class goals :
After completing this course, students should be able to:
Create a list report by using data from an existing database
Locate and present data in a specified order
Create groups to summarize report data
Build formulas to add non-database data to a report and display data differently
Format reports
Enhance reports by adding and modifying elements in a report
Create single data series charts
Distribute report data to other users
Content of Crystal Reports Version 11 Introduction
Creating a Report
Set Default Report Settings
Specify Fields for a New Report
Preview the Report
Modify Field Display
Add a Report Title
Position Fields
Add Fields from Additional Tables
Displaying Specific Report Data
Find Data
Sort Data
Filter Data by Single Criterion
Grouping Report Data
Insert a Group
Add Summaries
Format Summary Information
Change Group Options
Add an Additional Group
Filter by Group
Create a Top N Sort Group
Building Formulas
Write a Formula
Create a Formula
Edit a Formula
Combine Fields by Formula
Delete a Formula
Filter Data by Multiple Criteria
Modify a Filter Using an OR Operator
Create a Parameter Field
Account for Null Fields in a Formula
Formatting Reports
Remove White Space
Insert Page Header/Footer Data
Add Borders, Boxes, and Lines
Change Field Background Color
Change the Margins
Enhancing Reports
Add a Watermark
Insert Objects Using Object Linking and Embedding
Modify Formatting Based on Data Value
Suppress Report Sections
Insert Hyperlinks
Hide Blank Report Sections
Creating and Modifying Pie Charts
Create a Pie Chart with a Drill-down
Modify Chart Text
Format a Chart
Present a Chart by Group
Distributing Data
Export to PDF
Export to Microsoft Excel File
Export to an Microsoft Access Database File
Create a Report Definition
Create Mailing Labels
Training Crystal Reports Version 11 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, …
This is a course that covers SQL for querying and modifying databases, as well as database transaction processing, creation and dropping of tables and databases and tables. The aim is to provide a sound foundation of SQL, both in general, and in the context of PostgreSQL.
The course is a hands on course and the emphasis is on creating SQL scripts textually, rather than through a GUI.
Class goals :
This is a course that covers SQL for querying and modifying databases, as well as database transaction processing, creation and dropping of tables and databases and tables. The aim is to provide a sound foundation of SQL, both in general, and in the context of PostgreSQL.
The course is a hands on course and the emphasis is on creating SQL scripts textually, rather than through a GUI.
Content of Foundations of SQL for PostgreSQL
Introduction to Database Concepts
overview of relational database and the client – server model
database concepts – tables, rows and columns, primary keys and foreign keys
database data types
Introduction to SQL
creating and running SQL scripts
overview of SQL syntax
guidelines for writing readable and maintainable SQL
Retrieving data – SELECT, WHERE and ORDER
Overview of the SELECT statement and its clauses
specifying source table(s) – using the FROM clause
specifying which columns in a table ( or the entire table ) are to be retrieved
result sets
Renaming columns using aliases
Sorting the query results using ORDER BY
Filter Results using the WHERE clause
logical expressions using numeric and string comparison Operators
basic numeric and string based filtering
filtering based on results of calculations
duplicate removal – using DISTINCT
combining and extending logical expressions using AND , OR and NOT
specifing ranges – BETWEEN and IN
handling NULL values
basic pattern matching – LIKE
Using UNION, INTERSECT and EXCEPT to join SELECT Results
This course covers the installation and use of Navicat for administering PostgreSQL database. It will cover the administration, tuning, backup and recovery of PostgreSQL databases using the Navicat Database Administration Tool.
Class goals :
This course covers the installation and use of Navicat for administering PostgreSQL database. It will cover the administration, tuning, backup and recovery of PostgreSQL databases using the Navicat Database Administration Tool.
Content of PostgreSQL Administration using Navicat
INavicat for PostgreSQL – installation and configuration
Configuring connectivity
SSL vs. non SSL
Tunneling connections through SSH
Understanding Connection keep-alives
connection parameter storage
Navicat and Cluster Management
Adding and dropping databases
Configuring database defaults
Carrying out database VACCUUM and ANALYZE operations
Duplicating database objects
Using server monitor to modify and manage systems
Backup and Recovery
creating backups
Converting a backup files into an SQL Script
Running recovery scripts
Exporting data using Navicat Data export tools
Working with the Navicat Data Viewer/Editor
Form and Grid Views
BLOB and large text editing
custom display formats
Sorting & Searching
Following Primary Key – Foreign key relationships
more complex record filtering
Working with the Navicat Query Builder
Overview and features – Syntax highlighting. SQL code completion
SQL console
Navicat Query logging
Importing and exporting data
importing via ODBC
importing data from MS-Excel, CSV, Text, DBF …
exporting data to Excel, Access, PDF, HTML
Graphical exploration of database/table structure
Managing schemas, view and stored procedures
Managing privileges amd access control
visual user manager
cloning users and their permissions
group membership management
Overview of the Navicat Report Management Tools
Report Builder
Report Viewer
Training PostgreSQL Administration using Navicat
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-brussels - business training center in Brussels 