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…

PRINCIPLES OF COMPUTER GRAPHICS & MULTIMEDIA TECHNOLOGY SYLLABUS

Computer Graphics
SECTION-A 
1. A Survey of Computer Graphics :

Computer Aided Design, Presentation Graphics, Computer art, Entertainment, Education and Training, Visualization, Image Pressing, Graphical User Interfaces.

2. Overview of Graphics Systems :

Video Display Devices, Raster Scan Systems, Random Scan Systems. Coloring technique : Beam Penetration, Shadow Mask. Graphics Monitors:Plasma Panel, LED,LCD. Properties of Display Devices : Persistence , Resolution, Aspect Ratio. and Workstations, Input Devices, Hard-copy devices, Graphics Software. Interactive Graphics, Passive Graphics.


SECTION-B
 3. Studying the Features and Developing Computer Graphics Using Standard Graphics packages like Auto CAD and Photoscape.

AutoCAD:

Features, Workspace, Commands to draw line, Polyline, rectangle, polygon, circle, spline, hatch; Modification Commands: Erase, copy, move, mirror, scale, Pan, Zoom, ESC, cl, trim; Layer, Dimension, image rotation, area calculation.

4. Developing Computer Graphics…