From b171347f739b2ada7960ad50bcba47e898d890d2 Mon Sep 17 00:00:00 2001 From: David Luevano Alvarado Date: Fri, 4 Jun 2021 23:50:58 -0600 Subject: reflect changes on updated pyssg using jinja templates --- blog/dst/a/sql_video_notes.html | 35 +++++++++++++++++++---------------- 1 file changed, 19 insertions(+), 16 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 1ef739c..ae5c5c3 100644 --- a/blog/dst/a/sql_video_notes.html +++ b/blog/dst/a/sql_video_notes.html @@ -1,10 +1,10 @@ - + - SQL tutorial video notes -- Luévano's Blog + SQL tutorial video notes -- Luévano's Blog @@ -64,8 +64,9 @@
-

SQL tutorial video notes

-

I was requested to make summaries of videos about SQL, these are the notes (mostly this is a transcription of what I found useful). The videos in question are: SQL Tutorial - Full Database Course for Beginners, MySQL Tutorial for Beginners [Full Course] and Advanced SQL course | SQL tutorial advanced. Also, some notes were taken from w3schools.com’s SQL Tutorial and MySQL 8.0 Reference Manual.

+

SQL tutorial video notes

+ +

I was requested to make summaries of videos about SQL, these are the notes (mostly this is a transcription of what I found useful). The videos in question are: SQL Tutorial - Full Database Course for Beginners, MySQL Tutorial for Beginners [Full Course] and Advanced SQL course | SQL tutorial advanced. Also, some notes were taken from w3schools.com’s SQL Tutorial and MySQL 8.0 Reference Manual.

What is a database (DB)?

Any collection of related information, such as a phone book, a shopping list, Facebook’s user base, etc.. It can be stored in different ways: on paper, on a computer, in your mind, etc..

Database Management Systems (DBMS)

@@ -201,17 +202,19 @@
  • 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

    -
    -
    -

    By: David Luévano

    -

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

    -

    Edited: Mon, May 17, 2021 @ 20:59 UTC

    -
    -

    Tags: -english, notes, sql

    -
    - -
    + +
    +
    +

    By David Luévano

    +

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

    +

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

    +
    +

    Tags: + english, + notes +

    +
    +
    - + \ No newline at end of file -- cgit v1.2.3-70-g09d2