SCO 210-211, New Petrol Pump, Sec-34A, Chandigarh
Welcome to Amit Book Depot.
7696866526, 0172 2665665
Categories

Have Doubts Regarding This Product ? Ask Your Question

  • Q1
    What is the primary focus of the book Fundamentals of Mathematical Statistics?
    A1

    The book is designed to provide a comprehensive understanding of the key concepts of mathematical statistics for BCA 1st-year students, covering both theoretical foundations and practical applications.

  • Q2
    Who are the authors of this book?
    A2

    The book is authored by Sanjeev Dhawan, Swati Sidhana, Archana Arora, and Ashwani Jain and published by Sharma Publications.

  • Q3
    What topics are covered in this textbook?
    A3

    Key topics include an introduction to statistics, data collection, classification of data, tabulation and presentation of data, measures of central tendency, measures of dispersion, correlation analysis, and regression analysis.

  • Q4
    Is this book suitable for beginners in statistics?
    A4

    Yes, the book is meticulously structured to guide students from basic to more advanced concepts, making it particularly valuable for beginners.

  • Q5
    How does this book facilitate practical learning?
    A5

    The book incorporates real-world examples, diagrams, and exercises, helping to contextualize statistical concepts and reinforcing learning through practical application.

  • Q6
    What does the exam format entail?
    A6

    The exam consists of four units, with nine questions in total. Students are required to attempt one question from each unit, plus one compulsory short answer question covering the entire syllabus.

  • Q7
    Are there practice exercises included in the book?
    A7

    Yes, worked-out examples and exercises are provided at the end of each chapter to help students master the material and prepare for exams.

  • Q8
    Can calculators be used during the examination?
    A8

    Students are allowed to use basic (non-programmable) calculators, and logarithm tables may be provided for computations.

  • Q9
    Does the book align with the BCA curriculum of Panjab University?
    A9

    Yes, the book is specifically designed to align with the curriculum requirements for BCA 1st-year students at Panjab University.

  • Q10
    What makes this book different from other statistics textbooks?
    A10

    This book not only covers definitions and formulas but also explains the "how" and "why" behind statistical methods, enabling students to understand the underlying principles.

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.

Top Trending Products

Related Products

Related Blog Posts