JJ Salley’s Post

JJ Salley

Protecting Privacy | Decentralized AI | Developer at Heart

8mo

Helpful cheat sheet for those entering data analytics. There are also a bunch of cool classes listed. :D

Aqsa Z.

Founder @ MLTUT | Top Data Analytics Voice| 30K+ LinkedIn Community!

8mo

To view or add a comment, sign in

More Relevant Posts

Oyedokun Feyisayo

Data Analyst
7mo
Report this post
Very portable and pocket friendly
Aqsa Z.

Founder @ MLTUT | Top Data Analytics Voice| 30K+ LinkedIn Community!
7mo

Top 20 SQL Courses- https://lnkd.in/dgyWrjvS 1. Learn SQL https://lnkd.in/eZGp32Bz 2. Learn SQL Basics for Data Science Specialization https://lnkd.in/eXJiGbBX 3. SQL for Data Analysis https://lnkd.in/evqpWaFg 4. Excel to MySQL: Analytic Techniques for Business Specialization https://lnkd.in/eUWZWi5X 5. SQL for Data Science https://lnkd.in/eKpHekVr 6. Advanced Databases and SQL Querying https://lnkd.in/enkaBmWh 7. Advanced SQL https://lnkd.in/e-HSWy_9 8. Introduction to Databases and SQL Querying https://lnkd.in/e8jfKgpy 9. Introduction to Structured Query Language (SQL) https://lnkd.in/eUmTqsNY 10. Modern Big Data Analysis with SQL Specialization https://lnkd.in/e9_vH32z 11. Intro to Relational Databases https://lnkd.in/eXQkn8wP 12. Data Warehousing for Business Intelligence Specialization https://lnkd.in/eEbtsBVZ 13. Advanced SQL https://lnkd.in/eG3prBTz 14. Databases and SQL for Data Science with Python https://lnkd.in/ewqiutAK 15. Oracle SQL – A Complete Introduction https://lnkd.in/epwxzt6f 16. Advanced SQL: MySQL Data Analysis & Business Intelligence https://lnkd.in/e5vgEZwu 17. Oracle SQL Basics https://lnkd.in/eHWjtnkh 18. Intro to SQL https://lnkd.in/ejPaqtzu 19. A Beginners Guide to SQL https://lnkd.in/evxD82qS 20. Intro to Relational Databases https://lnkd.in/eXQkn8wP Happy Learning!
Like Comment
To view or add a comment, sign in
Vyom Info Systems (VIS)

Vyom Info Systems
6mo
Report this post
Required Cheatsheet
Aqsa Z.

Founder @ MLTUT | Top Data Analytics Voice| 30K+ LinkedIn Community!
6mo

Top 20 SQL Courses- https://lnkd.in/dgyWrjvS 1. Learn SQL https://lnkd.in/eZGp32Bz 2. Learn SQL Basics for Data Science Specialization https://lnkd.in/eXJiGbBX 3. SQL for Data Analysis https://lnkd.in/evqpWaFg 4. Excel to MySQL: Analytic Techniques for Business Specialization https://lnkd.in/eUWZWi5X 5. SQL for Data Science https://lnkd.in/eKpHekVr 6. Advanced Databases and SQL Querying https://lnkd.in/enkaBmWh 7. Advanced SQL https://lnkd.in/e-HSWy_9 8. Introduction to Databases and SQL Querying https://lnkd.in/e8jfKgpy 9. Introduction to Structured Query Language (SQL) https://lnkd.in/eUmTqsNY 10. Modern Big Data Analysis with SQL Specialization https://lnkd.in/e9_vH32z 11. Intro to Relational Databases https://lnkd.in/eXQkn8wP 12. Data Warehousing for Business Intelligence Specialization https://lnkd.in/eEbtsBVZ 13. Advanced SQL https://lnkd.in/eG3prBTz 14. Databases and SQL for Data Science with Python https://lnkd.in/ewqiutAK 15. Oracle SQL – A Complete Introduction https://lnkd.in/epwxzt6f 16. Advanced SQL: MySQL Data Analysis & Business Intelligence https://lnkd.in/e5vgEZwu 17. Oracle SQL Basics https://lnkd.in/eHWjtnkh 18. Intro to SQL https://lnkd.in/ejPaqtzu 19. A Beginners Guide to SQL https://lnkd.in/evxD82qS 20. Intro to Relational Databases https://lnkd.in/eXQkn8wP Happy Learning!
Like Comment
To view or add a comment, sign in
Geon Peter

Data Analyst with Middle East Experience | Recently Relocated to Italy | Self-Taught Data Engineer | Passionate About Data | Seeking Data Engineering Internships Across Europe
6mo
Report this post
Here's a handy reference for some commonly used SQL commands, all summarized in one picture. Whether you're querying data, updating records, or managing databases, these essential SQL commands will boost your efficiency and productivity. Perfect for both beginners and experienced developers. Save it for quick access!
Aqsa Z.

Founder @ MLTUT | Top Data Analytics Voice| 30K+ LinkedIn Community!
6mo

Top 20 SQL Courses- https://lnkd.in/dgyWrjvS 1. Learn SQL https://lnkd.in/eZGp32Bz 2. Learn SQL Basics for Data Science Specialization https://lnkd.in/eXJiGbBX 3. SQL for Data Analysis https://lnkd.in/evqpWaFg 4. Excel to MySQL: Analytic Techniques for Business Specialization https://lnkd.in/eUWZWi5X 5. SQL for Data Science https://lnkd.in/eKpHekVr 6. Advanced Databases and SQL Querying https://lnkd.in/enkaBmWh 7. Advanced SQL https://lnkd.in/e-HSWy_9 8. Introduction to Databases and SQL Querying https://lnkd.in/e8jfKgpy 9. Introduction to Structured Query Language (SQL) https://lnkd.in/eUmTqsNY 10. Modern Big Data Analysis with SQL Specialization https://lnkd.in/e9_vH32z 11. Intro to Relational Databases https://lnkd.in/eXQkn8wP 12. Data Warehousing for Business Intelligence Specialization https://lnkd.in/eEbtsBVZ 13. Advanced SQL https://lnkd.in/eG3prBTz 14. Databases and SQL for Data Science with Python https://lnkd.in/ewqiutAK 15. Oracle SQL – A Complete Introduction https://lnkd.in/epwxzt6f 16. Advanced SQL: MySQL Data Analysis & Business Intelligence https://lnkd.in/e5vgEZwu 17. Oracle SQL Basics https://lnkd.in/eHWjtnkh 18. Intro to SQL https://lnkd.in/ejPaqtzu 19. A Beginners Guide to SQL https://lnkd.in/evxD82qS 20. Intro to Relational Databases https://lnkd.in/eXQkn8wP Happy Learning!
Like Comment
To view or add a comment, sign in
Chidinma Obianigwe.

Sales Analyst & Data analyst for BUSINESS OWNERS, ENTREPRENEURS, and ORGANISATIONS by turning your Data into Actionable Insights for Informed Decision-Making📈. Excel || Power Bi || SQL || Power Query || Google Suites ||
7mo
Report this post
SQL made easy... If you can remember these command statements in SQL, then solving a problem in dataanalystics with SQL becomes a piece of cake.
Aqsa Z.

Founder @ MLTUT | Top Data Analytics Voice| 30K+ LinkedIn Community!
8mo

Top 20 SQL Courses- https://lnkd.in/dgyWrjvS 1. Learn SQL https://lnkd.in/eZGp32Bz 2. Learn SQL Basics for Data Science Specialization https://lnkd.in/eXJiGbBX 3. SQL for Data Analysis https://lnkd.in/evqpWaFg 4. Excel to MySQL: Analytic Techniques for Business Specialization https://lnkd.in/eUWZWi5X 5. SQL for Data Science https://lnkd.in/eKpHekVr 6. Advanced Databases and SQL Querying https://lnkd.in/enkaBmWh 7. Advanced SQL https://lnkd.in/e-HSWy_9 8. Introduction to Databases and SQL Querying https://lnkd.in/e8jfKgpy 9. Introduction to Structured Query Language (SQL) https://lnkd.in/eUmTqsNY 10. Modern Big Data Analysis with SQL Specialization https://lnkd.in/e9_vH32z 11. Intro to Relational Databases https://lnkd.in/eXQkn8wP 12. Data Warehousing for Business Intelligence Specialization https://lnkd.in/eEbtsBVZ 13. Advanced SQL https://lnkd.in/eG3prBTz 14. Databases and SQL for Data Science with Python https://lnkd.in/ewqiutAK 15. Oracle SQL – A Complete Introduction https://lnkd.in/epwxzt6f 16. Advanced SQL: MySQL Data Analysis & Business Intelligence https://lnkd.in/e5vgEZwu 17. Oracle SQL Basics https://lnkd.in/eHWjtnkh 18. Intro to SQL https://lnkd.in/ejPaqtzu 19. A Beginners Guide to SQL https://lnkd.in/evxD82qS 20. Intro to Relational Databases https://lnkd.in/eXQkn8wP Happy Learning!
3 Comments
Like Comment
To view or add a comment, sign in
Muhammad Irfan Dzikrirazak

Business Analyst & Finance Officer @ Pollen | International Relations Degree
8mo
Report this post
great summary with an easy understanding
Aqsa Z.

Founder @ MLTUT | Top Data Analytics Voice| 30K+ LinkedIn Community!
8mo

Top 20 SQL Courses- https://lnkd.in/dgyWrjvS 1. Learn SQL https://lnkd.in/eZGp32Bz 2. Learn SQL Basics for Data Science Specialization https://lnkd.in/eXJiGbBX 3. SQL for Data Analysis https://lnkd.in/evqpWaFg 4. Excel to MySQL: Analytic Techniques for Business Specialization https://lnkd.in/eUWZWi5X 5. SQL for Data Science https://lnkd.in/eKpHekVr 6. Advanced Databases and SQL Querying https://lnkd.in/enkaBmWh 7. Advanced SQL https://lnkd.in/e-HSWy_9 8. Introduction to Databases and SQL Querying https://lnkd.in/e8jfKgpy 9. Introduction to Structured Query Language (SQL) https://lnkd.in/eUmTqsNY 10. Modern Big Data Analysis with SQL Specialization https://lnkd.in/e9_vH32z 11. Intro to Relational Databases https://lnkd.in/eXQkn8wP 12. Data Warehousing for Business Intelligence Specialization https://lnkd.in/eEbtsBVZ 13. Advanced SQL https://lnkd.in/eG3prBTz 14. Databases and SQL for Data Science with Python https://lnkd.in/ewqiutAK 15. Oracle SQL – A Complete Introduction https://lnkd.in/epwxzt6f 16. Advanced SQL: MySQL Data Analysis & Business Intelligence https://lnkd.in/e5vgEZwu 17. Oracle SQL Basics https://lnkd.in/eHWjtnkh 18. Intro to SQL https://lnkd.in/ejPaqtzu 19. A Beginners Guide to SQL https://lnkd.in/evxD82qS 20. Intro to Relational Databases https://lnkd.in/eXQkn8wP
Like Comment
To view or add a comment, sign in
Elijah Butler 📊

Senior Data Analyst @ Humana | I post FREE data analytics tips & resources
8mo Edited
Report this post
Getting started with SQL? Here are 4 FREE courses to help: Khan Academy SQL Course: https://lnkd.in/gWusacSx I LOVE this course. In this one, you’ll watch a short video explaining a SQL concept, then do a practice problem to apply what you learn. At the end of each module, you’ll do a mini-project to practice all you’ve learned. W3Schools.com: https://lnkd.in/gxH4tT34 This one is very popular and I know data analysts that still use it to review. In this course, you read about a SQL concept then do some practice problems to apply what you learned. This course isn’t as hard as the Khan Academy course, so if you’re stuck on KA, you can try this one. SQL Bolt: https://sqlbolt.com This one is similar to W3Schools where you read about concepts then practice. I really enjoyed this one. Alex the Analyst YouTube playlists: https://lnkd.in/gxTG_gFA If you don’t know about Alex Freberg, are you really learning data analytics? This “course” is really just a SQL playlist, but Alex explains concepts as clearly as anyone, so check out his channel! I’ve taken all four courses and you can’t go wrong with any of them. Mix and match them to your liking. Share to support other analysts 😃

24 Comments
Like Comment
To view or add a comment, sign in
Temotec Data Science, ML & Data Engineering: Interview Notes - Projects - Courses.

410 followers
6mo
Report this post
📢 Hello LinkedIn community! 🌟💼 🌟 Day 41/50 Days of SQL Challenge 🌟 SQL Course 2024: SQL for Data Analysis and Data Science. https://lnkd.in/g45cbiXa SQL Bootcamp 2024: Master SQL & PostgreSQL - Hands-On Course https://lnkd.in/gaHnijmg SQL Introduction Course 2024: SQL Crash Course. https://lnkd.in/dFyqBHBB Today, let's solve a SQL challenge that involves reporting the primary department for each employee. 📊👥 The combination of employee_id and department_id forms the primary key for this table. The primary_flag column is an ENUM (category) with values 'Y' or 'N'. If the primary_flag is 'Y', it indicates that the department is the primary department for the employee, and if it's 'N', it means the department is not the primary. Employees can belong to multiple departments, and when they join other departments, they need to specify their primary department. Note that when an employee belongs to only one department, their primary_flag is 'N'. Solution: SELECT employee_id, CASE WHEN COUNT(*) > 1 AND COUNT(CASE WHEN primary_flag = 'Y' THEN 1 END) = 1 THEN MAX(CASE WHEN primary_flag = 'Y' THEN department_id END) WHEN COUNT(*) = 1 THEN MAX(department_id) ELSE NULL END AS department_id FROM Employee GROUP BY employee_id HAVING department_id IS NOT NULL; we group the records by employee_id. We use a CASE statement to handle different scenarios. If an employee belongs to more than one department and has exactly one department marked as the primary (primary_flag = 'Y'), we select that department as their primary department. If an employee belongs to only one department, we select their only department as their primary department. If an employee belongs to multiple departments but doesn't have a primary department (primary_flag = 'Y' for any department), we return NULL for their department. The HAVING clause is used to filter out the employees who don't have a primary department (NULL department_id). Result: +-------------+---------------+ | employee_id | department_id | +-------------+---------------+ | 1 | 1 | | 2 | 1 | | 3 | 3 | | 4 | 3 | +-------------+---------------+ employee 1 has only one department (department 1), and it is considered their primary department. Employee 2 belongs to departments 1 and 2, but department 1 is marked as their primary department. Employee 3 belongs to department 3, and it is their primary department. Employee 4 belongs to departments 2, 3, and 4, but department 3 is marked as their primary department. #SQL hashtag #Databases hashtag #DataAnalysis hashtag #LeetCode hashtag #SQL hashtag #DataAnalysis hashtag #DataManipulation hashtag #ContinuousLearning hashtag #Temotec hashtag #TemotecAcademy hashtag #TamerAhmed hashtag #50DaysOFSQL hashtag #50daysofsqls hashtag #SQLChallenges hashtag #DataAnalysis hashtag #SQLQueries hashtag #DataManipulation hashtag #ProblemSolving hashtag

SQL Course 2024: SQL for Data Analysis and Data Science.

udemy.com
Like Comment
To view or add a comment, sign in
Temotec Data Science, ML & Data Engineering: Interview Notes - Projects - Courses.

410 followers
6mo
Report this post
📢 Hello LinkedIn community! 🌟💼 🌟 Day 39/50 Days of SQL Challenge 🌟 SQL Bootcamp 2024: Master SQL & PostgreSQL - Hands-On Course https://lnkd.in/gaHnijmg SQL Course 2024: SQL for Data Analysis and Data Science. https://lnkd.in/g45cbiXa SQL Introduction Course 2024: SQL Crash Course. https://lnkd.in/dFyqBHBB Today, let's solve a SQL challenge that involves finding the customer IDs from the `Customer` table who bought all the products in the `Product` table. 🛍️👥 We have two tables: `Customer` and `Product`. The `Customer` table contains information about each customer's purchase, including the customer ID and the product key. The `Product` table contains the product keys for all Write a solution to report the customer ids from the Customer table that bought all the products in the Product table. Return the result table in any order. The result format is in the following example. Example 1: Input: Customer table: +-------------+-------------+ | customer_id | product_key | +-------------+-------------+ | 1 | 5 | | 2 | 6 | | 3 | 5 | | 3 | 6 | | 1 | 6 | +-------------+-------------+ Product table: +-------------+ | product_key | +-------------+ | 5 | | 6 | +-------------+ Output: +-------------+ | customer_id | +-------------+ | 1 | | 3 | +-------------+ Explanation: The customers who bought all the products (5 and 6) are customers with IDs 1 and 3. Here's the SQL query that will provide the desired results: SELECT customer_id FROM Customer GROUP BY customer_id HAVING COUNT(DISTINCT product_key) = (SELECT COUNT(*) FROM Product); In this query, we use the `GROUP BY` clause to group the records in the `Customer` table by `customer_id`. Then, we use the `HAVING` clause to filter the groups, selecting only those groups where the count of distinct `product_key` values is equal to the total number of products in the `Product` table. The result will be a table with a single column: `customer_id`, representing the customer IDs who bought all the products. Example result: +-------------+ | customer_id | +-------------+ | 1 | | 3 | +-------------+ In this example, customers with IDs 1 and 3 bought all the products (product keys 5 and 6). Feel free to try out this query on your own database or the provided sample data to see the results. Happy coding! 💻🔢 #SQL hashtag #Databases hashtag #DataAnalysis hashtag #LeetCode hashtag #SQL hashtag #DataAnalysis hashtag #DataManipulation hashtag #LinkedInLearning hashtag #ContinuousLearning hashtag #Temotec hashtag #TemotecAcademy hashtag #TamerAhmed hashtag #50DaysOFSQL hashtag #50daysofsqls hashtag #SQLChallenges hashtag #DataAnalysis hashtag #SQLQueries hashtag #DataManipulation hashtag #ProblemSolving hashtag #DataDrivenInsights hashtag

SQL Bootcamp 2024: Master SQL & PostgreSQL - Hands-On Course

udemy.com
Like Comment
To view or add a comment, sign in
Temotec Data Science, ML & Data Engineering: Interview Notes - Projects - Courses.

410 followers
6mo
Report this post
📢 Hello LinkedIn community! 🌟💼 🌟 Day 40/50 Days of SQL Challenge 🌟 SQL Course 2024: SQL for Data Analysis and Data Science. https://lnkd.in/g45cbiXa SQL Bootcamp 2024: Master SQL & PostgreSQL - Hands-On Course https://lnkd.in/gaHnijmg SQL Introduction Course 2024: SQL Crash Course. https://lnkd.in/dFyqBHBB Today, let's solve a SQL challenge that involves reporting the number of employees who report to each manager, along with the average age of those reports. 📊👥 Table: Employees +-------------+----------+ | Column Name | Type | +-------------+----------+ | employee_id | int | | name | varchar | | reports_to | int | | age | int | +-------------+----------+ We have a table called Employees with several columns: employee_id, name, reports_to, and age. The employee_id column has unique values, and the reports_to column represents the manager's ID to whom the employee reports. Some employees may not report to anyone, indicated by a NULL value in the reports_to column. Here's the SQL query that will provide the desired results: SELECT e1.employee_id, e1.name, COUNT(*) AS reports_count, ROUND(AVG(e2.age)) AS average_age FROM Employees e1 JOIN Employees e2 ON e1.employee_id = e2.reports_to GROUP BY e1.employee_id, e1.name ORDER BY e1.employee_id; In this query, we perform a self-join on the Employees table to match each employee with their respective manager using the employee_id and reports_to columns. Then, we use the GROUP BY clause to group the records by the manager's employee_id and name. Within each group, we use the COUNT(*) function to count the number of reports for each manager and the AVG(e2.age) function to calculate the average age of the reports. The ROUND function is used to round the average age to the nearest integer. Finally, we order the result by the manager's employee_id in ascending order. Example result: +-------------+-------+---------------+-------------+ | employee_id | name | reports_count | average_age | +-------------+-------+---------------+-------------+ | 9 | Hercy | 2 | 39 | +-------------+-------+---------------+-------------+ In this example, employee Hercy with ID 9 has 2 direct reports (Alice and Bob). The average age of the reports is calculated as (41+36)/2 = 38.5, rounded to 39. #SQL hashtag #Databases hashtag #DataAnalysis hashtag #LeetCode hashtag #SQL hashtag #DataAnalysis hashtag #DataManipulation hashtag #LinkedInLearning hashtag #ContinuousLearning hashtag #Temotec hashtag #TemotecAcademy hashtag #TamerAhmed hashtag #50DaysOFSQL hashtag #50daysofsqls hashtag #SQLChallenges hashtag #DataAnalysis hashtag #SQLQueries hashtag #DataManipulation hashtag #ProblemSolving hashtag #DataDrivenInsights hashtag

SQL Course 2024: SQL for Data Analysis and Data Science.

udemy.com
Like Comment
To view or add a comment, sign in
Jyoti ..

LinkedIn Influencer|| Content Writer || Content Creator || SEO Executive || German- English Language Expert
5mo Edited
Report this post
SQL (Structured Query Language) is the backbone of database management. Mastering SQL enables you to efficiently retrieve, manipulate, and manage data. Key commands include SELECT for querying data, INSERT for adding data, UPDATE for modifying data, and DELETE for removing data. Understanding joins, subqueries, and aggregate functions further empowers your data handling capabilities. Here are the steps to follow( 𝗠𝗮𝗸𝗲 𝘀𝘂𝗿𝗲 𝘁𝗵𝗲 𝗼𝗿𝗱𝗲𝗿 𝗶𝘀 𝗺𝗮𝗶𝗻𝘁𝗮𝗶𝗻𝗲𝗱): 🎙️ Tutorials - https://lnkd.in/eWmC2vf8 🏗️ Projects - https://lnkd.in/ew5y5KP7 Learn Basic Statistics - Time : 3 days 🎙️ Tutorials - https://lnkd.in/emKawHBs Learn Power BI - Time: 20 days 🎙️ Tutorials - https://bit.ly/npowerbi 🏗️ Projects - http://bit.ly/3Xjpn0v Learn SQL - Time: 20 days 🎙️ Tutorials - https://lnkd.in/epAFJzJB 🏗️ Projects - https://lnkd.in/eq9jqcBq Learn Python - Time: 20 days 🎙️ Tutorials - https://lnkd.in/eh4gTQQ2 🏗️ Projects - https://lnkd.in/emzcrzTX Work on Projects and build your portfolio - Time: 15 days 🎙️ Portfolio - https://lnkd.in/eVFWpmFg 🏗️Projects - https://lnkd.in/epd_9Bx8 🔸Intro to Data Analytics https://lnkd.in/dns7Yvdv 🔸SQL for Data Science https://lnkd.in/gdVHm7Wk 🔸Google Data Analytics Certificate imp.i384100.net/JzWrLR 🔸Google Advanced Data Analytics Professional Certificate https://lnkd.in/gXzxA9ET 🔸IBM Data Analyst Professional Certificate https://lnkd.in/gz2g_8Qa #SQL #MasterSQL #LearnSQL #DataScience #BigData #DataAnalytics #TechEducationn #Programming #DataEngineering #DatabaseManagement #SQLQueries #TechTips #TechCommunity #SQLDeveloper #TechInnovation #DataManagement #BusinessIntelligence #SQLTraining #SQLSkills

4 Comments
Like Comment
To view or add a comment, sign in

3,552 followers

152 Posts

View Profile Follow

JJ Salley’s Post

More Relevant Posts

Explore topics