65,542 views
In this video, we learned how to create basic SQL queries using the following commands: SELECT, FROM, WHERE, DISTINCT, AND, OR, LIMIT. This is the second video of the Open SQL Course for Data Analysis here on the channel. Also watch the first video of the course and learn how to use the course's data environment: • What you need to know to get started... Our starting point was to review important concepts already covered in other videos and to understand more about the learning environment that we will use in the classes. 🎲 Link to the data: https://basedosdados.org/dataset/br-p... This course is intended for those who want to learn how to extract information from databases using SQL. We will use Big Query as the learning environment and some of the numerous databases made available, processed, and maintained by the Base dos Dados project as data sources. By the way, here is a recommendation for those who don't know this project whose mission is to universalize access to quality data in Brazil so that the distance between you and your analysis is just a good question :) Access it here: https://basedosdados.org/ #sql #dados #dadosabertos Get ready for the next classes, learning how to use BigQuery 👇🏾 Google BigQuery (SQL) 101 - / bigquery-101 Workshop: SQL + BigQuery - @Base dos Dados - • Workshop: SQL + BigQuery You might also like: WHAT IS A DATABASE? [ • WHAT IS A DATABASE? Computing... ]( • WHAT IS A DATABASE? Computing... ) Is SQL important for Data Scientists? Why learn SQL? [ • SQL is important for Data Scientists... ]( • SQL is important for Data Scientists... ) Computing for the Curious: • WHAT IS a Programming LANGUAGE?... What is SQL? SQL (Structured Query Language) is used to execute commands in relational databases, that is, based on tables. Although it is not the only means used for this purpose, it is certainly the most popular. Databases are organized collections of data that are related in a way that creates some sense and provides greater efficiency during a research or scientific study. Therefore, it presupposes logic, they are not files stored randomly. But organizing the data is not enough; we need a way to manage it. Create, remove, update, delete. The famous CRUD. For this, there are software that assist in this data management, database management systems, DBMSs. And how does this work in practice? These are software applications that run on a computer with processing capacity to manage and store data in files organized in a database. References: Elmasri, Ramez. Database systems. 6th ed. São Paulo: Pearson Addinson Wesley, 2011. Course SQL for Data Analysis. Udacity. 📚 Book to study Databases - https://amzn.to/3Hjjusc 📚 Recommended Data Science books: https://amzn.to/2XZyxUr 📚 Algorithms and Data Structures books: https://amzn.to/3d5wK4m SetUp - Equipment: https://amzn.to/37Cg3N2 Dynamic Programming Cuts: / @alforriah 🟣 Twitch channel for lives: / pgdinamica 🟦 Telegram channel to receive all videos: https://t.me/pgdinamica 🥰 If you like our work and find our performance on Youtube relevant, consider supporting us by becoming a member of the channel: https://www.youtube.com/programacaodi... ✉️ E-mails: – Commercial proposals: [email protected] – Other subjects: [email protected] 👩🏾💻👨🏾💻 Check out more content on our blog: /programacaodinamica 🔥 Join the free Programação Mais Dinâmica community: https://bit.ly/pgsparkle (download the app and join the community) TikTok: @pgdinamica 📸 Follow us on Instagram: /pgdinamica 📸 @kizzy_terra @hallpaz 🐦 Follow us on Twitter: /pgdinamica 🐦 @kizzy_terra @hallpaz Like Programação Dinâmica on Facebook: fb.com/pgdinamica Our repository on Github: github.com/programacaodinamica Check out the articles on Python Café: pythoncafe.com.br