Become a world-class Digital Marketer in the next 3 months. Join SkillCamper's Digital Marketing Bootcamp. Get guaranteed job placement and a minimum salary of Rs 5 lakhs.
Back to Study material
Syllabus
RDBMS
Relational Database Management System (Syllabus)
Course Code: DSC-301: Computer Science Paper-V
Course Title: Relational Database Management System
1 Introduction to RDBMS
Data ,Database, DBMS, RDBMS, Concepts of Data Models object based, Record based (Network, Hierarchical,Relational),Physical
Concept of RDBMS Terminologies: relation, attribute, domain, tuple, entities, DBA and Responsibilities of DBA
Relational Model: Structure of Relational Database, Relational Algebra.
2 Structured Query Language (SQL)
SQL: Data types-fixed length, variable length, ex.
Data Constraints-Primary key, Foreign key, Null, Check, Default
Clauses-(Select, where, group by, order by).
SQL Operators: Logical, Relational, Special-In, Between, Like
Sub Queries and Join-Sub queries and Nesting sub queries, Join: Equi join, Simple join , Outer join ,self join
Views, Indexes, Sequence
3 Introduction to PL-SQL
Comparison between SQL & PL-SQL
Structure of PL-SQL block.
Benefits of PL/SQL over SQL
Control structure: if statement, case statement, Loops-Simple looping, For, While.
Need of Iterative and looping statements in data handling
4 Introduction to MySQL
Difference between SQL and MySQL, Creating a Database and Tables, Inserting, Selecting,
Ordering, Limiting, Grouping, Analyzing and Manipulating Data, Changing, Deleting,
Searching, Database and Table Schema Statements, Data Manipulation Statements and Functions, Table Statements and Functions, Replication Statements and Functions.
Aggregate Clauses, Aggregate Functions, String Functions, Date and Time Functions, Mathematical Functions.
Reference book-
1. Data base system concept- KorthSilberschartz.
2. SQL-PL/SQL by Ivan Bayross BPB Publications.
3. Structure query language-By Osborne
4. Learning MySQL by O’reilly
Object Oriented Programming using C++
Object Oriented Programming using C++ (Syllabus)
Course Code: DSC-302
Course Title: Object Oriented Programming using C++
Unit 1
Object Oriented Concepts-
Difference between POP and OOP .
Concepts of OOP- Data abstraction, Encapsulation, Inheritance,
Polymorphism.
Basics of C++-
Terminology-Tokens, Keywords, Identifiers, constants.
Basic data types.
Structure of C++ program.
Input and output streams.
Unit 2
Operators in C++
Dynamic Memory allocation (New and Delete), this pointer.
Dynamic initialization of variable, reference variables.
Control structures-
Branching and looping statements.
Features of OOP:
Classes and objects-
Definitions, class declaration.
Member function-
Access modifiers : private, public and protected, Defining
member functions, static data members.
Array of objects, passing object as parameter, inline
function, reference arguments.
Friend function and friend class.
Unit 3
Constructors-
Definition, types- Default constructor, Copy constructor,
Parameterised constructor.
Destructors.
Operator overloading-
Definition
Overloading unary and binary operators.
Overloading operators using friend function.
Rules for overloading operator.
Unit 4
Inheritance-
Defining base and derived class.
Types of Inheritance –Single , multiple, multilevel, hierarchical, hybrid.
Polymorphism-
Definition.
Types of polymorphism.
Virtual function.
Reference Books:
1. Object oriented programming By E. Balagurusamy.
2. C++ Programming –By D. Ravichandran
3. Let Us C++ By YashawantKanetkar.
4. Object Oriented Programming in C++ - Dr. G. T. Thampi, Dr. S. S. Mantha
5. Mastering C++ -By Venugopal.