Page 202 - BSIT Course Syllabus (First Sem 2020-2021)

be able to: Concepts (II) Presentation Presentation) 13th week
4. DCL exercises
3. explain the concepts D. DCL (Data Demonstration/ Modules (Grant, Revoke)
and applications of Control Simulation 5.TCL (Commit,
DDL, DQL, DML, Language) Learning Rollback,
DCL, and TCL; and E. TCL (transaction Guide Savepoint, Set
4. apply the usage of Control transaction)
SQL (DDL, DQL, Language) Computer/
DML, DCL, and TCL) Laptop/
using DB software. mobile phone
14 After the completion of XI. MySQL functions Discussion Online Lecture Laboratory Before the
the unit, the students will A. Concepts and Learning (Power Point Activity 12 end of week
be able to: application of Presentation Presentation) 14th week
1. identify the usage aggregate functions: 1. Aggregate
and applications of Demonstration/ Modules function
MySQL functions; a. AVG Simulation exercises.
and b. COUNT Learning Apply the
2. create queries c. MAX Guide following(AV
using MySQL d. MIN G,COUNT,M
function scripts. e. SUM Computer/ AX,MIN,SU
f. Standard Deviation Laptop/ M,SD,GC)
g. GROUP_CONCAT mobile phone and
generate
outputs.
15 After the completion of XII. Advanced MySQL Discussion Online Lecture Laboratory Before the
the unit, the students will (I) Learning (Power Point Activity 13 end of week
be able to: Presentation Presentation) 15th week
1. explain the A. Concepts and 1. Advance
concepts and application of Demonstration/ Modules scripts
applications of advanced scripts: Simulation exercises.
advanced scripts; Learning Apply the
and a. BETWEEN Guide following
2. create queries b. LIKE (BETWEEN,
using MySQL c. ALIASES Computer/ LIKE,
Advance scripts. d. INNER JOIN Laptop/ ALIASES)

V02-2020-07-01