CS403 Final Term Preparation | VU Short Lectures | Lecture 22 to 40 SQL Statement Database. CS403 Final Term Preparation | VU Short Lectures | Lecture 22 to 40 SQL Statement Database. #CS403 #VU #VirtualUniversity. This is third and the second last session for the students of CS 403 database management system for any program of BSCS, BSIT or BS software engineering from Virtual University of Pakistan. Students can get concepts of structured query language and the types of structured query language with their detailed SQL statements and the execution of the SQL statements with the help of w3schools.com website. SQL statements are divided into two categories DML statements and DCL statements.
Topics of First CS403 Final Term short VU Final Exam Preparation includes first 18 lectures. VU Cs304 lectures 22 to Lecture 40.
1. Structured Query Language (SQL) 2. Types of Structured Query Language (SQL) 3. Data definition language (DDL) 4. Data control Language (DCL) 5. Select statement in urdu 6. Select with Group by 7. Select with order by 8. select with having clause 9. Select with attributes and alias 10. Joins and its types 11. inner joins 12. left join 13. right join 14. Insert into table 15. inset into values 16. select from where.