ABCDFGHIJKLMNOPQRSTUVWXYZ
1
MAHAVIR POLYTECHNIC, NASHIK
2
DEPARTMENT OF ARTIFICAL INTELLIGENCE AND MACHINE LEARNING
3
4
Semester : 3rd
Name of Faculty :Ms. Krutika D. Suryawanshi
5
Course name: Database Management system
Course code :AN3K
6
Virtual Lab Experiment
7
8
Sr. NoName Of Experiment Link
9
1 Install the provided database softwarehttps://youtu.be/fqqGYVCI7mM?si=HZkf8HUkPHgZTvj8
10
2Note :- Ensure to Carry out following
activities before creating database:
- Draw ER diagram for given problem
- Normalize the relation up to 3NF
1) Create Database for given application
2) Create tables for the given application
3)Assign Primary key for created table
4) Modify the table as per the application
needs		https://youtu.be/Y6q-bC_QJEE?si=ZPXg7CR7_bgTv2PK
11
3Write queries using DDL Statements for
following operations –
1 )Create, alter, truncate, drop ,rename
table
2) Apply Key Constraints for suitable
relation.
https://youtu.be/pW6KWvtDmEE?si=-WEqz9K_zzTPdii5
12
4Write queries using DML Statements for
following operations –
1) Select, Insert, delete, update, table
2) Apply Key Constraints for suitable
relation.
https://youtu.be/GMJrilN1200?si=nd33ehRegYesL7Vr
13
5Write queries using DCL Statements for
following operations – 1)Grant, Revoke		https://youtu.be/44213LyfBVs?si=0h_E7_23hHL6DefT
14
6Write queries using TCL Statements for
following operations –
1) Commit, Rollback, Savepoint
https://youtu.be/pw8GKP3ItoQ
15
7Write Queries using built-in Arithmetic
operators.		https://youtu.be/bN_H2aSRD6E?si=4v8W2k8f6P1l8CQQ
16
8Apply built-in Logical operators on given
data		https://youtu.be/bN_H2aSRD6E?si=4v8W2k8f6P1l8CQQ
17
9Apply built-in relational operators on given
data		https://youtu.be/bN_H2aSRD6E?si=4v8W2k8f6P1l8CQQ
18
10Use following Set operators to
perform different operations. 		https://youtu.be/bN_H2aSRD6E?si=4v8W2k8f6P1l8CQQ
19
11Write SQL Queries using built-in String
functions		https://youtu.be/Zv9BWgIWfjU?si=De_jqPxv7Qz-4SvG
20
12Write SQL Queries using built-in
Arithmetic functions		https://youtu.be/Zv9BWgIWfjU?si=De_jqPxv7Qz-4SvG
21
13Write Queries using built-in Date and Time functionshttps://youtu.be/Zv9BWgIWfjU?si=De_jqPxv7Qz-4SvG
22
14Write Queries using SQL built-in Aggregate
functions		https://youtu.be/Zv9BWgIWfjU?si=De_jqPxv7Qz-4SvG
23
15Implement Queries Using different Where, Having, Group by, & Order by clauses .https://youtu.be/5LpGq-8hRJo?si=6G_sd0Fw2urk3Rbe
24
16Implement SQL queries for Inner and Outer Joinhttps://youtu.be/0faboc8aDXc?si=zflfr4-DWDSJ--qo
25
17Create and Execute Views ,Seqeuence and Index in SQL.https://youtu.be/0BWfyhTUqHQ?si=wKm8_yXZ_30Zby_T https://youtu.be/zR40SrrRjPM?si=5-zljCq2UR_0hOWQ
26
18Write a PL/SQL program using Conditional Statements- if, if then else ,nested if, if elseif elsehttps://youtu.be/-zAoUlkXvWc?si=uAaPlbSsu93iYcUu
27
19Write a PL/SQL program using Iterative Statements- loop,for, do-while, whilehttps://youtu.be/-zAoUlkXvWc?si=uAaPlbSsu93iYcUu
28
20Write a PL/SQL program using Sequential Control-switch, continue,gotohttps://youtu.be/-zAoUlkXvWc?si=uAaPlbSsu93iYcUu
29
21Write a PL/SQL code to implement implicit & explicit cursorshttps://youtu.be/iJn1_PZq80M?si=TS9klg9IwdNiufuL
30
22Write a PL/SQL program based on Exception Handling (Pre-defined exceptions)https://youtu.be/JDp4LhGfeps?si=H1OzU2hRFl3XYLBA
31
23Write a PL/SQL program based on Exception Handling (user defined exceptions)https://youtu.be/JDp4LhGfeps?si=H1OzU2hRFl3XYLBA
32
24Write a PL/SQL code to create Procedures and stored procedureshttps://youtu.be/pJRkvKDR7ms?si=nkDexSQcLit2B1qs
33
25Write a PL/SQL code to create functionshttps://youtu.be/pJRkvKDR7ms?si=nkDexSQcLit2B1qs
34
26Write a PL/SQL code to create triggers for given database.https://youtu.be/PQnrq5EMYmM?si=8JK28Ro2BWK2xi4T
35
36
37
38
39
Sign of staff
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100