๐ฏ 5 Playlists = 5 courses ๐
1/ Generative AI (freecodecamp): https://youtu.be/mEsleV16qdo?si=PgiaT2kx43xMI78O
2/ Machine Learning (freecodecamp): https://youtu.be/i_LwzRVP7bg?si=iQfXCjLOSLYfVukE
3/ Ethical Hacking: https://youtu.be/Rgvzt0D8bR4?si=W5lskoyT88a18ppU
4/ Data Analytics (WSCube Tech): https://youtu.be/VaSjiJMrq24?si=ipirg6bbI68w7YeF
3/ Cyber Security (WSCube): https://youtu.be/Zdk01t_VTOA?si=MAKJccpTvKrvQ8Td
1/ Generative AI (freecodecamp): https://youtu.be/mEsleV16qdo?si=PgiaT2kx43xMI78O
2/ Machine Learning (freecodecamp): https://youtu.be/i_LwzRVP7bg?si=iQfXCjLOSLYfVukE
3/ Ethical Hacking: https://youtu.be/Rgvzt0D8bR4?si=W5lskoyT88a18ppU
4/ Data Analytics (WSCube Tech): https://youtu.be/VaSjiJMrq24?si=ipirg6bbI68w7YeF
3/ Cyber Security (WSCube): https://youtu.be/Zdk01t_VTOA?si=MAKJccpTvKrvQ8Td
โค5
GigaChat 3.5 Ultra Publicly Released โ The New Generation of the Flagship Model
Whatโs inside:
๐ A proprietary hybrid MLA + Gated DeltaNet architecture with a dedicated stabilization framework, without which this hybrid setup would not train reliably at this scale;
๐ Gated Attention: the model can locally down-weight overly strong signals from the attention layer;
๐ GatedNorm: normalization with an explicit gate that controls signal magnitude across features;
๐ Approximately 4x lower KV cache per token: with the same memory budget, the model can support 2.14x longer context and deliver a 20% throughput increase under load;
๐ Two MTP heads, enabling up to 2.2x faster generation;
๐ FP8 across all training stages with no quality degradation compared with bf16, enabled by custom Triton and CUDA kernels;
๐ A new online RL stage after SFT and DPO.
Results:
๐ GigaChat-3.5-Ultra-Base outperforms DeepSeek V3.2 Exp Base and DeepSeek V4 Flash Base on average across a set of general, math, and code benchmarks:
๐ GigaChat-3.5-Ultra-Instruct is comparable to DeepSeek V3.2 in terms of average score, despite having half the size;
๐ According to the MiniMax-M2.7 LLM judge, the average win rate against GigaChat 3.1 Ultra is 75.9%, and against GPT-5 is 68.7%.
โก๏ธ HuggingFace
The GigaChat team has released GigaChat 3.5 Ultra as open sourceโa new 432B model under the MIT license. This is the first open-source hybrid of GatedDeltaNet and MLA scaled to hundreds of billions of parameters, featuring a proprietary training recipe we refined through more than 1,500 experiments. The model has grown in terms of code, mathematics, agent scenarios, and application domainsโyet itโs 40% smaller than GigaChat 3.1 Ultra.
Whatโs inside:
Results:
The entire stack โ data (our own LLM-filtered Common Crawl, 600+ programming languages in the code), architecture, training methodology, and infrastructure โ was built end-to-end by GigaChat team.
Please open Telegram to view this post
VIEW IN TELEGRAM
โค3
๐ Frequently Asked Pandas Interview Questions (Beginner Level)
1๏ธโฃ What is the difference between a Series and a DataFrame?
๐ก Answer:
Series โ A one-dimensional labeled array.
DataFrame โ A two-dimensional table with rows and columns.
2๏ธโฃ How do you find missing
values in a DataFrame?
๐ก Answer:
3๏ธโฃ What is the difference between loc and iloc?
๐ก Answer:
4๏ธโฃ What is the difference between merge() and concat()?
๐ก Answer:
React โฅ๏ธ for more interview questions
1๏ธโฃ What is the difference between a Series and a DataFrame?
๐ก Answer:
Series โ A one-dimensional labeled array.
DataFrame โ A two-dimensional table with rows and columns.
2๏ธโฃ How do you find missing
values in a DataFrame?
๐ก Answer:
df.isnull().sum()
This returns the number of missing values in each column.3๏ธโฃ What is the difference between loc and iloc?
๐ก Answer:
loc โ Label-based indexing.iloc โ Integer position-based indexing.4๏ธโฃ What is the difference between merge() and concat()?
๐ก Answer:
merge() combines DataFrames using a common key (similar to an SQL JOIN).concat() combines DataFrames by stacking them vertically or horizontally.React โฅ๏ธ for more interview questions
โค10
Aaj hi ek certified Hackar bano!๐ป
Shuru se saari cheeze seekho bilkul basic se!!
PW skills leke aaya h certified Ethical Hacking ka course!!
Isme milega :
โ Hands on Practice
โ LIVE Hacking Labs
โ Certificate after Completion
Sirf Rs 4999 mai
Abhi enroll karo HACK30 Coupon code use karke 30% OFF milega!
Enroll NOW : https://pwskills.com/web-development/certified-ethical-hacking-course-035473/?source=pwskills.com&position=course_dropdown&from=home_page&utm_source=pwskills&utm_medium=telegram&utm_campaign=ethical_hacking
Shuru se saari cheeze seekho bilkul basic se!!
PW skills leke aaya h certified Ethical Hacking ka course!!
Isme milega :
โ Hands on Practice
โ LIVE Hacking Labs
โ Certificate after Completion
Sirf Rs 4999 mai
Abhi enroll karo HACK30 Coupon code use karke 30% OFF milega!
Enroll NOW : https://pwskills.com/web-development/certified-ethical-hacking-course-035473/?source=pwskills.com&position=course_dropdown&from=home_page&utm_source=pwskills&utm_medium=telegram&utm_campaign=ethical_hacking
โค3
๐ How to Land a Data Analyst Job Without Experience?
Many people asked me this question, so I thought to answer it here to help everyone. Here is the step-by-step approach i would recommend:
โ Step 1: Master the Essential Skills
You need to build a strong foundation in:
๐น SQL โ Learn how to extract and manipulate data
๐น Excel โ Master formulas, Pivot Tables, and dashboards
๐น Python โ Focus on Pandas, NumPy, and Matplotlib for data analysis
๐น Power BI/Tableau โ Learn to create interactive dashboards
๐น Statistics & Business Acumen โ Understand data trends and insights
Where to learn?
๐ Google Data Analytics Course
๐ SQL โ Mode Analytics (Free)
๐ Python โ Kaggle or DataCamp
โ Step 2: Work on Real-World Projects
Employers care more about what you can do rather than just your degree. Build 3-4 projects to showcase your skills.
๐น Project Ideas:
โ Analyze sales data to find profitable products
โ Clean messy datasets using SQL or Python
โ Build an interactive Power BI dashboard
โ Predict customer churn using machine learning (optional)
Use Kaggle, Data.gov, or Google Dataset Search to find free datasets!
โ Step 3: Build an Impressive Portfolio
Once you have projects, showcase them! Create:
๐ A GitHub repository to store your SQL/Python code
๐ A Tableau or Power BI Public Profile for dashboards
๐ A Medium or LinkedIn post explaining your projects
A strong portfolio = More job opportunities! ๐ก
โ Step 4: Get Hands-On Experience
If you donโt have experience, create your own!
๐ Do freelance projects on Upwork/Fiverr
๐ Join an internship or volunteer for NGOs
๐ Participate in Kaggle competitions
๐ Contribute to open-source projects
Real-world practice > Theoretical knowledge!
โ Step 5: Optimize Your Resume & LinkedIn Profile
Your resume should highlight:
โ๏ธ Skills (SQL, Python, Power BI, etc.)
โ๏ธ Projects (Brief descriptions with links)
โ๏ธ Certifications (Google Data Analytics, Coursera, etc.)
Bonus Tip:
๐น Write "Data Analyst in Training" on LinkedIn
๐น Start posting insights from your learning journey
๐น Engage with recruiters & join LinkedIn groups
โ Step 6: Start Applying for Jobs
Donโt wait for the perfect jobโstart applying!
๐ Apply on LinkedIn, Indeed, and company websites
๐ Network with professionals in the industry
๐ Be ready for SQL & Excel assessments
Pro Tip: Even if you donโt meet 100% of the job requirements, apply anyway! Many companies are open to hiring self-taught analysts.
You donโt need a fancy degree to become a Data Analyst. Skills + Projects + Networking = Your job offer!
๐ฅ Your Challenge: Start your first project today and track your progress!
Share with credits: https://t.me/sqlspecialist
Hope it helps :)
Many people asked me this question, so I thought to answer it here to help everyone. Here is the step-by-step approach i would recommend:
โ Step 1: Master the Essential Skills
You need to build a strong foundation in:
๐น SQL โ Learn how to extract and manipulate data
๐น Excel โ Master formulas, Pivot Tables, and dashboards
๐น Python โ Focus on Pandas, NumPy, and Matplotlib for data analysis
๐น Power BI/Tableau โ Learn to create interactive dashboards
๐น Statistics & Business Acumen โ Understand data trends and insights
Where to learn?
๐ Google Data Analytics Course
๐ SQL โ Mode Analytics (Free)
๐ Python โ Kaggle or DataCamp
โ Step 2: Work on Real-World Projects
Employers care more about what you can do rather than just your degree. Build 3-4 projects to showcase your skills.
๐น Project Ideas:
โ Analyze sales data to find profitable products
โ Clean messy datasets using SQL or Python
โ Build an interactive Power BI dashboard
โ Predict customer churn using machine learning (optional)
Use Kaggle, Data.gov, or Google Dataset Search to find free datasets!
โ Step 3: Build an Impressive Portfolio
Once you have projects, showcase them! Create:
๐ A GitHub repository to store your SQL/Python code
๐ A Tableau or Power BI Public Profile for dashboards
๐ A Medium or LinkedIn post explaining your projects
A strong portfolio = More job opportunities! ๐ก
โ Step 4: Get Hands-On Experience
If you donโt have experience, create your own!
๐ Do freelance projects on Upwork/Fiverr
๐ Join an internship or volunteer for NGOs
๐ Participate in Kaggle competitions
๐ Contribute to open-source projects
Real-world practice > Theoretical knowledge!
โ Step 5: Optimize Your Resume & LinkedIn Profile
Your resume should highlight:
โ๏ธ Skills (SQL, Python, Power BI, etc.)
โ๏ธ Projects (Brief descriptions with links)
โ๏ธ Certifications (Google Data Analytics, Coursera, etc.)
Bonus Tip:
๐น Write "Data Analyst in Training" on LinkedIn
๐น Start posting insights from your learning journey
๐น Engage with recruiters & join LinkedIn groups
โ Step 6: Start Applying for Jobs
Donโt wait for the perfect jobโstart applying!
๐ Apply on LinkedIn, Indeed, and company websites
๐ Network with professionals in the industry
๐ Be ready for SQL & Excel assessments
Pro Tip: Even if you donโt meet 100% of the job requirements, apply anyway! Many companies are open to hiring self-taught analysts.
You donโt need a fancy degree to become a Data Analyst. Skills + Projects + Networking = Your job offer!
๐ฅ Your Challenge: Start your first project today and track your progress!
Share with credits: https://t.me/sqlspecialist
Hope it helps :)
โค7
๐๐ข๐ฉ๐ฌ ๐๐จ๐ซ ๐๐ฒ๐ญ๐ก๐จ๐ง ๐๐จ๐๐ข๐ง๐ ๐ข๐ง ๐๐๐ญ๐ ๐๐ง๐๐ฅ๐ฒ๐ญ๐ข๐๐ฌ:
๐ ๐จ๐ฆ๐ต ๐ด๐ฐ ๐ฎ๐ข๐ฏ๐บ ๐ฒ๐ถ๐ฆ๐ด๐ต๐ช๐ฐ๐ฏ๐ด ๐ง๐ณ๐ฐ๐ฎ ๐ฅ๐ข๐ต๐ข ๐ข๐ฏ๐ข๐ญ๐บ๐ต๐ช๐ค๐ด ๐ข๐ด๐ฑ๐ช๐ณ๐ข๐ฏ๐ต๐ด ๐ข๐ฏ๐ฅ ๐ฑ๐ณ๐ฐ๐ง๐ฆ๐ด๐ด๐ช๐ฐ๐ฏ๐ข๐ญ๐ด ๐ฐ๐ฏ ๐ฉ๐ฐ๐ธ ๐ต๐ฐ ๐จ๐ข๐ช๐ฏ ๐ค๐ฐ๐ฎ๐ฎ๐ข๐ฏ๐ฅ ๐ฐ๐ง ๐๐บ๐ต๐ฉ๐ฐ๐ฏ.
๐๐๐๐๐ซ๐ง ๐๐จ๐ซ๐ ๐๐ฒ๐ญ๐ก๐จ๐ง ๐๐ข๐๐ซ๐๐ซ๐ข๐๐ฌ: Master Python libraries for data analytics, like
-pandas for dataframes,
-NumPy for numerical operations,
-Matplotlib/Seaborn for plotting,
-scikit-learn for machine learning.
๐๐๐ง๐๐๐ซ๐ฌ๐ญ๐๐ง๐ ๐๐จ๐ง๐๐๐ฉ๐ญ๐ฌ: Important concepts like list comprehensions, lambda functions, object-oriented programming, and error handling to write efficient code.
๐๐๐ฌ๐ ๐๐ซ๐จ๐๐ฅ๐๐ฆ-๐๐จ๐ฅ๐ฏ๐ข๐ง๐ ๐๐๐ญ๐ก๐จ๐๐ฌ: Apply data wrangling techniques, efficient loops, and vectorized operations in NumPy/pandas for optimized performance.
๐๐๐จ ๐๐จ๐๐ค ๐๐ซ๐จ๐ฃ๐๐๐ญ๐ฌ: Work on end-to-end Python analytics projectsโdata loading, cleaning, analysis, and visualization.
๐๐๐๐๐ซ๐ง ๐๐ซ๐จ๐ฆ ๐๐๐ฌ๐ญ ๐๐ซ๐จ๐ฃ๐๐๐ญ๐ฌ: Review your previous Python projects to see where your code can be more efficient.
Like this post if you need more resources like this ๐โค๏ธ
๐ ๐จ๐ฆ๐ต ๐ด๐ฐ ๐ฎ๐ข๐ฏ๐บ ๐ฒ๐ถ๐ฆ๐ด๐ต๐ช๐ฐ๐ฏ๐ด ๐ง๐ณ๐ฐ๐ฎ ๐ฅ๐ข๐ต๐ข ๐ข๐ฏ๐ข๐ญ๐บ๐ต๐ช๐ค๐ด ๐ข๐ด๐ฑ๐ช๐ณ๐ข๐ฏ๐ต๐ด ๐ข๐ฏ๐ฅ ๐ฑ๐ณ๐ฐ๐ง๐ฆ๐ด๐ด๐ช๐ฐ๐ฏ๐ข๐ญ๐ด ๐ฐ๐ฏ ๐ฉ๐ฐ๐ธ ๐ต๐ฐ ๐จ๐ข๐ช๐ฏ ๐ค๐ฐ๐ฎ๐ฎ๐ข๐ฏ๐ฅ ๐ฐ๐ง ๐๐บ๐ต๐ฉ๐ฐ๐ฏ.
๐๐๐๐๐ซ๐ง ๐๐จ๐ซ๐ ๐๐ฒ๐ญ๐ก๐จ๐ง ๐๐ข๐๐ซ๐๐ซ๐ข๐๐ฌ: Master Python libraries for data analytics, like
-pandas for dataframes,
-NumPy for numerical operations,
-Matplotlib/Seaborn for plotting,
-scikit-learn for machine learning.
๐๐๐ง๐๐๐ซ๐ฌ๐ญ๐๐ง๐ ๐๐จ๐ง๐๐๐ฉ๐ญ๐ฌ: Important concepts like list comprehensions, lambda functions, object-oriented programming, and error handling to write efficient code.
๐๐๐ฌ๐ ๐๐ซ๐จ๐๐ฅ๐๐ฆ-๐๐จ๐ฅ๐ฏ๐ข๐ง๐ ๐๐๐ญ๐ก๐จ๐๐ฌ: Apply data wrangling techniques, efficient loops, and vectorized operations in NumPy/pandas for optimized performance.
๐๐๐จ ๐๐จ๐๐ค ๐๐ซ๐จ๐ฃ๐๐๐ญ๐ฌ: Work on end-to-end Python analytics projectsโdata loading, cleaning, analysis, and visualization.
๐๐๐๐๐ซ๐ง ๐๐ซ๐จ๐ฆ ๐๐๐ฌ๐ญ ๐๐ซ๐จ๐ฃ๐๐๐ญ๐ฌ: Review your previous Python projects to see where your code can be more efficient.
Like this post if you need more resources like this ๐โค๏ธ
โค5
If youโre a student, graduate, or someone looking for a career switch, read this.
Most people spend months watching random YouTube videos and still donโt become job-ready.
Instead, learn in a structured offline classroom.
๐ Data Analytics with GenAI
๐ Python + SQL + Power BI
๐ 6-Month Program
๐ 1:1 Mentorship
๐ Job Assistance
๐Now available in your city.
Seats are limited.
๐ Register Here: https://lp.pwskills.com/data-analytics-course-offline-batch0?utm_source=telegram&utm_medium=influencer&utm_campaign=daoffline
Most people spend months watching random YouTube videos and still donโt become job-ready.
Instead, learn in a structured offline classroom.
๐ Data Analytics with GenAI
๐ Python + SQL + Power BI
๐ 6-Month Program
๐ 1:1 Mentorship
๐ Job Assistance
๐Now available in your city.
Seats are limited.
๐ Register Here: https://lp.pwskills.com/data-analytics-course-offline-batch0?utm_source=telegram&utm_medium=influencer&utm_campaign=daoffline