3275: Database Lab Syllabus for Cloud Computing & Big Data 3rd Sem 2021 Revision SITTTR

Database Lab detailed syllabus for Cloud Computing & Big Data (CC) for 2021 revision curriculum has been taken from the SITTTRs official website and presented for the Cloud Computing & Big Data students. For course code, course name, number of credits for a course and other scheme related information, do visit full semester subjects post given below.

For Cloud Computing & Big Data 3rd Sem scheme and its subjects, do visit Cloud Computing & Big Data (CC) 3rd Sem 2021 revision scheme. The detailed syllabus of database lab is as follows.

Course Objectives:

• Impart the design and management of relational databases using SQL.
• Familiarize with the design and management of NOSQL databases.

Course Outcomes:

On completion of the course, the student will be able to:

1. Demonstrate the use of DDL and DML commands in database
2. Illustrate SQL queries involving aggregate functions, join operations, views and nested queries
3. Construct SQL programs using functions, procedures, and trigger
4. Implement document based NOSQL databases using MongoDB

Module 1:

1. Demonstrate DDL commands-CREATE, ALTER, DROP
2. Apply integrity constraints – PRIMARY KEY, NOT NULL, DEFAULT, CHECK, UNIQUE, FOREIGN KEY
3. Experiment DML commands – INSERT, SELECT, UPDATE and DELETE to manipulate databases
4. Use WHERE, DISTINCT, BETWEEN, ORDER BY, IN, LIKE, set operations in SELECT statements for data retrieval from the databases

Module 2:

1. Implement aggregate functions -SUM, AVG, COUNT, MIN, MAX – GROUP BY and HAVING clause
2. Construct nested queries
3. Demonstrate SQL queries for inner and outer joins.
4. Illustrate various views of the table

Module 3:

1. Demonstrate the stored procedures for simple tasks
2. Apply stored functions for database manipulations
3. Illustrate SQL programs using triggers

Module 4:

1. Demonstrate the Installation and configuration of MongoDB
2. Experiment the functions of Mongoengine library – connect, Document, ListField, EmbeddedDocument
3. Illustrate the use of insert, save, print, update and delete functions in MongoDB

Text Books:

1. Elmasri, Navathe, Fundamentals of Database Systems, 7th Ed., Pearson

Reference Books:

1. Sliberschatz A., H. F. Korth and S. Sudarshan, Database System Concepts, 6th ed, McGraw Hill, 2011.
2. ITL Education Solutions ltd, Introduction to Database Systems, Pearson,2011

Online Resources

1. https://www.w3schools.com/sql
2. https://www.tutorialspoint.com/sql
3. https://www.j avatpoint. com/sql
4. https://www.guru99.com/sql
5. https://webcms3.cse.unsw.edu.au/COMP9321/18s1/resources/16130
6. https://docs.mongodb.com/manual/tutorial/getting-started/

For detailed syllabus of all other subjects of Cloud Computing & Big Data (CC), 2021 revision curriculum do visit Cloud Computing & Big Data 3rd Sem subject syllabuses for 2021 revision.

To see the syllabus of all other branches of diploma 2021 revision curriculum do visit SITTTR diploma all branches syllabus..

To see the results of Cloud Computing & Big Data (CC) of diploma 2021 revision curriculum do visit SITTTR diploma Cloud Computing & Big Data (CC) results..

For all Cloud Computing & Big Data academic calendars, visit Cloud Computing & Big Data all semesters academic calendar direct link.