Best of SQL — January 2024
- 1
- 2
MotherDuck·2y
Why you should learn SQL in 2024
SQL is a valuable and marketable skill that every organization needs. It is essential for manipulating and analyzing data stored in databases. SQL is a portable skill that can be used across different databases and data tools. Learning SQL is made easier with DuckDB and MotherDuck.
- 3
- 4
- 5
Hacker News·2y
vanna-ai/vanna: 🤖 Chat with your SQL database 📊. Accurate Text-to-SQL Generation via LLMs using RAG 🔄.
Vanna is an open-source Python framework for SQL generation using RAG. It allows users to train a model and ask questions to generate SQL queries for their database. The framework provides high accuracy, security, self-learning capabilities, and supports any SQL database. Users can also extend Vanna to use their own LLM or vector database.
- 6
SQL Shack·2y
Difference between SQL SELECT UNIQUE and SELECT DISTINCT
Learn about the difference between SQL SELECT UNIQUE and SELECT DISTINCT, the use of UNIQUE constraint, and the syntax for executing these statements in Oracle. Both statements are used to fetch unique values from a column that may have duplicate values.
- 7
gitconnected·2y
Mastering SQL Fundamentals
This post provides a comprehensive guide to mastering SQL fundamentals, covering database terminology, relational models, applying SQL to real data, creating a new schema in MySQL, querying data using the SELECT statement, filtering data using the WHERE clause, ordering results using the ORDER BY clause, using logical and special operators, and understanding the importance of query efficiency. Mastery of SQL is emphasized as a valuable skill for data professionals.
- 8
- 9
- 10
TigerData (Creators of TimescaleDB)·2y
PostgreSQL vs MySQL: Which to Choose and When
Comparison of PostgreSQL and MySQL as relational databases. Explore their similarities, strengths, and weaknesses. Learn about their features and decide the right database solution based on your project requirements, scale, and data operations.
- 11
freeCodeCamp·2y
Learn Data Analysis with Comprehensive 19-Hour Bootcamp
A comprehensive 19-hour data analysis bootcamp has been published on the freeCodeCamp.org YouTube channel. It covers topics such as SQL, Excel, Tableau, Power BI, and Python for data analysis. The bootcamp includes hands-on projects and career guidance. It is developed by Alex Freberg.
- 12
Community Picks·2y
How the PostgreSQL optimizer works to speed up queries
This post explains how the PostgreSQL optimizer works and highlights some important techniques it uses to speed up queries, such as constant folding, function inlining, join optimization, join order determination, join pruning, and optimized sorting for ORDER BY.
- 13
DEV·2y
Modern Data Engineering RoadMap - 2024
Data engineering is a fast-growing field with increasing demand. This article provides a roadmap for becoming a data engineer in 2024, covering the fundamentals, cloud computing, distributed frameworks, data warehouses, real-time data processing, NoSQL databases, and workflow orchestration tools. It also highlights the importance of upgrading from ETL to ELT, cloud dominance, the rise of real-time data processing, and automation and democratization in data engineering.
- 14
