Skip to main content

CLIENT SERVER COMPUTING USING ORACLE

By

SECTION-A 

  1. Introduction to DBMS, Advantages and disadvantages of DBMS, introduction to RDBMS, Codd's Rule for RDBMS, Difference between DBMS and RDBMS. Normalization. Data Models and their types (Hierarchical, Networking, Relational). Introduction to Client-Server Computing, Architecture of Client-Server Computing, Advantages of Client-Server Computing. Introduction to SQL *Plus: Introduction to SQL, Oracle Data types, Starting SQL *Plus, Data Manipulation and 
Control-I : Data Definition Language (DDL), Creating Tables, Creating a Table with data from another table, Inserting Values into a Table, Updating Column(s) of a Table, Deleting Row(s) from a Table, Dropping a Column, Querying database tables, Conditional retrieval of rows, Working with Null Values, Matching a pattern from a table, Ordering the Result of a Query, Aggregate Functions, Grouping the Result of a Query, ROLLUP Operation: Getting Sub Totals, CUBE Operation: Getting Cross Tabs, Command Summary of SQL *Plus Editor. 
SECTION-B 

 2. Functions : Arithmetic Functions, Character Functions, Date Functions, General Functions; Group Functions. Introduction to VIEWs, Manipulating the Base table(s) through VIEWs, Rules of DML Statements on Join Views, Dropping a VIEW, Inline Views, Materialised Views. Querying Multiple Tables: Collating Information: Equi-Joins, Cartesian Joins, Outer Joins, Self Joins. ; Set Operator: Union, Intersect, Minus; Nested Queries. Data Manipulation and 
Control-II: Database Security and Privileges, GRANT Command, REVOKE Command, Application Privileges Management, Enhancing Performance, Sequences, Paper Maintaining Database Objects, COMMIT and ROLLBACK.

SECTION-C 

 3. PL/SQL-I : Introduction to PL/SQL, The Advantage of PL/SQL, PL/SQL Block Structure, PL/SQL Architecture, Fundamentals of PL/SQL, PL/SQL Data Types, Variables and Constants, Scope and Visibility of a Variable, Assignments and Expressions, Operator Precedence, Referencing Non- PL/SQL Variables, Built-inFunctions, Conditional and Iterative Control, SQL Within PL/SQL, Writing PL/SQL Code, Composite Datatypes. 
SECTION-D 

 4. PL/SQL-II: Cursor Management in PL/SQL, Cursor Manipulation, Implicit Cursor Attributes, Exception Handling in PL/SQL; Predefined Exceptions, User-Defined Exceptions. 
Advanced PL/SQL: Subprograms in PL/SQL, Advantages of Subprograms, Procedure, Functions, Actual versus Formal Parameters, Argument Modes, Stored Packages, Advantages of Packages, Dropping a Procedure, Dropping a Function, Dropping a Package, Using Stored Function in SQL Statements, Database Trigger, Types of Triggers, Dropping Triggers, Storage for Triggers.

Question Papers:
 


Labels

Labels:

Comments

Post a Comment

Thanks for the comment and don't forget to subscribe.

Popular posts from this blog

CAREER OPTIONS AFTER BCA

By
Career Options after BCA There are several doors opened, once you are done with your bachelor's in computer application(BCA).Apart from MCA or MBA in IT , one can also go for :  Masters in Computer Management  Masters Degree in Information Management (MIM)  Master of Science in Information Technology (M.Sc IT)  G-CAT Master  Postgraduate Diploma in Computer Applications  Post Graduate Program in Corporate Studies (PGPCS)  Postgraduate Diploma in Management (PGDM)  Program in Information Security Management  If one wants to get recruited and desires to be the part of corporate sector....there are numerous options for that too. One can work as a software developer, web developer, graphic Designer, App Developer for
4 comments
Read more

PROJECT MANAGEMENT AND SYSTEM DEVELOPMENT

By
SECTION-A    1. Concept of a Project, Project Life Cycle Phases, Tools & Techniques of Project Management, Roles & Responsibilities of a Project Manager, Feasibility Report, Types of Feasibility, Financing Arrangements, Preparation of Cost Estimates, Project Implementation Schedule, Evaluation of Project Profitability. SECTION-B  2. Working & Design of Systems, System Design & Execution Plan, Work Breakdown Structure, Project Procedure Manual, Planning, Scheduling & Monitoring, Project Direction & Co- ordination, Communications in a Project, Project Control-Progress, Performance, Schedule & Cost Control, Performance Indicators & Performance Improvement, Project Management Environment.
1 comment
Read more

REVALUATION FORM-JULY-2018

By
How to Fill a Re-evaluation Form   Now no need to rush to the cyber cafe for getting your re-evaluation done...BCAHUB brings you an easy way to fill the re-evaluation form for the 2nd, 4th, and 6th Semester (May 2018) Exam.You can fill the form without going to Punjab University at your convenience.....Go Ahead.. Last date is 20  July 2018. **Read the steps before opening the website. Step 1 :  Go to  puchd.ac.in This is a website to fill the re-evaluation form for (2-4-6) Semester. Open it and do the following steps.  Step 2 : On the centre of the web page. Fill the categories such as
1 comment
Read more