GitHub - Sri-Hasini/DBMS_college_programs-3rd_sem-: Programs in DBMS related to college(3rd Sem)

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 44 Commits
2.1 Querying and modifying the database using Data Manipulation Language commands -select, insert, update, delete.sql		2.1 Querying and modifying the database using Data Manipulation Language commands -select, insert, update, delete.sql
2.2 Implementation of Aggregate Functions – sum, avg, min, max, count. Use group-by and having clause..sql		2.2 Implementation of Aggregate Functions – sum, avg, min, max, count. Use group-by and having clause..sql
3.1 Perform Join Operations-Natural Join, Equi-Join, Outer Join, Left Outer Join, Right Outer Join, Inner Join and assess the impact of query plans on the performance of join heavy queries.sql		3.1 Perform Join Operations-Natural Join, Equi-Join, Outer Join, Left Outer Join, Right Outer Join, Inner Join and assess the impact of query plans on the performance of join heavy queries.sql
3.2 Perform Set Operations-Union, Intersection, Set Difference .sql		3.2 Perform Set Operations-Union, Intersection, Set Difference .sql
3.3 Implementation of Correlated sub-queries and Nested queries .sql		3.3 Implementation of Correlated sub-queries and Nested queries .sql
3.4 Creating and Querying views and Materialized views.sql		3.4 Creating and Querying views and Materialized views.sql
4.1 Implement SQL queries on a normalized database schema based on the provided schema.sql		4.1 Implement SQL queries on a normalized database schema based on the provided schema.sql
4.2 (A) Implementation of Data Control Language commands — GRANT and REVOKE.sql		4.2 (A) Implementation of Data Control Language commands — GRANT and REVOKE.sql
4.2 (B) Implementation of Transaction Control Language commands — COMMIT, SAVEPOINT, and ROLLBACK.sql		4.2 (B) Implementation of Transaction Control Language commands — COMMIT, SAVEPOINT, and ROLLBACK.sql
5.1 Create a Primary and Secondary Index on a Column .sql		5.1 Create a Primary and Secondary Index on a Column .sql
5.2 Retrieve Data Using an Index .sql		5.2 Retrieve Data Using an Index .sql
5.3 Insert Data and Update Indexes .sql		5.3 Insert Data and Update Indexes .sql
5.4 Delete Data and Observe Impact on Indexes.sql		5.4 Delete Data and Observe Impact on Indexes.sql