Name: Towards AI Legal Name: Towards AI, Inc. Description: Towards AI is the world's leading artificial intelligence (AI) and technology publication. Read by thought-leaders and decision-makers around the world. Phone Number: +1-650-246-9381 Email: [email protected]
228 Park Avenue South New York, NY 10003 United States
Website: Publisher: https://towardsai.net/#publisher Diversity Policy: https://towardsai.net/about Ethics Policy: https://towardsai.net/about Masthead: https://towardsai.net/about
Name: Towards AI Legal Name: Towards AI, Inc. Description: Towards AI is the world's leading artificial intelligence (AI) and technology publication. Founders: Roberto Iriondo, , Job Title: Co-founder and Advisor Works for: Towards AI, Inc. Follow Roberto: X, LinkedIn, GitHub, Google Scholar, Towards AI Profile, Medium, ML@CMU, FreeCodeCamp, Crunchbase, Bloomberg, Roberto Iriondo, Generative AI Lab, Generative AI Lab Denis Piffaretti, Job Title: Co-founder Works for: Towards AI, Inc. Louie Peters, Job Title: Co-founder Works for: Towards AI, Inc. Louis-François Bouchard, Job Title: Co-founder Works for: Towards AI, Inc. Cover:
Towards AI Cover
Logo:
Towards AI Logo
Areas Served: Worldwide Alternate Name: Towards AI, Inc. Alternate Name: Towards AI Co. Alternate Name: towards ai Alternate Name: towardsai Alternate Name: towards.ai Alternate Name: tai Alternate Name: toward ai Alternate Name: toward.ai Alternate Name: Towards AI, Inc. Alternate Name: towardsai.net Alternate Name: pub.towardsai.net
5 stars – based on 497 reviews

Frequently Used, Contextual References

TODO: Remember to copy unique IDs whenever it needs used. i.e., URL: 304b2e42315e

Resources

Unlock the full potential of AI with Building LLMs for Production—our 470+ page guide to mastering LLMs with practical projects and expert insights!

Publication

SQL — From Intermediate to Superhero
Latest   Machine Learning

SQL — From Intermediate to Superhero

Last Updated on July 20, 2023 by Editorial Team

Author(s): Eyal Trabelsi

Originally published on Towards AI.

Programming

Practical SQL For Advanced Analytics

Source: https://www.maximizemarketresearch.com/advance-analytics/

SQL is a programming language used for querying and managing data in databases and has become the backbone of modern analytics.

“SQL is the worst form of database querying,

except for all the other forms.” — Lukas Eder

There are great resources some advanced topics in SQL like performance optimization.

Yet, there is no one go-to place for advance analytics using SQL. In this article, I collected resources (listed in the bottom) about advance patterns for analytics using SQL.

It's important to note that, many databases lack some of the capabilities and thus you will gain the most by understanding the way of thoughts.

General Patterns

  • Counting Patterns: SQL Design Patterns has dedicated 2 chapters that can be found 1 and 2.
  • Window Functions Patterns: presentation regarding advance usages of window functions can be found here.
  • Writing sane SQL: presentation regarding SQL oddities, best practices, and execution order can be found here.
  • Working With Strings: presentation regarding patterns on how to work correctly with strings can be found here.
Source: https://en.wikipedia.org/wiki/The_Starry_Night

Hierarchical Traversal Patterns

source: https://www.flickr.com/photos/torley/2361164281

Data Science Patterns

It's important to note that there are better ways to do some of these (using python for example).

Source: gigabitmagazine.com/ai/report-predicts-ai-spending-reach-almost-98bn-2023

Last Words

This article is somewhat of advance SQL pattern couldn’t be possible without:

I hope you found it interesting and useful. I am open to any kind of constructive feedback.

Join thousands of data leaders on the AI newsletter. Join over 80,000 subscribers and keep up to date with the latest developments in AI. From research to projects and ideas. If you are building an AI startup, an AI-related product, or a service, we invite you to consider becoming a sponsor.

Published via Towards AI

Feedback ↓