CS-504 (A) · Internet and Web Technology/Official Syllabus
Internet and Web Technology (CS-504 (A)) - Official Syllabus (CS-504)
1
Unit 1
UNIT-1 : Database Management System Concepts
- Introduction Significance of Database
- Database System Applications;
- Data Independence;
- Data Modeling for a Database;
- Entities and their Attributes Entities Attributes
- Relationships and Relationships Types
- Advantages and Disadvantages of Database Management System
- DBMS Vs RDBMS.
2
Unit 2
UNIT-2 : Database Models and Implementation
- Data Model and Types of Data Model
- Relational Data Model Hierarchical Model
- Network Data Model Object/Relational Model
- Object-Oriented Model; Entity-Relationship Model
- Modeling using E-R Diagrams
- Notation used in E-R Model
- Relationships and Relationship Types; Associative Database Model
3
Unit 3
UNIT-3 : SQL
- Data Definition Language :Categories of SQL Commands;
- Data Definition Language;
- Create table Drop table and Alter Table.
- Primary Key Foreign Key
- Truncate Table Index Cursor.
4
Unit 4
UNIT-4 : SQL DML
- Data Manipulation Language
- Insert Statement Multiple Inserts
- Delete Statement
- Delete with conditions
- Update statement
- Update with Conditions
- Merge Statement
5
Unit 5
UNIT-5 : SELECT
- SQL queries Data extraction from single
- multiple tables equi-join non equi-join self-join
- outer join. Usage of like any all exists in Special operators.
- Hierarchical queries inline queries
- flashback queries.
- Introduction of ANSI SQL anonymous block
- nested anonymous block
- branching and looping constructs in ANSI SQL.
6
Unit 6
== END OF UNITS==
Go to where you left off?
Quick Add to Notes
Save questions, your own notes and screenshots into notes filed by unit. It takes a free account.
Create free accountHave an account? Log in
Notes Panel