SQLSkills をつくるのはどうでしょうか？ よくする集計や関数利用のサンプルsqlをreferences にいれておく。 場合分けしてSQL を参照させる。 few-shotプロンプト的に、具体的なコードと指示を紐付けて上げるのはどうでしょうか？ あとは気になる問題点をSKILL .mdに記載してチェックする。

Day 4 📚 My fave task? The last one, hands down! 😎 Already got the skills and knowledge to crush it, especially navigating through SQL like a pro! 💻 #Tech4Africans #Tech4AfricansGraduation #Tech4AfricansScholars #DataAnalysis #TechCrush #VisibilityChallenge #SQLskills

Back in the saddle after a trying 2025! [Blog] The Curious Case of… log truncation in a distributed availability group sqlskills.com/blogs/paul/the… #sqlserver #sqlskills

Download my free eBook to unlock the full potential of CTE in SQL. It's time to level up your skills: stedman.us/ctebook #SQLSkills #CTEExplained stedman.us/ctebook

𝐓𝐚𝐤𝐞 𝐚 𝐪𝐮𝐢𝐜𝐤 𝐪𝐮𝐢𝐳 𝐚𝐧𝐝 𝐠𝐞𝐭 𝐲𝐨𝐮𝐫 𝐨𝐟𝐟𝐢𝐜𝐢𝐚𝐥 𝐂𝐒𝐡𝐚𝐫𝐩𝐂𝐨𝐫𝐧𝐞𝐫 𝐌𝐲𝐒𝐐𝐋 𝐂𝐞𝐫𝐭𝐢𝐟𝐢𝐜𝐚𝐭𝐢𝐨𝐧 𝐭𝐨𝐝𝐚𝐲! ✅ Prove your SQL skills 🚀 Boost your career 🎓 Learn from the best 𝐒𝐭𝐚𝐫𝐭 𝐧𝐨𝐰 👉 c-sharpcorner.com/certificat… #MySQL #SQL #mysqlcertification #CSharpCorner #TechSkills #CareerBoost #GetCertified #LearnToEarn #upskill #CodeYourFuture #ITCareers #certificationmatters #LevelUpYourCareer #TechEducation #onlinelearning #MySQL #Certification #careergrowthtips #sqlskills #CSharpCorner

Catching up on Day 7 of #SQLwithFunmi! 🔷 Mastered aggregation with MIN, MAX, COUNT, GROUP BY, and ORDER BY. Found youngest/oldest corps members and counted members by institution state. Powerful techniques for data analysis! 💻 #30DaysOfSQL #SQLSkills #DataAnalytics

Master the Must-Have Skills for a Data Analytics Career! instagram.com/p/DKXFwohyCWe/… Join Senseacademy of Technology and turn your passion for data into real-world impact. #DataAnalytics #Senseacademy #LearnPython #PowerBI #SQLSkills #ExcelForData #senseacademyoftechnology

📊 SQL = Smarter Testing ✔ Write real queries ✔ Validate test data ✔ Report on backend issues 📅 6–7 Aug | 💻 Live Online 🔗 sq72.co/sql-for-testers/ #SQLSkills #SoftwareTesting #TestSmarter

What if anyone in your org could query the database with AI? 🧐 🎯 See how LLM-based Text-to-SQL automates query-building and unlocks real-time insights for everyone in your org. 🟢 Watch “Bridging the SQL Skills Gap: How LLM-Based Text-to-SQL Boosts Team Productivity” 🔗 youtu.be/UrH6VLYCQAA 👈🏻 🔎 and discover how to: • Shorten query development time and reduce reliance on specialized SQL skills. • Implement Text-to-SQL with in-context learning and effective prompt engineering. • Leverage database structure representation for swift, accurate data retrieval • Eliminate bottlenecks and enhance collaboration across technical and non-technical teams. 👤 Ai Heroes 2024 talk: @sivanbiham (Machine Learning Researcher). 🗓️ Don’t forget to mark your calendar for AI Heroes 2025, May 27 in Turin (and Online)! 🎟️ aiheroes.it/2025/tickets/ #AIHeroes #DataAccess #SQLSkills #TextToSQL #MachineLearning #PromptEngineering #DataDemocratization #TechConference #TeamProductivity #Innovation

Mastering SQL is an essential skill for anyone diving into the world of data analytics or data science. From creating powerful queries with GROUP BY and JOINS to leveraging functions like SUM() and COUNT(), SQL simplifies data manipulation and analysis for businesses of all sizes. Ready to take your SQL and data analytics skills to the next level? Don’t just learn—transform your career! 📅 Join our Data Science Bootcamp (online) from April 28th to May 2nd, 2025, and get hands-on experience in SQL, Python, machine learning, and more. 🔗 Register Now: datasciencedojo.com/data-sci… #SQL #DataAnalytics #DataScience #SQLSkills #CareerGrowth #TechEducation

📊 Ready to start your SQL journey in 2025? Join Jasmin Ludolf for our SQL for Absolute Beginners webinar and master the essentials of querying data! 🚀 🗓️ Save your spot: ow.ly/KCZY50Uxf7c #DataCamp #SQLSkills #LearnSQL

Don’t skip SQL, or you might just get skipped. Follow @FocusDataPro for more amazing content #SQLSkills #DataAnalytics #CareerTips

🚀 𝗚𝗲𝘁 𝗥𝗲𝗮𝗱𝘆 𝗳𝗼𝗿 𝘁𝗵𝗲 𝗨𝗽𝗰𝗼𝗺𝗶𝗻𝗴 𝗟𝗮𝘂𝗻𝗰𝗵 𝗼𝗳 𝗢𝘂𝗿 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗦𝗤𝗟 𝗧𝗿𝗮𝗰𝗸! 🚀 We're just a few days away from unveiling this 𝗰𝗼𝗺𝗽𝗿𝗲𝗵𝗲𝗻𝘀𝗶𝘃𝗲 𝗰𝗼𝘂𝗿𝘀𝗲 designed to take your SQL skills to the next level! 💻✨ 🌟 One of the standout projects in this track is the "𝗟𝗼𝗴𝗶𝗰𝗮𝗹 𝗢𝗽𝗲𝗿𝗮𝘁𝗼𝗿 𝗣𝗿𝗮𝗰𝘁𝗶𝗰𝗲 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝘄𝗶𝘁𝗵 𝗔𝗱𝘃𝗲𝗻𝘁𝘂𝗿𝗲 𝗪𝗼𝗿𝗸𝘀" 🌟 This project offers a fantastic opportunity to deepen your understanding of 𝗹𝗼𝗴𝗶𝗰𝗮𝗹 𝗼𝗽𝗲𝗿𝗮𝘁𝗼𝗿𝘀 within a 𝗿𝗲𝗮𝗹-𝘄𝗼𝗿𝗹𝗱 𝗰𝗼𝗻𝘁𝗲𝘅𝘁, using the renowned 𝗔𝗱𝘃𝗲𝗻𝘁𝘂𝗿𝗲 𝗪𝗼𝗿𝗸𝘀 database. 📊📚 🔥 Don't miss this chance to elevate your SQL expertise! 👉 𝗦𝗶𝗴𝗻 𝘂𝗽 𝗻𝗼𝘄 and get ready to dive into the project. 🔗 𝗔𝗰𝗰𝗲𝘀𝘀 𝘁𝗵𝗲 𝗽𝗿𝗼𝗷𝗲𝗰𝘁 𝗱𝗶𝗿𝗲𝗰𝘁𝗹𝘆 𝗵𝗲𝗿𝗲: buff.ly/4fQAyHo 💡 𝗟𝗲𝘁'𝘀 𝘁𝗮𝗸𝗲 𝘆𝗼𝘂𝗿 𝗦𝗤𝗟 𝗷𝗼𝘂𝗿𝗻𝗲𝘆 𝘁𝗼 𝗻𝗲𝘄 𝗵𝗲𝗶𝗴𝗵𝘁𝘀! #SQLSkills #AdvancedSQL #DataAnalysis #LogicalOperators #AdventureWorks #SQLProjects #LearnSQL #DataWars #TechEducation #SQLPractice

You don't need to learn a lot of tools to land a data analyst role. Just focus on the tools that are really necessary, which I will tell you about in this post. 𝗟𝗲𝗮𝗿𝗻: • SQL • Excel • Visualization tool (Tableau or Power BI) • Cloud Data Warehouse like Snowflake or Redshift • Python (if you are up for it) The roadmap to learn the tools of data analytics is not tough, you just need to focus on important tools, start learning them, and build real-world projects on them. Enjoy. Follow for more. #DataAnalytics #DataAnalyst #AnalyticsCareers #LearnAnalytics #SQLSkills #ExcelTips #Tableau #PowerBI #Snowflake #Redshift #PythonForData #AnalyticsTools #DataAnalyticsTips #RealWorldProjects #TechCareers #GlobalDataCareers #USDataAnalyst #UKDataAnalyst #EuropeDataAnalyst #DataSkills #AnalyticsCommunity #AnalyticsJobsWorldwide #HiringDataAnalysts #VisualizationTools #DataLearning #CareerInAnalytics #DataDrivenCareers #AnalyticsRoadmap #LearnSQL #DataWarehouse #DataVisualization

SQL is one of the most valuable skills in data analytics. 𝗟𝗲𝘁'𝘀 𝗱𝗶𝘀𝗰𝘂𝘀𝘀 𝘀𝗼𝗺𝗲 𝘁𝗲𝗰𝗵𝗻𝗶𝗾𝘂𝗲𝘀 𝘁𝗵𝗮𝘁 𝘆𝗼𝘂 𝘀𝗵𝗼𝘂𝗹𝗱 𝗳𝗼𝗰𝘂𝘀 𝗼𝗻 𝗺𝗮𝘀𝘁𝗲𝗿𝗶𝗻𝗴 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁 👇 Follow for more! #DataAnalyst #SQLSkills #SQLTechniques #DataAnalytics #SQLMastery #DataAnalysis #DataScience #SQLQuery #DataEngineer #SQLForDataAnalysts #CTE #Subqueries #WindowFunctions #SQLFunctions #BusinessIntelligence #TechSkills #SQLTraining #AnalyticsCommunity #DataDriven #TechCareers #SQLTips #SQLLearning #DataVisualization #DataAnalyticsCommunity #DataProfessionals #AnalyticsJobs #DataCareers #SQLExperts #UKDataAnalytics #USDataAnalytics #EuropeAnalytics #GlobalDataCommunity #HiringDataAnalysts #DataScienceJobs

Pattern matching is such an important part of data analytics and it is very easy to use in SQL. 𝗟𝗲𝘁'𝘀 𝘂𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱 𝗵𝗼𝘄 𝘆𝗼𝘂 𝗰𝗮𝗻 𝗽𝗲𝗿𝗳𝗼𝗿𝗺 𝗽𝗮𝘁𝘁𝗲𝗿𝗻 𝗺𝗮𝘁𝗰𝗵𝗶𝗻𝗴 𝗶𝗻 𝗦𝗤𝗟 𝗮𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁: You can use the 'LIKE' keyword in SQL for pattern matching. Also, you have wildcards in SQL that can be used in combination with the 'LIKE' keyword. 𝗟𝗲𝘁'𝘀 𝘀𝗲𝗲 𝘁𝗵𝗲 𝘄𝗶𝗹𝗱𝗰𝗮𝗿𝗱𝘀 𝗮𝗻𝗱 𝘁𝗵𝗲𝗻 𝗜 𝘄𝗶𝗹𝗹 𝗽𝗿𝗼𝘃𝗶𝗱𝗲 𝘆𝗼𝘂 𝘀𝗼𝗺𝗲 𝗲𝘅𝗮𝗺𝗽𝗹𝗲𝘀 𝗮𝘀 𝘄𝗲𝗹𝗹: '%' - It is used to represent n number of characters after/before or between desired text. 𝗘𝘅𝗮𝗺𝗽𝗹𝗲: • 𝗪𝗛𝗘𝗥𝗘 𝗰𝗼𝗹𝘂𝗺𝗻_𝗻𝗮𝗺𝗲 𝗟𝗜𝗞𝗘 '𝗦%' (finds values that start with S with n number of characters.) • 𝗪𝗛𝗘𝗥𝗘 𝗰𝗼𝗹𝘂𝗺𝗻_𝗻𝗮𝗺𝗲 𝗟𝗜𝗞𝗘 '%𝘀' (finds values that end with 's' with n number of characters.) • 𝗪𝗛𝗘𝗥𝗘 𝗰𝗼𝗹𝘂𝗺𝗻_𝗻𝗮𝗺𝗲 𝗟𝗜𝗞𝗘 '%𝘀%' (finds values that have 's' in between with n number of characters.) '_' -> It represents a single character. 𝗘𝘅𝗮𝗺𝗽𝗹𝗲: • 𝗪𝗛𝗘𝗥𝗘 𝗰𝗼𝗹𝘂𝗺𝗻_𝗻𝗮𝗺𝗲 𝗟𝗜𝗞𝗘 '𝗦_' (find values that have only 2 characters starting with 'S') So, this is how you can perform pattern matching in SQL as a data analyst. Enjoy. Follow for more! #DataAnalysis #SQLPatternMatching #SQLTips #DataAnalyst #PatternMatching #DataScience #DataAnalystLife #SQLSkills #DataCleaning #DatabaseManagement #DataAnalytics #DataJobsUSA #SQLUSA #AnalyticsCareersUSA #DataAnalystUK #SQLUK #AnalyticsUK #DataAnalystEurope #SQLEurope #AnalyticsEurope #GlobalDataJobs #SQLWorldwide #DataScienceGlobal #AnalyticsCareersGlobal

Working with SQL as a data analyst is so fun and I really love it. It is also very important to learn SQL if you want to work as a data analyst. While working with SQL as a data analyst, a lot of times, we need to delete rows, columns, views, and other objects as well. Today, let's discuss how you can delete objects from a database using SQL keywords. 𝗗𝗶𝗳𝗳𝗲𝗿𝗲𝗻𝘁 𝗸𝗲𝘆𝘄𝗼𝗿𝗱𝘀/𝗰𝗼𝗺𝗺𝗮𝗻𝗱𝘀 𝘁𝗼 𝗱𝗲𝗹𝗲𝘁𝗲 𝗿𝗼𝘄𝘀 𝗮𝗻𝗱 𝗼𝘁𝗵𝗲𝗿 𝗼𝗯𝗷𝗲𝗰𝘁𝘀 𝗳𝗿𝗼𝗺 𝗮 𝗱𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗶𝗻𝗰𝗹𝘂𝗱𝗲: 1. 𝗗𝗘𝗟𝗘𝗧𝗘 2. 𝗧𝗥𝗨𝗡𝗖𝗔𝗧𝗘 3. 𝗗𝗥𝗢𝗣 𝗟𝗲𝘁'𝘀 𝗱𝗶𝘀𝗰𝘂𝘀𝘀 𝗮𝗯𝗼𝘂𝘁 𝘁𝗵𝗲𝗺 𝗶𝗻 𝗮 𝗯𝗶𝘁 𝗱𝗲𝘁𝗮𝗶𝗹: • 𝗗𝗘𝗟𝗘𝗧𝗘: It is used to delete rows from a table. If a WHERE clause is not provided in DELETE statements then it deletes all the rows from the table. Also, it doesn't free up the space occupied by the table. 𝗘𝘅𝗮𝗺𝗽𝗹𝗲: DELETE FROM employees WHERE fired_employee = 'Yes' • 𝗧𝗥𝗨𝗡𝗖𝗔𝗧𝗘: It deletes all the rows from the table. It also clears the space that a table occupies. It is faster than DELETE. Also, in some databases, it cannot be rolled back unless it is used in a transaction. 𝗘𝘅𝗮𝗺𝗽𝗹𝗲: TRUNCATE TABLE old_employees • 𝗗𝗥𝗢𝗣: It is used for the deletion/removal of a database object. This command deletes all the rows present in the table and removes the complete table structure as well. It can also be used to delete databases 𝗘𝘅𝗮𝗺𝗽𝗹𝗲: DROP DATABASE marketing So, these are the keywords/commands that you can use to delete rows and other objects from the database as a data analyst. Enjoy. Follow for more! #DataAnalysis #SQLTips #SQLCommands #DatabaseManagement #DataAnalyst #SQLForData #DataCleaning #SQLSkills #DataScience #DataAnalystLife #TechTips #SQL #DataJobsUSA #SQLUSA #AnalyticsCareersUSA #DataAnalystUK #SQLUK #AnalyticsUK #DataAnalystEurope #SQLEurope #AnalyticsEurope #GlobalDataJobs #SQLWorldwide #DataScienceGlobal #AnalyticsCareersGlobal

As a data analyst, you need to work with SQL and you cannot run away from it. Also, it is important to ensure that your SQL query performance is optimal. Let's discuss that in this thread. #SQLTips #SQLPerformance #DataAnalyst #DataOptimization #QueryOptimization #DataAnalytics #TechCareers #SQLIndexing #DatabaseOptimization #SQLSkills #AnalyticsCommunity #DataJobs #DataEngineering #CTEs #DataJobsUSA #SQLForDataUSA #USAnalytics #SQLUK #DataAnalyticsUK #UKTechJobs #SQLEurope #DataAnalystEurope #EuropeanTechJob #GlobalDataJobs #InternationalAnalytics #WorldwideSQL #GlobalDataScience

You will need to clean data in an extensive manner when you are working as a data analyst. Generally, you will be using SQL for data cleaning as a data analyst. Let's discuss that in this thread. #DataCleaning #SQLFunctions #DataQuality #SQLTips #DataPreparation #SQLSkills #DataAnalyst #DataAnalysis #DataWrangling #AnalyticsSkills #TechCareers #DataScienceCommunity #DataAnalyticsUSA #SQLInUSA #DataCareersUSA #USTechJobs #DataAnalyticsUK #SQLUK #UKTechCareers #DataAnalystUK #EuropeData #SQLInEurope #DataJobsEU #EUTech #GlobalDataCommunity #SQLWorldwide #InternationalAnalytics #DataScienceGlobal

Day 5 of #SQL in my #100DaysOfCode journey! 🚀 Learned string functions: -UPPER() -LOWER() -LENGTH() -REPLACE() -SUBSTRING() -NOW() -FORMAT() -CONCAT() and TRIM() Excited to transform and manipulate text data! 📊 #DataScience #SQLSkills #LearningSQL#DataScience #SQLSkills