diff options
Diffstat (limited to 'blog/dst/a/sql_video_notes.html')
| -rw-r--r-- | blog/dst/a/sql_video_notes.html | 18 |
1 files changed, 11 insertions, 7 deletions
diff --git a/blog/dst/a/sql_video_notes.html b/blog/dst/a/sql_video_notes.html index 14a0e56..867c265 100644 --- a/blog/dst/a/sql_video_notes.html +++ b/blog/dst/a/sql_video_notes.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="en" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> @@ -186,10 +190,10 @@ <li><code>RIGHT (OUTER) JOIN</code>: returns all records from the right table, and the matched records from the left table.</li> <li><code>FULL (OUTER) JOIN</code>: returns all records when there is a match in either left or right table.</li> </ul> -<p><img alt="INNER JOIN" src="https://static.luevano.xyz/images/b/notes/sql/img_innerjoin.gif"> -<img alt="LEFT JOIN" src="https://static.luevano.xyz/images/b/notes/sql/img_leftjoin.gif"> -<img alt="RIGHT JOIN" src="https://static.luevano.xyz/images/b/notes/sql/img_rightjoin.gif"> -<img alt="FULL OUTER JOIN" src="https://static.luevano.xyz/images/b/notes/sql/img_fulljoin.gif"></p> +<p><img alt="INNER JOIN" src="images/b/notes/sql/img_innerjoin.gif"> +<img alt="LEFT JOIN" src="images/b/notes/sql/img_leftjoin.gif"> +<img alt="RIGHT JOIN" src="images/b/notes/sql/img_rightjoin.gif"> +<img alt="FULL OUTER JOIN" src="images/b/notes/sql/img_fulljoin.gif"></p> <h4 id="nested-queries">Nested queries</h4> <p>A query composed of multiple select statements to get a specific piece of information. This is self explanatory, you do a <code>SELECT</code> query somewhere inside another one, for example <code>SELECT ... IN (SELECT ...)</code>, where the nesting is occurring inside the parenthesis after the <code>IN</code> statement.</p> <p>A nesting isn’t constrained to the <code>IN</code> statement, it can appear anywhere, for example in a <code>WHERE</code> statement: <code>SELECT ... WHERE something = (SELECT ...)</code>.</p> @@ -212,13 +216,13 @@ <li><strong>Weak entity’s primary key</strong>: oval with its text underlined, but the line is dotted.</li> <li><strong>Identifying relationship</strong>: a diamond inside a diamond with its name inside; a relationship that serves to uniquely identify the weak entity.</li> </ul> -<p><img alt="ERD example taken from wikipedia" src="https://static.luevano.xyz/images/b/notes/sql/erd_example.png"></p> +<p><img alt="ERD example taken from wikipedia" src="images/b/notes/sql/erd_example.png"></p> <hr> <div class="article-info"> <p>By David LuĂ©vano</p> <p>Created: Tue, Mar 02, 2021 @ 14:35 UTC</p> - <p>Modified: Fri, Jun 04, 2021 @ 08:00 UTC</p> + <p>Modified: Sun, Jun 06, 2021 @ 00:22 UTC</p> <div class="article-tags"> <p>Tags: <a href="https://blog.luevano.xyz/tag/@english.html">english</a>, <a href="https://blog.luevano.xyz/tag/@notes.html">notes</a> </p> |