[admission-open-date]
- Back to School Homepage
- Back to Department Homepage
CS13 – Oracle 10g
Teaching Hours : 60 [ 30 hours Theory + 30 hours LAB ]
Prerequisite: any background
Modules
Unit 1
- Content Outline: Introduction to Database Concepts ,Users of Oracle, The Relational Database Model, The Development Life Cycle ,Data Normalization , Overview of Normalization ,The Normal Forms , Logical Design , Data Modeling , Entities and Attributes , Entities and Their Relationships
-
5 hours
Unit 2:
- Introduction to Structured Query Language ,Introduction to SQL*Plus , The SELECT Statement
- Data Definition Language (DDL) ,Data Control Language (DCL) , Data Manipulation Language (DML) ,Transaction Control Language (TCL) ,
-
8 hours
Unit 3:
- Procedural Language / Structured Query Language ,Overview of PL/SQL , Stored Packages, Procedures, and Functions Triggers Database Objects Datablocks Database Storage
-
7 hours
Unit 4:
- Forms and reports
-
5 hours
Unit 5:
- Oracle and Object-oriented Methodology Oracle Architecture The Oracle Database The Oracle Instance Accessing the Database Other Oracle Products and Tools
-
5 hours
-
Text Book
-
Kevin Loney, Oracle Database 10g: The Complete Reference, Mc-Graw Hill Osborne media, 2004.
-
Reference
-
Ian Abramson , Michael Abbey, Michael J Corey, Oracle Database 10g: A beginners guide, Mc-Graw Hill Osborne media, 2004.
C Programming Lab
Guidelines
Article
Follow Coding standards
Article I
The output of the programs should be neatly formatted
Article II
The programs should be user friendly and interactive
Article III
Use comment wherever necessary
Lab Programs
SQL
-
Demonstrate the DDL commands -
Demonstrate the DML commands -
Demonstrate the DCL commands -
Demonstrate the TCL commands -
Demonstrate the Single line functions -
Demonstrate the Multiline functions -
Demonstrate the Join commands -
Demonstrate the Inner Join commands -
Demonstrate the outer Join commands -
Demonstrate the subqueries
PL/SQL
-
Demonstration of simple programs -
Demonstration of Cursors -
Demonstration of Triggers -
Demonstration of Packages -
Demonstration of functions -
Development of a mini project using forms and reports
Admission Queries
For any queries at any given time during the application and admission process, you may contact us through the following Email ID’s:
Bangalore Central Campus
The Office of Admissions,CHRIST (Deemed to be University), Hosur Road,Bengaluru – 560 029, Karnataka, INDIA
Phone
+91 92430 80800
+91 80 4012 9400
Email IDs
Indian candidates: admissions@christuniversity.in
NRI candidates: nri.admission@christuniversity.in
International: isc.admission@christuniversity.in
Bangalore Kengeri Campus
CHRIST (Deemed to be University)
Kanmanike, Kumbalgodu, Mysore Road,
Bengaluru – 560 074, Karnataka, INDIA
Delhi NCR Campus
CHRIST (Deemed to be University),
Mariam Nagar, Meerut Road,
Delhi NCR Ghaziabad – 201003
Phone
1800-123-3212
Bangalore Bannerghatta Road Campus
CHRIST (Deemed to be University)
Hulimavu, Bannerghatta Road,
Bengaluru – 560 076, Karnataka, INDIA
Phone
+91 080 4655 1306
Email
admissions.bgr@christuniversity.in
Bangalore Yeshwanthpur Campus
CHRIST (Deemed to be University)
Nagasandra, Near Tumkur Road,
Bengaluru 560 073, Karnataka, INDIA
Pune Lavasa Campus
CHRIST (Deemed to be University),
Christ University Road, 30 Valor Court, PO Dasve Lavasa, Mulshi, Pune – 412112, Maharashtra
Phone
1800-123-2009
Between: Monday to Friday: 09:00 AM to 04:00 PM,
Saturday: 09:00 AM to 12:00 PM
(Office remains closed on Sundays, Government Holidays and Any special events)
CS13 – Oracle 10g
Teaching Hours : 60 [ 30 hours Theory + 30 hours LAB ]
Prerequisite: any background
Modules
Unit 1
- Content Outline: Introduction to Database Concepts ,Users of Oracle, The Relational Database Model, The Development Life Cycle ,Data Normalization , Overview of Normalization ,The Normal Forms , Logical Design , Data Modeling , Entities and Attributes , Entities and Their Relationships
-
5 hours
Unit 2:
- Introduction to Structured Query Language ,Introduction to SQL*Plus , The SELECT Statement
- Data Definition Language (DDL) ,Data Control Language (DCL) , Data Manipulation Language (DML) ,Transaction Control Language (TCL) ,
-
8 hours
Unit 3:
- Procedural Language / Structured Query Language ,Overview of PL/SQL , Stored Packages, Procedures, and Functions Triggers Database Objects Datablocks Database Storage
-
7 hours
Unit 4:
- Forms and reports
-
5 hours
Unit 5:
- Oracle and Object-oriented Methodology Oracle Architecture The Oracle Database The Oracle Instance Accessing the Database Other Oracle Products and Tools
-
5 hours
Unit 1
- Content Outline: Introduction to Database Concepts ,Users of Oracle, The Relational Database Model, The Development Life Cycle ,Data Normalization , Overview of Normalization ,The Normal Forms , Logical Design , Data Modeling , Entities and Attributes , Entities and Their Relationships
-
5 hours
Unit 2:
- Introduction to Structured Query Language ,Introduction to SQL*Plus , The SELECT Statement
- Data Definition Language (DDL) ,Data Control Language (DCL) , Data Manipulation Language (DML) ,Transaction Control Language (TCL) ,
-
8 hours
Unit 3:
- Procedural Language / Structured Query Language ,Overview of PL/SQL , Stored Packages, Procedures, and Functions Triggers Database Objects Datablocks Database Storage
-
7 hours
Unit 4:
- Forms and reports
-
5 hours
Unit 5:
- Oracle and Object-oriented Methodology Oracle Architecture The Oracle Database The Oracle Instance Accessing the Database Other Oracle Products and Tools
-
5 hours
-
Text Book
-
Kevin Loney, Oracle Database 10g: The Complete Reference, Mc-Graw Hill Osborne media, 2004.
-
Reference
-
Ian Abramson , Michael Abbey, Michael J Corey, Oracle Database 10g: A beginners guide, Mc-Graw Hill Osborne media, 2004.
C Programming Lab
Guidelines
Article
Follow Coding standards
Article I
The output of the programs should be neatly formatted
Article II
The programs should be user friendly and interactive
Article III
Use comment wherever necessary
Lab Programs
SQL
-
Demonstrate the DDL commands -
Demonstrate the DML commands -
Demonstrate the DCL commands -
Demonstrate the TCL commands -
Demonstrate the Single line functions -
Demonstrate the Multiline functions -
Demonstrate the Join commands -
Demonstrate the Inner Join commands -
Demonstrate the outer Join commands -
Demonstrate the subqueries
PL/SQL
-
Demonstration of simple programs -
Demonstration of Cursors -
Demonstration of Triggers -
Demonstration of Packages -
Demonstration of functions -
Development of a mini project using forms and reports
Admission Queries
For any queries at any given time during the application and admission process, you may contact us through the following Email ID’s:
Bangalore Central Campus
The Office of Admissions,CHRIST (Deemed to be University), Hosur Road,Bengaluru – 560 029, Karnataka, INDIA
Phone
+91 92430 80800
+91 80 4012 9400
Email IDs
Indian candidates: admissions@christuniversity.in
NRI candidates: nri.admission@christuniversity.in
International: isc.admission@christuniversity.in
Bangalore Kengeri Campus
CHRIST (Deemed to be University)
Kanmanike, Kumbalgodu, Mysore Road,
Bengaluru – 560 074, Karnataka, INDIA
Delhi NCR Campus
CHRIST (Deemed to be University),
Mariam Nagar, Meerut Road,
Delhi NCR Ghaziabad – 201003
Phone
1800-123-3212
The Office of Admissions,CHRIST (Deemed to be University), Hosur Road,Bengaluru – 560 029, Karnataka, INDIA
Phone
+91 92430 80800
+91 80 4012 9400
Email IDs
Indian candidates: admissions@christuniversity.in
NRI candidates: nri.admission@christuniversity.in
International: isc.admission@christuniversity.in
CHRIST (Deemed to be University)
Kanmanike, Kumbalgodu, Mysore Road,
Bengaluru – 560 074, Karnataka, INDIA
Phone
+91 80 4012 9800,
+91 80 4012 9802
+91 80 4012 9820
Email
admissions.kengeri@christuniversity.in
CHRIST (Deemed to be University),
Mariam Nagar, Meerut Road,
Delhi NCR Ghaziabad – 201003
Phone
1800-123-3212
Email
admission.ncr@christuniversity.in
Bangalore Bannerghatta Road Campus
CHRIST (Deemed to be University)
Hulimavu, Bannerghatta Road,
Bengaluru – 560 076, Karnataka, INDIA
Phone
+91 080 4655 1306
Email
admissions.bgr@christuniversity.in
Bangalore Yeshwanthpur Campus
CHRIST (Deemed to be University)
Nagasandra, Near Tumkur Road,
Bengaluru 560 073, Karnataka, INDIA
Pune Lavasa Campus
CHRIST (Deemed to be University),
Christ University Road, 30 Valor Court, PO Dasve Lavasa, Mulshi, Pune – 412112, Maharashtra
Phone
1800-123-2009
CHRIST (Deemed to be University)
Hulimavu, Bannerghatta Road,
Bengaluru – 560 076, Karnataka, INDIA
Phone
+91 080 4655 1306
Email
admissions.bgr@christuniversity.in
CHRIST (Deemed to be University)
Nagasandra, Near Tumkur Road,
Bengaluru 560 073, Karnataka, INDIA
Phone
+91 97422 44407
+91 80 6989 6666
Email
admissions.yeshwanthpur@christuniversity.in
CHRIST (Deemed to be University),
Christ University Road, 30 Valor Court, PO Dasve Lavasa, Mulshi, Pune – 412112, Maharashtra
Phone
1800-123-2009
Email
admission.lavasa@christuniversity.in
Between: Monday to Friday: 09:00 AM to 04:00 PM,
Saturday: 09:00 AM to 12:00 PM
(Office remains closed on Sundays, Government Holidays and Any special events)