Anmar Abbas 💫

Growth & User Acquisition (Performance Marketing) , Helping businesses to become data-driven and get customers online.

[Matt Dancho (Business Science) @mdancho84]

OpenAI, Google, and Anthropic just published guides on:

• Prompt engineering
• Building agents
• AI in business
• 601 AI use cases

9 of the best guides you can't miss:

[Abdul Șhakoor @abxxai]

I collected the exact NotebookLM prompts that went viral across Reddit, X, and research communities.

They turn NotebookLM from a demo tool into a nuclear missile that finishes hours of work in seconds.

10 copy paste prompts.
No fluff. No theory.

Check them out 👇

[Jason D @JasonUXUI]

Project Workspace - Timeline full view ✨

Built with @shadcn,@_phosphoricons

[Science girl @sciencegirl]

Precision tile work

[Bytebytego @bytebytego]

Visualizing a SQL query

SQL statements are executed by the database system in several steps, including:
- Parsing the SQL statement and checking its validity
- Transforming the SQL into an internal representation, such as relational algebra
- Optimizing the internal representation and creating an execution plan that utilizes index information
- Executing the plan and returning the results

–
Subscribe to our weekly newsletter to get a Free System Design PDF (158 pages): https://t.co/FIzCeaWsZV

[Dr Milan Milanović @milan_milanovic]

𝗧𝗼𝗽 𝟮𝟬 𝗦𝗤𝗟 𝗾𝘂𝗲𝗿𝘆 𝗼𝗽𝘁𝗶𝗺𝗶𝘇𝗮𝘁𝗶𝗼𝗻 𝘁𝗲𝗰𝗵𝗻𝗶𝗾𝘂���𝘀

Here is the list of the top 20 SQL query optimization techniques I found noteworthy:

1. Create an index on huge tables (>1.000.000) rows
2. Use EXIST() instead of COUNT() to find an element in the table
3. SELECT fields instead of using SELECT *
4. Avoid Subqueries in WHERE Clause
5. Avoid SELECT DISTINCT where possible
6. Use WHERE Clause instead of HAVING
7. Create joins with INNER JOIN (not WHERE)
8. Use LIMIT to sample query results
9. Use UNION ALL instead of UNION wherever possible
10. Use UNION where instead of WHERE ... or ... query.
11. Run your query during off-peak hours
12. Avoid using OR in join queries
14. Choose GROUP BY over window functions
15. Use derived and temporary tables
16. Drop the index before loading bulk data
16. Use materialized views instead of views
17. Avoid != or <> (not equal) operator
18. Minimize the number of subqueries
19. Use INNER join as little as possible when you can get the same output using LEFT/RIGHT join.
20. For retrieving the same dataset, frequently try to use temporary sources.

Do you know what is 𝗤𝘂𝗲𝗿𝘆 𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗲𝗿? Its primary function is to determine 𝘁𝗵𝗲 𝗺𝗼𝘀𝘁 𝗲𝗳𝗳𝗶𝗰𝗶𝗲��𝘁 ��𝗮𝘆 to execute a given SQL query by finding the best execution plan. The query optimizer works by taking the SQL query as input and analyzing it to determine how best to execute it. The first step is to parse the SQL query and create a syntax tree. The optimizer then analyzes the syntax tree to determine how to run the query.

Next, the optimizer generates 𝗮𝗹𝘁𝗲𝗿𝗻𝗮𝘁𝗶𝘃𝗲 𝗲𝘅𝗲𝗰𝘂𝘁𝗶𝗼𝗻 𝗽𝗹𝗮𝗻𝘀, which are different ways of executing the same query. Each execution plan specifies the order in which the tables should be accessed, the join methods, and any filtering or sorting operations. The optimizer then assigns a 𝗰𝗼𝘀𝘁 to each execution plan based on the number of disk reads and the CPU time required to execute the query.

Finally, the optimizer 𝗰𝗵𝗼𝗼𝘀𝗲𝘀 𝘁𝗵𝗲 𝗲𝘅𝗲𝗰𝘂𝘁𝗶𝗼𝗻 𝗽𝗹𝗮𝗻 with the lowest cost as the optimal execution plan for the query. This plan is then used to execute the query.

Check in the image the 𝗼𝗿𝗱𝗲𝗿 𝗶𝗻 𝘄𝗵𝗶𝗰𝗵 𝗦𝗤𝗟 𝗾𝘂𝗲𝗿𝗶𝗲𝘀 𝗿𝘂𝗻.

#technology #softwareengineering #programming #techworldwithmilan #sql

[Anmar Abbas 💫 @Anmar3bbas]

Key takeaways: 📚 "Storytelling with Data" by @storywithdata

- Understand how people see, how the brain perceives, and how you can use that to your advantage when crafting visuals.

- Clutter is your enemy. Remove unnecessary visual elements that do not…https://t.co/zxaC3sGfFr

[Anmar Abbas 💫 @Anmar3bbas]

Thrilled to share some key takeaways from the ongoing #DataAISummit 2023 hosted by Databricks!

1️⃣ Delta Lake 3.0: an open-source framework that supports multiple table formats, including Apache #Iceberg and #Hudi. This will offer greater flexibility and…https://t.co/KzKBYXJjh7

[Anmar Abbas 💫 @Anmar3bbas]

It was a truly remarkable day at the Data and Analytics Summit, filled with thought-provoking insights and robust discussions that underlined the dynamism of our field.

The keynote speech by Peter Jackson on the 'Data and Technology Operating Model' was,…https://t.co/lPtEi9ekVq

[Anmar Abbas 💫 @Anmar3bbas]

Data Product Manager.
--------------------------
Companies often struggle to deploy AI and analytics models into production. To address this issue, many organizations are adopting the concept of data products—reusable datasets that can be analyzed in vari…https://t.co/KfuOPyMdJk

[Anmar Abbas 💫 @Anmar3bbas]

True story :) https://t.co/3BKT8LxucP

[Anmar Abbas 💫 @Anmar3bbas]

The future of work is to have a unique perspective.
-----------
With the rise of artificial intelligence, Automation, and SaaS. I believe the most essential skills in the market will be:

1- System thinking
traditional thinking (component thinking) breaks…https://t.co/QtiOQmvWwn

[Anmar Abbas 💫 @Anmar3bbas]

It was great to meet great people and share up-to-date knowledge and actionable, practical work experience advice about Modern Data Stack, digital analytics, and high-demand digital skills to learn.
Hop It will be a flame light for new people to find and…https://t.co/wST9eEJqRo

[Anmar Abbas 💫 @Anmar3bbas]

As I'm on my vacation, reading my favorite business book: 80/20 Sales and Marketing by Perry Marshall.
I asked openai (first time trying it) about: LinkedIn post ideas on vacation, and this is the result.

Summarizing the key ideas as a carousel LinkedIn…https://t.co/vfYQ8SzIlQ

[Anmar Abbas 💫 @Anmar3bbas]

Happy to attend the #CustomerExperienceSummit 2022.

8020 insights:
- EX + CX = success brand (Employee &amp; Customer Experience)
- CX Strategy = Hi to buy, then buy again.
- Eliminate complexity, remove friction and accelerate productivity.
- Deal with CX…https://t.co/r9hmDqK5Iw

[Anmar Abbas 💫 @Anmar3bbas]

Google Data Studio is now re-branded as Looker Studio.
And there are a lot of great advanced features on the roadmap, including sharing visualization charts in a google doc, google Slides, and even email.

I'm always a big fan of the google ecosystem :)…https://t.co/9XIiojzc1g

[Anmar Abbas 💫 @Anmar3bbas]

Intensity Vs. Consistency https://t.co/7kZy80LW2T

[Anmar Abbas 💫 @Anmar3bbas]

i believe that feedback loop effect, is one of the most important, but ambiguous nature concepts. if you understand it deeply, and design a system with fine-tuning feedback loop, you can reach exponential result. even this implementation on your personal…https://t.co/wK9TzqXj6Q

[Anmar Abbas 💫 @Anmar3bbas]

As a take away from Vibe MarTech Fest 2022.

"let data drive your decisions, not the highest paid person's opinion."

in my opinion, 3 steps for digital transformation.

1. Cloud data pipeline (Modern Data Stack)
- Consolidate all your data in one place…https://t.co/EVAzyFH6Xw

[Anmar Abbas 💫 @Anmar3bbas]

80/20 and Employee Performance
When you’re measuring people or economics or anything in business, the 80/20 Curve is almost always more insightful. and 80/20 rule says:
If you want a high performance organization, 80% of people are NOT up to the task. It’…https://t.co/Tn4R5uqsRn