Episode 3: Discover How To Select Data From Multiple Tables Part 1 скачать в хорошем качестве

Episode 3: Discover How To Select Data From Multiple Tables Part 1

📌 Discover How To Select Data From Multiple Tables | SQL Fundamentals | SQL Basic In this episode, we explore ways on how to retrieve data from multiple tables using SQL, one of the most fundamental skills for anyone working with data. 🔍 Topics Covered in This Episode: Cross Join / Cartesian Product Inner Join Tools Used: SQL Server Azure Data Studio Docker Table Creation for Practice: Director Table: CREATE TABLE director ( id integer, name varchar(100), birth_year integer ); INSERT INTO director (id, name, birth_year) VALUES (1, 'Alfred Hitchcock', 1899), (2, 'Steven Spielberg', 1946), (3, 'Woody Allen', 1935), (4, 'Quentin Tarantino', 1963), (5, 'Pedro Almodóvar', 1949); Movie Table: CREATE TABLE movie ( id integer, title varchar(100), production_year integer, director_id integer ); INSERT INTO movie (id, title, production_year, director_id) VALUES (1, 'Psycho', 1960, 1), (2, 'Saving Private Ryan', 1998, 2), (3, 'Schindler''s List', 1993, 2), (4, 'Midnight in Paris', 2011, 3), (5, 'Sweet and Lowdown', 1993, 3), (6, 'Pulp fiction', 1994, 4), (7, 'Talk to her', 2002, 5), (8, 'The skin I live in', 2011, 5); 👍 Like, share, and subscribe for more SQL and data tutorials.