Should you learn SQL?
HTML-код
- Опубликовано: 10 окт 2024
- SQL is used in many high paying tech industries. Despite this, its been on a downward popularity trajectory since the early 2000s. So, is it still worth it to learn SQL in 2020? Find out in this video!
Looking to get hands on experience building on AWS with a REAL project? Check out my course - The AWS Learning Accelerator! courses.beabet...
00:07 What is SQL?
01:01 Who uses SQL?
03:20 Limitations of SQL - Scaling
03:35 What is NoSQL?
🎉SUPPORT BE A BETTER DEV🎉
Become a Patron: / beabetterdev
📚 MY RECOMMENDED READING LIST FOR SOFTWARE DEVELOPERS📚
Clean Code - amzn.to/37T7xdP
Clean Architecture - amzn.to/3sCEGCe
Head First Design Patterns - amzn.to/37WXAMy
Domain Driver Design - amzn.to/3aWSW2W
Code Complete - amzn.to/3ksQDrB
The Pragmatic Programmer - amzn.to/3uH4kaQ
Algorithms - amzn.to/3syvyP5
Working Effectively with Legacy Code - amzn.to/3kvMza7
Refactoring - amzn.to/3r6FQ8U
🎙 MY RECORDING EQUIPMENT 🎙
Shure SM58 Microphone - amzn.to/3r5Hrf9
Behringer UM2 Audio Interface - amzn.to/2MuEllM
XLR Cable - amzn.to/3uGyZFx
Acoustic Sound Absorbing Foam Panels - amzn.to/3ktIrY6
Desk Microphone Mount - amzn.to/3qXMVIO
Logitech C920s Webcam - amzn.to/303zGu9
Fujilm XS10 Camera - amzn.to/3uGa30E
Fujifilm XF 35mm F2 Lens - amzn.to/3rentPe
Neewer 2 Piece Studio Lights - amzn.to/3uyoa8p
💻 MY DESKTOP EQUIPMENT 💻
Dell 34 inch Ultrawide Monitor - amzn.to/2NJwph6
Autonomous ErgoChair 2 - bit.ly/2YzomEm
Autonomous SmartDesk 2 Standing Desk - bit.ly/2YzomEm
MX Master 3 Productivity Mouse - amzn.to/3aYwKVZ
Das Keyboard Prime 13 MX Brown Mechanical- amzn.to/3uH6VBF
Veikk A15 Drawing Tablet - amzn.to/3uBRWsN
Horizontal vs Vertical Scaling video - • System Design: What is...
SQL vs NoSQL video - • SQL vs NoSQL Explained
🌎 Find me here:
Twitter - / beabetterdevv
Instagram - / beabetterdevv
Patreon - Donations help fund additional content - / beabetterdev
#Databases
#SQL
#NoSQL
Thank you!
I realized I need to scroll youtube faster :)
Well, what is actually happening is that nosql database adds a SQL layer on top of there products so that more people will be able to query the data since SQL is so ubiquitous. So yes - learn SQL it's here to stay and has a far better chance to survive after many other querying languages will be forgotten :)
I couldn't agree more Dudi!
that said, Yes learn SQL!
This was an excellent video, accept the part where it asks: Is SQL still relevant? I don't think the answer is "it's complicated". Because, later in the video you said that SQL is not going anywhere. So, the answer to: Is SQL still relevant is: YESSS!!!! lol
Other than that, I enjoyed the video!
I came here because I have an upcoming Structured Database class and we'll be using SQL. Wanted to know if I will be wasting my time. Guess not, I'll start preparing for it now. Thanks for the video!
Always a good choice and you're welcome Victor! Good luck with your class!
Daniel
I learnt so much in just 7 mins, information well compiled and explained thanks a lot
You're very welcome, Temitope!
So within a month u will be a full stack developer. Congratulations 🎊
@@amwalonline 😂😂, I’m sure it doesn't work like that
Thanks for the free and useful Tutorial!
You are welcome!
Remember that any software or almost any company right now has data... And they need to store that somewhere.
SQL isn't going anywhere any time soon. At least I don't think.
Also, at 4:13.. I now understand where Calculus swoops in. Lol
Great point Kit! SQL is here to stay atleast for the forseeable future. Cheers.
Sql is gonna stay for 30 more years ahead of python
There are multiple RDBMS(SQL) that use a "scale out approach" like NoSQL.
Great content.
SQL developers or as a skill is highly in demand and will always be. As long as data is considered SQL is what needs to be in the resume. With high capabilities of modern database tech SQL is becoming powerful and more easy to interact between the products. So no doubt why SQL shines in data science/analysis interviews and in many more job roles.
Sql is pretty hard, for example, can you write a query to delete all duplicate rows from a table?
Either that, or I'm stupid.
@@amitv9128 I'm pretty new at SQL but what if you use the PRIMARY KEY constraint on one of your columns?
@@amitv9128 haha, that’s basic stuff. Very easy
In short learn sql, It's not hard and you won;t regret it
Couldn't agree more!
Thank you
By the way, could you explain when ORM worth to use and when raw SQL queries can't be replaced with it?
Sir i want to enter into data analysist role .. As an entry level so far i have learned postgre sql n python .. I didnt learn python lib only python programming ..is it sufficient to get a job for an entry level..?
Hi Aruneem,
This is a tough question to answer. I would think though that having SQL and python knowledge and basic knowledge of IT should be a good starting point for your first job. I wish you the best of luck!
Daniel
SQL makes you lazy. You just put together your tables and your done. No need to think about acces patterns...unless you want to scale. Then you switch to a NoSQL solution.
Well thats why SQL is more prevalent for some. Its flexibility allows you to easily modify/migrate and restructure your datasets. When working with clients that have no idea what data access patterns will be required to suit their rapidly developing business requirements, SQL is great to start off with in order to flesh it out. Once you start identifying portions of "feature complete" sections, you can then look to start migrating into a NoSQL solution.
@@connergoldberg Yes, that's exactly my point. SQL is great for development and early stage production, but once you start to hit great numbers of request, then using a NoSQL database becomes a cheaper/scalable option.
Great comment Zoltan. I tend to agree. I think it makes sense to start out a project with SQL because its a two way door; you can always change later to NoSQL. This isn't always the case if you start with NoSQL solutions.
Want lazy? Seen a few rdbms tables in my time with raw json and xml before.. or comma delimited text with ids... i mean.. what even...
@@connergoldberg I use Citus Data(Hyperscale) on AWS which is based on PostgreSQL RDBMS. Citus Data is a clustered RDBMS with capabilities to scale out/horizontal and scale up/vertical with hundreds worker nodes per DB formation/instance. IMHO nowadays RDBMS(SQL) which can scale out is going towards NoSQL DB's features in part of horizontal scalability and data representation and vice versa NoSQL DBs add a query language capabilities similar to classic SQL, of course the horizontal scaling/scale out has a lot of concerns in part of query execution either it is RDBMS or NoSQL, moreover both RDBMS and NoSQL shall prefer to use "materialized path"/preprocessed data to avoid join like operations and cross-joins between DB cluster workers/nodes, take into account potential inefficient distributed query planing/execution, data collocation specific, the query push down logic, distributed indexes implementation specific and etc., but this is common problem for any distributed DBs.
💛
😃
I think the title of this video doesn’t match the content.