Links to other fields:

 

Business Management

 

Information Technology

 
- .NET Technology

- VB.NET

- Oracle Database Development

- WEB Development - Java,
   HTML, JavaScript, ASP.NET

- C# for Programmers

- Advanced Java Programming

- Business Reports Analysis
   using Crystal Reports /
   Enterprise

- Web Site Development with
   HTML, JavaScript, ASP.NET

- Database Development -
   Oracle and VB.NET

- Lotus Notes Application
   Development

- LAN / WAN Network Design
   and Support

 

Engineering

     
 

Database Development

 
 

Oracle and VB.NET

 
 

Course Benefits:

In this hands-on course, students will gain a comprehensive introduction to Oracle and VB.NET, providing them the skills needed to take advantage of critical database features. The hands-on exercises provide practical experience developing robust, high-performance and scalable applications. Students will develop dynamic real-world Windows applications and learn how to package and deploy them.

 

Time Allocation:

Database Development is a 160 hour course.

 

This course will include:

Part A—Oracle

  • Client-Server Application basics
  • Designing Relational Databases
  • Data Types and Modeling
  • Normalization Techniques
  • SQL Plus Line Editor, Queries, Retrieving Data
  • SQL Plus Reporting Tools
  • Data Manipulation Language
  • Oracle Functions
  • Transaction Control
  • Security in Oracle: Data Control Language
  • Data Definition Language
  • Integrity Constraints
  • SQL Plus Host Variables and Code Generator
  • Creating Triggers using PL / SQL
  • Part B—VB.NET

  • Fundamental concepts of program development, structure and
  •     design

  • Write, compile and debug programs using VB.NET
  • Build and deploy Windows applications for the .NET Framework
  • Develop GUI front-ends for client / server systems
  • Apply object-oriented techniques to VB.NET programs
  • Trap and respond to exceptions with structured exception
  •     handling

  • Access relational data using ADO.NET
  • Implement bitmap and vector graphics
  • Develop WEB applications and services using ASP.NET and
  •     VB.NET

     

    Who Should Attend:

    This course is valuable for Programmers and Software Developers as well as System Analysts and other computer professionals.

     

    Prerequisite:

    Experience with macros and / or a scripting language.