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:

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

ABOUT THE AUTHOR

By
Hey, I am Raja Vikrant Sharma a student of BCA -2 at GGDSD College, Panjab University. I am fond of wildlife photography and recently got my two clicks published in the newspaper. Presently i am interning at a Website Development Company as a backend developer. I have developed an educational site named BCAHUB which is one year old and getting a traffic of 3500 page views per month. Now i am working for my YouTube channel Bcahub and TechBuzz . Less words , more actions...this is the dictum that I kept in my mind as I stepped into the campus of one of the most renowned college of my city, SD college. Like every novice I was too gripped by the anxiety on the first day of my college. The enthusiastic ambience of the college somehow proved a blessing for me.
2 comments
Read more

SYLLABUS OF THE CDS EXAMINATION 2017

By
B. STANDARD AND SYLLABUS OF THE EXAMINATION  The standard of the papers in Elementary Mathematics will be of Matriculation level. The standard of papers in other subjects will approximately be such as may be expected of a graduate of an Indian University. SYLLABUS: ENGLISH (Code No. 01)  The question paper will be designed to test the candidates’ understanding of English and workmanlike use of words. GENERAL KNOWLEDGE (Code No. 02)  General Knowledge including knowledge of current events and of such matters of everyday observation and experience in their scientific aspects as may be expected of an educated person who has not made a special study of any scientific subject. The paper will also include questions on History of India and Geography of a nature which candidate should be able to answer without special study. ELEMENTARY MATHEMATICS (Code No. 03)  ARITHMETIC  Number System—Natural numbers, Integers, Rational and Real numb...
1 comment
Read more