Data Analytics

Important Topics which you should know to learn SQL 👉Beginners Topics *DDL - Data Definition Language (Create Table,Drop Table,Truncate Table,Alter Table) *DML - Data Manipulation Language (Delete,Update,Insert into) *DQL vs TQL *Constraints (Check,Default,NOT NULL, UNIQUE, Primary key,and Foreign key) *Create and Drop DataBase * SQL Syntax ( SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING, LIKE, CASE WHEN, SELECT DISTINCT, AND, OR, NOT, SELECT TOP, LIMIT) * Joins (Inner, Full, Left, Right, Self) & Union * Insert into - Values *Wildcards (%,_,[],^,-,#) *Aggregate functions (Min, Max, Sum,Avg, Count) * Other operators (IN, BETWEEN, ANY, AS, ALL, IFNULL, IsNull) *Data Types(String,DateTime,Number,Boolean) 👉Intermediate Topics *Functions (LEFT,RIGHT,LENGTH,TRIM,POSITION,STRPOS, SUBSTR, CONCAT, UPPER, LOWER, COALESCE) * Sub-queries * Views, Index and Comments * Window Functions (ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD(), OVER, PARTITION BY, Alias) *Formatting Dates in SQL *Pivoting Data in SQL *Tuning SQL queries *Star Schema *Stored Procedures 👉👉 Free Useful Resources to start learning SQL https://t.me/programming_guide/287 https://www.codecademy.com/learn/learn-sql https://www.w3schools.com/sql/ https://www.hackerrank.com/domains/sql https://www.windowfunctions.com/ https://leetcode.com/problemset/database/ https://books.goalkicker.com/SQLBook/SQLNotesForProfessionals.pdf https://imp.i115008.net/WDvrQ3 https://t.me/sqlspecialist/45 https://mode.com/sql-tutorial/introduction-to-sql ENJOY LEARNING 👍👍

LeetCode SQL 👇👇 https://t.me/dsabooks/28?single

Python Most Ask Interview Questions 👇👇 https://t.me/crackingthecodinginterview/629

1. What is Density-based Clustering? Density-Based Clustering is an unsupervised machine learning method that identifies different groups or clusters in the data space. These clustering techniques are based on the concept that a cluster in the data space is a contiguous region of high point density, separated from other such clusters by contiguous regions of low point density. Partition-based(K-means) and Hierarchical clustering techniques are highly efficient with normal-shaped clusters while density-based techniques are efficient in arbitrary-shaped clusters or detecting outliers. 2. How to create empty tables with the same structure as another table? To create empty tables: Using the INTO operator to fetch the records of one table into a new table while setting a WHERE clause to false for all entries, it is possible to create empty tables with the same structure. As a result, SQL creates a new table with a duplicate structure to accept the fetched entries, but nothing is stored into the new table since the WHERE clause is active. 3. What is a Parameter in Tableau? Give an Example. A parameter is a dynamic value that a customer could select, and you can use it to replace constant values in calculations, filters, and reference lines. For example, when creating a filter to show the top 10 products based on total profit instead of the fixed value, you can update the filter to show the top 10, 20, or 30 products using a parameter. 4. How will you write the formula for the following in Excel? - Multiply the value in cell A1 by 10, add the result by 5, and divide it by 2. To write a formula for the above-stated question, we have to follow the PEDMAS Precedence. The correct answer is ((A1*10)+5)/2. Answers such as =A1*10+5/2 and =(A1*10)+5/2 are not correct. We must put parentheses brackets after a particular operation. 5. How can you remove duplicate values in a range of cells? 1. To delete duplicate values in a column, select the highlighted cells, and press the delete button. After deleting the values, go to the ‘Conditional Formatting’ option present in the Home tab. Choose ‘Clear Rules’ to remove the rules from the sheet. 2. You can also delete duplicate values by selecting the ‘Remove Duplicates’ option under Data Tools present in the Data tab.

SQL Handwritten Notes 👇👇 https://t.me/learndataanalysis/352

Learning and Practicing SQL: Resources and Platforms 1. https://sqlbolt.com/ 2. https://sqlzoo.net/ 3. https://www.codecademy.com/learn/learn-sql 4. https://www.w3schools.com/sql/ 5. https://www.hackerrank.com/domains/sql 6. https://www.windowfunctions.com/ 7. https://selectstarsql.com/ 8. https://quip.com/2gwZArKuWk7W 9. https://leetcode.com/problemset/database/ 10. http://thedatamonk.com/

The best way to learn about AI is to build real projects with it. When you build, you learn what’s valuable and what’s not. Use GitHub, Kaggle, paperswithcode, YouTube tutorial and build a strong foundation around it. Develop a solid skillset and always remember there is no alternative to practice and hard work 💪