🔥 Save Your time with these Shortcuts 🔥

Ctrl + A - Select All
Ctrl + B - Bold
Ctrl + C - Copy
Ctrl + D - Fill
Ctrl + F - Find
Ctrl + G - Find next instance of text
Ctrl + H - Replace
Ctrl + I - Italic
Ctrl + K - Insert a hyperlink
Ctrl + N - New workbook
Ctrl + O - Open
Ctrl + P - Print
Ctrl + R - Nothing right
Ctrl + S - Save
Ctrl + U - Underlined
Ctrl + V - Paste
Ctrl W - Close
Ctrl + X - Cut
Ctrl + Y - Repeat
Ctrl + Z - Cancel
F1 - Help
F2 - Edition
F3 - Paste the name
F4 - Repeat the last action
F5 - Goto
F6 - Next Pane
F7 - Spell Check
F8 - Extension of the mode
F9 - Recalculate all workbooks
F10 - Activate Menubar
F11 - New graph
F12 - Save As
Shift + F1 - What is it?
Shift + F2 - Edit cell comment
Shift + F3 - Paste the function into the formula
Shift + F4 - Search Next
Shift + F5 - Find
Shift + F6 - Previous Panel
Shift + F8 - Add to the selection
Shift + F9 - Calculate the active worksheet
Shift + F10 - Popup menu display
Shift + F11 - New spreadsheet
Shift + F12 - Save
Ctrl + F3 - Set name
Ctrl + F4 - Close
Ctrl + F5 - XL, size of the restore window
Ctrl + F6 - Next Workbook Window
Shift + Ctrl + F6 - Previous Workbook Window
Ctrl + F7 - Move window
Ctrl + F8 - Resize Window
Ctrl + F9 - Minimize the workbook
Ctrl + F10 - Maximize or Restore Window
Ctrl + F11 - Inset 4.0 Macro sheet
Ctrl + F1 - Open File
Alt + F1 - Insert a graph
Alt + F2 - Save As
Alt + F4 - Output
Alt + F8 - Macro dialog

Join for more
https://telegram.me/sign2tech

40 famous GitHub repos to help you pass software engineering job interviews:

𝗖𝗼𝗱𝗶𝗻𝗴 𝗮𝗻𝗱 𝗦𝘆𝘀𝘁𝗲𝗺 𝗗𝗲𝘀𝗶𝗴𝗻

1. Tech Interview Handbook:
https://lnkd.in/d2F5z4Af (by Yangshun Tay)

2. Guide to software engineering interviews:
https://lnkd.in/dm2MbsgD (by Kevin Naughton)

3. Coding Interview University:
https://lnkd.in/gydeNvaV

4. What Happens when you type google.com in browser:
https://lnkd.in/gbWkADQ6

5. 30 seconds of Code:
https://lnkd.in/g2MeSvmT

6. System Design Chapter Wise Explained:
https://lnkd.in/gtYDU8UD

7. Computer Science Papers for System Design by Arpit Adlakha (𝐀𝐮𝐭𝐡𝐨𝐫):
https://lnkd.in/gkxJ8QAM

8. Top System Design Resources by Gaurav Sen:
https://lnkd.in/dbjymD_2

9. All Resources for Coding, LLD and HLD interviews by Arpit Adlakha
https://lnkd.in/g8W4NrP5

10. Big Tech engineering tech blogs:
https://lnkd.in/dJaGjeES

11. System design primer:
https://lnkd.in/dkPScaCW (by Donne Martin)

12. Essential JS design patterns:
https://lnkd.in/dWmBwK-i (by Addy Osmani)

13. Awesome scalability:
https://lnkd.in/de4UZbiA

14. Awesome System Design Resources:
https://lnkd.in/dU6wFXkn (by Ashish Pratap Singh)

15. Coding Challenges solutions:
https://lnkd.in/dJV_8pgH (by John Crickett)


𝗟𝗟𝗠/𝗔𝗜:

16. Hands on LLM:
https://lnkd.in/dww8GPdt (by Paul Iusztin)

17. Papers we love:
https://lnkd.in/dkjsCq8z

18. Notes on AI for software engineers:
https://lnkd.in/dANSnC4f

19. LLM 101 course: '
https://lnkd.in/dVKwvVUR (by Maxime Labonne)

20. ML paper of the week:
https://lnkd.in/d66HxP52 (by Elvis S.)


𝗖𝗼𝗺𝗽𝗹𝗲𝘁𝗲 𝗿𝗼𝗮𝗱𝗺𝗮𝗽𝘀:

21. Path to senior engineer handbook:
https://lnkd.in/dC3dQvy6 (by Jordan Cutler)

22. 100+ Resources to become a great Engineering leader: https://lnkd.in/dFwV2GMv (by Gregor Ojstersek)

23. DevOps roadmap in 2024:
https://lnkd.in/ddE5DkDJ (by Dr Milan Milanović)

24. The Book of Secret Knowledge:
https://lnkd.in/d69jrK4T

25. Free programming books:
https://lnkd.in/d5JCRakw

26. The ultimate developer roadmap:
https://lnkd.in/dsCJgDnS (by Kamran Ahmed)


𝗙𝗿𝗼𝗻𝘁𝗲𝗻𝗱:

27. CSS for JS dev notes:
https://lnkd.in/dCNavrNv (by Tiger Abrodi)

28. Javascript Questions:
https://lnkd.in/dt_96xJZ (by Lydia Hallie)

29. Typescript advanced patterns workshop:
https://lnkd.in/deTBDhCb (by Matt Pocock)

30. You Don't know JS by Kyle Simpson:
https://lnkd.in/gXthz97k

𝗠𝗶𝘀𝗰𝗲𝗹𝗹𝗮𝗻𝗲𝗼𝘂𝘀

31) https://lnkd.in/e7SUQ3ei
32) https://lnkd.in/e7EjsJNF
33) https://lnkd.in/e9MuB_Yg
34) https://lnkd.in/exkJCxVi
35) https://lnkd.in/eXAzAJ3M
36) https://lnkd.in/eMzPM_rd
37) https://lnkd.in/e5Cv-hqb
38) https://lnkd.in/e_4pA8xV
39) https://lnkd.in/ePCzV3zF
40) https://lnkd.in/gxwTMhHh

Hidden Codes for Android👨🏻‍💻

*#06#- IMEI number

the*#0*#- Enter the service menu

*#*#4636#*#*- Phone information, usage statistics and battery

*#*#34971539#*#*- Detailed camera information

*#*#273282*255*663282*#*#*- Immediate backup of all media files

*#*#197328640#*#*- Enable test mode for service

*#*#232339#*#*-Wireless LAN tests

*#*#0842#*#*-Backlight/vibration test

*#*#2664#*#*-Test the touch screen

*#*#1111#*#*-FTA software version (1234 in the same code will give PDA and Firmware version)

*#12580*369#-Software and hardware info

*#9090#-Diagnostic configuration

*#872564#-USB logging control

*#9900#-System dump mode

*#301279#-HSDPA/HSUPA Control Menu

*#7465625#-View phone lock status

*#*#7780#*#*-Reset the/data partition to factory state

*2767*3855#-Format device to factory state (will delete everything on the phone)

##7764726-Hidden service

Join for More
https://whatsapp.com/channel/0029Va9pSbzBlHpU1fu6ff1Q

https://telegram.me/sign2tech

𝗢𝗿𝗮𝗰𝗹𝗲 𝗦𝗤𝗟 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲😍

Learn SQL in this FREE 12-part boot camp. It will help you get started with Oracle Database and SQL.

Complete the course to get your free certificate.

𝐋𝐢𝐧𝐤 👇:- 

https://whatsapp.com/channel/0029Va9pSbzBlHpU1fu6ff1Q/395

100+ YouTube channels you should subscribe now as per your need :

❯ HTML/CSS ➟ Kevin Powell
❯ C ➟ Jacob Sorber
❯ C++ ➟ TheCherno
❯ Java ➟ Telusko
❯ C# ➟ kudvenkat
❯ Python ➟ Corey Schafer
❯ JavaScript ➟ developedbyed
❯ SQL ➟ Joey Blue
❯ Golang ➟ Jon Calhoun
❯ Swift ➟ CodeWithChris
❯ Kotlin ➟ PhilippLackner
❯ PHP ➟ ProgramWithGio
❯ Ruby ➟ DriftingRuby
❯ Rust ➟ NoBoilerplate
❯ Lua ➟ Steve's teacher
❯ Scala ➟ DevInsideYou
❯ Julia ➟ TheJuliaLanguage
❯ MATLAB ➟ Joseph Delgadillo
❯ R ➟ marinstatlectures

❯ C++ ➟ javidx9
❯ C++ ➟ LearningLad
❯ C++ ➟ Trevor Payne
❯ JavaScript ➟ Akshay Saini
❯ TypeScript ➟ basarat
❯ TypeScript ➟ TypeScriptTV
❯ C# ➟ Microsoft Developer [Bob Tabor]
❯ C# ➟ dotnet [Scott/Kendra]
❯ SQL ➟ The Magic of SQL

-- Frameworks --

❯ Node.js ➟ Traversy Media
❯ React ➟ Codevolution
❯ React ➟ Dave Gray
❯ React ➟ Jack Herrington
❯ Next.js ➟ Lama Dev
❯ Vue ➟ Vue Mastery
❯ Svelte ➟ Joy of Code
❯ Angular ➟ Angular University
❯ Django ➟ CodingEntrepreneurs
❯ Laravel ➟ LaravelDaily
❯ Blazor ➟ James Montemagno
❯ Spring ➟ SpringSourceDev
❯ SpringBoot ➟ amigoscode
❯ Ruby on Rails ➟ GorailsTV

-- Mobile App --

❯ React Native ➟ Codevolution
❯ React Native ➟ Hitesh Choudhary
❯ Flutter ➟ The Flutter Way
❯ Flutter ➟ Tadas Petra

-- DSA --

❯ take U forward
❯ mycodeschool
❯ Abdul Bari
❯ Kunal Kushwaha
❯ Jenny's Lectures CS IT
❯ CodeWithHarry

-- Full Stack --

❯ Traversy Media
❯ NetNinja
❯ Dave Gray

❯ Projects
➟ WebDevSimplified
➟ JavaScript King
❯ UI Design
➟ developedbyed
➟ DesignCourse

-- DevOps --

❯ GIT ➟ The Modern Coder
❯ Linux ➟ Learn Linux TV
❯ DevOps ➟ DevOpsToolkit
❯ CI/CD ➟ TechWorld with Nana
❯ Docker ➟ Bret Fisher
❯ Kubernetes ➟ Kubesimplify
❯ Microservices ➟ freeCodeCamp
❯ Selenium ➟ edureka!
❯ Playwright ➟ Jaydeep Karale

-- Cloud Computing --

❯ AWS ➟ amazonwebservices
❯ Azure ➟ Adam Marczak
❯ GCP ➟ edureka!
❯ Serverless ➟ Serverless
❯ Jenkins ➟ DevOps Journey
❯ Puppet ➟ simplilearn
❯ Chef ➟ simplilearn
❯ Ansible ➟ Learn Linux TV

-- Data Science --

❯ Mathematics
➟ 3Blue1Brown
➟ ProfRobBob
➟ Ghrist Math
➟ Numberphile

❯ Machine Learning
➟ sentdex
➟ DeepLearningAI
➟ StatQuest

❯ Excel
➟ ExcelIsFun
➟ Kevin Stratvert
➟ Chandoo

❯ Tableau ➟ Tableau Tim

❯ PowerBI
➟ Guy in a Cube
➟ Chandoo

❯ Data Science
➟ Krish Naik
➟ Leila Gharani
➟ Socratica

❯ Data Analyst
➟ AlexTheAnalyst
➟ Luke Barousse

❯ Projects ➟ Ken Jee

-- Code Editors --

❯ Vim ➟ ThePrimeagen
❯ VS Code ➟ Visual Studio Code
❯ Jupyter Notebook ➟ Corey Schafer

-- Special Mentions --

❯ Programming in 100 Sec ➟ Fireship
❯ Interviews ➟ NeetCode

-- Free Education --

➟ freecodecamp
➟ Simplilearn
➟ edureka!

-- Most Valuable --

➟ TechWithTim
➟ programmingwithmosh
➟ Traversy Media
➟ BroCodez
➟ thenewboston
➟ Telusko
➟ Derek Banas
➟ CodeWithHarry
➟ MySirG .com
➟ TechWorld with Nana
➟ KodeKloud


Join for More
https://whatsapp.com/channel/0029Va9pSbzBlHpU1fu6ff1Q

https://telegram.me/sign2tech

🎯 lmportant information for placements:

✅ Top 10 Sites for your career:
1. Linkedin
2. Indeed
3. Naukri
4. Cocubes
5. JobBait
6. Careercloud
7. Dice
8. CareerBuilder
9. Jibberjobber
10. Glassdoor

✅ Top 10 Tech Skills in demand:
1. Machine Learning
2. Mobile Development
3. SEO/SEM Marketing
4. Data Visualization
5. Data Engineering
6. UI/UX Design
7. Cyber-security
8. Cloud Computing/AWS
9. Blockchain
10. IOT

✅ Top 10 Sites for Free Online Education:
1. Coursera
2. edX
3. Udemy
4. MIT OpenCourseWare
5. Stanford Online
6. iTunesU Free Courses
7. Codecademy
8. ict iitr
9. ict iitk
10. NPTEL

✅ Top 10 Sites to learn Excel for free:
1. Microsoft Excel Help Center
2. Excel Exposure
3. Chandoo
4. Excel Central
5. Contextures
6. Excel Hero b.
7. Mr. Excel
8. Improve Your Excel
9. Excel Easy
10. Excel Jet

✅ Top 10 Sites to review your resume for free:
1. Zety Resume Builder
2. Resumonk
3. Resume dot com
4. VisualCV
5. Cvmaker
6. ResumUP
7. Resume Genius
8. Resume builder
9. Resume Baking
10. Enhance

✅ Top 10 Sites for Interview Preparation:
1.HackerRank
2.Hacker Earth
3. Caggle
4.Leetcode
5.Geeksforgeeks
6.Ambitionbox
7. AceThelnterview
8. Gainlo
9. Careercup
10. Codercareer

➖➖➖➖➖➖➖➖➖➖➖➖
Join for more
https://telegram.me/sign2tech

PYTHON FOR EVERYTHING:

Python + Flask = Web Development

Python + Django = Full-Stack Web Applications

Python + NumPy = Scientific Computing

Python + Pandas = Data Analysis

Python + TensorFlow = Machine Learning

Python + Keras = Deep Learning

Python + OpenCV = Computer Vision

Python + Matplotlib = Data Visualization

Python + Scrapy = Web Scraping

Python + PyTorch = Neural Networks

Python + SQLAlchemy = Database Management

Python + Selenium = Automated Testing

Companies which hire freshers Off-Campus!🚀

👉 Nagarro: https://lnkd.in/dRyQ_rkk
👉 Virtusa: https://lnkd.in/dHJwPXiG
👉Zoho: https://lnkd.in/dUw9Qi4B
👉 CGI: https://lnkd.in/d3vs3whb
👉 Finastra: https://lnkd.in/dsXSfUev
👉 FIS: https://lnkd.in/dJCX6aVz
👉 Fiserv: https://lnkd.in/d7inSReM
👉 IQVIA : https://lnkd.in/dsxAXftw
👉 JIO: https://lnkd.in/dqVxSNgW
👉 MAQ Software: https://lnkd.in/d2dkHExY
👉 Optum: https://lnkd.in/dvxb_7ds
👉 Publicis Sapient: https://lnkd.in/d6G3tHUF
👉 Geekyants: https://lnkd.in/dDKQVqv2
👉 Accolite: https://lnkd.in/dDN5PWQk
👉 Airtel:https://lnkd.in/d9i9YwjV
👉 EA: https://lnkd.in/dHTe2pFc
👉Gartner: https://lnkd.in/dgsH4KUz
👉 HARMAN: https://lnkd.in/dBP_hSFE
👉 Yellow[.]ai: https://lnkd.in/dUPgitVf
👉 Seimens : https://lnkd.in/df4czTeb
👉 Samsung: https://lnkd.in/d5gUrDxq
👉 Vmware: https://lnkd.in/d7zgbhXk
👉 Adobe https://lnkd.in/dMWhmAKZ
👉 Amazon: https://lnkd.in/dSYUatGR
👉 Cadence Design Systems: https://lnkd.in/dAjV2Df4
👉 CleverTap: https://lnkd.in/dUNg4sZP
👉Cisco: https://jobs.cisco.com/
👉 Dunzo: https://lnkd.in/d5ZUmmG6
👉 FamPay: https://apply.fampay.in/
👉 Flipkart: https://lnkd.in/d_9WfsNY
👉 Google: https://lnkd.in/dGMfCuRs
👉 Hackererath : https://lnkd.in/ds2n7SNb
👉 Morgan Stanley: https://lnkd.in/d53kRcp3
👉 EY: https://lnkd.in/d9MbsS3V
👉 MyGate: https://lnkd.in/d5pTjwxs
👉 McAfee: https://lnkd.in/d7vST4g6
👉 Oracle: https://lnkd.in/dDDbnZMu
👉 Microsoft: https://lnkd.in/dKt2drwp
👉 PhonePe: https://lnkd.in/dtTZzhXn
👉 PWC: https://lnkd.in/d4b8DTft
👉 Rakuten: https://lnkd.in/dRuSSrq2
👉Razorpay: https://lnkd.in/dveHTU3p
👉 SAP: https://lnkd.in/dDVKcPST
👉 Media[.]net: https://lnkd.in/dfti6QZ8
👉 Twilio: https://lnkd.in/dskmG6eT
👉 Byju’s: https://lnkd.in/dX4g5UrW
👉 TCS : https://lnkd.in/dJpHXdvv
👉 Infosys : https://lnkd.in/dEcdZ7gf
👉 Wipro: https://lnkd.in/d89txDcp
👉 Cognizant: https://lnkd.in/d6tp6F_p
👉 LTI: https://lnkd.in/dnCVuQzD
👉 Capgemini: https://lnkd.in/dZBUYY88
👉 DXC Technology: https://lnkd.in/dnVzT7eb
👉 HCL: https://lnkd.in/dwTuQWAf
👉 Hashedin: https://lnkd.in/d2ePnTG4
👉 Hexaware: https://jobs.hexaware.com/
👉 Revature: https://lnkd.in/dtJkkrBp
👉 IBM: https://lnkd.in/dU-VhUCw

Follow our Community❤️🌻
https://telegram.me/sign2tech

Age of Programming Languages👨🏻‍💻

🦅 Swift (10 years old) (2014)
🚀 Kotlin (12 years old) (2011)
🦀 Rust (13 years old) (2010)
🐹 Go (14 years old) (2009)
🔷 TypeScript (11 years old) (2012)
🎸 C# (23 years old) (2000)
💎 Ruby (28 years old) (1995)
☕ Java (28 years old) (1995)
🌐 JavaScript (28 years old) (1995)
🐘 PHP (29 years old) (1994)
🐍 Python (33 years old) (1991)
🐪 Perl (36 years old) (1987)
🚀 C++ (38 years old) (1985)
📱 Objective-C (39 years old) (1984)
🔍 Prolog (51 years old) (1972)
🗣️ Smalltalk (51 years old) (1972)
🖥️ C (51 years old) (1972)
📝 Pascal (53 years old) (1970)
🎓 BASIC (59 years old) (1964)
💼 COBOL (64 years old) (1959)
🤖 Lisp (65 years old) (1958)
📜 Fortran (66 years old) (1957)

Join for more
https://telegram.me/sign2tech

SQL Essentials for Quick Revision

🚀 SELECT
Retrieve data from one or more tables.

🎯 WHERE Clause
Filter records based on specific conditions.

🔄 ORDER BY
Sort query results in ascending (ASC) or descending (DESC) order.

📊 Aggregation Functions

MIN, MAX, AVG, COUNT: Summarize data.

Window Functions: Perform calculations across a dataset without grouping rows.


🔑 GROUP BY
Group data based on one or more columns and apply aggregate functions.

🔗 JOINS

INNER JOIN: Fetch matching rows from both tables.

LEFT JOIN: All rows from the left table and matching rows from the right.

RIGHT JOIN: All rows from the right table and matching rows from the left.

FULL JOIN: Combine rows when there is a match in either table.

SELF JOIN: Join a table with itself.


🧩 Common Table Expressions (CTE)
Simplify complex queries with temporary result sets.

Quick SQL Revision Notes 📌
Master these concepts for interviews and projects!

Join for more
https://whatsapp.com/channel/0029Va9pSbzBlHpU1fu6ff1Q

https://telegram.me/sign2tech

Everyone's talking about #ChatGPT. But 90% of you are missing out on the AI revolution. Here are the top AI tools you NEED to know about.

1. Krisp: Krisp's AI removes background voices, noises, and echo from your calls, giving you peace of call
Link: https://krisp.ai/


2. Beatoven: Create unique royalty-free music that elevates your story
Link: https://www.beatoven.ai/


3. Cleanvoice: Automatically edit your podcast episodes
Link: https://cleanvoice.ai/


4. Podcastle: Studio quality recording, right from your computer
Link: https://podcastle.ai/


5. Flair: Design branded content in a flash
Link: https://flair.ai/


6. Illustroke: Create killer vector images from text prompts
Link: https://illustroke.com/


7. Patterned: Generate the exact patterns you need for and design
Link: https://www.patterned.ai/


8. Stockimg: Generate the perfect stock photo you need, every time
Link: https://stockimg.ai/


9. Copy: AI Generated copy, that actually increases conversion
Link:https://www.copy.ai/


10. CopyMonkey: Create Amazon listings in seconds
Link: http://copymonkey.ai/


11. Ocoya: Create and schedule social media content 10x faster
Link: https://www.ocoya.com/


12. Unbounce Smart Copy: Write high-performing cold emails at scale
Link: https://unbounce.com/


13. Vidyo: Make short-form vids from long-form content in just a few clicks
Link: https://vidyo.ai/


14. Maverick: Generate personalized videos at scale
Link:https://lnkd.in/dmrkz_ah


15. Quickchat: AI chatbots that automate customer service charts
Link: https://www.quickchat.ai/


16. Puzzle: Build an AI-powered knowledge base for your team and customers
Link: https://www.puzzlelabs.ai/


17. Soundraw: Stop searching for the song you need. Create it.
Link: https://soundraw.io/


18. Cleanup: Remove any wanted object, defect, people, or text from your pictures in seconds
Link: https://cleanup.pictures/


19. Resumeworded: Improve your resume and LinkedIn profile
Link: https://lnkd.in/d9EurcnX


20. Looka: Design your own beautiful brand
Link: https://looka.com/


21. theresanaiforthat: Comprehensive database of AIs available for every task
Link: https://lnkd.in/dKhqaaF3


22. Synthesia: Create AI videos by simply typing in text.
Link: https://www.synthesia.io/


23. descript: New way to make video and podcasts
Link: https://lnkd.in/d_Kdj35E


24. Otter: Capture and share insights from your meetings
Link: https://otter.ai/


25. Inkforall: AI content (Generation, Optimization, Performance)
Link: https://inkforall.com/


26. Thundercontent: Generate Content with AI
Link: https://lnkd.in/djFxMZsZ


Join for More
https://whatsapp.com/channel/0029Va9pSbzBlHpU1fu6ff1Q

https://telegram.me/sign2tech

Excel vs SQL vs Python (pandas):

1️⃣ Filtering Data
↳ Excel: =FILTER(A2:D100, B2:B100>50) (Excel 365 users)
↳ SQL: SELECT * FROM table WHERE column > 50;
↳ Python: df_filtered = df[df['column'] > 50]

2️⃣ Sorting Data
↳ Excel: Data → Sort (or =SORT(A2:A100, 1, TRUE))
↳ SQL: SELECT * FROM table ORDER BY column ASC;
↳ Python: df_sorted = df.sort_values(by="column")

3️⃣ Counting Rows
↳ Excel: =COUNTA(A:A)
↳ SQL: SELECT COUNT(*) FROM table;
↳ Python: row_count = len(df)

4️⃣ Removing Duplicates
↳ Excel: Data → Remove Duplicates
↳ SQL: SELECT DISTINCT * FROM table;
↳ Python: df_unique = df.drop_duplicates()

5️⃣ Joining Tables
↳ Excel: Power Query → Merge Queries (or VLOOKUP/XLOOKUP)
↳ SQL: SELECT * FROM table1 JOIN table2 ON table1.id = table2.id;
↳ Python: df_merged = pd.merge(df1, df2, on="id")

6️⃣ Ranking Data
↳ Excel: =RANK.EQ(A2, $A$2:$A$100)
↳ SQL: SELECT column, RANK() OVER (ORDER BY column DESC) AS rank FROM table;
↳ Python: df["rank"] = df["column"].rank(method="min", ascending=False)

7️⃣ Moving Average Calculation
↳ Excel: =AVERAGE(B2:B4) (manually for rolling window)
↳ SQL: SELECT date, AVG(value) OVER (ORDER BY date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS moving_avg FROM table;
↳ Python: df["moving_avg"] = df["value"].rolling(window=3).mean()

8️⃣ Running Total
↳ Excel: =SUM($B$2:B2) (drag down)
↳ SQL: SELECT date, SUM(value) OVER (ORDER BY date) AS running_total FROM table;
↳ Python: df["running_total"] = df["value"].cumsum()



Join for more
https://telegram.me/sign2tech

https://whatsapp.com/channel/0029Va9pSbzBlHpU1fu6ff1Q

🔐 Key Python Libraries for Data Science:

Numpy: Core for numerical operations and array handling.

SciPy: Complements Numpy with scientific computing features like optimization.

Pandas: Crucial for data manipulation, offering powerful DataFrames.

Matplotlib: Versatile plotting library for creating various visualizations.

Keras: High-level neural networks API for quick deep learning prototyping.

TensorFlow: Popular open-source ML framework for building and training models.

Scikit-learn: Efficient tools for data mining and statistical modeling.

Seaborn: Enhances data visualization with appealing statistical graphics.

Statsmodels: Focuses on estimating and testing statistical models.

NLTK: Library for working with human language data.

These libraries empower data scientists across tasks, from preprocessing to advanced machine learning.

Join for More
https://whatsapp.com/channel/0029Va9pSbzBlHpU1fu6ff1Q

https://telegram.me/sign2tech

💥Different Tools and their use cases

1. Selenium: 🌐 Automation testing that scales effortlessly.
2. Postman: 🔗 Simplify your API testing journey.
3. Appium: 📱 Master mobile app testing like a pro.
4. JIRA: 🐛 Track bugs & collaborate with ease.
5. JMeter: ⚡️ Unleash the power of performance testing.
6. TestRail: 🧾 Organize and manage your test cases seamlessly.
7. Cypress: 🕵️‍♀️ Take UI automation to the next level with modern tools.
8. SoapUI: 🛠 Comprehensive API testing and service virtualization.
9. Katalon Studio: 🔍 A versatile web, API, and mobile testing tool.
10. QTest: 📋 A reliable tool for test management and execution.
11. BrowserStack: 🌐 Test across multiple browsers and devices.
12. TestComplete: 🤖 Build reliable automated UI tests quickly.
13. Robot Framework: 🛠 Open-source automation for everyone.
14. LoadRunner: 🚀 Performance testing for heavy loads and stress tests.
15. Bugzilla: 🐞 Lightweight yet powerful bug tracking tool.
16. Ranorex: 🎯 User-friendly desktop, web, and mobile application automation.
17. Cucumber: 🥒 Simplify behavior-driven testing (BDD).
18. TestLink: 🖇 Manage test cases and requirements effectively.
19. Zephyr: 📊 Integrate testing into your Agile workflow seamlessly.
20. Charles Proxy: 🕵️ Debug and monitor HTTP/HTTPS traffic effortlessly.

95% of the companies ask the same SQL questions 😱

Check the questions list below 🔻

1.) Explain order of execution of SQL.
2.) What is difference between where and having?
3.) What is the use of group by?
4.) Explain all types of joins in SQL?
5.) What are triggers in SQL?
6.) What is stored procedure in SQL
7.) Explain all types of window functions?
(Mainly rank, row_num, dense_rank, lead & lag)
8.) What is difference between Delete and Truncate?
9.) What is difference between DML, DDL and DCL?
10.) What are aggregate function and when do we use them? explain with few example.
11.) Which is faster between CTE and Subquery?
12.) What are constraints and types of Constraints?
13.) Types of Keys?
14.) Different types of Operators ?
15.) Difference between Group By and Where?
16.) What are Views?
17.) What are different types of constraints?
18.) What is difference between varchar and nvarchar?
19.) Similar for char and nchar?
20.) What are index and their types?
21.) What is an index? Explain its different types.
22.) List the different types of relationships in SQL.
23.) Differentiate between UNION and UNION ALL.
24.) How many types of clauses in SQL?
25.) What is the difference between UNION and UNION ALL in SQL?
26.) What are the various types of relationships in SQL?
27.) Difference between Primary Key and Secondary Key?
28.) What is the difference between where and having?
29.) Find the second highest salary of an employee?
30.) Write retention query in SQL?
31.) Write year-on-year growth in SQL?
32.) Write a query for cumulative sum in SQL?
33.) Difference between Function and Store procedure ?
34.) Do we use variable in views?
35.) What are the limitations of views?


Follow our Community❤️🌻
https://telegram.me/sign2tech


https://whatsapp.com/channel/0029Va9pSbzBlHpU1fu6ff1Q

8 Key Data Structures That Power Modern Databases

🔹Skiplist: a common in-memory index type. Used in Redis
🔹Hash index: a very common implementation of the “Map” data structure (or “Collection”)
🔹SSTable: immutable on-disk “Map” implementation
🔹LSM tree: Skiplist + SSTable. High write throughput
🔹B-tree: disk-based solution. Consistent read/write performance
🔹Inverted index: used for document indexing. Used in Lucene
🔹Suffix tree: for string pattern search
🔹R-tree: multi-dimension search, such as finding the nearest neighbor

25 Papers That Completely Transformed the Computer World.

1. Dynamo - Amazon’s Highly Available Key Value Store
2. Google File System: Insights into a highly scalable file system
3. Scaling Memcached at Facebook: A look at the complexities of Caching
4. BigTable: The design principles behind a distributed storage system
5. Borg - Large Scale Cluster Management at Google
6. Cassandra: A look at the design and architecture of a distributed NoSQL database
7. Attention Is All You Need: Into a new deep learning architecture known as the transformer
8. Kafka: Internals of the distributed messaging platform
9. FoundationDB: A look at how a distributed database
10. Amazon Aurora: To learn how Amazon provides high-availability and performance
11. Spanner: Design and architecture of Google’s globally distributed databas
12. MapReduce: A detailed look at how MapReduce enables parallel processing of massive volumes of data
13. Shard Manager: Understanding the generic shard management framework
14. Dapper: Insights into Google’s distributed systems tracing infrastructure
15. Flink: A detailed look at the unified architecture of stream and batch processing
16. A Comprehensive Survey on Vector Databases
17. Zanzibar: A look at the design, implementation and deployment of a global system for managing access control lists at Google
18. Monarch: Architecture of Google’s in-memory time series database
19. Thrift: Explore the design choices behind Facebook’s code-generation tool
20. Bitcoin: The ground-breaking introduction to the peer-to-peer electronic cash system
21. WTF - Who to Follow Service at Twitter: Twitter’s (now X) user recommendation system
22. MyRocks: LSM-Tree Database Storage Engine
23. GoTo Considered Harmful
24. Raft Consensus Algorithm: To learn about the more understandable consensus algorithm
25. Time Clocks and Ordering of Events: The extremely important paper that explains the concept of time and event ordering in a distributed system

Follow our Community❤️🌻
https://whatsapp.com/channel/0029Va9pSbzBlHpU1fu6ff1Q
https://telegram.me/sign2tech