Learn SQL the right way - session 3 | Primary Key vs Unique Key | Trendytech

preview_player
ะŸะพะบะฐะทะฐั‚ัŒ ะพะฟะธัะฐะฝะธะต
๐–๐š๐ง๐ญ ๐ญ๐จ ๐Œ๐š๐ฌ๐ญ๐ž๐ซ ๐’๐๐‹? ๐‹๐ž๐š๐ซ๐ง ๐’๐๐‹ ๐ญ๐ก๐ž ๐ซ๐ข๐ ๐ก๐ญ ๐ฐ๐š๐ฒ ๐ญ๐ก๐ซ๐จ๐ฎ๐ ๐ก ๐ญ๐ก๐ž ๐ฆ๐จ๐ฌ๐ญ ๐ฌ๐จ๐ฎ๐ ๐ก๐ญ ๐š๐Ÿ๐ญ๐ž๐ซ ๐œ๐จ๐ฎ๐ซ๐ฌ๐ž - ๐’๐๐‹ ๐‚๐ก๐š๐ฆ๐ฉ๐ข๐จ๐ง๐ฌ ๐๐ซ๐จ๐ ๐ซ๐š๐ฆ ๐›๐ฒ ๐’๐ฎ๐ฆ๐ข๐ญ ๐’๐ข๐ซ!

"๐€ 8 ๐ฐ๐ž๐ž๐ค ๐๐ซ๐จ๐ ๐ซ๐š๐ฆ ๐๐ž๐ฌ๐ข๐ ๐ง๐ž๐ ๐ญ๐จ ๐ก๐ž๐ฅ๐ฉ ๐ฒ๐จ๐ฎ ๐œ๐ซ๐š๐œ๐ค ๐ญ๐ก๐ž ๐ข๐ง๐ญ๐ž๐ซ๐ฏ๐ข๐ž๐ฐ๐ฌ ๐จ๐Ÿ ๐ญ๐จ๐ฉ ๐ฉ๐ซ๐จ๐๐ฎ๐œ๐ญ ๐›๐š๐ฌ๐ž๐ ๐œ๐จ๐ฆ๐ฉ๐š๐ง๐ข๐ž๐ฌ ๐›๐ฒ ๐๐ž๐ฏ๐ž๐ฅ๐จ๐ฉ๐ข๐ง๐  ๐š ๐ญ๐ก๐จ๐ฎ๐ ๐ก๐ญ ๐ฉ๐ซ๐จ๐œ๐ž๐ฌ๐ฌ ๐š๐ง๐ ๐š๐ง ๐š๐ฉ๐ฉ๐ซ๐จ๐š๐œ๐ก ๐ญ๐จ ๐ฌ๐จ๐ฅ๐ฏ๐ž ๐š๐ง ๐ฎ๐ง๐ฌ๐ž๐ž๐ง ๐๐ซ๐จ๐›๐ฅ๐ž๐ฆ."

๐‡๐ž๐ซ๐ž ๐ข๐ฌ ๐ก๐จ๐ฐ ๐ฒ๐จ๐ฎ ๐œ๐š๐ง ๐ซ๐ž๐ ๐ข๐ฌ๐ญ๐ž๐ซ ๐Ÿ๐จ๐ซ ๐ญ๐ก๐ž ๐๐ซ๐จ๐ ๐ซ๐š๐ฆ -

๐–๐š๐ง๐ญ ๐ญ๐จ ๐ฅ๐ž๐š๐ซ๐ง ๐๐ข๐  ๐ƒ๐š๐ญ๐š ๐›๐ฒ ๐’๐ฎ๐ฆ๐ข๐ญ ๐’๐ข๐ซ?
๐œ๐ก๐ž๐œ๐ค๐จ๐ฎ๐ญ ๐ญ๐ก๐ž ๐›๐ข๐  ๐๐š๐ญ๐š ๐œ๐จ๐ฎ๐ซ๐ฌ๐ž ๐๐ž๐ญ๐š๐ข๐ฅ๐ฌ

I have trained over 20,000+ professionals in the field of Data Engineering in the last 5 years.

Primary Key
Unique Key
Auto Increment Values
Primary vs Unique Key

TABLE OF CONTENT
2:25 Primary key
11:00 Auto increment key
14:00 Unique key
15:30 Primary key vs Unique key

๐—๐—ผ๐—ถ๐—ป ๐—บ๐—ฒ ๐—ผ๐—ป ๐—ฆ๐—ผ๐—ฐ๐—ถ๐—ฎ๐—น ๐— ๐—ฒ๐—ฑ๐—ถ๐—ฎ:๐Ÿ”ฅ

If you're looking to master SQL with real time usecases & looking to crack top product based companies, this tutorial is for you. Just follow through and you'll be able to write SQL queries in no time.

SQL, short for Structured Query Language, is a language used by software developers, data engineers, data scientists and anyone who works with data. With SQL, you can store data in relational databases and write queries to extract valuable information.

Even if you are someone who is working on SQL Server, Oracle DB, PostgreSQL or any other relational DB. Then you should be able to use your learning with hardly 5% syntax change.

#SQL #RDBMS #database #bigdata #dataengineering
  1. Sumit Mittal
  2. sql
  3. sql tutorial
  4. sql course
  5. sql for beginners
  6. Structured Query Language
ะ ะตะบะพะผะตะฝะดะฐั†ะธะธ ะฟะพ ั‚ะตะผะต
you need to 0:24:25

you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)

Complete Roadmap To 0:05:46

Complete Roadmap To Learn SQL Properly

Learn Basic SQL 0:17:40

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

BEST Websites to 0:00:43

BEST Websites to Learn SQL FAST ๐Ÿƒ๐Ÿฝโ€โ™‚๏ธ๐Ÿ’จ

I learned SQL 0:04:10

I learned SQL for data analytics in 15 days | From Scratch

How to learn 0:27:20

How to learn SQL for free | Roadmap to learning SQL

Getting started with 0:34:55

Getting started with SQL - Session 1 | Learn SQL the right way | Trendytech

SQL Course for 3:10:19

SQL Course for Beginners [Full Course]

Batch 57 MS 2:06:19

Batch 57 MS Sql DBA Class 6 Full Discussion Sql Server 2019 Installation || Contact +91 9902590140

SQL Tutorial for 0:44:57

SQL Tutorial for Beginners

My one tip 0:06:05

My one tip to learn SQL faster for a data analyst career

Start Learning SQL 0:00:22

Start Learning SQL in 3 Easy Steps

Learn SQL the 0:16:06

Learn SQL the right way | SQL Live Training | Learn SQL from me

Learn SQL Basics 0:16:57

Learn SQL Basics in Just 15 Minutes!

Study Plan To 0:00:59

Study Plan To Master SQL๐Ÿ”ฅโœ…๏ธ๐ŸŽฏ #sql #mysql

Learn SQL the 0:37:23

Learn SQL the right way - Session 2 | Trendytech

MySQL - The 0:17:17

MySQL - The Basics // Learn SQL in 23 Easy Steps

Complete SQL Course 0:09:15

Complete SQL Course by Sumit Sir | Learn SQL the right way | Trendytech

The most effective 0:08:00

The most effective way to learn SQL

How long does 0:09:57

How long does it take to MASTER SQL?

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

The best way 0:08:17

The best way to learn SQL when it seems hard

Learn SQL In 0:56:24

Learn SQL In 60 Minutes

How to learn 0:00:18

How to learn SQL? Check out this fun resource!

ะšะพะผะผะตะฝั‚ะฐั€ะธะธ
ะะฒั‚ะพั€

I have watched a lot off tutorial on udemy and youtube no one teach like you sir. Your teaching is simple and understandable thanx a lot sir โคโค

Soham_III
ะะฒั‚ะพั€

waiting for the completion of basics and upcoming advanced concepts of sql sumit sir....excellent work n gift for working professionals.

nikhilgupta
ะะฒั‚ะพั€

Beyond the ordinary..No words to describe your teaching..it is flawless..

dineshchavan
ะะฒั‚ะพั€

Hello Sumit. Thank you for providing valuable course in tough times. I've followed few channels for SQL and it's always confusing because lot of other flavours of SQL are mixed with it. Hopefully I'll find out complete SQL course and be able to write easy to intermediate queries required for Data Analyst. Thank you again and very good luck to all the viewer's and subscribers of this course ๐Ÿ‘๐Ÿ™๐Ÿ™‚

narenderreddynarender
ะะฒั‚ะพั€

It is rare to find such easy and descriptive session .My suggestion is to go through complete playlist practice along side . It will take some time but trust it will worth it.
I am one of student of Sumit sir's big data program. The way he explain the concept is just phenomenal.
Thanks Sumit sir :)

pankajmaheshwari
ะะฒั‚ะพั€

Well described, My 2nd Day of this learning session.

rokibchi
ะะฒั‚ะพั€

Sumit Sir makes everything simple, he is a true magician.
Thank you so much Sir for the SQL couse, I am loving it! โค๏ธ

dlakhaiyar
ะะฒั‚ะพั€

Amazing SQL videos.. finally i have found good channel for SQL

yogeshkumarkumawat
ะะฒั‚ะพั€

It is really a very good course. I am learning SQL from your videos and I am loving it. Thank you.

PriyankaBhatt-mo
ะะฒั‚ะพั€

Wonderful lession sir ...looking forward to go deeper into SQL๐Ÿ™‚

saurabhtekale
ะะฒั‚ะพั€

Really appreciate your way of teaching sir . Clarity is on next level . Many thanks for your complete SQL play list .

atigyamishra
ะะฒั‚ะพั€

so far the session are upto point, very easy to understand - good work sumit sir ๐Ÿ‘

charansai
ะะฒั‚ะพั€

Hi Sir, an amazing journey, I am starting it to sharpen my skills in SQL, without you it wouldn't have possible. Hats of for you Sir.

ksktest
ะะฒั‚ะพั€

Sir, your way of teaching is amazing.

kvmadhu
ะะฒั‚ะพั€

thank you for the quality course SUMIT SIR

abhishekkumar-sjjj
ะะฒั‚ะพั€

sir when primary key is set auto-increment for id and we have a unique key for name ..why for each wrong value for unique key ..the primary key auto increment it self? like my id=1 if i give unique key two times wrong .then 3rd time i gave correct value as per unique key..now my id=4..why not id=2 or 3 because value was not inserted in db and they were wrong as per unique key.

akp-
ะะฒั‚ะพั€

You are doing an excellent work sir. Keep it up.

jyothia
ะะฒั‚ะพั€

Hi Sumit sir, can you please help with the names of other DB's where multiple null values are not allowed for Unique Key constraint?

abhijeetsondkar
ะะฒั‚ะพั€

13:45 autoincrement is irrespective of primary key right ? good candidate i didnt get
๐Ÿค”

akshay
ะะฒั‚ะพั€

@Sumit Sir: If you can share the commands & class notes in the description section that would be really great.

SoumyaChatterjee-ot