Practical SQL Course for Beginners - #4 Subqueries in SQL
This course on YouTube is a very shortened (demo) version of the full course, which you can purchase on stepik (with a card from the Russian Federation) or Udemy (with a card from outside the Russian Federation)
Buy the full course on stepik:
https://www.engineerspock.com/buy-pos... - get a 30% discount
Buy the full course on udemy:
https://www.engineerspock.com/buy-pos...
All courses from EngineerSpock: https://www.engineerspock.com/offer-s...
Subscribe to the channel in Telegram: https://t.me/engineerspock_it
Subscribe to Boosty: https://boosty.to/engineerspock
Donations for development: https://pay.cloudtips.ru/p/1f080f72
Chat in Telegram: https://t.me/python_devs
Link to the repository in GitHub: https://github.com/EngineerSpock/post...
-------------------------------------------------------------------------------------------
Databases (DB) in general and relational databases in particular are very broad topics. This series of SQL lessons is devoted specifically to the development of relational databases running PostgreSQL (PostgreSQL is a DBMS, i.e. a database management system).
In this SQL course, you will master the basics of SQL: you will learn what SQL is, learn how to write SQL queries of varying complexity. All the knowledge that you will receive on the course is easily applicable to other DBMS, such as MySQL, Microsoft SQL Server, Oracle.
Learning SQL is one of the fastest ways to climb the career ladder and start earning even more. On the course, you will study and receive assignments for your own verification and improvement of your understanding of the material.
In this video lesson on SQL we analyze:
00:00 Introduction to SQL subqueries
14:05 WHERE EXISTS
22:26 Subqueries with quantifiers ANY, ALL
34:40 Homework "SQL subqueries"
34:50 Homework "SQL subqueries" - Solution
You will find all the scripts and homework for this lesson in the folder at the link: https://bit.ly/3p1maTz
#sql #postgresql #engineerspock
Subscribe to the channel https://bit.ly/2QBesmw
In questa pagina del sito puoi guardare il video online Practical SQL Course for Beginners - #4 Subqueries in SQL della durata di ore minuti seconda in buona qualità , che l'utente ha caricato EngineerSpock - IT & программирование 31 maggio 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 83,809 volte e gli è piaciuto 1.2 mille spettatori. Buona visione!
