Skip to main content

CLIENT SERVER COMPUTING USING ORACLE


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:


 


Comments

  1. I ‘d mention that most of us visitors are endowed to exist in a fabulous place with very many wonderful individuals with very helpful things.

    oracle training in bangalore

    oracle training in chennai

    ReplyDelete

Post a Comment

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

Popular posts from this blog

COMPUTER ORGANISATION

6TH SEMESTER: SECTION-A 
1. Computer Organisation : Evolution of Computers, Stored program concept and Von Neumann Architecture, Information representation and codes, Combinatorial Blocks : Gates, Multiplexers, Decoders, Encoders, Sequential Building blocks : Flip-Flops, Registers, Counters, Arithmetic algorithms : Addition and subtraction for signed magnitude and 2's complement numbers, integer multiplication using shift and add, Booth's algorithms, Integer and floating point representation.

SECTION-B
 2. Architecture of a Simple Processor : An instruction set, Addressing Modes, Instruction formats, Instruction execution in terms of Microinstructions, Concept of interrupt and simple I/O organisation, I/O organization : Strobe-based and Handshake based communication, Vector and priority interrupts, DMA-based data transfer; CPU organisation with large registers, Stacks and handling of interrupts and subroutines. Concept of Bus, data movement among registers, data movement from/to…

ENTREPRENEURSHIP DEVELOPMENT PROGRAMME SYLLABUS

ENTREPRENEURSHIP DEVELOPMENT PROGRAMME
SECTION-A 
1.Project Formulation :

Need, Scope and approaches for project formulation; the structure of project report; study and analysis of sample project report; preparation of a project report; Techno- economic feasibility of the project. (No. of Periods : 25)

SECTION-B
2. Finance & Accounting :

Working capital assessment, its management & exercise thereon; Assessment of fixed capital and exercise thereon; Capital budgeting; Product costing and cost consciousness. Financial ratios and their significance; Break-even analysis; Credit institutions and financing procedures; Books of accounts, financial statements & fund flow analysis.

SECTION-C
3. Managing the Enterprise:

Resource management – men, material, money, and machines; Personnel management, Office management. E-Commerce: Introduction to E-Commerce, Benefits, Impact of E-Commerce, Classification of E-Commerce, Application of E-Commerce.

SECTION - D
4. Rules & Regulations:

Lic…

COMPUTER NETWORKS

6TH SEMESTER - SECTION-A
1. Introduction to Data Communication: Data Communication fundamentals, Simplex, Half-Duplex, Full-Duplex Network definition, Network Hardware and Software, Network Topologies, Uses of Computer Networks, OSI reference model, TCP/IP Reference Model. Comparison of OSI & TCP/IP reference model. 2. Physical Layer: Transmission Media, Switching, ISDN & its services, Multiplexing, Modems.

SECTION-B
3. Data Link Layer: Design Issue, Error Detection & Correction Codes, Elementary Data Link Protocols, Static & Dynamic Channel Allocation, Introduction to IEEE standards, Sliding Window Protocols: One-bit Sliding Window Protocol, Go Back n, Selective Repeat.