ऑनलाइन क्लासेस

फ्रैंचाइज़ी सर्टिफिकेट वेरिफाई करें संपर्क English लॉगिन

You can keep up to 10 CVs here -- delete one you don't need.

You can keep up to 10 CVs here -- delete one you don't need.

DBMS Lab (Diploma)

SQL queries, database design and practice on MySQL or Oracle.

6 महीनेअवधि 5Chapters19टॉपिक

अभी पूछताछ करें

सिलेबस · पाठ्यक्रम

01SQL Basics and DDL 3 टॉपिक

Installing MySQL and using the command line client
Data types
CREATE, ALTER, DROP, TRUNCATE and RENAME table

02DML and Constraints 3 टॉपिक

INSERT, UPDATE and DELETE
Primary key, foreign key, unique, not null, check and default constraints
COMMIT, ROLLBACK and SAVEPOINT

03Queries and Functions 5 टॉपिक

SELECT with WHERE, BETWEEN, IN, LIKE
ORDER BY
Aggregate functions - COUNT, SUM, AVG, MIN, MAX
GROUP BY and HAVING
String, numeric and date functions

04Joins, Subqueries and Views 4 टॉपिक

Inner join, left and right outer join, self join
Nested subqueries with IN and EXISTS
Creating and using views
Set operations - UNION

05Database Design Mini Exercise 4 टॉपिक

Drawing an ER diagram for a library or student database
Converting the ER diagram to tables
Normalisation up to 3NF
Users, GRANT and REVOKE

परिचय

आप यह कर पाएँगे

Create, alter and drop tables using SQL DDL commands with proper data types
Insert, update, delete and retrieve records using SQL DML commands
Apply primary key, foreign key, unique, not null and check constraints
Write queries using WHERE, ORDER BY, GROUP BY, HAVING and aggregate functions
Write join queries, subqueries and create views
Design a small database from an ER diagram and normalise its tables

यह किसके लिए है

Diploma Computer Science & Engineering students of Semester 3 (BTEUP)
Diploma IT students preparing for the DBMS practical exam

आपको क्या चाहिए

Basic computer operation and the theory of DBMS (taught in the same semester)
MySQL or Oracle installed on the lab computer

सवाल

Which syllabus is followed?

The BTEUP Diploma CSE Semester 3 DBMS Lab list. Where your college lab list differs, the centre follows your own syllabus.

MySQL or Oracle?

Practice is done on MySQL; the SQL is standard, and Oracle differences are pointed out where your college uses Oracle.

Is viva preparation included?

Yes. Viva questions on SQL commands, keys and normalisation are practised with every experiment.