-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.html
166 lines (155 loc) · 6.17 KB
/
index.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<script src="https://cdn.tailwindcss.com"></script>
<link rel="stylesheet" href="css/homepage.css">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/font/bootstrap-icons.min.css">
<link rel="stylesheet" href="css/default.css">
<title>Learn SQL</title>
</head>
<body>
<div class="sidenav">
<div class="logo">
<a href="index.html" class="header">Learn SQL</a>
<p>With <a href="#">Me😊</a></p>
</div>
<div class="topics">
<a href="topics/database.html" class="topic">Database</a>
<a href="topics/basic_sql_queries.html" class="topic">Basic SQL Queries</a>
<a href="topics/filtering_data.html" class="topic">Filtering Data</a>
<a href="topics/working_with_functions.html" class="topic">Working with Functions</a>
<a href="topics/joining_tables.html" class="topic">Joining Tables</a>
<a href="topics/sub_queries.html" class="topic">Subqueries</a>
<a href="topics/modifying_data.html" class="topic">Modifying Data</a>
<a href="topics/advanced_queries.html" class="topic">Advanced Queries</a>
<a href="topics/transactions_and_locking.html" class="topic">Transactions and Locking</a>
<a href="topics/indexing_and_optimization.html" class="topic">Indexing and Optimization</a>
<a href="topics/sql_best_practices.html" class="topic">SQL Best Practices</a>
</div>
<div class="social-icons">
<!-- linkedin -->
<a href="https://www.linkedin.com/in/prayushadhikari/" class="social-link">
<i class="bi bi-linkedin"></i>
</a>
<!-- github -->
<a href="https://www.github.com/adhikareeprayush" class="social-link">
<i class="bi bi-github"></i>
</a>
<!-- twitter -->
<a href="https://www.twitter.com/prayushadhikari" class="social-link">
<i class="bi bi-twitter"></i>
</a>
<!-- instagram -->
<a href="https://www.instagram.com/prayushadhikari" class="social-link">
<i class="bi bi-instagram"></i>
</a>
</div>
</div>
<div class="content">
<div class="greeting flex flex-col items-center justify-center">
<h1>Hello, Everyone!</h1>
<p>I am <span class="name">Prayush Adhikari</span> </p>
</div>
<h4 class="w-full">Here is what we will learn in this entire journey!</h4>
<div class="syllabus w-full">
<div class="topic card">
<h2>Database</h2>
<ul>
<li>Introduction to Database</li>
<li>Types of Database</li>
<li>Database Management System</li>
<li>SQL vs NoSQL</li>
</ul>
</div>
<div class="topic card">
<h2>Basic SQL Queries</h2>
<ul>
<li>SELECT Statement</li>
<li>WHERE Clause</li>
<li>ORDER BY Clause</li>
<li>LIMIT and OFFSET Clauses</li>
</ul>
</div>
<div class="topic card">
<h2>Filtering Data</h2>
<ul>
<li>Using Comparison Operators</li>
<li>Using Logical Operators (AND,OR,NOT)</li>
<li>BETWEEN and IN Operators</li>
</ul>
</div>
<div class="topic card">
<h2>Working with Functions</h2>
<ul>
<li>Aggregate functions (SUM, AVG, COUNT, etc.)
</li>
<li>Scalar functions (UPPER, LOWER, CONCAT, etc.)
</li>
<li>Date and time functions</li>
</ul>
</div>
<div class="topic card">
<h2>Joining Tables</h2>
<ul>
<li>INNER JOIN</li>
<li>LEFT JOIN</li>
<li>RIGHT JOIN</li>
<li>FULL JOIN</li>
</ul>
</div>
<div class="topic card">
<h2>Subqueries</h2>
<ul>
<li>Single Row Subquery</li>
<li>Multiple Row Subquery</li>
<li>Correlated Subquery</li>
</ul>
</div>
<div class="topic card">
<h2>Modifying Data</h2>
<ul>
<li>INSERT Statement</li>
<li>UPDATE Statement</li>
<li>DELETE Statement</li>
</ul>
</div>
<div class="topic card">
<h2>Advanced Queries</h2>
<ul>
<li>CASE Statement</li>
<li>NULL values handling</li>
<li>GROUP BY Clause</li>
</ul>
</div>
<div class="topic card">
<h2>Transactions and Locking</h2>
<ul>
<li>Introduction to transactions
</li>
<li>ACID properties</li>
<li>Lock types (shared, exclusive, etc.)</li>
</ul>
</div>
<div class="topic card">
<h2>Indexing and Optimization</h2>
<ul>
<li>Indexes in SQL</li>
<li>Query Optimization Techniques</li>
<li>Normalization and Denormalization</li>
</ul>
</div>
<div class="topic card">
<h2>SQL Best Practices</h2>
<ul>
<li>Qriting efficient queries</li>
<li>Avoiding SQL Injections</li>
<li>Database Security Practices</li>
</ul>
</div>
</div>
</div>
<script src="js/script.js"></script>
</body>
</html>