Categories
College Bookssss >
BA PU Chandigarh
BSC PU Chandigarh
MSC PU Chandigarh
BBA PU Chandigarh
MA PU Chandigarh
Medical Books
Engineering Books
Management Books
PGDCA Books
BCOM PU Chandigarh
MCOM PU Chandigarh
BCA PU Chandigarh
MCA PU Chandigarh
animate-books

Have Doubts Regarding This Product ? Ask Your Question

  • Q1
    What is the main focus of the book "Client Server Computing Using Oracle"?
    A1

    The book focuses on client-server architecture and database management using Oracle, specifically tailored for BCA 2nd-year students.

  • Q2
    Who are the authors of this book?
    A2

    The book is authored by Puneet Kumar and Sushil Bhardwaj.

  • Q3
    Which semester and program is this book designed for?
    A3

    This book is designed for BCA 2nd-year students in their 4th semester at Panjab University, Chandigarh.

  • Q4
    What are the key topics covered in this book?
    A4

    The key topics include SQL and PL/SQL programming, transaction management, database security, and client-server computing principles.

  • Q5
    Are there any practical sessions included in the book?
    A5

    Yes, there are practical sessions provided in the appendices for SQL queries and PL/SQL programs.

  • Q6
    What programming language is emphasized in the book?
    A6

    The book emphasizes SQL and PL/SQL, Oracle's procedural language extension for SQL.

  • Q7
    Does the book provide a guide for installing Oracle software?
    A7

    Yes, it includes a step-by-step installation guide for Oracle 10g.

  • Q8
    How does this book align with the curriculum of Panjab University?
    A8

    The book aligns with the syllabus set by Panjab University for BCA students, ensuring it meets the academic requirements for the subject.

  • Q9
    Is this book suitable for self-study, or is it recommended for classroom use?
    A9

    The book is designed for both self-study and classroom use, facilitating a comprehensive understanding of the subject matter.

  • Q10
    What is the significance of transaction management covered in the book?
    A10

    Transaction management is crucial for maintaining database integrity, and the book teaches commands related to COMMIT and ROLLBACK.

0.00

0 Overall Rating
  • 5
    0
  • 4
    0
  • 3
    0
  • 2
    0
  • 1
    0

Try this product & share your review & thoughts

1. Introduction to DBMS
2. Introduction to RDBMS
3. Data Models
4. Client - Server Computing
5. Oracle
6. Introduction to SQL *Plus
7. Querying Multiple Tables
8. Functions
9. Data Manipulation and Control - I
10. Views
11. Data Manipulation and Control - II
12. Introduction to PL/SQL
13. Control Structure in PL/SQL
14. Cursor Management in PL/SQL
15. Exception Handling in PL/SQL
16. Advance PL/SQL
17. Database Trigger
Appendix
Appendix-I ( Installation of Oracle 10g)
Appendix-II ( SQL Queries - Practice Session)
Appendix-III ( PL/SQL Programs - Practice Session)
Objectives: This course aims at giving the students the insight of client-server computing and creating applications using the Oracle.

Note:
(i) The syllabus of this paper has been divided into four sections.
(ii) The examiner will set a total of nine questions, comprising two questions from each section and one compulsory question of the short answer type covering the whole syllabus.
(iii) The students are required to attempt one question from each section and the entire compulsory question.
(iv) All questions carry equal marks, unless specified.
(v) The students can use only non-programmable and non-storage type calculators. 

Section A
1. Introduction to DBMS, advantages and disadvantages of DBMS, Introduction to RDBMS, Codd’s Rule for RDBMS, Difference between DBMS and RDBMS.
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 Subtotals CUBE Operation: Getting Cross Tabs, Command Summary of SQL Plus Editor. 

Section B
2. Functions: Arithmetic Functions, Character Functions, Date Functions, General Functions, and Group Functions. Introduction to VIEWs, Manipulating the base table(s) through views and materialized views. Querying Multiple Tables: Collating Information: Equi Joins, Cartesian Joins, Outer, 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, 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-in functions, 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, Procedures, Functions, Actual versus formal parameters, argument modes, stored packages, advantages of packages, Dropping a procedure, Dropping a Functions, Dropping a package, Using Stored Function in SQL statements, Database Trigger, Types of Triggers, Dropping , Triggers, Storage for Triggers.

Unlock the intricacies of database management and client-server architecture with Client Server Computing Using Oracle, an essential textbook tailor-made for BCA 2nd-year students in their 4th semester at Panjab University, Chandigarh. Authored by renowned educators Puneet Kumar and Sushil Bhardwaj and published by Kalyani Publishers, this comprehensive guide serves as a vital resource for students eager to deepen their understanding of client-server computing through Oracle technologies.

The book delves into the core aspects of client-server computing, explaining how this model enhances communication between clients and servers, ensures efficient data storage, and supports numerous applications in the real world. Moreover, with a dedicated section on Oracle, students will gain insights into one of the most widely used database systems, equipping them with the practical skills necessary for both academic excellence and career success.

Key features of the textbook include an introduction to SQL Plus, where students will learn to execute queries, manipulate data, and explore advanced functions. The structured chapters guide readers through the process of querying multiple tables, employing data manipulation controls, and understanding views, all integral to working with databases effectively.

A significant focus is placed on PL/SQL, Oracle's proprietary procedural language extension for SQL. Students will learn about control structures, cursor management, and exception handling within PL/SQL, enabling them to write robust and efficient database programs. The advanced topics on PL/SQL and database triggers empower students to implement complex logic and automation within their databases, further enhancing their programming skills.

The textbook is thoughtfully organized, beginning with foundational concepts and gradually advancing to intricate programming solutions, ensuring a progressive learning experience. Appendix sections include practical sessions on SQL queries and PL/SQL programs, reinforcing theoretical concepts with hands-on applications. Additionally, the step-by-step installation guide for Oracle 10g prepares students to set up their environments for practice and experimentation.

Whether you are searching for Client Server Computing Using Oracle by Puneet Kumar, Sushil Bhardwaj or Client Server Computing Using Oracle by Kalyani Publishers, this book is your gateway to mastering the vital concepts of client-server computing for BCA 2nd year, semester 4th. It combines theoretical knowledge with practical skills, making it an indispensable asset for students looking to excel in their studies and future careers in the tech industry.

1. Introduction to DBMS
2. Introduction to RDBMS
3. Data Models
4. Client - Server Computing
5. Oracle
6. Introduction to SQL *Plus
7. Querying Multiple Tables
8. Functions
9. Data Manipulation and Control - I
10. Views
11. Data Manipulation and Control - II
12. Introduction to PL/SQL
13. Control Structure in PL/SQL
14. Cursor Management in PL/SQL
15. Exception Handling in PL/SQL
16. Advance PL/SQL
17. Database Trigger
Appendix
Appendix-I ( Installation of Oracle 10g)
Appendix-II ( SQL Queries - Practice Session)
Appendix-III ( PL/SQL Programs - Practice Session)

Have Doubts Regarding This Product ? Ask Your Question

  • Q1
    What is the main focus of the book "Client Server Computing Using Oracle"?
    A1

    The book focuses on client-server architecture and database management using Oracle, specifically tailored for BCA 2nd-year students.

  • Q2
    Who are the authors of this book?
    A2

    The book is authored by Puneet Kumar and Sushil Bhardwaj.

  • Q3
    Which semester and program is this book designed for?
    A3

    This book is designed for BCA 2nd-year students in their 4th semester at Panjab University, Chandigarh.

  • Q4
    What are the key topics covered in this book?
    A4

    The key topics include SQL and PL/SQL programming, transaction management, database security, and client-server computing principles.

  • Q5
    Are there any practical sessions included in the book?
    A5

    Yes, there are practical sessions provided in the appendices for SQL queries and PL/SQL programs.

  • Q6
    What programming language is emphasized in the book?
    A6

    The book emphasizes SQL and PL/SQL, Oracle's procedural language extension for SQL.

  • Q7
    Does the book provide a guide for installing Oracle software?
    A7

    Yes, it includes a step-by-step installation guide for Oracle 10g.

  • Q8
    How does this book align with the curriculum of Panjab University?
    A8

    The book aligns with the syllabus set by Panjab University for BCA students, ensuring it meets the academic requirements for the subject.

  • Q9
    Is this book suitable for self-study, or is it recommended for classroom use?
    A9

    The book is designed for both self-study and classroom use, facilitating a comprehensive understanding of the subject matter.

  • Q10
    What is the significance of transaction management covered in the book?
    A10

    Transaction management is crucial for maintaining database integrity, and the book teaches commands related to COMMIT and ROLLBACK.

Objectives: This course aims at giving the students the insight of client-server computing and creating applications using the Oracle.

Note:
(i) The syllabus of this paper has been divided into four sections.
(ii) The examiner will set a total of nine questions, comprising two questions from each section and one compulsory question of the short answer type covering the whole syllabus.
(iii) The students are required to attempt one question from each section and the entire compulsory question.
(iv) All questions carry equal marks, unless specified.
(v) The students can use only non-programmable and non-storage type calculators. 

Section A
1. Introduction to DBMS, advantages and disadvantages of DBMS, Introduction to RDBMS, Codd’s Rule for RDBMS, Difference between DBMS and RDBMS.
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 Subtotals CUBE Operation: Getting Cross Tabs, Command Summary of SQL Plus Editor. 

Section B
2. Functions: Arithmetic Functions, Character Functions, Date Functions, General Functions, and Group Functions. Introduction to VIEWs, Manipulating the base table(s) through views and materialized views. Querying Multiple Tables: Collating Information: Equi Joins, Cartesian Joins, Outer, 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, 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-in functions, 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, Procedures, Functions, Actual versus formal parameters, argument modes, stored packages, advantages of packages, Dropping a procedure, Dropping a Functions, Dropping a package, Using Stored Function in SQL statements, Database Trigger, Types of Triggers, Dropping , Triggers, Storage for Triggers.

0.00

0 Overall Rating
  • 5
    0
  • 4
    0
  • 3
    0
  • 2
    0
  • 1
    0

Try this product & share your review & thoughts

Top Trending Product

Related Product

Related Product

Related Blog Posts

Latest Blogs

Latest Blogs

blog-img
Classic Literature Reimagined: Discuss modern twists on classic novels.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Utenim ad minim veniam, quis nostrud exercitation ullamco Lorem ipsum dolor sit amet, consecte...
Read more
Author name | 10 jan, 2025
blog-img
Classic Literature Reimagined: Discuss modern twists on classic novels.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Utenim ad minim veniam, quis nostrud exercitation ullamco Lorem ipsum dolor sit amet, consecte...
Read more
Author name | 10 jan, 2025
blog-img
Classic Literature Reimagined: Discuss modern twists on classic novels.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Utenim ad minim veniam, quis nostrud exercitation ullamco Lorem ipsum dolor sit amet, consecte...
Read more
Author name | 10 jan, 2025
blog-img
Classic Literature Reimagined: Discuss modern twists on classic novels.
Lorem ipsum dolor sit amet, consectetur adipiscing elit...
Read more
Author Name | 10 Jan, 2025
blog-img
Classic Literature Reimagined: Discuss modern twists on classic novels.
Lorem ipsum dolor sit amet, consectetur adipiscing elit...
Read more
Author Name | 10 Jan, 2025
blog-img
Classic Literature Reimagined: Discuss modern twists on classic novels.
Lorem ipsum dolor sit amet, consectetur adipiscing elit...
Read more
Author Name | 10 Jan, 2025
blog-img
Classic Literature Reimagined: Discuss modern twists on classic novels.
Lorem ipsum dolor sit amet, consectetur adipiscing elit...
Read more
Author Name | 10 Jan, 2025
blog-img
Classic Literature Reimagined: Discuss modern twists on classic novels.
Lorem ipsum dolor sit amet, consectetur adipiscing elit...
Read more
Author Name | 10 Jan, 2025
blog-img
Classic Literature Reimagined: Discuss modern twists on classic novels.
Lorem ipsum dolor sit amet, consectetur adipiscing elit...
Read more
Author Name | 10 Jan, 2025
blog-img
Classic Literature Reimagined: Discuss modern twists on classic novels.
Lorem ipsum dolor sit amet, consectetur adipiscing elit...
Read more
Author Name | 10 Jan, 2025
blog-img
Classic Literature Reimagined: Discuss modern twists on classic novels.
Lorem ipsum dolor sit amet, consectetur adipiscing elit...
Read more
Author Name | 10 Jan, 2025
blog-img
Classic Literature Reimagined: Discuss modern twists on classic novels.
Lorem ipsum dolor sit amet, consectetur adipiscing elit...
Read more
Author Name | 10 Jan, 2025