|
|
7c7d251ced
|
Added comment for input in p_roll
|
2024-11-11 23:52:41 +05:30 |
|
|
|
8ffbbcf06b
|
Minor change to P2, added input for book in quotes and fixed Status datatype.
|
2024-11-11 23:51:21 +05:30 |
|
|
|
aea7ec864a
|
Added queries for M6 (mongo).
|
2024-11-10 22:46:59 +05:30 |
|
|
|
c7a40d7ed0
|
Added P8 trigger (PLSQL)
|
2024-11-10 22:34:09 +05:30 |
|
|
|
778cf6f892
|
Added p.s. and changed function name to match p.s.
|
2024-11-10 22:10:04 +05:30 |
|
|
|
b5cd49389b
|
Added queries for P6 as per p.s., no roll in Stud_Marks table but in Result makes it quite dumb.
|
2024-11-10 21:52:07 +05:30 |
|
|
|
3309645905
|
Removed .obisidian folder from SQL, might be accidentally pushed by Afan. Shoulda taught him .gitignore 🙄
|
2024-11-10 21:51:32 +05:30 |
|
|
|
59d480fceb
|
Fixed problem statement line break.
|
2024-11-10 21:50:20 +05:30 |
|
|
|
9318f3069b
|
Appended block in filename for P1 so it doesn't feel lonely.
|
2024-11-10 21:50:20 +05:30 |
|
|
|
ad930d8a5a
|
updated readme.md
|
2024-11-10 21:31:52 +05:30 |
|
Afan Shaikh
|
a299cbc9b3
|
Fixed Deletion of records in SQL S3.4
|
2024-11-10 21:25:06 +05:30 |
|
|
|
42363aa8eb
|
Fixed others exception
|
2024-11-10 19:33:00 +05:30 |
|
|
|
4d878d51ca
|
Made changed to data inserted in table. Added another exception and changed outputs to be more polite.
|
2024-11-10 19:31:16 +05:30 |
|
|
|
ceabc021bd
|
Added plsql code blocks for P1, P2, P3 (sqlplus).
|
2024-11-10 19:07:37 +05:30 |
|
|
|
110255f6d1
|
Added C1 mongo connectivity.
|
2024-11-10 16:02:27 +05:30 |
|
|
|
2d3a9ff598
|
added comments for update and delete opn and added new line char in python3 execution command to automatically execute on copying. lastly changed pip to python3-pip
|
2024-11-10 16:00:22 +05:30 |
|
|
|
3692f8819d
|
Changed C1 to C2 since it's C2
|
2024-11-10 15:44:59 +05:30 |
|
|
|
bc04babb8d
|
Added mysql connectivity.
|
2024-11-10 15:44:08 +05:30 |
|
|
|
51a7f8cb49
|
Added queries for M5 (MongoDB).
|
2024-11-10 12:51:21 +05:30 |
|
|
|
7261620545
|
Added indexing in filename and title in file since it also contains indexing!
|
2024-11-10 12:50:32 +05:30 |
|
|
|
a716d17799
|
updated macho's phone number
|
2024-11-10 12:19:21 +05:30 |
|
|
|
61af64c72e
|
Simplified query 6.
|
2024-11-10 12:16:58 +05:30 |
|
|
|
0e41344f45
|
Updated output for query 6 after running on new machine.
|
2024-11-10 12:12:19 +05:30 |
|
|
|
5476813944
|
Appended 2 to database name to avoid conflit with crud operations.
|
2024-11-10 12:10:20 +05:30 |
|
|
|
964f534b16
|
Added queries for M4 (MongoDB).
|
2024-11-10 12:08:48 +05:30 |
|
|
|
151fab47d8
|
Appended 1 to database name to avoid conflict with aggregation p.s.
|
2024-11-10 11:29:54 +05:30 |
|
|
|
3175ea83b5
|
Fixed query 7, didn't realize count was already there, wayyyyyyyyyy too sleeeppyyyyyy to see that 😫
|
2024-11-10 00:56:55 +05:30 |
|
|
|
02e284ad48
|
Moved s9 to SQL folder, forgot about that, i'm sleepppppyyyyyyyyyyy
|
2024-11-09 23:59:11 +05:30 |
|
|
|
2327418cdf
|
Added queries for S9 (MySQL).
|
2024-11-09 23:58:23 +05:30 |
|
|
|
883422bf08
|
Added link for problem statements in readme.
|
2024-11-09 23:27:27 +05:30 |
|
|
|
d7a0bb4823
|
Added pdf for all problem statements (november 2024) for practical exam.
|
2024-11-09 23:24:27 +05:30 |
|
|
|
dcadee52ce
|
Fixed union query since union combines results from two queries, but the number of columns and their data types must match.
|
2024-11-09 23:10:17 +05:30 |
|
|
|
3dc24979ba
|
Added queries for S8 (MySQL).
|
2024-11-09 23:04:43 +05:30 |
|
|
|
0babf2b3ee
|
Appended 1 to database name to avoid conflits with other store databases.
|
2024-11-09 22:29:36 +05:30 |
|
|
|
4a934c1bbd
|
updated query 3 of s5 since we're supposed to update city column of employee table and not company
|
2024-11-09 20:38:30 +05:30 |
|
|
|
371bf261b9
|
fixed s7 problem statement
|
2024-11-09 16:41:54 +05:30 |
|
|
|
ddb2505d9f
|
Fixed unique index query (query 5).
|
2024-11-09 16:13:12 +05:30 |
|
|
|
1ca836f6a1
|
Added queries for S7 (MySQL).
|
2024-11-09 16:09:38 +05:30 |
|
|
|
3dc3d1e78c
|
Added select statement to view changes after firing query 1.
|
2024-11-09 15:26:58 +05:30 |
|
|
|
0178c80bf5
|
Added queries for S6 (MySQL).
|
2024-11-09 15:24:21 +05:30 |
|
|
|
8936f48ab7
|
Appended 1 in database name to avoid conflict with S6.
|
2024-11-09 15:07:32 +05:30 |
|
|
|
005b7e3a40
|
Added describe table line in 5th query to view changes.
|
2024-11-09 13:13:24 +05:30 |
|
|
|
c672bfb5f9
|
Added select line in 3rd query to view changes.
|
2024-11-09 13:11:34 +05:30 |
|
|
|
802e2107cd
|
Added queries for S5 (MySQL).
|
2024-11-09 13:09:12 +05:30 |
|
|
|
3a80156268
|
Added P10 trigger (plsql). Engineered by Macho.
|
2024-11-09 12:14:26 +05:30 |
|
|
|
997137287e
|
Added out params for function as per req. p.s. Thanks to Macho for providing the patch.
|
2024-11-09 12:05:14 +05:30 |
|
|
|
06c90bf376
|
Deleting one instead of many in 5th query.
|
2024-11-09 11:51:58 +05:30 |
|
|
|
ff283c93df
|
Fixed 3rd query, added or thingy.
|
2024-11-09 11:50:08 +05:30 |
|
|
|
86ba61f9c3
|
Added queries for P5. Thanks to Macho, again.
|
2024-11-09 02:11:29 +05:30 |
|
|
|
9a7400d5d8
|
Moved p.s. up to p.s. heading. Also, thanks to Macho for these queries!
|
2024-11-09 02:05:09 +05:30 |
|
