Summary
Keywords
Full Transcript
SQL Full Course Playlist π https://www.youtube.com/playlist?list=PLdOKnrf8EcP17p05q13WXbHO5Z_JfXNpw Like, Share & Subscribe Now :) β Subscribe for more SQL tutorials like this: https://bit.ly/3Fc7Gc6 βββββββββββββ Timestamps: 00:00 Intro 00:06 SELECT Statement in SQL 02:16 Where Clause in SQL 03:15 Operators in SQL 05:45 LIMIT Clause & ORDER BY Clause in SQL βββββββββββββ Queries used: π Customer Table CREATE TABLE customer ( CustID int8 PRIMARY KEY, CustName varchar(50) NOT NULL, Age int NOT NULL, City char(50), Salary numeric ); INSERT INTO customer (CustID, Custhame, Age, City, Salary) VALUES (1, βsamβ, 26, βDelhiβ, 9008), (2, βRamβ, 19, βBangaloreβ, 11000), (3, βPamβ, 31, βMumbaiβ, 6060), (4, β3amβ, 42, βPuneβ, 10000); π Classroom Table CREATE TABLE classroom ( rollno int8 PRIMARY KEY, name varchar(50) NOT NULL, house char(12) NOT NULL, grade char(1) ); INSERT INTO classroom (rollno, name, house, grade) VALUES (1, βSamβ, βAkashβ, βBβ), (2, βRamβ, βAgniβ, βAβ), (3, βShyamβ, βJalβ, βBβ), (4, βSundarβ, βAgniβ, βAβ), (5, βRamβ, βYayuβ, βBβ); βββββββββββββ Related Videos Introduction to SQL - What Is SQL + Database | SQL Tutorial In Hindi 1 https://www.youtube.com/watch?v=yH1zCq-iaeU Data Types, Primary-Foreign Keys & Constraints in SQL | SQL Tutorial In Hindi 2 https://www.youtube.com/watch?v=HmH-76_2Ak8 Create Table In SQL & Create Database | SQL Tutorial In Hindi 3 https://www.youtube.com/watch?v=v-2cIUgx_jw INSERT UPDATE, DELETE & ALTER Table in SQL With Example | SQL Tutorial in Hindi 4 https://www.youtube.com/watch?v=4YAAgrm8_ZI βββββββββββββ Connect on other Social Media handles: Instagram: https://www.instagram.com/rishabhnmishra/ LinkedIn: https://www.linkedin.com/in/rishabhnmishra/ Twitter: https://twitter.com/rishabhnmishra βββββββββββββ If this is the first ever video you're watching allow me to introduce myself, Hey I'm Rishabh Mishra and currently working as Senior Data Analyst at Bangalore. On this channel I like to guide and help my juniors and data science aspirants regarding Data Science jobs and useful tips for college students. Have a great day buddy!
