📢 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
Temotec Data Science, ML & Data Engineering: Interview Notes - Projects - Courses.’s Post
More Relevant Posts
-
📢 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
-
📢 Hello LinkedIn community! 🌟💼 🌟 Day 37/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 Today, let's solve a SQL challenge that involves finding the number of followers for each user in a social media app. 📱👥 We have a table called Followers with two columns: user_id and follower_id. Each row represents a follower following a user in the app. The combination of user_id and follower_id is the primary key of the table. Here's the SQL query that will provide the desired results: Example : Input: Followers table: +---------+-------------+ | user_id | follower_id | +---------+-------------+ | 0 | 1 | | 1 | 0 | | 2 | 0 | | 2 | 1 | +---------+-------------+ Output: +---------+----------------+ | user_id | followers_count| +---------+----------------+ | 0 | 1 | | 1 | 1 | | 2 | 2 | +---------+----------------+ Explanation: The followers of 0 are {1} The followers of 1 are {0} The followers of 2 are {0,1} SELECT user_id, COUNT(follower_id) AS followers_count FROM Followers GROUP BY user_id ORDER BY user_id; In this query, we use the GROUP BY clause to group the records by user_id. Then, we use the COUNT function to count the number of followers (follower_id) for each user. Finally, we order the result by user_id in ascending order. The result will be a table with two columns: user_id and followers_count, representing the user ID and the count of their followers, respectively. Example result: +---------+----------------+ | user_id | followers_count| +---------+----------------+ | 0 | 1 | | 1 | 1 | | 2 | 2 | +---------+----------------+ In this example, user 0 has 1 follower, user 1 has 1 follower, and user 2 has 2 followers. 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
-
-
📢 Hello LinkedIn community! 🌟💼 🌟 Day 38/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 Today, let's solve a SQL challenge that involves finding the largest single number from a table of numbers. 🧮🔢 We have a table called MyNumbers with a single column num of type int. The table may contain duplicate numbers, and there is no primary key defined for this table. The result format is in the following example. Example 1: Input: MyNumbers table: +-----+ | num | +-----+ | 8 | | 8 | | 3 | | 3 | | 1 | | 4 | | 5 | | 6 | +-----+ Output: +-----+ | num | +-----+ | 6 | +-----+ Explanation: The single numbers are 1, 4, 5, and 6. Since 6 is the largest single number, we return it. Example 2: Input: MyNumbers table: +-----+ | num | +-----+ | 8 | | 8 | | 7 | | 7 | | 3 | | 3 | | 3 | +-----+ Output: +------+ | num | +------+ | null | +------+ Explanation: There are no single numbers in the input table so we return null. Here's the SQL query that will provide the desired result: SELECT MAX(num) AS num FROM ( SELECT num FROM MyNumbers GROUP BY num HAVING COUNT(*) = 1 ) AS SingleNumbers; In this query, we use a subquery to find all the numbers that appear exactly once in the MyNumbers table. The subquery selects the distinct numbers (num) using the GROUP BY clause and filters out the groups with a count of 1 using the HAVING clause. The outer query then selects the maximum (MAX) value from the single numbers. If there are no single numbers, the MAX function will return NULL. Example result 1: +-----+ | num | +-----+ | 6 | +-----+ In this example, the single numbers are 1, 4, 5, and 6. Since 6 is the largest single number, it is returned. Example result 2: +------+ | num | +------+ | null | +------+ In this example, there are no single numbers in the input table, so the result is NULL. 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
-
-
📢 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
-
Business Analyst & Finance Officer @ Pollen | International Relations Degree
great summary with an easy understanding
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
-
-
🚀 Roadmap to Master SQL🚀 Check this out 👇 1. Introduction to SQL 📝 Objective: Understand the basics of SQL, its history, and its importance. Topics Covered: 1.What is SQL? 2.Relational Database Concepts 3.SQL Syntax 4.Basic SQL Commands: SELECT, INSERT, UPDATE, DELETE Resources: 1.W3Schools SQL Tutorial: https://lnkd.in/gm_c8AKt 2.Khan Academy's Intro to SQL: https://lnkd.in/gnf-TXsf 3.Codecademy SQL Course: https://lnkd.in/gqzxrPt8 2. Basic SQL Queries 🔍 Objective: Learn to retrieve data from databases. Topics Covered: 1.SELECT Statement 2.Filtering Data: WHERE Clause 3.Sorting Data: ORDER BY Clause 4.Limiting Data: LIMIT/OFFSET Resources: 1.Mode Analytics SQL Tutorial: https://lnkd.in/gVedkiUT 2.SQLBolt: https://sqlbolt.com/ 3. Intermediate SQL 🔄 Objective: Dive deeper into SQL queries and database manipulation. Topics Covered: 1.Joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN 2.Aggregations: COUNT, SUM, AVG, MIN, MAX 3.Grouping Data: GROUP BY Clause 4.Subqueries 5.Working with Date and Time Resources: 1.Khan Academy Advanced SQL: https://lnkd.in/gHiQxRAE 2.Udemy - SQL for Data Science: https://lnkd.in/gzZctVrh 4. Advanced SQL 🚀 Objective: Master complex SQL queries and database optimization techniques. Topics Covered: 1.Window Functions 2.Common Table Expressions (CTEs) 3.Indexes and Performance Tuning 4.Stored Procedures and Functions 5.Triggers 6.Transactions and Concurrency Control Resources: 1.SQL Server Tutorial - Advanced SQL: https://lnkd.in/gB-6k_Ua 2.Coursera - Advanced SQL for Data Scientists: https://lnkd.in/gwh58tVe 3.Udemy - The Complete SQL Bootcamp: https://lnkd.in/guuqCeeV 5. Practical SQL Experience 🛠️ Objective: Apply SQL knowledge to real-world problems and projects. Resources: LeetCode - SQL Problems: https://lnkd.in/gzes3Gex HackerRank - SQL Practice: https://lnkd.in/gZpB-yDW DataCamp - SQL Projects: https://lnkd.in/gHXG585m 6. SQL Certifications 🎓 Objective: Validate your SQL skills with certifications. Resources: Microsoft Certified: Azure Data Fundamentals: https://lnkd.in/gZMKaMzt Oracle Database SQL Certified Associate: https://lnkd.in/gUTZvdKw IBM Certified Database Associate: https://lnkd.in/g_YQzjfw 💡 Tips for Mastering SQL 1.Practice Regularly: Consistency is key to mastering SQL. 2.Work on Projects: Apply your skills in real-world projects. 3.Join Communities: Participate in forums and communities like Stack Overflow, Reddit, and SQLServerCentral. #SQL #SQLTutorial #LearnSQL #SQLTraining #DataScience #Database #DataAnalytics #Coding #TechSkills #Programming
-
-
Helpful cheat sheet for those entering data analytics. There are also a bunch of cool classes listed. :D
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!
-
-
Data Analyst with Middle East Experience | Recently Relocated to Italy | Self-Taught Data Engineer | Passionate About Data | Seeking Data Engineering Internships Across Europe
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!
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!
-
-
ML Engineer @PayPal | SDE @Microsoft | 21k+ @Linkedin | Mentor @Scaler | Instructor @GrowthSchool | SDE, AI, ML, Tech, Data Content | Top 1% @TopMate | DM for Collaborations
𝐒𝐐𝐋 𝐌𝐚𝐬𝐭𝐞𝐫𝐲 : 𝐀 𝐂𝐨𝐦𝐩𝐫𝐞𝐡𝐞𝐧𝐬𝐢𝐯𝐞 𝐆𝐮𝐢𝐝𝐞 𝐟𝐫𝐨𝐦 𝐍𝐨𝐯𝐢𝐜𝐞 𝐭𝐨 𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝟏. 𝐒𝐐𝐋 𝐁𝐚𝐬𝐢𝐜𝐬 First, you will start by learning the SQL basics commands which include SELECT, WHERE, JOINS, Aggregate Functions (Count, Sum, AVG, etc.), and table commands such as (create, delete, insert, etc.) There are many resources to learn these basics but I recommend SQL Bolt. 𝐋𝐢𝐧𝐤: https://sqlbolt.com/ 𝟐. 𝐈𝐧𝐭𝐞𝐫𝐦𝐞𝐝𝐢𝐚𝐭𝐞 & 𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐒𝐐𝐋 Now it is time to learn more advanced SQL concepts such as Subqueries, Window functions, SQL for data wrangling, and more. A great place to learn these concepts is Mode SQL. 𝐋𝐢𝐧𝐤: https://lnkd.in/dUVyGKwV 𝟑. 𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞 𝐟𝐨𝐫 𝐃𝐚𝐭𝐚 𝐒𝐜𝐢𝐞𝐧𝐜𝐞 After studying SQL commands and statements it will be important to have a basic understanding of databases and their main characteristics and concepts. My recommendation is the Stanford Databases: Relational Databases and SQL Course. 𝐋𝐢𝐧𝐤: https://lnkd.in/dsq_4Cac 𝟒. 𝐒𝐐𝐋 𝐂𝐚𝐬𝐞 𝐒𝐭𝐮𝐝𝐢𝐞𝐬 Now you are ready for practicing. I would recommend starting with practicing real case studies. A great place to do so is the 8-week SQL challenge by Danny Ma. 𝐋𝐢𝐧𝐤: https://lnkd.in/d22aWUmw 𝟓. 𝐒𝐐𝐋 𝐏𝐫𝐚𝐜𝐭𝐢𝐜𝐞 Finally, you can start to solve SQL questions that you will expect to meet in a data science interview and also in practice. There are a lot of resources to do so. Here are a few good options: ✅ 𝐋𝐞𝐞𝐭𝐜𝐨𝐝𝐞: https://lnkd.in/dEEhGu6F ✅ 𝐒𝐭𝐫𝐚𝐭𝐚𝐬𝐜𝐫𝐚𝐭𝐜𝐡: https://lnkd.in/dMdzZVwD ✅ 𝐃𝐚𝐭𝐚𝐋𝐞𝐦𝐮𝐫: https://datalemur.com/ 𝟔. 𝐁𝐞𝐜𝐨𝐦𝐞 𝐒𝐐𝐋 𝐄𝐱𝐩𝐞𝐫𝐭 If you would like to build more knowledge you can start studying from more advanced resources. I recommend three books: ✅ 𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞 𝐒𝐲𝐬𝐭𝐞𝐦𝐬: The Complete Book https://lnkd.in/dYSF2qvc ✅ 𝐒𝐐𝐋 𝐂𝐨𝐨𝐤𝐛𝐨𝐨𝐤: Query Solutions and Techniques for Database Developers https://lnkd.in/dZ8Se4Rj ✅ 𝐇𝐢𝐠𝐡-𝐏𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞 𝐌𝐲𝐒𝐐𝐋: Optimization, Backups, and Replication https://lnkd.in/dDFbqSHB #sql #fresher #novice #advanced #beginner #expert #linkedin #datascience #dataanalyst #dataengineer #softwareengineer #jobs
-
-
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 ||
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.
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!
-
