![We Learn SQL](/img/default-banner.jpg)
- Видео 65
- Просмотров 270 816
We Learn SQL
Добавлен 14 ноя 2019
54 Years of SQL Promo - SQL Courses
Thanks to SQL's father, Edgar Codd, who invented relational databases 54 years ago, get 75% off our All Forever Course Package!
Full experience SQL platform: SQL assessment, practical courses, certification, cookbooks.
Full experience SQL platform: SQL assessment, practical courses, certification, cookbooks.
Просмотров: 63
Видео
54 Years of SQL - Anniversary Promo
Просмотров 5421 день назад
Thanks to the father of SQL - Edgar Frank Codd - you can get our All Forever Package with 75% off! That means you will save $450! The promo lasts until July 8.
Was ist SQL?
Просмотров 79Месяц назад
Erfahren Sie mehr auf learnsql.de/ In diesem Video erklären wir, was SQL ist und warum es eine gefragte Fähigkeit auf dem Arbeitsmarkt ist. Entdecken Sie, wie SQL in verschiedenen Branchen genutzt wird, um Daten effizient zu verwalten und zu analysieren. SQL wird in vielen Bereichen eingesetzt, darunter Finanzen, Marketing und Gesundheitswesen. Mit SQL-Kenntnissen können Sie komplexe Datenabfra...
Star Wars Day 2024 at LearnSQL.com!
Просмотров 3,5 тыс.2 месяца назад
Catch the main sale of the spring and May the 4th be with you! 75% off the All forever SQL Package!
LearnSQL.com turn 4! SQL Courses Anniversary Sale
Просмотров 1805 месяцев назад
Let’s celebrate the anniversary together! We turn 4 today! Your success is our greatest inspiration, that’s why you truly deserve gifts: over 70 SQL courses inside All Forever SQL Package, which is now available for an anniversary price - just $149. Birthday deal guarantees lifetime access to all SQL courses with a 75% discount! All Forever SQL Package winter offer: - SQL certification at the...
LearnSQL.com - comprehensive SQL courses with certification.
Просмотров 1,2 тыс.5 месяцев назад
LearnSQL.com: - 6900 hands-on exercises - 70@mrwaleedwaleyspecial courses - cheat sheets ( for mobile) - cookbooks - free accounts
Learn SQL in 2024 - New Year Sale 2024
Просмотров 1016 месяцев назад
Use the New Year discount! Learn everything you need to know about SQL and its dialects.
New Year Sale at LearnSQL.com!
Просмотров 2656 месяцев назад
SQL Holiday Sale. Full experience SQL platform: SQL assessment, courses, certification
Winter Holiday SQL Courses Sale at LearnSQL.com!
Просмотров 1,5 тыс.7 месяцев назад
Christmas sale of SQL courses. Don't miss the blowout
Christmas Sale 2023 at LearnSQL.com!
Просмотров 9697 месяцев назад
Last deal of 2023: 70 SQL courses in one package. Christmas at LearnSQL.com!
All Forever Package Black Week 2022 Promo 2
Просмотров 198Год назад
All Forever Package Black Week 2022 Promo 2
All Forever Package Black Week 2022 Promo
Просмотров 98Год назад
All Forever Package Black Week 2022 Promo
Learn and Practice SQL | Learning SQL has never been easier!
Просмотров 22 тыс.2 года назад
Learn and Practice SQL | Learning SQL has never been easier!
Practice SQL in Your Browser - LearnSQL.com - 2
Просмотров 6392 года назад
Practice SQL in Your Browser - LearnSQL.com - 2
Practice SQL in Your Browser - LearnSQL.com - 1
Просмотров 9592 года назад
Practice SQL in Your Browser - LearnSQL.com - 1
We Learn SQL #17 | What is Data Engineering?
Просмотров 2,7 тыс.3 года назад
We Learn SQL #17 | What is Data Engineering?
We Learn SQL #16 | Common SQL Mistakes
Просмотров 5 тыс.3 года назад
We Learn SQL #16 | Common SQL Mistakes
We Learn SQL #15 | SQL Subqueries in SELECT
Просмотров 11 тыс.3 года назад
We Learn SQL #15 | SQL Subqueries in SELECT
We Learn SQL #14 | Correlated subqueries with EXISTS in SQL
Просмотров 13 тыс.3 года назад
We Learn SQL #14 | Correlated subqueries with EXISTS in SQL
We Learn SQL #13 | Intro to correlated subqueries in SQL
Просмотров 18 тыс.4 года назад
We Learn SQL #13 | Intro to correlated subqueries in SQL
We Learn SQL #12 | SQL Subqueries in FROM
Просмотров 10 тыс.4 года назад
We Learn SQL #12 | SQL Subqueries in FROM
We Learn SQL #11 | Subqueries in SQL with operators ANY and ALL
Просмотров 29 тыс.4 года назад
We Learn SQL #11 | Subqueries in SQL with operators ANY and ALL
We Learn SQL #10 | Subqueries with the IN operator in SQL
Просмотров 16 тыс.4 года назад
We Learn SQL #10 | Subqueries with the IN operator in SQL
Think the output shown in video for "WHERE NOT EXISTS" is incorrect. It should fetch 2 values instead of 1. It should be "Magical Products" and "Amazing Stuff" as both of them have items less than 1 $
How to apply
Go to LearnSQL.com, sign up for free, and check how it works. If you will find it worth it, by All Forever Package, which is a pack of all our available SQL courses.
What if we need column name , instead of aggregates ?
Kindly help me understand what data types did you use
video is good but background music is so annoying.
That was quite helpful, thank you so much, but would you mind turn off the background music, it's distracting, I can barely hear your voice.
Please remove background music, hard to focus on what you're saying. Otherwise, great video!
Hello, I recently purchased the $90 lifetime access course package. I lost my login credentials and have been locked out of my account. A password reset is not working. Can someone please help me get access to my account. Thanks.
thank u
Hi, where could i find the solution for the common error you described at 3:35 (=Common mistake #2) ?
Your videos are really very helpful to me to learn SQL with great explanation, thank you a lot.
The result in 2:12 only should have one column "ID". Learn yourself sql before teaching.
This book could help ... Data Science and Engineering - A learning path - Volume 4 Relational and non-relational databases and SQL: with applications in MySQL, SQLite and Orange Data Mining
This book could help ... Data Science and Engineering - A learning path - Volume 4 Relational and non-relational databases and SQL: with applications in MySQL, SQLite and Orange Data Mining
ر
that was good
Absolute brilliant example and explanation. Thank you!!!
Good overview. Thanks. I'd like to add one thing to keep in mind. It seems easy to consider this and use is null instead. However the pitfall is, when you compare against a column value (e.g. in a join), where null values exist. Or when you use optional user inputs and try something like this: tbl.col = NVL({input}, tbl.col) When this columns contains nulls then this becomes tbl.col = null what fails. (Here the solution could be tbl.col = {input} or {input} is null) The danger is, when you get a good looking resultset and don't recognize, that you compare against null!
Your videos are great. Not sure why included this background music. You just ruined your efforts.
Thank you, Adrian! Your videos are short and sweet. Worth them to watch. Really loved them. Thanks!
do we get a solution and explanation for practice problems?
I'm really trying to listen to you but the music is so annoying...
Excellent explanations, now I'm your subscriber.😊
Please : get RID OF THE MUSIC..can hardly hear you
AARGH.......whats with the super intrusive music? overshadows what you're saying. NOt watching anymore.
Good video - but please ditch the annoying background music
Yes, on my way!!
Raise the music so we can’t hear you ❤
What will happen if we put reverse in subquery City. Countryid = bigCity.CountryID? Is this same?
Hi How to join this course?
Teşekkürler dostum
Quick and to the point !
Good video. But you may consider to reduce the background sound or drop it altogether. Thanks. Good job tho. Peace
is't better use distinct in subquery? `SELECT * FROM city WHERE id IN (SELECT DISTINCT city_id FROM university WHERE rank <= 100);`
You should try and find people to interview who have learned SQL and how it has helped their career!
Hi, are you one of those people?
@@welearnsql I'm working on it! I will be in the near future!
Just wanted to get a brush up on some SQL topics, and your video was really helpful. But please, please do not put music on such a lecture video. It is really disturbing the purpose of the instructor, most of the words were not audible.
Thank you so much. I finally understood how they work 🥺
What an amazing explanation! Congrats from Brazil.
Thank you for the explanation but please can you reduce the background sound in subsequent videos, it was overshadowing your voice and was quite distracting. Thanks again
Thank you, I was confused about this for a bit. You video really cleared this up!
Brilliant thank you
Really clear videos, great stuff
(This course is very technical to listen in english (because i'm french) it looks very interesting but really the music in the background is really disturbing .. i can't listen)
Thanks
I couldn't still get it. So , what is the real function of this exists though? If we, let's say remove it from your query sample, what will be fundamentally changed in the result set?
Great video! I just want to add that subqueries in the select statement are also referred to as 'subselects' and that a subselect query can reference columns in the select query. However, subqueries used in join cannot. Queries used in joins can also have multiple columns and are similar to a common table expressions (CTE). In SQL the only parts you need single-row unique columns are in: subselects and in where clause subqueries.
thank you for this amazing explanation but the first one we can do like this select * from students where age > (select min (age ) from lecturer);
Music is bothering...
Q1: Is there any student older than all lecturers in the university? Q2: Is there any lecturer who is younger than all students?
ARE U HEISENBERG?