2-2, Database Systems course at BITS Pilani, Hyderabad Campus
Data modeling, database design theory, data definition and manipulation languages, relational data model, relational algebra and relational calculus, SQL, functional dependencies and normalization, storage and indexing techniques, query processing and optimization, transaction management - concurrency control and crash recovery.
| Lab | Topic | Lab Sheet | Date |
|---|---|---|---|
| 1 | Learning basic sql queries to create table and filter data | Lab 1 | 21 Jan 2023 |
| 2 | How to create user, difference between CDB and PDB, learning advanced sql queries | Lab 2 | 28 Jan 2023 |
| 3 | Creating tables with foreign key, creating tables having circular and self-reference | Lab 3 | 4 Feb 2023 |
| 4 | Using substring queries, set operations, exists and in clause | Lab 4 | 11 Feb 2023 |
| 5 | Using aggregate functions in sql, full outer join, group by and having clause | Lab 5 | 25 Feb 2023 |
| 6 | Joining three tables, trying various approaches like without nesting, using set operations | Lab 6 | 11 March 2023 |
| 7 | Joining three tables, trying various approaches like without nesting, using set operations | Lab 7 | 18 March 2023 |
| 8 | Introduction to PL-SQL, creating procedures and functions and executing them | Lab 8 | 25 March 2023 |
| 9 | Creating procedures and functions in PL-SQL | Lab 9 | 8 April 2023 |
| 10 | Triggers, Cursor, Sequence and inbuilt functions in SQL | Lab 10 | 15 April 2023 |