Page 168 - IT_Bulletin
P. 168
DATABASE MANAGEMENT SYSTEM
Contents Introduction to my SQL language, Structure of my SQL statements & my SQL
writing guidelines, Data Definition commands: Creating a Database, Show,
Creating a Table ,Use, Altering the Database, Altering the Table, RENAME,
DESCRIBE, Dropping the Database, Dropping the Table, TRUNCATE.
Method of Lab Manual -External Practical
Assessme nt
Learning Outcome Modify Data Base and Tables with the he lp of DML. 9 10
2
Contents Data Manipulation State me nts: SELECT statement that are described in
(FROM, WHERE, GROUP BY, HAVING, ORDER BY),INSERT, UPDATE,
Method of DELETE, REPLACE.
Assessme nt
External Practical
Learning Outcome Make use of Aggregate Functions and Various 9 10
3 Constraints.
Contents Aggregate Function (AVG, COUNT, MAX, MIN, SUM). Defining primary keys,
foreign ke ys, Unique Keys, CHECK constra ints in a table, removing constraints
Method of from tab le.
Assessme nt
External Practical
Learning Outcome Conclude Various Joins Ope rations and View 9 10
4 state me nts.
Contents Joins (INNER, OUTER, SELF ) and SELF Join, View (CREATE VIEW
Statement, ALTER VIEW Statement , DROP VIEW Statement.
Method of Lab Manual -Internal Practical- lab work
Assessme nt
Course Outcome 4 Outline Advance Database Concepts. Hrs Marks
Learning Outcome Explain Trigger and Database 09 10
1 Connectivity to various languages.
Contents Overview of Trigger with example, Database Connectivity with Various
Languages
Method of Internal Practical- lab work
Assessme nt
DATABASE MANAGEMENT SYSTEM
Contents Introduction to my SQL language, Structure of my SQL statements & my SQL
writing guidelines, Data Definition commands: Creating a Database, Show,
Creating a Table ,Use, Altering the Database, Altering the Table, RENAME,
DESCRIBE, Dropping the Database, Dropping the Table, TRUNCATE.
Method of Lab Manual -External Practical
Assessme nt
Learning Outcome Modify Data Base and Tables with the he lp of DML. 9 10
2
Contents Data Manipulation State me nts: SELECT statement that are described in
(FROM, WHERE, GROUP BY, HAVING, ORDER BY),INSERT, UPDATE,
Method of DELETE, REPLACE.
Assessme nt
External Practical
Learning Outcome Make use of Aggregate Functions and Various 9 10
3 Constraints.
Contents Aggregate Function (AVG, COUNT, MAX, MIN, SUM). Defining primary keys,
foreign ke ys, Unique Keys, CHECK constra ints in a table, removing constraints
Method of from tab le.
Assessme nt
External Practical
Learning Outcome Conclude Various Joins Ope rations and View 9 10
4 state me nts.
Contents Joins (INNER, OUTER, SELF ) and SELF Join, View (CREATE VIEW
Statement, ALTER VIEW Statement , DROP VIEW Statement.
Method of Lab Manual -Internal Practical- lab work
Assessme nt
Course Outcome 4 Outline Advance Database Concepts. Hrs Marks
Learning Outcome Explain Trigger and Database 09 10
1 Connectivity to various languages.
Contents Overview of Trigger with example, Database Connectivity with Various
Languages
Method of Internal Practical- lab work
Assessme nt
DATABASE MANAGEMENT SYSTEM
