Databases are at the heart of modern engineering and communication applications. They are used to store large amounts of data for efficient update and retrieval. The purpose of this course is to provide and introduction to the design and use of database systems, as well as an understanding of the key issues in building such systems. This course will enable students better to engineer database system and handle practical problems in modeling and developing real world data driven applications.
Prerequisites
| 1 | Introduction to Database Basic Concept of Databases Architectures Entity Relationship modeling ER-to-Relational mapping Overview of SQLSQL as Declarative Language SQL Syntax and Datatypes |
| 2 | SQL Sublanguages DQL, DML, DDL, DCL DQL (Data Query Language) in Detail Displaying Table Structure Selecting Specific Columns Arithmetic Expressions Operator Precedence Defining a Column Alias Restricting and Sorting Data Limiting Rows Selected Comparison Operators Other operators (BETWEEN, IN, LIKE, IS NULL) |
| 3 | SQL Sublanguages Views creation Logical Operators and Rules of Precedence Order by Clause Single-Row Functions Group functions Sub Query Table joins JOIN clause UNION operator |
| 4 | DDL (Data Definition Language) Overview Creating and Managing Tables CONSTRAINTS Overview NULL i NOT NULL CONSTRAINT clause check PRIMARY KEY UNIQUE FOREIGN KEY DEFAULT clause |
| 5 | DML (Data Manipulation Language) Overview Insert rows into a table Update rows in a table Delete rows from a table Control transactions |
| 6 | Language DCL Granting and revoking permissions (GRANT, REVOKE) Roles Creating Users sequences Synonyms The views (perspective) |
Schedule
Visit Schedule Page to see detailed schedule and fee of this course.
Contact
Address: ICEPT, Plot 5, Khayaban-e-Johar, Sector H-9, Islamabad
Phone: 0331-44-42378(ICEPT)
Email: info@icept.iqraisb.edu.pk