In SQL, a VIEW is a virtual table. It lets you package a complex query into a single table. We will discuss several queries in increasing difficulty to show how VIEWs can greatly simplify your work. In our examples we will introduce CROSS JOINs, Unions, the CONCAT() function, and the COALESCE() function.
Our SQL playlist starts here:
↪
Be sure to SUBSCRIBE for more SQL!
↪
You may also enjoy our Python playlist:
↪
♦♦♦♦♦♦♦♦♦♦
Ways to support our channel:
► Join our Patreon :
► Make a one-time PayPal donation:
► We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9
Thank you!
♦♦♦♦♦♦♦♦♦♦
Connect with us!
Facebook:
Instagram:
Twitter:
♦♦♦♦♦♦♦♦♦♦
SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter)
Written & Produced by Kimberly Hatch Harrison (@khhsocratica) & Michael Harrison (@mlh496)
♦♦♦♦♦♦♦♦♦♦
Tag: view sql, Socratica, SocraticaCS, SQL, structured query language, sql tutorial, learn sql, database, databases, mysql, postgresql, mariadb, oracle, sql server, sqlite, view, views, cross join, union, concat, coalesce, create view, easy sql tutorial, how to use views in sql, views in sql, what are views in sql, sql for beginners, sql tutorial for beginners, sql views, learn views in sql, beginner sql, beginner sql tutorial, sql lessons, concat in sql, coalesce in sql, cross joins sql
Xem thêm: https://meocongnghe.org/category/pc
Nguồn: https://meocongnghe.org
![Hướng dẫn cách tải và slow trên VSCO Pro [không mất phí nha😻]](https://i.ytimg.com/vi/VQlZ7Kabu3s/maxresdefault.jpg)
It's official! The Socratica Python Kickstarter was a success! Thank you to all of our supporters. Because of you, many more Python videos coming soon!! 💜🦉
The man is impressed!
Just………Amazing…………..😍😍 don't have any word for the way you teach
Wahh! soo coool! I love it! thank you
you are the most amazing teacher ever. Absolutely amazing
Very good… the previous video on JOINS states there are 4 types (INNER/LEFT,RIGHT,FULL), this video adds a 5th (CROSS) , are there anymore that martians should know about?
I’ve been working on SQL for years now, but completed this video just because I thoroughly enjoyed it
super awesome……….
Great way to teach SQL! Definitely eye-catching and entertaining!
i love the way how you teach the sql <3
The combination of being funny, intelligent and being creepy at the same time.
I just love it. ❤️
Awesome explaination, thank you
You’ve just saved me more grey hair. Thank you for the edutainment. 😊
What a lovely way to teach!
I agree this lady makes the best SQL video!
I avoided databases for decades becoz it was boring & irrelevant at the time. Then THIS !! Made sense easily, FAST (!!!) & so much more fun. Can't Thank you enough @socratica
Excellent explanation! I'm glad I subscribed the channel. Thanks!
Your explanations are so on point. Thank you!
7:43 she’s got bars!!!!!!!😂😁
Amazing. 😁😁😁😁😁Learning while being entertained 👌
I love the way you are explaining stuff in this video. It is very funny. Thank you for the great content!
good damn she is nice!! Hilarious teaching humor!
I literally subscribed 30 seconds into the video
more women should teach computer science stuff. the way you presented your teaching was full of dedication, what i admire. you went the extra mile for using an entertaining and visual example. most computer scientists don't. they explain things very boring and incomprehensible (although on youtube there are really good ones).
Another awesome video!!! I might end up watching everything you two have posted.
See below the code to create and insert data into the 'martian_confidential' table for this video lesson, step by step (just select and uncomment the code to run it):
— CREATE TABLE public.martian_confidential
— (martian_id serial PRIMARY KEY,
— first_name varchar,
— last_name varchar,
— base_id integer,
— super_id integer,
— salary integer,
— dna_id varchar)
— INSERT INTO martian_confidential
— (first_name, last_name, base_id, super_id)
— SELECT first_name, last_name, base_id, super_id
— FROM martian;
— UPDATE martian_confidential
— SET salary = 155900, dna_id = 'gctaggaatgtagaatctcctgttg'
— WHERE martian_id = 1;
— UPDATE martian_confidential
— SET salary = 120100, dna_id = 'cagttaatggttgaagctgggatt'
— WHERE martian_id = 2;
— UPDATE martian_confidential
— SET salary = 110000, dna_id = 'cgaagcgctagatgctgtgttgtag'
— WHERE martian_id = 3;
— UPDATE martian_confidential
— SET salary = 10000, dna_id = 'gactaatgtcttcgtggattgcaga'
— WHERE martian_id = 4;
— UPDATE martian_confidential
— SET salary = 125000, dna_id ='gttacctttgcgaaagccgtggctac'
— WHERE martian_id = 5;
— UPDATE martian_confidential
— SET salary = 137000, dna_id = 'gcaggaatggaagcaactgccatat'
— WHERE martian_id = 6;
— UPDATE martian_confidential
— SET salary = 145250, dna_id = 'cttcgatcgtcaatggagtccggac'
— WHERE martian_id = 7;
— UPDATE martian_confidential
— SET salary = 121100, dna_id ='gacacgaggcgaactatgtcgcggc'
— WHERE martian_id = 8;
— UPDATE martian_confidential
— SET salary = 130000, dna_id = 'cttagactaggtgtgaaacccgtta'
— WHERE martian_id = 9;
— UPDATE martian_confidential
— SET salary = 125000, dna_id = 'ggggggttacgacgaggaatccat'
— WHERE martian_id = 10;
— UPDATE martian_confidential
— SET salary = 105000, dna_id = 'ggctccctgggcgggatattggatg'
— WHERE martian_id = 11;
— UPDATE martian_confidential
— SET salary = 155800, dna_id = 'atctgcttggatcaatagcgctgcg'
— WHERE martian_id = 12;
— UPDATE martian_confidential
— SET salary = 129500, dna_id = 'ccaatcgtgcgagtcgcgatagtct'
— WHERE martian_id = 13;
— SELECT *
— FROM martian_confidential
— ORDER BY martian_id;
awesome view explanation on view that i just view on YouTube view
I couldn't believe future can be this slow. It took 25ms to run a query. What a bad, old fashioned computer you have.
Superb!
Teaching the futuristic way. Kudos 🙂
Your such a fun to talk with
the background eerie music keeps me awake and in suspense .. what will happen next. Teaching method is awesome .. keep it up gal.
I like the view
You are my best view
Hewwwww
I finally understood that! Thank you for brilliant overVIEW 😀
Amazing vid! Love how you've explained it with the graphics and storytelling. Quality content!
How about indexing views
I really liked this tutorial! It made SQL VIEWS so much easier!!!
Your explanations are fantastic thank you
Superbly Explained!
this woman's expression reminds me of the overly attached girlfriend meme. Thaat being said, this is fun and very well explained. Great tut!
Thank you. The database for this tutorial is here: https://github.com/socratica/data/issues/2
I fixed what someone else had already provided and then made available my version. Cheers.
What a delight watching this video. Clear, concise and very helpful. Thank you very much!
Awesome
That data is now a rumour 😆.
You’re a fantastic teacher! Thank you!!
Can we find all the tables which used to create a view if we have a view name? If so can you please explain?