#sql

学習時間：3.4時間 今日やったこと：データベースのSQL学習 一言：データを取り出したり絞り込んだりする書き方が、少しずつ分かってきた。思った通りの結果が返ってくると、地味にうれしい。 #コーチテック #COACHTECH #SQL #データベース

New to SQL or brushing up on the basics? This clear, beginner-friendly guide explains exactly what SQL is and why it matters. Perfect starting point! #learnsql #sql @MarkusWinand @pinaldave

@paradigmasoft @MarkusWinand @pinaldave Только начинаете работать с SQL или хотите освежить базовые знания? Это понятное и дружелюбное для новичков руководство объясняет, что такое SQL и почему он так важен. Идеальная отправная точка! #Программирование #SQL #ОбучениеIT

Только начинаете работать с SQL или хотите освежить базовые знания? Это понятное и дружелюбное для новичков руководство объясняет, что такое SQL и почему он так важен. Идеальная отправная точка! #Программирование #SQL #ОбучениеIT

Week 1 of my DE roadmap ends with a checkpoint, not a course certificate: Why do COUNT(*) and COUNT(col) differ? Why does a LEFT JOIN with a filter in WHERE become an INNER JOIN? Can't answer out loud? Repeat the week. Don't skip ahead. #DataEngineering #SQL

Intranet #TLS certificate monitoring using @certkitio You can now keep track of certificates installed on DCs, RDP servers, #SQL servers, and more! #security

🚨 DataLemur is LIVE! 🚨 Solve 50+ SQL Interview questions from companies like Facebook, Amazon, and Google for FREE! Even if you aren’t on the job hunt, DataLemur is still a great place to practice your #SQL skills on tricky problems:

🔥 SQL CHALLENGE #32 Can you identify customers with an average order value above ₦150,000? Use GROUP BY, AVG() and HAVING to solve this business problem. 🧠 Drop your SQL query in the comments! 👇 #SQL #DataAnalytics #SQLChallenge #LearnSQL

SQuizL 22-OCT-26 3/6 guesses 144 seconds 🟩🟦🟩🟨🟩⬜🟦 🟩🟦🟩⬜🟩🟩🟦 🟩🟦🟩🟩🟩🟩🟦 #SQuizL #SQL

1️⃣ Aggregate Functions: COUNT(), SUM(), AVG(), MAX(). MIN() Use cases: - COUNT(): Quick dataset snapshots & detecting nulls vs total cases. - SUM(): Overall analysis, group totals & part to whole analysis.

3️⃣ Value Functions: LEAD(), LAG(), FIRST_VALUE(), LAST_VALUE() Use cases: - LEAD() & LAG(): Time series analysis(YoY and MoM trends) & customer retention. - FIRST_VALUE() & LAST_VALUE(): Performance comparison against extremes.

Onto the next chapter! #DataEngineering #SQL #BuildInPublic

Full Post is on Instagram: . . #SQL #interview #DataScience #DataAnalytics #ArtificialIntelligence #data #BusinessAnalyst #DataAnalyst #Database #DataEngineering #Tech #rajesh_data_ai #rajesh_umrao @rajesh_data_ai

A session can verify its active namespace with SHOW CURRENT_DATABASE. In the Apache IoTDB database Table model, the result is null until a database is selected. #ApacheIoTDB #SQL

Building , Learning and Relearning I encountered duplicate records in my country summary table, investigated with SQL, reran my dbt model, and validated the results in Power BI. Debugging is part of the process! 📊 #DataEngineering #SQL #dbt

🚨 PostgreSQL 18: RETURNING now supports OLD and NEW values on UPDATE! #SQL #PostgreSQL

Day 1 of SQL practice 🐘💻 8/8 questions completed ✅ Me thinking SQL would be easy: 😎 Me remembering the syntax: 💀 #BuildInPublic #SQL

Day 23/100 PostgreSQL 🗄️💻 Today, I Created another database in mockaroo and I explored arithmetic operators and aggregate functions in PostgreSQL, learning how to perform calculations using MAX(), MIN(), AVG(), and SUM(). #100DaysOfCode #PostgreSQL #SQL #BackendDevelopment

🔥 SQL Challenge #31! Which day generated the highest sales? 📊 Can you write ONE SQL query to find the top-performing sales date? No guessing—just SQL and problem-solving! 💻 Drop your query below 👇 #SQL #DataAnalytics #SQLChallenge

Excel, SQL чи Pandas — який інструмент обрати для аналізу даних? Порівняйте, як кожен із них обробляє фільтрацію, сортування, агрегацію, з’єднання, пропущені дані та візуалізацію. #Excel #SQL #Pandas #Python #DataAnalytics #DataAnalyst #DataScience

Giveaway Alert: Skill Up with this SQL Mastery Course. This SQL Mastery Course can help you make $100,000/yr-$250,000/yr. This SQL Resource Cost $200 but FREE for 96 Hours You just have to: [1] Follow Me (@ahuja_priyank) [2] Comment "SQL" [3] ReTweet #SQL #Giveaway

💥 A visual representation of SQL query execution order. Source: @atishkumarjain #SQL #DataScience

Can you crack this SQL output? 🧠 Table: orders id | amount 1 | 100 2 | 200 3 | NULL 4 | 300 SELECT AVG(amount) FROM orders; What's the output? A) 150 B) 200 C) 120 D) 600 Comment your answer before checking 👇 #SQL