Complete topics & subtopics of hashtag #SQL for Data Analyst role:-

𝟭. 𝗕𝗮𝘀𝗶𝗰 𝗦𝗤𝗟 𝗦𝘆𝗻𝘁𝗮𝘅:
SQL keywords
Data types
Operators
SQL statements (SELECT, INSERT, UPDATE, DELETE)

𝟮. 𝗗𝗮𝘁𝗮 𝗗𝗲𝗳𝗶𝗻𝗶𝘁𝗶𝗼𝗻 𝗟𝗮𝗻𝗴𝘂𝗮𝗴𝗲 (𝗗𝗗𝗟):
CREATE TABLE
ALTER TABLE
DROP TABLE
Truncate table

𝟯. 𝗗𝗮𝘁𝗮 𝗠𝗮𝗻𝗶𝗽𝘂𝗹𝗮𝘁𝗶𝗼𝗻 𝗟𝗮𝗻𝗴𝘂𝗮𝗴𝗲 (𝗗𝗠𝗟):
SELECT statement (SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING, JOINs)
INSERT statement
UPDATE statement
DELETE statement

𝟰. 𝗔𝗴𝗴𝗿𝗲𝗴𝗮𝘁𝗲 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀:
SUM, AVG, COUNT, MIN, MAX
GROUP BY clause
HAVING clause

𝟱. 𝗗𝗮𝘁𝗮 𝗖𝗼𝗻𝘀𝘁𝗿𝗮𝗶𝗻𝘁𝘀:
Primary Key
Foreign Key
Unique
NOT NULL
CHECK

𝟲. 𝗝𝗼𝗶𝗻𝘀:
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL OUTER JOIN
Self Join
Cross Join

𝟳. 𝗦𝘂𝗯𝗾𝘂𝗲𝗿𝗶𝗲𝘀:
Types of subqueries (scalar, column, row, table)
Nested subqueries
Correlated subqueries

𝟴. 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗦𝗤𝗟 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀:
String functions (CONCAT, LENGTH, SUBSTRING, REPLACE, UPPER, LOWER)
Date and time functions (DATE, TIME, TIMESTAMP, DATEPART, DATEADD)
Numeric functions (ROUND, CEILING, FLOOR, ABS, MOD)
Conditional functions (CASE, COALESCE, NULLIF)

𝟵. 𝗩𝗶𝗲𝘄𝘀:
Creating views
Modifying views
Dropping views

𝟭𝟬. 𝗜𝗻𝗱𝗲𝘅𝗲𝘀:
Creating indexes
Using indexes for query optimization

𝟭𝟭. 𝗧𝗿𝗮𝗻𝘀𝗮𝗰𝘁𝗶𝗼𝗻𝘀:
ACID properties
Transaction management (BEGIN, COMMIT, ROLLBACK, SAVEPOINT)
Transaction isolation levels

𝟭𝟮. 𝗗𝗮𝘁𝗮 𝗜𝗻𝘁𝗲𝗴𝗿𝗶𝘁𝘆 𝗮𝗻𝗱 𝗦𝗲𝗰𝘂𝗿𝗶𝘁𝘆:
Data integrity constraints (referential integrity, entity integrity)
GRANT and REVOKE statements (granting and revoking permissions)
Database security best practices

𝟭𝟯. 𝗦𝘁𝗼𝗿𝗲𝗱 𝗣𝗿𝗼𝗰𝗲𝗱𝘂𝗿𝗲𝘀 𝗮𝗻𝗱 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀:
Creating stored procedures
Executing stored procedures
Creating functions
Using functions in queries

𝟭𝟰. 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲 𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗮𝘁𝗶𝗼𝗻:
Query optimization techniques (using indexes, optimizing joins, reducing subqueries)
Performance tuning best practices

𝟭𝟱. 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗦𝗤𝗟 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀:
Recursive queries
Pivot and unpivot operations
Window functions (Row_number, rank, dense_rank, lead & lag)
CTEs (Common Table Expressions)
Dynamic SQL

𝗝𝗼𝗶𝗻 𝗺𝘆 𝗧𝗲𝗹𝗲𝗴𝗿𝗮𝗺 𝗖𝗵𝗮𝗻𝗻𝗲𝗹 - https://t.me/codingdidi

If you've read so far, do LIKE the post👍

Identifying outliers in a data science project is an important step to ensure the quality and accuracy of your analysis. Outliers can be caused by measurement errors, data entry mistakes, or even intentional manipulation. Here are some approaches you can use to identify liars in your data science project:

1. Visual Exploration: Start by visualizing your data using plots such as histograms, box plots, or scatter plots. Look for any data points that appear significantly different from the majority of the data. Outliers may appear as points that are far away from the main cluster or exhibit unusual patterns.

2. Statistical Methods: Utilize statistical methods to identify outliers. One common approach is to calculate the z-score or standard deviation of each data point and flag those that fall outside a certain threshold (e.g., more than 3 standard deviations away). Another method is the interquartile range (IQR), where data points outside the range of 1.5 times the IQR are considered outliers.

3. Domain Knowledge: Leverage your domain expertise to identify potential outliers. If you have a good understanding of the data and the context in which it was collected, you may be able to identify values that are implausible or inconsistent with what is expected.

4. Machine Learning Techniques: You can use machine learning algorithms to detect outliers. Unsupervised learning algorithms like clustering or density-based methods (e.g., DBSCAN) can help identify unusual patterns or clusters in the data that may indicate outliers.

5. Data Validation: Cross-check your data with external sources or known benchmarks. If possible, compare your data with other reliable sources or conduct external validation to verify its accuracy and consistency.

6. Outlier Detection Models: Train outlier detection models on your dataset. These models can learn patterns from the majority of the data and flag any observations that deviate significantly from those patterns.

It's important to note that not all outliers are necessarily liars or errors; some may represent valid and interesting data points. It's crucial to carefully investigate and understand the reasons behind the outliers before making any decisions about their treatment or exclusion from the analysis.



Like for more ❤️

Nvidia has launched multiple GenAi, and AI courses.

Check this video!

https://www.instagram.com/reel/C7hAmjyPGPc/?igsh=YzFxaTAxcTV0M2tw

FREE COURSES link:- 🖇️
https://learn.nvidia.com/en-us/training/self-paced-courses



Follow for more❤️

Don't forget to comment on the video if you want more posts like these. 😇

Walmart global is hiring for Data Analyst role

0-2 years of experience is required

So any fresher can apply

https://www.linkedin.com/jobs/view/3849477026

All the best 👍👍

Barclays is hiring for a fresher entry level data analyst!
https://search.jobs.barclays/job/-/-/13015/65691977856?src=JB-12860&

Hi all,
I have updated the SQL roadmap with the 🔗 links .



Here's the link.

https://docs.google.com/document/d/1rk7A5vqLXRhrTwIgHcnxL15JxMWwsvqsj7PlWZL0Ufk/edit?usp=drivesdk

❤️share with credit :-https://t.me/codingdidi ✅

👉👉Here's how you can create a portfolio using python.

https://www.instagram.com/p/C7i_TZMSqWh/?igsh=bTd1Nmt3dnpwbHpv

If you like this post don't forget to comment "codingdidi" to get the GitHub repo link in your bio 😍.


And share it with your fellow friends.

If you want me to create an explanation video on yt, comment "explain on yt* on the post



✅ Follow @codingdidi ✅

Swiss Re is hiring!
Position: Associate Data Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 8 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore, India

📌Apply Now: https://careers.swissre.com/job/Bangalore-Associate-Data-Analyst-KA/1065982501/

Grow Solutions Hiring for Fresher Data Analyst              
Location: Gujrat
Qualification : Any degree       
Work Experience: Fresher        
CTC: upto 8 LPA                 
Apply Link: https://grow.keka.com/careers/jobdetails/59500


Deliveroo Hiring for Fresher Machine Learning Engineer          
Location: Hyderabad
Qualification : Any degree       
Work Experience: Fresher        
CTC: upto 8 LPA                 
Apply Link: https://boards.greenhouse.io/deliveroo/jobs/5688028?gh_src=1df4cbd01us

Like for more ❤️

All the best 👍👍

Natwest Group is hiring for the role of Business Analyst.

Experince - 1 to 3 Years
Location - Chennai

Apply Link -
https://unstop.com/o/KziQcS9?lb=8eEx09ow&utm_medium=Share&utm_source=shortUrl

Free courses/Tutorials for learning.


https://www.instagram.com/reel/C7l7mRbP5-W/?igsh=MWMzejVyM3cxcHR3ag==

Company name :6sense
Job role :Data Analyst II
Job type :Full-time · Entry level
Location : Pune
Qualifications:

Bachelor’s degree in a technical or math-based discipline, or equivalent practical experience required
Minimum of 2 years of data analytics experience
Hands-on experience of advanced SQL (window functions, CTEs, etc.)
Experience working with a BI tool like such as Tableau, Chartio or Looker
Some hands-on experience with data pipelines and/or ETL processes is an added benefit


https://boards.greenhouse.io/embed/job_app?token=5962614

✅Follow @codingdidi

Learning how to use AI TOOL is essential in 2024.

Here's the link 🔗 for chatgpt prompts.

https://drive.google.com/file/d/1NPaJYHjHK5Youo-4utE36SuqaJi8ni4j/view?usp=sharing


Follow ✅ @codingdidi

Data analyst scenario based questions!


🔗 Link
https://docs.google.com/document/d/1YOry3-u3PSq6d6-H9yoWJLeDbpfl3bTtAvs9dM0Vlxc/edit?usp=drivesdk


Share with credit @codingdidi.

What is web scrapping?

https://youtu.be/gyGHvSJ6RRE?si=LNcGM5TXenWZAzok

Here's the pdf for Data science interview questions!!


https://drive.google.com/file/d/1MfhGorMBXNAj7iHdgYO7ai0Knn8Enma9/view?usp=drive_link


👍Like for more posts like these ✅

❤️Follow @Codingdidi

Exciting Opportunities at Google Bangalore

Google Play Strategy & Analytics org is expanding in India, and the team is on the lookout for talented individuals to shape the future of Google Play Store. With a focus on developing and interpreting recommendations from data, the team works on a variety of challenging data science projects to drive product decisions and strategic planning for Play.

You can be a part of this journey of transformation and build world class systems! Explore and apply for open roles through the links below:

Head of Analytics: https://www.google.com/about/careers/applications/jobs/results/133671594995131078/?src=Online/Social/Googler_share&utm_medium=googler-share&utm_source=social

Product Data Scientist: https://www.google.com/about/careers/applications/jobs/results/132185041309442758/?src=Online/Social/Googler_share&utm_medium=googler-share&utm_source=social

Business Intelligence Analyst: https://www.google.com/about/careers/applications/jobs/results/85159434728153798/?src=Online/Social/Googler_share&utm_medium=googler-share&utm_source=social

FREE REMOTE VIRTUAL INTERNSHIPS

Apply and boost your career with:
The Sparks Foundation Virtual Internship
Join the Data Science and Business Analytics program provided by


✅ The Sparks Foundation:

https://internship.thesparksfoundation.info/


✅KPMG AU Data Analytics Virtual Experience Program

https://www.theforage.com/virtual-internships/theme/m7W4GMqeT3bh9Nb2c/KPMG-Data-Analytics-Virtual-Internship


✅ LetsGrowMore Data Science

Virtual Program
https://letsgrowmore.in/vip/


Follow @codingdidi ❤️

Learn how to extract the data from .com websites and create a basic game on the same extracted data..



Here is the link 🔗

https://youtu.be/r_q4NzjpTrA?si=kpFSsCkYl7EV8bKU

Don't forget to comment your view on the video.