ADDRESS:  Water Pump, Fedral B Area - Block 17

CONTACT:  0321-3832217

COMPUTER EDUCATION






Study Soft is consulting, development, mentoring, and training company & I.T

Institute with experience in the various facets of industrial and non industrial environment.

We are offering services in IT Solutions, Education Systems,

Information systems, Project & Office Deployment.



Study Soft is a trademark of success in case study & Certification base programs & trainings.


Besides providing technology services, we also inform our students

about what is happening in the technology world so that our students

always stay ahead of their competition.



  • SQL
  • PL/SQL
  • REPORTS
  • FORMS
  • FEES
  • OTHER

  • Retriving data using the SQL select statement.
  • Restricting and sorting& filtering data.
  • Using single row function to customize output.
  • Displaying data from multiple tables –I.
  • Displaying data from multiple tables-II.
  • Using sub queries to solve problems.
  • Using set operators.
  • Character function.
  • Manipulating function.
  • Conversion, Number & date function.
  • Conditional expressions.
  • Joins
  • Using DML statements.
  • Using DCL statements.
  • Using DDL statements to create and manage tables
  • Constraints.
  • Simple view, views & complex view.
  • Retrieving data using sub queries.
  • Creating other schema objects.
  • Managing schema objects.
  • Managing objects with data dictionary.
  • Controlling user access.
  • Manipulating large data sets.



  • Introducation.
  • Declaring Variables.
  • Writing Executable Statements.
  • Interacting with Oracle Server.
  • Working with Composite Data Types.
  • Writing Explicit Cursors.
  • Writing Implicit Cursors.
  • Handling Exceptions.
  • Creating Procedures.
  • Creating Functions.
  • Creating Loops.



  • Designing and executing a simple report.
  • Managing the appearance of data in reports with layout objects.
  • Customizing the display of data in reports.
  • Integrating text and graphics in reports.
  • Linking tabular, break, master/detail, matrix and form letter reports.
  • Applying the packaged functions and procedures supplied with the reports builder component of Developer.
  • Writing queries to retrieve data.
  • Create and modify by wizard & manual basic tabular reports.
  • Create and modify by wizard & manual group above reports.
  • Create and modify by wizard & manual other report styles such as break reports and matrix reports.
  • Create and modify by wizard & manual other report styles such as break reports and matrix with group reports.
  • Determining how to best produce reports by analyzing report structures.
  • Filtering report information from the database server.
  • Building modules in Developer Reports for use with other Developer tools.



  • Creating data blocks and relationships as source data for retrieval and display.
  • Creating input items: text, list, checkbox, radio group and buttons.
  • Creating non-input items: display, image and buttons.
  • Defining item values in their respective property palette.
  • Creating forms with multiple window and content canvases.
  • Saving and running a form module using designer and runtime executables.
  • Developing a tabular and group layout form.
  • Identifying characteristics of each forms file storage type.
  • Creating program units and learning to create and attach program unit libraries.
  • Using Oracle built-in packages, calendars and timers.
  • Writing application triggers for various form events.
  • Creating trigger code to interact with windows.
  • Passing data between forms using parameter lists.
  • Passing values between forms using global variables.
  • Enhancing the default menu.
  • Adding basic menu items and context menus.
  • Embedding charts into a form module using the Chart Wizard.
  • Incorporating existing graphic displays in a form module.
  • Creating and invoking reports in a form using the Report Wizard.
  • Controlling a report programmatically in a form.



Fee for both Tracks
(Developer & Database)
Rs.30000/- (Thirty Thousand only)
Breakup Fee on monthly basis
Rs.5000/-Duration: Six Months
Classes: Three alternate days a week
Timing: (8:30pm to 11:30pm).....



For further details of ORACLE

Name
RABEE SALEEM
Contact
0340-2026675, 0315-3188430
Social Media
Name
FAZAL-SHAH
Contact
0321-3832217
Social Media


Studysoft


Study Soft is consulting, development, mentoring, and training company & I.T

Institute with experience in the various facets of industrial and non industrial environment.

We are offering services in IT Solutions, Education Systems,

Information systems, Project & Office Deployment.



Study Soft is a trademark of success in case study & Certification base programs & trainings.


Besides providing technology services, we also inform our students

about what is happening in the technology world so that our students

always stay ahead of their competition.



  • BASICS
  • ADVANCE

HTML 5 & CSS 3
  • Define HTML 5.
  • Build HTML 5 Pages.
  • Understand the major benefits of HTML 5.
  • Elements and attributes of HTML 5.
  • Work with audio and video in HTML 5.
  • New Style Sheet using CSS 3.
PHP with MySQL
  • Basic PHP programming Concepts.
  • Variable & Data types.
  • Conditions & Looping.
  • Using PHP with HTML Form Elements.
  • Super Global Variables in PHP.
  • Functions (Built-in & User Defined).
  • Session in PHP.
  • Use of Cookies.
  • Introduction to Database.
  • Interface & Use of MYSQL.
  • Different Queries of MySQL.
  • Integration of MySQL with PHP.
  • Building Web Application in PHP.
JavaScript
  • Programming Fundamentals.
  • Introduction to JavaScript.
  • Variables and Data types.
  • Decision Statements.
  • Looping & Its Types.
  • String Functions.
  • Using Arrays.
  • Using Object.
  • Clients Side Form Validation.

Fee for Basics Web Development

Rs._________________/-
(Rupees _________________ Only)

Breakup Fee on monthly basis

Rs.___________/- Duration: _____ Months
Classes: ___________ alternate days a week
Timing: (___________ to __________).....



CSS Framework Bootstrap
  • Installation and syntax of Bootstrap.
  • Using Bootstrap.
  • Effects of Bootstrap.
  • Bootstrap Examples.
  • Make the responsive structure of web page.
JavaScript Library JQuery
  • Installation and syntax of JQuery.
  • Using JQuery With Different Events.
  • Effects of JQuery.
  • Simple Effects (Show, hide, toggle).
  • Sliding Effects.
  • Fading Effects.
  • JQuery with HTML.
  • JQuery Animation Effects.
  • JQuery Examples.
PHP Framework Codeigniter
  • OOPS.
  • About PHP/OOPS & MySQL.
  • Advantage of using Framework.
  • Introducing CodeIgniter Framework.
  • Ajax Basics.
  • Create first project with CodeIgniter Framework.

Fee for Advance Web Development

Rs._________________/-
(Rupees _________________ Only)

Breakup Fee on monthly basis

Rs.___________/- Duration: _____ Months
Classes: ___________ alternate days a week
Timing: (___________ to __________).....


Studysoft

Data Working Progress



Studysoft

Selected tab:






For any support

ADDRESS:  Water Pump, Fedral B Area - Block 17

CONTACT:  0321-3832217