SQL Constraints and Relating Data Using PRIMARY and FOREIGN KEYs (SQLite Tutorial Video 6)

Veröffentlicht am: 01 Januar 1970
auf dem Kanal: Studious Tok

This video teaches you the main 6 constraints in SQL (NOT NULL, DEFAULT, UNIQUE, CHECK, PRIMARY KEY, and FOREIGN KEY). We also finally take a deep dive into how PRIMARY and FOREIGN KEY act as both constraints and a way to relate rows across different tables. If you're still confused about PRIMARY and FOREIGN KEYs, don't worry! The next video will discuss them in more detail and how the ways in which they are used allow us to create different types of relationships between data.

The playlist for this series can be found at: • Using SQL with SQLite3 via the Command Lin...

Video 1: What is SQLite, getting started, creating tables, adding data, and basic SELECT queries.

Video 2: Loading/importing external, non-SQL, databases, filtering with WHERE, and conditional logic.

Video 3: Column aliases, aggregate functions (COUNT/SUM/AVG/MIN/MAX), GROUP BY and HAVING, LIMIT, DISTINCT, creating backups, working with .sql files, and creating views.

Video 4: Handling NULL data

Video 5: Table Schema, JOIN, UNION, and Duplicate Data

Auf dieser Seite können Sie das Online-Video SQL Constraints and Relating Data Using PRIMARY and FOREIGN KEYs (SQLite Tutorial Video 6) mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Studious Tok 01 Januar 1970 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 20 Mal angesehen und es wurde von 2 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

5,170