โค3๐3
๐๐ฟ๐ฒ ๐ฌ๐ผ๐ ๐ฆ๐ธ๐ถ๐ฝ๐ฝ๐ถ๐ป๐ด ๐ง๐ต๐ถ๐ ๐๐บ๐ฝ๐ผ๐ฟ๐๐ฎ๐ป๐ ๐ฆ๐๐ฒ๐ฝ ๐ช๐ต๐ฒ๐ป ๐ช๐ฟ๐ถ๐๐ถ๐ป๐ด ๐ฆ๐ค๐ ๐ค๐๐ฒ๐ฟ๐ถ๐ฒ๐?
๐ง๐ต๐ถ๐ป๐ธ ๐๐ผ๐๐ฟ ๐ฆ๐ค๐ ๐พ๐๐ฒ๐ฟ๐ถ๐ฒ๐ ๐ฎ๐ฟ๐ฒ ๐ฒ๐ณ๐ณ๐ถ๐ฐ๐ถ๐ฒ๐ป๐? ๐ฌ๐ผ๐ ๐บ๐ถ๐ด๐ต๐ ๐ฏ๐ฒ ๐๐ธ๐ถ๐ฝ๐ฝ๐ถ๐ป๐ด ๐๐ต๐ถ๐!
Hi everyone! Writing SQL queries can be tricky, especially if you forget to include one key part: indexing.
When I first started writing SQL queries, I didnโt pay much attention to indexing. My queries worked, but they took way longer to run.
Hereโs why indexing is so important:
- ๐ช๐ต๐ฎ๐ ๐๐ ๐๐ป๐ฑ๐ฒ๐ ๐ถ๐ป๐ด?: Indexing is like creating a shortcut for your database to find the data you need faster. Without it, your database might have to scan through all the data, making your queries slow.
- ๐ช๐ต๐ ๐๐ ๐ ๐ฎ๐๐๐ฒ๐ฟ๐: If your query takes too long, it can slow down your entire system. Adding the right indexes helps your queries run faster and more efficiently.
- ๐๐ผ๐ ๐๐ผ ๐จ๐๐ฒ ๐๐ป๐ฑ๐ฒ๐ ๐ฒ๐: When you create a table, consider which columns are used often in WHERE clauses or JOIN conditions. Index those columns to speed up your queries.
Indexing is a simple step that can make a big difference in performance. Donโt skip it!
Like this post if you need more ๐โค๏ธ
Hope it helps :)
๐ง๐ต๐ถ๐ป๐ธ ๐๐ผ๐๐ฟ ๐ฆ๐ค๐ ๐พ๐๐ฒ๐ฟ๐ถ๐ฒ๐ ๐ฎ๐ฟ๐ฒ ๐ฒ๐ณ๐ณ๐ถ๐ฐ๐ถ๐ฒ๐ป๐? ๐ฌ๐ผ๐ ๐บ๐ถ๐ด๐ต๐ ๐ฏ๐ฒ ๐๐ธ๐ถ๐ฝ๐ฝ๐ถ๐ป๐ด ๐๐ต๐ถ๐!
Hi everyone! Writing SQL queries can be tricky, especially if you forget to include one key part: indexing.
When I first started writing SQL queries, I didnโt pay much attention to indexing. My queries worked, but they took way longer to run.
Hereโs why indexing is so important:
- ๐ช๐ต๐ฎ๐ ๐๐ ๐๐ป๐ฑ๐ฒ๐ ๐ถ๐ป๐ด?: Indexing is like creating a shortcut for your database to find the data you need faster. Without it, your database might have to scan through all the data, making your queries slow.
- ๐ช๐ต๐ ๐๐ ๐ ๐ฎ๐๐๐ฒ๐ฟ๐: If your query takes too long, it can slow down your entire system. Adding the right indexes helps your queries run faster and more efficiently.
- ๐๐ผ๐ ๐๐ผ ๐จ๐๐ฒ ๐๐ป๐ฑ๐ฒ๐ ๐ฒ๐: When you create a table, consider which columns are used often in WHERE clauses or JOIN conditions. Index those columns to speed up your queries.
Indexing is a simple step that can make a big difference in performance. Donโt skip it!
Like this post if you need more ๐โค๏ธ
Hope it helps :)
๐7
Ashley Global Capability Center
Ashley GCC is currently seeking Business Intelligence professionals with 3-10 years of experience. If you are skilled in SQL, Power BI, Tableau, Excel, Python, Azure Synapse, Databricks, and Spark, If you feel you have the necessary skill sets and are passionate about the job, please send your profile to
vthulasiram@ashleyfurnitureindia.com.
The job location is Chennai.
Ashley GCC is currently seeking Business Intelligence professionals with 3-10 years of experience. If you are skilled in SQL, Power BI, Tableau, Excel, Python, Azure Synapse, Databricks, and Spark, If you feel you have the necessary skill sets and are passionate about the job, please send your profile to
vthulasiram@ashleyfurnitureindia.com.
The job location is Chennai.
Deloitte is hiring!
Position: Associate Analyst/ Analyst
Qualification: Bachelorโs/ Masterโs Degree
Salary: 5 - 8.6 LPA (Expected)
Experienc๏ปฟe: 0 - 2 (Years)
Location: Hyderabad, India (Work From Home/ Office)
๐Apply Now: https://usijobs.deloitte.com/careersUSI/JobDetail/USI-EH25-Global-CoRe-KS-KX-Assets-Spanish-Analyst/192347
https://usijobs.deloitte.com/careersUSI/JobDetail/USI-EH-FY25-EA-MF-CA-CBS-Admin-Shared-Services-Analyst-Associate-Analyst/191991
Like for more โค๏ธ
All the best ๐๐
Position: Associate Analyst/ Analyst
Qualification: Bachelorโs/ Masterโs Degree
Salary: 5 - 8.6 LPA (Expected)
Experienc๏ปฟe: 0 - 2 (Years)
Location: Hyderabad, India (Work From Home/ Office)
๐Apply Now: https://usijobs.deloitte.com/careersUSI/JobDetail/USI-EH25-Global-CoRe-KS-KX-Assets-Spanish-Analyst/192347
https://usijobs.deloitte.com/careersUSI/JobDetail/USI-EH-FY25-EA-MF-CA-CBS-Admin-Shared-Services-Analyst-Associate-Analyst/191991
Like for more โค๏ธ
All the best ๐๐
๐4
How to master Python from scratch๐
1. Setup and Basics ๐
- Install Python ๐ฅ๏ธ: Download Python and set it up.
- Hello, World! ๐: Write your first Hello World program.
2. Basic Syntax ๐
- Variables and Data Types ๐: Learn about strings, integers, floats, and booleans.
- Control Structures ๐: Understand if-else statements, for loops, and while loops.
- Functions ๐ ๏ธ: Write reusable blocks of code.
3. Data Structures ๐
- Lists ๐: Manage collections of items.
- Dictionaries ๐: Store key-value pairs.
- Tuples ๐ฆ: Work with immutable sequences.
- Sets ๐ข: Handle collections of unique items.
4. Modules and Packages ๐ฆ
- Standard Library ๐: Explore built-in modules.
- Third-Party Packages ๐: Install and use packages with pip.
5. File Handling ๐
- Read and Write Files ๐
- CSV and JSON ๐
6. Object-Oriented Programming ๐งฉ
- Classes and Objects ๐๏ธ
- Inheritance and Polymorphism ๐จโ๐ฉโ๐ง
7. Web Development ๐
- Flask ๐ผ: Start with a micro web framework.
- Django ๐ฆ: Dive into a full-fledged web framework.
8. Data Science and Machine Learning ๐ง
- NumPy ๐: Numerical operations.
- Pandas ๐ผ: Data manipulation and analysis.
- Matplotlib ๐ and Seaborn ๐: Data visualization.
- Scikit-learn ๐ค: Machine learning.
9. Automation and Scripting ๐ค
- Automate Tasks ๐ ๏ธ: Use Python to automate repetitive tasks.
- APIs ๐: Interact with web services.
10. Testing and Debugging ๐
- Unit Testing ๐งช: Write tests for your code.
- Debugging ๐: Learn to debug efficiently.
11. Advanced Topics ๐
- Concurrency and Parallelism ๐
- Decorators ๐ and Generators โ๏ธ
- Web Scraping ๐ธ๏ธ: Extract data from websites using BeautifulSoup and Scrapy.
12. Practice Projects ๐ก
- Calculator ๐งฎ
- To-Do List App ๐
- Weather App โ๏ธ
- Personal Blog ๐
13. Community and Collaboration ๐ค
- Contribute to Open Source ๐
- Join Coding Communities ๐ฌ
- Participate in Hackathons ๐
14. Keep Learning and Improving ๐
- Read Books ๐: Like "Automate the Boring Stuff with Python".
- Watch Tutorials ๐ฅ: Follow video courses and tutorials.
- Solve Challenges ๐งฉ: On platforms like LeetCode, HackerRank, and CodeWars.
15. Teach and Share Knowledge ๐ข
- Write Blogs โ๏ธ
- Create Video Tutorials ๐น
- Mentor Others ๐จโ๐ซ
Hope you'll like it
Like this post if you need more resources like this ๐โค๏ธ
1. Setup and Basics ๐
- Install Python ๐ฅ๏ธ: Download Python and set it up.
- Hello, World! ๐: Write your first Hello World program.
2. Basic Syntax ๐
- Variables and Data Types ๐: Learn about strings, integers, floats, and booleans.
- Control Structures ๐: Understand if-else statements, for loops, and while loops.
- Functions ๐ ๏ธ: Write reusable blocks of code.
3. Data Structures ๐
- Lists ๐: Manage collections of items.
- Dictionaries ๐: Store key-value pairs.
- Tuples ๐ฆ: Work with immutable sequences.
- Sets ๐ข: Handle collections of unique items.
4. Modules and Packages ๐ฆ
- Standard Library ๐: Explore built-in modules.
- Third-Party Packages ๐: Install and use packages with pip.
5. File Handling ๐
- Read and Write Files ๐
- CSV and JSON ๐
6. Object-Oriented Programming ๐งฉ
- Classes and Objects ๐๏ธ
- Inheritance and Polymorphism ๐จโ๐ฉโ๐ง
7. Web Development ๐
- Flask ๐ผ: Start with a micro web framework.
- Django ๐ฆ: Dive into a full-fledged web framework.
8. Data Science and Machine Learning ๐ง
- NumPy ๐: Numerical operations.
- Pandas ๐ผ: Data manipulation and analysis.
- Matplotlib ๐ and Seaborn ๐: Data visualization.
- Scikit-learn ๐ค: Machine learning.
9. Automation and Scripting ๐ค
- Automate Tasks ๐ ๏ธ: Use Python to automate repetitive tasks.
- APIs ๐: Interact with web services.
10. Testing and Debugging ๐
- Unit Testing ๐งช: Write tests for your code.
- Debugging ๐: Learn to debug efficiently.
11. Advanced Topics ๐
- Concurrency and Parallelism ๐
- Decorators ๐ and Generators โ๏ธ
- Web Scraping ๐ธ๏ธ: Extract data from websites using BeautifulSoup and Scrapy.
12. Practice Projects ๐ก
- Calculator ๐งฎ
- To-Do List App ๐
- Weather App โ๏ธ
- Personal Blog ๐
13. Community and Collaboration ๐ค
- Contribute to Open Source ๐
- Join Coding Communities ๐ฌ
- Participate in Hackathons ๐
14. Keep Learning and Improving ๐
- Read Books ๐: Like "Automate the Boring Stuff with Python".
- Watch Tutorials ๐ฅ: Follow video courses and tutorials.
- Solve Challenges ๐งฉ: On platforms like LeetCode, HackerRank, and CodeWars.
15. Teach and Share Knowledge ๐ข
- Write Blogs โ๏ธ
- Create Video Tutorials ๐น
- Mentor Others ๐จโ๐ซ
Hope you'll like it
Like this post if you need more resources like this ๐โค๏ธ
๐16
If this helps.
Don't forget to comment.
https://www.linkedin.com/pulse/how-can-you-build-personal-brand-become-thought-leader-akansha-yadav-71qvc?utm_source=share&utm_medium=member_android&utm_campaign=share_via
๐!! ๐๐ป
Don't forget to comment.
https://www.linkedin.com/pulse/how-can-you-build-personal-brand-become-thought-leader-akansha-yadav-71qvc?utm_source=share&utm_medium=member_android&utm_campaign=share_via
๐!! ๐๐ป
Linkedin
How can you build a personal brand and become a thought leader as a mid-career Data Scientist?
Here's how you can achieve it. 1.
๐2
Here's the link for the complete pdf of 100 pages, for those who want to learn statistics for FREE for Machine Learning role.
https://topmate.io/codingdidi/1177807
๐๐โ
https://www.instagram.com/reel/C_M7GNXyHFk/?utm_source=ig_web_copy_link&igsh=MzRlODBiNWFlZA==
https://topmate.io/codingdidi/1177807
๐๐โ
https://www.instagram.com/reel/C_M7GNXyHFk/?utm_source=ig_web_copy_link&igsh=MzRlODBiNWFlZA==
topmate.io
Statistics for Machine Learning with Codingdidi
Complete statistics notes for data science
โค1๐1
Many people reached out to me saying telegram may get banned in their countries. So I've decided to create WhatsApp channel ๐๐
Follow the CODING DIDI channel on WhatsApp:
https://whatsapp.com/channel/0029VaiVMpH2kNFyMWeMDV2Z
Donโt worry Guys your contact number will stay hidden!
ENJOY LEARNING ๐๐
Follow the CODING DIDI channel on WhatsApp:
https://whatsapp.com/channel/0029VaiVMpH2kNFyMWeMDV2Z
Donโt worry Guys your contact number will stay hidden!
ENJOY LEARNING ๐๐
WhatsApp.com
CODING DIDI | WhatsApp Channel
CODING DIDI WhatsApp Channel. I will provide free resources, for learning machine learning, data analytics, data science and many more in the AI domain. 0 followers
This media is not supported in your browser
VIEW IN TELEGRAM
๐จHere's an opportunity for youโ ๏ธ
*Webinar highlights:-*
โ Data acquisition
โ Data cleaning
โ Data analysis
โ Data visualization
โ Dashboard creation
โ Story creation
*Tools that will be covered in the webinar:-*
๐๐ปPython
๐๐ปMysql
๐๐ปPowerbi
*Goal of the webinar:-*
โ A complete data analyst project.
โ A good decision maker.
โ Practical real world project.
*ADD ONS*:-
- Pandas notes ๐๏ธ which is worth rupees 299/-
- Statistics notes
- โ Power BI guide
- โ Data analysis notes
- โ Sql notes
- โ Power Bi 7 days live session access, early bird access.
*Highlights*:-
- 3 hours live session.
- access to the recording for 2 months
*Here's how you can enroll!!*
- Pay 249/- INR
- Fill out the Google form.
*Date:-* 22nd sept 2024
*Timing:-* 7 pm - 10 pm IST
*Webinar highlights:-*
โ Data acquisition
โ Data cleaning
โ Data analysis
โ Data visualization
โ Dashboard creation
โ Story creation
*Tools that will be covered in the webinar:-*
๐๐ปPython
๐๐ปMysql
๐๐ปPowerbi
*Goal of the webinar:-*
โ A complete data analyst project.
โ A good decision maker.
โ Practical real world project.
*ADD ONS*:-
- Pandas notes ๐๏ธ which is worth rupees 299/-
- Statistics notes
- โ Power BI guide
- โ Data analysis notes
- โ Sql notes
- โ Power Bi 7 days live session access, early bird access.
*Highlights*:-
- 3 hours live session.
- access to the recording for 2 months
*Here's how you can enroll!!*
- Pay 249/- INR
- Fill out the Google form.
*Date:-* 22nd sept 2024
*Timing:-* 7 pm - 10 pm IST
๐2
FREE RESOURCES TO LEARN PYTHON
๐๐
Free Udacity Course to learn Python
https://imp.i115008.net/5bK93j
Data Structure and OOPS in Python Free Courses
https://bit.ly/3t1WEBt
Free Certified Python course by Freecodecamp
https://www.freecodecamp.org/learn/scientific-computing-with-python/
Free Python Course from Google
https://developers.google.com/edu/python
Free Python Tutorials from Kaggle
https://www.kaggle.com/learn/python
Python hands-on Project
https://t.me/Programming_experts/23
Free Python Books Collection
https://cfm.ehu.es/ricardo/docs/python/Learning_Python.pdf
https://static.realpython.com/python-basics-sample-chapters.pdf
๐จโ๐ปWebsites to Practice Python
1. http://codingbat.com/python
2. https://www.hackerrank.com/
3. https://www.hackerearth.com/practice/
4. https://projecteuler.net/archives
5. http://www.codeabbey.com/index/task_list
6. http://www.pythonchallenge.com/
Beginner's guide to Python Free Book
https://t.me/pythondevelopersindia/144
Official Documentation
https://docs.python.org/3/
ENJOY LEARNING ๐๐
๐๐
Free Udacity Course to learn Python
https://imp.i115008.net/5bK93j
Data Structure and OOPS in Python Free Courses
https://bit.ly/3t1WEBt
Free Certified Python course by Freecodecamp
https://www.freecodecamp.org/learn/scientific-computing-with-python/
Free Python Course from Google
https://developers.google.com/edu/python
Free Python Tutorials from Kaggle
https://www.kaggle.com/learn/python
Python hands-on Project
https://t.me/Programming_experts/23
Free Python Books Collection
https://cfm.ehu.es/ricardo/docs/python/Learning_Python.pdf
https://static.realpython.com/python-basics-sample-chapters.pdf
๐จโ๐ปWebsites to Practice Python
1. http://codingbat.com/python
2. https://www.hackerrank.com/
3. https://www.hackerearth.com/practice/
4. https://projecteuler.net/archives
5. http://www.codeabbey.com/index/task_list
6. http://www.pythonchallenge.com/
Beginner's guide to Python Free Book
https://t.me/pythondevelopersindia/144
Official Documentation
https://docs.python.org/3/
ENJOY LEARNING ๐๐
๐4