Welcome to Computrain

We Make it Easy to Learn Microsoft Word, Excel, Outlook and More - No Matter What Your Skill Level ...

PowerBuilder 6

Course Outline

Course Description
This course will teach you how to use the impressive tools of PowerBuilder 6, including object oriented programming, user-defined objects and datawindow techniques. Learn database painter, SQL in powerscript, menus and toolbars, polymorphism and more.

About Trainer
Brian J. Smith is a certified PowerBuilder Professional and the president of Brian J. Smith and Associates, Inc. He is also a contributing editor to Databased Advisor Magazine and the principle author of Foundations of PowerBuilder 5.

Course Sets - Single User License *

A complete set of 6

$140.00

(*) Please Email sales@computrainsolutions.com if you have question regarding to our multi-user licensing for this course or check our FAQ on the left menu.

Detailed Course Outlines:

	Level 1 (1 Hr 51 Mins)
	1.0	Getting Started (56 mins)
	1.1	What is PowerBuilder?
	1.2	The Development Process
	1.3	The PowerBuilder Environment
	1.4	Components of PowerBuilder Development
	1.5	Developing Your First Application
	1.6	Simple Scripts (Extending Our Application)
	2.0	The PowerScript Language (52 mins)
	2.1	Event-Driven Programming
	2.2	Events
	2.3	Programming Style
	2.4	Assignment Statements
	2.5	Variables
	2.6	Arrays & Structures
	Level 2 (1 Hr 44 Mins)
	1.0	Client/Server Systems & Databases (29 mins)
	1.1	What Is Client/Server?
	1.2	Connecting from Client to Server
	1.3	Database Profiles
	1.4	ODBC
	2.0	The Database Painter (31 mins)
	2.1	Selecting Tables
	2.2	The Data Manipulation Painter
	2.3	The Table Painter
	2.4	Extended Attributes of a Column
	2.5	Indexes
	2.6	Views
	3.0	Introduction to SQL (43 mins)
	3.1	What Is SQL?
	3.2	FThe Database Administration Painter & Simple SELECT Queries
	3.3	Joins
	3.4	Nested Select
	3.5	Insert
	3.6	Data Definition Commands
	3.7	The SQL Painter
	Power Builder Level 3 (1 Hr 50 Mins)
	1.0	SQL in PowerScript (59 mins)
	1.1	An UPDATE Command in a Script
	1.2	Transaction Objects
	1.3	Error Handling
	1.4	Move Connect/Disconnect to Open/Close event Script
	1.5	Reading Connection Parameters from an .INI File
	1.6	Other Embedded SQL Commands
	1.7	Null Values Procedures
	1.8	Dynamic SQL
	2.0	Introduction to DataWindows (50 mins)
	2.1	What Is a DataWindow?
	2.2	Creating a New DataWindow Object
	2.3	Designing the Data Window Object & Scripts Required
	2.4	Retrieve & Update Buttons
	2.5	Navigation Controls & Row Counter
	2.6	Insert
	2.7	Printing as Report
	2.8	Error Handling

	Level 4 (2 Hrs 5 Mins)
	1.0	DataWindow Techniques (53 mins)
	1.1	The DataWindow Painter
	1.2	Adding Another Column
	1.3	Adding a Computed Field
	1.4	Display Formats
	1.5	DataWindow Painter Expressions
	1.6	Changing a DataWindow's Properties in a Script
	1.7	The SQL Behind the Scenes
	1.8	The Rows Menu Choices
	1.9	Data Sources & Presentation Styles
	1.10	Drop Down DataWindows
	2.0	Data Entry Programming (1 Hr 8 mins)
	2.1	Field-Oriented Processing
	2.2	The ItemChanged Event Script
	2.3	The ItemError Event Script
	2.4	Row-Oriented Processing
	2.5	The DataWindow Buffers
	2.6	Update-Oriented Processing
	Level 5 (1 Hr 48 Mins)
	1.0	Object-Oriented Programming (43 mins)
	1.1	The Elements of Object-Oriented Programming
	1.2	What Is an Object? (Encapsulation)
	1.3	The Importance of Objects
	1.4	Messages
	1.5	Object Classes & Instances
	1.6	Object Class Hierarchy
	1.7	User-Defined Classes
	1.8	Inheritance
	1.9	Polymorphism
	1.10	Object Variables
	1.11	Function Overloading
	2.0	User-Defined Objects (45 mins)
	2.1	Defining a Subclass
	2.2	The User Object Painter
	2.3	Standard Visual User Objects
	2.4	Adding Functions & Events
	2.5	Instance Variables
	2.6	User-Defined Functions
	2.7	User-Defined Events
	2.8	Custom Visual User Objects
	2.9	Standard Nonvisual User Objects
	2.10	Custom Nonvisual User Objects
	2.11	The Smart Transaction Object
	Level 6 (1 Hr 59 Mins)
	1.0	Inheritance (39 mins)
	1.1	Property Inheritance
	1.2	Event Script Inheritance
	1.3	Function Inheritance
	1.4	Regenerate/Rebuild
	1.5	Designing Your Object Model
	1.6	Data Window Inheritance
	1.7	A Smart DataWindow Control
	2.0	Windows (38 mins)
	2.1	The Six Types of Windows
	2.2	The Open Function & Its Variations
	2.3	MDI Applications
	2.4	Dialog Boxes
	3.0	Menus & Toolbars (21 mins)
	3.1	Menu Components
	3.2	The Menu Painter
	3.3	Menu Event Scripts
	3.4	Adding a Toolbar Button
	3.5	Menu Inheritance
	4.0	Deploying Your Application (19 mins)
	4.1	The Project Painter
	4.2	Multi-Library Applications
	4.3	Resource Files