Online Dynamic Sql Programming eLearning

Dynamic SQL and Metadata Dynamic SQL and Metadata Oracle To write dynamic SQL and use the DBMS_METADATA package  more...

Oracle Report Builder Controlling Reports Course Overview This course is the third in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course helps participants learn how to develop report templates, code PL/SQL triggers in a report, and use Report Builder's built-in package. Finally, building reports for different environments will be covered. L earn To: Identify the regions of  more...

Oracle Form Builder R6 Controlling the User Interface Programmatically Course Overview This course is the fifth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course enables learners to create Key triggers, to write code that responds to mouse events, to manage windows and canvases, and to use the Object Navigator. In addition, learners work with multiple form applications, record groups, and list items. L earn To:  more...

Oracle Reports R6 Control Reports Course Overview This course is the third in a three-part Oracle Reports series that is based on Oracle Reports Release 6. This course introduces the learner to features of Oracle Reports that can be used to control report output. This course covers developing templates, creating and using parameters, coding PL/SQL triggers, exporing built-in package procedures, using the Reports Server, and  more...

Oracle PL SQL Database Programming Course Overview This course is the third in a series of three titles, and discusses the features of stored subprograms and packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored  more...

IBM DB2 Univ Database V7 1 Transition Part 2 Business Intelligence Course Overview This is the second course in a two part series that students will be introduced to the concept of business intelligence. This course also covers administrative enhancements, and it discusses DB2 family enhancements. Learn To Identify the components of the data warehousing process. Identify the enhancements in Business Intelligence (BI) products available for DB2 version  more...

Oracle9i Database Admin Manage an Instance Course Overview The Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are  more...

Visual Basic NET-Web Based Development Part 3 Assuming that the learner is now familiar with the basics of Web forms and controls, this course introduces ADO .NET and guides the learner through database connections and data access. Learn To: o To identify features of ADO.NET. o To ientify the syntax for importing ADO.NET namespaces. o To ientify features of the ADO.NET object model. o To identify features of SQL Server security  more...

Visual Basic NET-Web Based Development Part 3 Assuming that the learner is now familiar with the basics of Web forms and controls, this course introduces ADO .NET and guides the learner through database connections and data access. Learn To: o To identify features of ADO.NET. o To ientify the syntax for importing ADO.NET namespaces. o To ientify features of the ADO.NET object model. o To identify features of SQL Server security  more...

IBM DB2 Universal Database V6 1 App Devel Curriculum Course Overview The Complete IBM DB2 Universal Database V6.1 Application Development Curriculum includes the courses needed to prepare for IBM Certified Solutions Expert certification exams 509 and 511. Students will learn fundamental DB2 v6.1 skills and knowledge, such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of  more...

IBM DB2 Universal Database V6 1 App Devel Curriculum Course Overview The Complete IBM DB2 Universal Database V6.1 Application Development Curriculum includes the courses needed to prepare for IBM Certified Solutions Expert certification exams 509 and 511. Students will learn fundamental DB2 v6.1 skills and knowledge, such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of  more...

IBM DB2 Universal Database V6 1--App Development ...cation development objects, embedded SQL programming, and dynamic SQL programming. L earn To: Use SQL functions in DB2 Applications. Use different application objects in DB2, such as schema, user-defined types, user-defined functions, and stored procedures. Use SQL within an application. Use dynamic SQL within an application. C ontent Emphasis Skills-Based A udience  more...

IBM DB2 Universal Database V6 1--App Development ...cation development objects, embedded SQL programming, and dynamic SQL programming. L earn To: Use SQL functions in DB2 Applications. Use different application objects in DB2, such as schema, user-defined types, user-defined functions, and stored procedures. Use SQL within an application. Use dynamic SQL within an application. C ontent Emphasis Skills-Based A udience  more...

CIW Dynamic Server Pages Part 1 Course Overview This is the first course in a three part series that introduces students to PHP Hypertext Processor and provides the foundational knowledge for the course series. Additionally, this course will cover an introduction to PHP, PHP fundamentals, string manipulation and file input/output, and PHP and databases. Learn To • Identify PHP. • Identify the basic and  more...