@Codingdidi
9.45K subscribers
26 photos
7 videos
47 files
257 links
Free learning Resources For Data Analysts, Data science, ML, AI, GEN AI and Job updates, career growth, Tech updates
Download Telegram
๐—”๐—ฟ๐—ฒ ๐—ฌ๐—ผ๐˜‚ ๐—ฆ๐—ธ๐—ถ๐—ฝ๐—ฝ๐—ถ๐—ป๐—ด ๐—ง๐—ต๐—ถ๐˜€ ๐—œ๐—บ๐—ฝ๐—ผ๐—ฟ๐˜๐—ฎ๐—ป๐˜ ๐—ฆ๐˜๐—ฒ๐—ฝ ๐—ช๐—ต๐—ฒ๐—ป ๐—ช๐—ฟ๐—ถ๐˜๐—ถ๐—ป๐—ด ๐—ฆ๐—ค๐—Ÿ ๐—ค๐˜‚๐—ฒ๐—ฟ๐—ถ๐—ฒ๐˜€?

๐—ง๐—ต๐—ถ๐—ป๐—ธ ๐˜†๐—ผ๐˜‚๐—ฟ ๐—ฆ๐—ค๐—Ÿ ๐—พ๐˜‚๐—ฒ๐—ฟ๐—ถ๐—ฒ๐˜€ ๐—ฎ๐—ฟ๐—ฒ ๐—ฒ๐—ณ๐—ณ๐—ถ๐—ฐ๐—ถ๐—ฒ๐—ป๐˜? ๐—ฌ๐—ผ๐˜‚ ๐—บ๐—ถ๐—ด๐—ต๐˜ ๐—ฏ๐—ฒ ๐˜€๐—ธ๐—ถ๐—ฝ๐—ฝ๐—ถ๐—ป๐—ด ๐˜๐—ต๐—ถ๐˜€!

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.
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 ๐Ÿ‘๐Ÿ‘
๐Ÿ‘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 ๐Ÿ‘โค๏ธ
๐Ÿ‘16