51 Commits

Author SHA1 Message Date
Prakash Gatiyala
647afb6d17
Update 01-database-fundamentals.md (#16)
Fixes typo in 01-database-fundamentals.md.
2023-03-25 14:56:32 +00:00
Shreyas Das
178dd374c0
Update 06-sql-joins-aggregation.md (#15) 2023-01-08 16:01:42 +00:00
Tanmay
9235cca546 Adds notes. 2022-10-11 15:29:12 +01:00
Tanmay
e371662e0d Adds notes. 2022-10-08 16:21:02 +01:00
Tanmay
7b32d3b6cb Adds questions. 2022-10-06 14:59:19 +01:00
Tanmay
a408ec280a Adds notes. 2022-10-06 14:56:52 +01:00
Tanmay
f0bbd9a03f Adds notes. 2022-09-27 15:27:53 +01:00
Tanmay
4e7f75642e Fixes order. 2022-09-27 15:27:09 +01:00
Tanmay
9f7ae4d01f Adds practice problems for sql primer. 2022-09-17 15:50:17 +01:00
Tanmay
da45d3e04c Adds notes for data normalisation. 2022-09-15 15:46:38 +01:00
Tanmay
f114791398 Adds notes for schema design. 2022-09-13 14:27:20 +01:00
Tanmay
3ef8e9b5b5 Updates dbms notes. 2022-09-10 15:55:44 +01:00
Tanmay
be41100eca Adds notes 2022-08-29 19:47:27 +01:00
Tanmay
b37ffe48f8 Adds section on query execution. 2022-08-29 16:18:51 +01:00
Tanmay
86e3b5352e Adds notes and code for index and window functions. 2022-08-29 14:56:56 +01:00
Kachwal Uttam Sharma
b99e7fd973
Update 06-sql-joins-aggregation.md (#3) 2022-08-11 00:11:53 +05:30
Kachwal Uttam Sharma
f41736d40e
Update 05-sql-primer.md (#2) 2022-08-11 00:11:41 +05:30
Tanmay Kacker
f96818ed63
Merge pull request #1 from jyoti-jindal/patch-1 2022-08-10 16:39:40 +01:00
Tanmay
e33a6eca70 Adds lecture notes for remedial session. 2022-08-10 13:58:28 +01:00
Tanmay
da49cc63b6 Adds hw notes. 2022-07-22 19:52:41 +01:00
Tanmay
ac98acdc41 Adds sub-queries and functions. 2022-07-22 14:34:01 +01:00
Jyoti
59eddd123d
Fixing typos 2022-07-21 00:20:43 +05:30
Tanmay
d8962162a1 Adds pdf. 2022-07-20 19:42:32 +01:00
Tanmay
bd15293a27 Finishes aggregate questions. 2022-07-20 14:47:29 +01:00
Tanmay
c607e8c386 Adds joins lecture notes. 2022-07-20 12:50:39 +01:00
Tanmay
e37556f5c5 Adds pdf notes. 2022-07-20 11:40:28 +01:00
Jyoti
e4182307e1
Update 05-sql-primer-worksheet.md 2022-07-18 21:56:40 +05:30
Tanmay
2220088fce Adds SQL commands section. 2022-07-18 16:25:17 +01:00
Tanmay
fe37f5c3d2 Adds note for SQL primer. 2022-07-18 13:21:32 +01:00
Tanmay
9683da16d0 Fixes id. 2022-07-18 00:29:29 +01:00
Tanmay
555a5629f4 Adds SQL primer. 2022-07-18 00:24:02 +01:00
Tanmay
b7d9c8cb7a Adds pdf notes. 2022-07-13 19:42:16 +01:00
Tanmay
ac25972437 Adds handwritten notes. 2022-07-13 16:27:51 +01:00
Tanmay
54fedd92cf Finishes dbms 4. 2022-07-13 16:27:27 +01:00
Tanmay
923b9eb665 Finishes indexes section. 2022-07-13 14:42:08 +01:00
Tanmay
b95bc171f0 Adds notes for transactions. 2022-07-13 13:02:30 +01:00
Tanmay
2b4f720b89 Adds PDF for normalisation. 2022-07-13 13:02:15 +01:00
Tanmay
ee55b7be20 Adds Transactions and ACID. 2022-07-11 12:13:14 +01:00
Tanmay
96cd5e7d72 Adds normalisation notes. 2022-07-11 11:04:28 +01:00
Tanmay
518f1a8dc8 Adds pdf version of DBMS 2. 2022-07-08 19:27:07 +01:00
Tanmay
cefa4e4bc0 Updates links. 2022-07-08 16:01:23 +01:00
Tanmay
e19ac05fa7 Formatting fixes. 2022-07-08 15:33:33 +01:00
Tanmay
ca07cf781a Formatting fixes. 2022-07-08 15:32:47 +01:00
Tanmay
7e3f1df597 Formatting fixes. 2022-07-08 15:31:35 +01:00
Tanmay
e0aa69b3b9 Updates one-to-many 2022-07-08 15:06:09 +01:00
Tanmay
b6fd488ada Adds ER Diagram section. 2022-07-08 14:59:24 +01:00
Tanmay
bdcb950fbf Finishes integrity section. 2022-07-08 13:20:24 +01:00
Tanmay
bed40913c2 Adds data integrity section. 2022-07-08 12:33:15 +01:00
Tanmay
8ef2c29211 Fixes callout. 2022-07-08 12:03:50 +01:00
Tanmay
adf45c80da Draft commit - Integrity & ER. 2022-07-08 11:53:42 +01:00