Diploma in Application Programming Course Details
This Course encompasses the client Server Technology using Microsoft visual Basic as a front end Oracle or SQL as the backend. This Course gives as clear picture about the application development and storing the data using the database.
An application program is a comprehensive, self-contained program that performs a particular function directly for the user. The two main types of software available are application software and system software. System software manages the computer's internal operation, primarily through the OS. Peripherals such as storage devices, printers and monitors are also managed. Conversely, application or program software guides the computer to implement user-provided instructions.
System software includes background programs to allow applications to work. System programs include file management tools and OS itself, compiler, assembler and file management tools. Application programmes, as the systems software is compiled from low-level programmes, work on the top of the system software. During the installation of the OS, system software is installed automatically. Users can however choose which application programs on their systems are installed.
Diploma in Application Programming Highlights
SQL
Retriving data using the SQL select statement] - Restricting and sorting data
- Using single row function to customize output.
- Reporting aggregated data using the grout function.
- Displaying data from multiple tables –I
- Displaying data from multiple tables-II
- Using sub queries to solve problems
- Using set operators
- Manipulating data
- Using DDL statements to create and manage tables
- Creating other schema objects
- Managing objects with data dictionary
- Controlling User access
- Managing schema objects
- Manipulating large data sets
- Generating report by grouping related data
- Managing data in different time zones
- Retrieving data using sub queries
- Hierarchical retrieval
- Regular expression support
PL/SQL
- Introduction
- Declaring Variables
- Writing Executable Statements
- Interacting with Oracle Server
- Writing Control Structures
- Working with Composite Data Types
- Writing Explicit Cursors
- Writing Implicit Cursors
- Handling Exceptions
- Creating Procedures
- Creating Functions
- Managing Subprograms
- Creating Packages
- More Package concepts
- Oracle supplied Packages
- Manipulating Large Objects
- Creating Database Triggers
- More Trigger concepts
- Managing Dependents
- Retriving data using the SQL select statement]
- Restricting and sorting data
- Using single row function to customize output.
- Reporting aggregated data using the grout function.
- Displaying data from multiple tables –I
- Displaying data from multiple tables-II
- Using sub queries to solve problems
- Using set operators
- Manipulating data
- Using DDL statements to create and manage tables
- Creating other schema objects
- Managing objects with data dictionary
- Controlling User access
- Managing schema objects
- Manipulating large data sets
- Generating report by grouping related data
- Managing data in different time zones
- Retrieving data using sub queries
- Hierarchical retrieval
- Regular expression support