-
Notifications
You must be signed in to change notification settings - Fork 1
/
mysql.html
executable file
·186 lines (185 loc) · 12 KB
/
mysql.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
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<link rel="preconnect" href="https://fonts.googleapis.com">
<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
<link href="https://fonts.googleapis.com/css2?family=Press+Start+2P&display=swap" rel="stylesheet">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet"
integrity="sha384-1BmE4kWBq78iYhFldvKuhfTAU6auU8tT94WrHftjDbrCEXSU1oBoqyl2QvZ6jIW3" crossorigin="anonymous">
<link rel="apple-touch-icon" sizes="180x180" href="/assets/apple-touch-icon.png">
<link rel="icon" type="image/png" sizes="32x32" href="/assets/favicon-32x32.png">
<link rel="icon" type="image/png" sizes="16x16" href="/assets/favicon-16x16.png">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="x-ua-compatible" content="ie=edge">
<link rel="manifest" href="/site.webmanifest">
<title>DevDum!</title>
<link rel="stylesheet" href="style.css">
<script src="script.js"></script>
</head>
<body>
<header>
<div id="header">
<svg version="1.1" id="Capa_1" xmlns="https://www.w3.org/2000/svg" xmlns:xlink="https://www.w3.org/1999/xlink" x="0px" y="0px"
viewBox="0 0 512 512" style="enable-background:new 0 0 512 512;" xml:space="preserve"></svg>
</div>
</div>
<div id="mobileMenuToggle" title="Menu">Menu</div>
<div id="headerLeft">
<a href="/"><img alt="Home" title="Home" id="menuToggle" src="DevDum copy (1).png" width="190px"/></a>
</div>
<div id="headerRight">
<nav>
<ul>
<li><a id="github" rel="nofollow" href="https://github.com/" target="_blank">GitHub</a></li>
<li><a id="dailydev" rel="nofollow" href="https://app.daily.dev/" target="_blank">DailyDev</a></li>
<li><a id="w3" rel="nofollow" href="https://www.w3schools.com/" target="_blank">W3Schools</a></li>
<li><a id="mdn" rel="nofollow" href="https://developer.mozilla.org/en-US/" target="_blank">MDN WebDocs</a></li>
<li><a id="stack" rel="nofollow" href="https://stackoverflow.com/" target="_blank">StackOverflow</a></li>
</ul>
</nav>
</div>
</div>
</header>
<div id="wrapall">
<div id="sidebar">
<div id="stickThis">
<div id="sidebarContent">
<!-- <div id="logo"><imd </h1>
<h4>Less Searching. More Learning.</h4> -->
<aside>
<div><a id="color1" href="html.html"><img alt="HTML" title="HTML" src="icons/output-onlineimagetools-html.png"/></a></div>
<div><a id="color2" href="style.html"><img alt="CSS" title="CSS" src="icons/output-onlineimagetools-css.png"/></a></div>
<div><a id="color3" href="javascript.html"><img alt="JavaScript" title="Javascript" src="icons/output-onlineimagetools-js.png" width="53px"/></a></div>
<div><a id="color4" href="bootstrap.html"><img alt="Bootstrap" title="Bootstrap" src="icons/output-onlineimagetools-bootstrap.png"/></a></div>
<div><a id="color5" href="react.html"><img alt="React" title="React" src="icons/output-onlineimagetools-react.png"/></a></div>
<div><a id="color6" href="nodejs.html"><img alt="Node" title="Node" src="icons/output-onlineimagetools-nodejs.png" width="50px"/></a></div>
<div><a id="color7" href="api.html"><img alt="API" title="API" src="icons/output-onlineimagetools-api.png"/></a></div>
<div><a id="color8" href="mysql.html"><img alt="SQL" title="SQL" src="icons/output-onlineimagetools-sql.png"/></a></div>
<div><a id="color9" href="github.html"><img alt="GitHub" title="GitHub" src="icons/output-onlineimagetools-github.png"/></a></div>
<div><a id="color10" href="youtube.html"><img alt="YouTube" title="YouTube" src="icons/output-onlineimagetools-youtube.png"/></a></div>
<div><a id="color11" href="more.html"><img alt="More" title="More" src="icons/output-onlineimagetools-more.png" width="48px"/></a></div>
<a class="back2Top" href="#"><code>⮝ Back to Top ⮝</code></a>
</aside>
</div>
</div>
<div id="stick-here"></div>
</div>
<div id="main">
<section id="page">
<main>
<article id="yellow">
<h1 class="display-2">SQL<span class="vim-caret"><img alt="mysql" title="mysql" src="icons/output-onlineimagetools-sql.png" width="68px"/></span></h1>
<h4><strong>SQL (Structured Query Language) is a descriptive computer language designed for updating, retrieving, and calculating data in table-based databases.</strong></h4>
<input type="text" id="myInput" onkeyup="myFunction()" placeholder="Search for resources..." title="Type in a name">
</article>
<ul id="myUL">
<article>
<h2><a href="https://www.w3schools.com/sql/" target="_blank">W3 Schools | SQL Tutorial</a></h2>
<p>Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.</p>
</article>
<article>
<h2><a href="https://sqlbolt.com/" target="_blank">SQLBOLT | Introduction to SQL</a></h2>
<p>Welcome to SQLBolt, a series of interactive lessons and exercises designed to help you quickly learn SQL right in your browser.</p>
</article>
<article>
<h2><a href="https://www.w3schools.com/sql/sql_quickref.asp" target="_blank">W3 Schools | SQL Quick ref</a></h2>
<p>A quick reference lists of standard SQL queries that can be used in most databases.</p>
</article>
<article>
<h2><a href="https://www.mysql.com/" target="_blank">MySQL Website</a></h2>
<p>MySQL is the world's most popular open source database.</p>
<p><a href="https://dev.mysql.com/downloads/workbench/" target="_blank">The MySQL Workbench</a> is available to download free for Microsoft Windows, MacOS, and Linux.</p>
</article>
<article>
<h2><a href="https://www.invicti.com/blog/web-security/sql-injection-cheat-sheet/" target="_blank">SQL Injection Cheat Sheet</a></h2>
<p>In this cheat sheet you can find detailed technical information about SQL Injection vulnerabilities against MySQL, Microsoft SQL Server, Oracle and PostgreSQL SQL servers.</p>
</article>
<article>
<h2><a href="https://poorsql.com/" target="_blank">POOR SQL | Open Source SQL Formatter</a></h2>
<p>Take pity on your SQL with instant, free and open-source, online or offline formatting using the Poor Man's T-SQL Formatter library.</p>
</article>
<article>
<h2><a href="https://www.simplilearn.com/tutorials/sql-tutorial/difference-between-sql-and-mysql#:~:text=SQL%20is%20a%20query%20programming,data%20in%20an%20organized%20way." target="_blank">The Difference Between SQL And MySQL</a></h2>
<p><a href="https://www.simplilearn.com/">Simplilearn</a>is the world's #1 online bootcamps with free online courses and learning resources</p>
</article>
<article>
<h2><a href=":https://sqlzoo.net/wiki/SQL_Tutorial" target="_blank">SQL Zoo |Learn SQL in Stages</a></h2>
<p>SQLZoo is a well-established online platform (since 1999) for writing and running SQL queries against a live database.</p>
</article>
<article>
<h2><a href="https://www.youtube.com/watch?v=7S_tz1z_5bA" target="_blank">MySQL Tutorial Video For Beginners</a></h2>
<p>MySQL tutorial for beginners - Learn MySQL, the world's most popular open source database.</p>
</article>
<article>
<h2><a href="https://www.mysqltutorial.org/" target="_blank">MySQL Cheat Sheet</a></h2>
<p>MySQL cheat sheet provides you with one-page that contains the most commonly used MySQL commands and statements that help you work with MySQL more effectively.</p>
</article>
<article>
<h2><a href="shorturl.at/noxDW" target="_blank">SQL vs NoSQL: Five Main Differences</a></h2>
<p>SQL is the programming language used to interface with relational databases.NoSQL is a class of DBMs that are non-relational and generally do not use SQL.</p>
</article>
<article>
<h2><a href="https://www.mongodb.com/" target="_blank">MongoDB | NoSQL Database</a></h2>
<p>An integrated suite of cloud database and data services to accelerate and simplify how you build with data.</p>
</article>
<article>
<h2><a href="https://mongoosejs.com/" target="_blank">MONGOOSEJS</a></h2>
<p>Mongoose provides a straight-forward, schema-based solution to model your application data. It includes built-in type casting, validation, query building, business logic hooks and more, out of the box.</p>
</article>
<article>
<h2><a href="https://www.softwaretestinghelp.com/mongodb/" target="_blank">Free MongoDB Course</a></h2>
<p>An Exclusive range of 20+ in-depth MongoDB Tutorial for beginners to learn MongoDB from scratch.</p>
</article>
<article>
<h2><a href="https://www.softwaretestinghelp.com/mongodb/robo-3t-robomongo-tutorial/" target="_blank">Software Testing Help | Robo3T Tutorial </a></h2>
<p>Robo 3T is a free and machine friendly software, that uses a small number of one’s resources available on a machine.It’s highly appreciated and recognized as
the world-famous project with highest success ratio in giving prime output.</p>
</article>
<article>
<h2><a href="https://blog.webdevsimplified.com/2022-02/mongo-db/"" target="_blank">MongoDB Ultimate Guide | Web.dev Simplified</a></h2>
<p>In this video we will dive into the MongoDB NoSQL database and look at the fundamentals </p>
</article>
<article>
<h2><a href="https://www.youtube.com/watch?v=pWbMrx5rVBE" target="_blank">Traversy Media | MongoDB in 30 Minutes </a></h2>
<p>In this video we will dive into the MongoDB NoSQL database and look at the fundamentals and the syntax to create, read, update and delete documents/data.</p>
</article>
<article>
<h2><a href="https://www.youtube.com/watch?v=1NrHkjlWVhM&t=4s" target="_blank">How To Build A MarkDown Blog Using Node.js and MongoDB</a></h2>
<p>In this video I cover absolutely everything you need to know about Node.js, MongoDB, and Express by building out a complete blog with markdown support.</p>
</article>
<article>
<h2><a href="https://www.youtube.com/watch?v=ZS_kXvOeQ5Y" target="_blank">SQL vs NoSQL or MySQL vs MongoDB</a></h2>
<p>SQL or NoSQL? MySQL vs MongoDB? Which database is better? Which one should you use? Read the blog on this video here for more helpful documentation.<a href="https://academind.com/tutorials/sql-vs-nosql">Academind.com</a></p>
</article>
</ul>
</main>
<footer>
<p>©DevDum! Less searching. More learning. <a rel="nofollow" href="https://github.com/rdevans87/DevDum" target="_blank" rel="nofollow">Hosted on GitHub!</a></p>
<a href="https://www.buymeacoffee.com/ryanevans" target="_blank"><img src="https://cdn.buymeacoffee.com/buttons/v2/default-yellow.png" alt="Buy Me A Coffee" style="height: 42px !important;width: 180px !important;"></a>
<a href="https://www.producthunt.com/posts/devdum-code-smarter-not-harder?utm_source=badge-featured&utm_medium=badge&utm_souce=badge-devdum-code-smarter-not-harder" target="_blank"><img src="https://api.producthunt.com/widgets/embed-image/v1/featured.svg?post_id=343032&theme=light"
alt="DevDum! Code Smarter. Not Harder. - 200+ Resources for web developers. It's a no brainer! | Product Hunt" style="width: 200px; height: 43px;" width="250" height="54" /></a>
</footer>
</section>
</div>
</div>
</body>
<script>
function myFunction() {
var input, filter, ul, li, a, i, txtValue;
input = document.getElementById("myInput");
filter = input.value.toUpperCase();
ul = document.getElementById("myUL");
article = ul.getElementsByTagName("article");
for (i = 0; i < article.length; i++) {
a = article[i].getElementsByTagName("a")[0];
txtValue = a.textContent || a.innerText;
if (txtValue.toUpperCase().indexOf(filter) > -1) {
article[i].style.display = "";
} else {
article[i].style.display = "none";
}
}
}
</script>
</html>