From f2b417553920d1d4b195e5a9d78e3fe019b2c163 Mon Sep 17 00:00:00 2001 From: David Luevano Alvarado Date: Sat, 5 Jun 2021 19:19:19 -0600 Subject: modify relative links, add base for art page --- blog/dst/a/sql_video_notes.html | 18 +++++++++++------- 1 file changed, 11 insertions(+), 7 deletions(-) (limited to 'blog/dst/a/sql_video_notes.html') 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 @@ + prefix="og: https://ogp.me/ns#"> @@ -46,6 +46,10 @@ Blog +
  • + Art +
    • +
  • Git -

    INNER JOIN -LEFT JOIN -RIGHT JOIN -FULL OUTER JOIN

    +

    INNER JOIN +LEFT JOIN +RIGHT JOIN +FULL OUTER JOIN

    Nested queries

    A query composed of multiple select statements to get a specific piece of information. This is self explanatory, you do a SELECT query somewhere inside another one, for example SELECT ... IN (SELECT ...), where the nesting is occurring inside the parenthesis after the IN statement.

    A nesting isn’t constrained to the IN statement, it can appear anywhere, for example in a WHERE statement: SELECT ... WHERE something = (SELECT ...).

    @@ -212,13 +216,13 @@
  • Weak entity’s primary key: oval with its text underlined, but the line is dotted.
  • Identifying relationship: a diamond inside a diamond with its name inside; a relationship that serves to uniquely identify the weak entity.
    • -

    ERD example taken from wikipedia

    +

    ERD example taken from wikipedia

    By David Luévano

    Created: Tue, Mar 02, 2021 @ 14:35 UTC

    -

    Modified: Fri, Jun 04, 2021 @ 08:00 UTC

    +

    Modified: Sun, Jun 06, 2021 @ 00:22 UTC

    Tags: english, notes

    -- cgit v1.2.3-54-g00ecf