Day 7 we are creating a table about Disney Pixar Films and using SQL to query it. Learn how to create a table in sql, insert data, and query the table to return the data, get unique values, and rename columns. Also understand data types and constraints when creating tables for SQL databases.
Project Steps:
STEP 1: Create a table called pixar_films
with these columns: film_id (Num & PK-AI),
film_title (TEXT-no nulls), release_year (Num-No Nulls, greater than 1995),
director (TEXT), tomatoes_score (Num-bw 0-100)
Step 2: Insert data
Toy Story, 1995, John Lasseter, 100
Finding Nemo, 2003, Andrew Stanton, 99
Inside Out, 2015, Pete Docter, 98
Ratatouille, 2007, Brad Bird, 96
Coco, 2017, Lee Unkrich, 97
Step 3: Select everything
Step 4: Select unique release_years
Step 5: Rename film_title to Title
and release_year to Year
-----------------------------------------------------------------
Download SQLite Studio Here: sqlitestudio.pl/
Download the Chinook Database: www.sqlitetuto...
Link to Topic List: docs.google.co...
Link to Facebook Support Group: / 767988395118964
Link to my Data Etsy Shop (support me to keep making content): jellysgeekygoo...
Buy me a coffee to show support: buymeacoffee.c...
#sql #sqltutorial #sqlforbeginners
29 сен 2024
