SQL opens the door for multiple career options.

Master these 10 key SQL topics and you are ready to ——— ➊ Fundamentals

➀ What is a database and DBMS?
➁ What is a relational database?
➂ What are some popular RDBMS?
➃ What is normalization?
➄ Different normalization forms (NFs).
➅ What is SQL?
➆ Different components of SQL.
➇ What is ERD?

👩‍💻 150+ Algorithms asked in Interviews

Practice in
❍ C++
❍ Java
❍ Python
❍ JavaScript
Or, any language of your choice

⇩ ➊ Array - Algorithms

➀ Creating an Array
➁ Iterate through Array
➂ Get an Element
➃ Search an Element
➄ Insert Element(s)
➅ Delete Element(s)
➆ Filter an Array
➇ Fetch a Sub-Array
➈ Merging Arrays
➉ Reverse Array
➀➀ Rotate Array

Python opens the door to multiple career options.

9 key topics you should master to be an Expert: ➊ Simple Data Types

Effort: 1 to 2 hours daily + Normal practice

❯ Boolean
⬩bool
❯ Number
⬩int
⬩float
⬩complex
❯ String
⬩str
❯ Bytes
⬩bytes
⬩bytearray
⬩memoryview

Remote software jobs paying in USD

Check this out: ➊ WWR

🖇️

Over 4.5M people visited it to find a remote job.

⬩Front end
⬩Back end
⬩Full-stack
⬩DevOps
⬩Marketing
⬩IT Support
⬩Management weworkremotely.com

If you have Python interview in just 6 hours,

This is how you can prepare: ➊ Don't panic

⬘ List down all the things (mentioned in subsequent tweets of this thread).

⬗ Keep your phone in silent and airplane mode.

⬙ Keep 2 ltr of water and some snacks/food.

DSA is a key skill for Developers.

Master these 12 key topics and crack any interviews. ➊ Fundamentals

➀ What is an algorithm
➁ Types of algorithms

➂ Asymptotic Notations
➃ Time & Space Complexity

➄ What is a data structure
➅ Linearity & Contiguity
➆ Fundamental Operations

https://twitter.com/swapnakpanda/status/1655550811919859717

YouTube is FREE.
ChatGPT is FREE.
W3Schools is FREE.

But no certificates. Top 13 Alternatives: 1. freeCodeCamp

Learn. Practice. Earn Certification.

❯ Frontend, Backend, Database
❯ Data Analysis
❯ ML
❯ JavaScript, Python, C#, SQL

🖇️ freecodecamp.org/learn/

25 Top FREE Courses for Absolute Beginners:

❯ Python


❯ JavaScript


❯ SQL


❯ C


❯ C++


❯ Java


❯ C#
cs50.harvard.edu/python/
openclassrooms.com/en/courses/566…
online.stanford.edu/courses/soe-yd…
alison.com/course/diploma…
alison.com/course/c-plus-…
scaler.com/topics/course/…
freecodecamp.org/learn/foundati… ❯ HTML and CSS


❯ React


❯ MongoDB


❯ Kafka


❯ Redis
openclassrooms.com/en/courses/526…
scrimba.com/learn/learnrea…
learn.mongodb.com
developer.confluent.io/courses/
university.redis.com

👩‍💻 Practice these 125+ Algorithms in

❍ C++
❍ Java
❍ Python
❍ JavaScript
Or, any language of your choice

Stay in top 5% of programmers.
⇩ ➊ Array - Algorithms

➀ Creating an Array
➁ Iterate through Array
➂ Get an Element
➃ Search an Element
➄ Insert Element(s)
➅ Delete Element(s)
➆ Filter an Array
➇ Fetch a Sub-Array
➈ Merging Arrays
➉ Reverse Array
➀➀ Rotate Array

Python is the door to multiple career options.

Master these 9 key topics and you are ready to ——— ➊ Simple Data Types

Effort: 1 to 2 hours daily + Normal practice

✧ Boolean
❯ bool
✧ Number
❯ int
❯ float
❯ complex
✧ String
❯ str
✧ Bytes
❯ bytes
❯ bytearray
❯ memoryview

FREE Certifications that are fully accepted in the industry:

1. freecodecamp.org/learn/ 2. Hackerrank Certifications

Get certified and also earn badges for free on Hackerrank.

Subjects: SQL, Python, JavaScript, React, Angular, Java, DSA.

🖇️ hackerrank.com/skills-verific…

Looking for a remote job that pays you in USD?

But don't know how to make it? Here's a guide that works 💯 🄌 ❝Is remote job good for me?❞

Remote jobs have many advantages, but they're not suitable for all.

⬩ Does loneliness bother you?
⬩ Are you afraid of working and delivering alone?
⬩ Do you lose motivation when alone?

If the answer is "NO," you'll enjoy a remote job.

If your goal is to be an SQL expert in 2024, this thread is for you: Beginner
⭣ Learn fundamentals ➊
⭣ Choose a Database ➋
⭣ Install ➌
⭣ Working w/ table ➍
⭣ Working w/ data ➎
⭣ Querying the data ➏
⭣ Operators ➐
⭣ Functions ➑
⭣ Database objects ➒
⭣ Programming in SQL ➓
⭣ Users and Roles ➊➊
⭣ Advanced Concepts ➊➋
Expert

Best YouTube channels for Data Science:

❯ Python ➟ Corey Schafer
❯ SQL ➟ Joey Blue
❯ MS Excel ➟ Chandoo
❯ PowerBI ➟ Guy in a Cube
❯ Data Analyst ➟ AlexTheAnalyst
❯ Mathematics ➟ 3Blue1Brown
❯ Machine Learning ➟ sentdex
❯ Most Valuable ➟ Krish Naik More Data Science Channels [1/4]

❯ Python
➟ Bro Code
➟ TokyoEdtech
➟ thenewboston
❯ SQL
➟ The Magic of SQL
➟ AlexTheAnalyst
❯ R ➟ marinstatlectures

YouTube is FREE, but No Certificates.

Top alternatives:

1. freecodecamp.org/learn/ 2. Harvard CS50

❯ Learn Computer Science


❯ Learn Python


❯ Learn Web Dev
cs50.harvard.edu/x/2023/
cs50.harvard.edu/python/2022/
cs50.harvard.edu/web/2020/

🛣️ Complete DSA Roadmap of 2024

👩‍⚕️ Beginner → Array, Linked List, ...
↓
👩‍🏫 Medium → Hash Table, Tree, ...
↓
👩‍💻 Advanced → Graph, ...
↓
👩‍🎓 Pro
⇩ Beginner's Roadmap

Step-1: Learn Fundamentals

➀ What is an algorithm
➁ Types of algorithms

➂ Asymptotic Notations
➃ Time & Space Complexity

➄ What is a data structure
➅ Linearity & Contiguity
➆ Fundamental Operations

A student bagged a Junior Full-Stack Developer role in a US-based remote job. It took him ~3 months.

A 37 y/o lady bagged a Web Developer remote job in a startup without any degree. It took her ~1 year.

Here's how I guided them to achieve this: 1. Go for a remote job

⬘ You can try for FAANGs or other top MNCs. But don't be obsessed.

⬙ The biggest asset for a software engineer is his experience which will give more opportunities in the future.

Try for a remote job in any startup company.

https://twitter.com/swapnakpanda/status/1620394000355307523

75+ SQL Practice Questions

⇩ Questions will be from:

➊ DDL Commands on Table
➋ Constraints
➀ Primary Key ➁ Unique
➂ Not Null ➃ Default
➄ Check ➅ Foreign Key
➌ Insert, Update, Delete Records
➍ Select Records

💎 HTML, CSS, JavaScript Cheat Sheets

1. CSS Shorthand Properties 2. List of all HTML Elements

👩‍💻 Practice 100+ Problems

Using any language
❍ C/C++
❍ Python
❍ Java
❍ C#
❍ Golang
❍ JavaScript
⇩ Problems based on "numbers" are the best way to start practicing to improve programming skills.

I am presenting here the problems on

➊ Simple Numbers
➋ Unit Conversion
➌ Calculation
➍ Geometry
➎ Vector
➏ Matrix
➐ Set
➑ Special Numbers

Roadmap for Data Scientists of 2024

(Must read for Absolute Beginners) ➊ Programming:

❯ Learn a programming language like Python, R, Scala, or Java.

❯ Learn SQL

❯ Learn Excel Formulas