A short introduction to SQL

We currently live in a world that revolves around data, which is why we have seen new areas of employment such as DataStack (Data Science, Data Engineering or Data Analyst) and most importantly, these areas use a language that has come Using since the …


This content originally appeared on DEV Community 👩‍💻👨‍💻 and was authored by mrGoonies

We currently live in a world that revolves around data, which is why we have seen new areas of employment such as DataStack (Data Science, Data Engineering or Data Analyst) and most importantly, these areas use a language that has come Using since the 70's.

SQL

It is a programming language created to interact with database management systems, as well as manipulate data and manage these systems. It is worth mentioning that each database manager implements it differently from other managers but they use certain things in common since it is stipulated in ANSI (it is an implementation standard for the SQL language). SQL is among the most used programming languages around the world.

Why use SQL?

  1. It is used in different areas of engineering such as web or data development.

  2. It is within the Data Science Stack together with Python and R.

  3. If we compare SQL with Excel and Access (tools that allow working with data) SQL has the advantage that it has no limits when working and storing data, this is because Excel has a limit of rows and Access the limit of tables and amount of data. Of course SQL will have limitations and these will depend on the Hardware where the database engine is running.

Final Words

I hope that by reading this article you get motivated and try to learn this language and above all learn to answer your questions using SQL, for which I will leave you some links to different resources to learn SQL.

Resources

  1. The ones I recommend the most (paid)
    1.1 Learning SQL, 3rd Edition (Orreily)
    1.2 Practical SQL, 2nd Edition

  2. Free Resources
    2.1 Learn SQL in 60 minutes
    2.2 Learn SQL

  3. Plattforms
    3.1 Codecademy
    3.2 Datacamp

If you have other resources for the community, don't forget to leave them in the comments.


This content originally appeared on DEV Community 👩‍💻👨‍💻 and was authored by mrGoonies


Print Share Comment Cite Upload Translate Updates
APA

mrGoonies | Sciencx (2022-12-30T19:54:52+00:00) A short introduction to SQL. Retrieved from https://www.scien.cx/2022/12/30/a-short-introduction-to-sql/

MLA
" » A short introduction to SQL." mrGoonies | Sciencx - Friday December 30, 2022, https://www.scien.cx/2022/12/30/a-short-introduction-to-sql/
HARVARD
mrGoonies | Sciencx Friday December 30, 2022 » A short introduction to SQL., viewed ,<https://www.scien.cx/2022/12/30/a-short-introduction-to-sql/>
VANCOUVER
mrGoonies | Sciencx - » A short introduction to SQL. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2022/12/30/a-short-introduction-to-sql/
CHICAGO
" » A short introduction to SQL." mrGoonies | Sciencx - Accessed . https://www.scien.cx/2022/12/30/a-short-introduction-to-sql/
IEEE
" » A short introduction to SQL." mrGoonies | Sciencx [Online]. Available: https://www.scien.cx/2022/12/30/a-short-introduction-to-sql/. [Accessed: ]
rf:citation
» A short introduction to SQL | mrGoonies | Sciencx | https://www.scien.cx/2022/12/30/a-short-introduction-to-sql/ |

Please log in to upload a file.



There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.

Related Posts