Share this page!

Enter Twitter Thread URL to Unroll

Needs to be the full URL like: https://twitter.com/threadreaderapp/status/1644127596119195649

How to get URL link on Twitter App

  1. On the Twitter thread, click on or icon on the bottom
  2. Click again on or Share Via icon
  3. Click on Copy Link to Tweet
  4. Paste it above and click "Unroll Thread"!
  5. More info at Twitter Help
Vikas Rajput Profile picture
@vikasrajputin
Jul 17 • 8 tweets • 3 min read Twitter logo Read on Twitter
Mastering SQL, helps you make a successfull career into datascience, fullstack, backend development.

Here's list of videos to help you get quickly started with it:
1. SQL Tutorial - Full Course for Beginner

Probably the most popular SQL course on youtube, starting from scratch to explaining advanced topics it is a must-watch.

Duration - 4:20 hrs
Database Used in Tutorial - MySQL

2. MySQL Tutorial for Beginner Full course

Another great video where SQL is explained from scratch this course is using some pretty simple examples and beginner friendly

Duration - 3:10 hrs
Database Used - MySQL

3. SQL Tutorial for Beginner

Live SQL workshop and the most detailed one where the trainer has explained lots of advanced concepts in detail and very useful for DBAs

Duration - 5:17 hrs
Database - MS SQL Server

4. SQL Full Course

Less detailed as compared to the previous one but covers all the important topics needed to be an expert in SQL.

Duration - 4:07 hrs
Database - MS SQL Server

5. SQL in 60 mins

Shortest of all courses, this can be considered as a crash course in SQL and covers all topics needed to get started with SQL

Duration - 56 mins
Database - MySQL

6. SQL For Beginners Tutorial

If you're organization/client uses Postgres then this detailed course can explain to you all the important topics with great examples

Duration - 4:22 hrs
Database - Postgres

Thanks for Reading!

Every week, I write about my experience and learning as a Backend Developer.

For more content like this, follow me @vikasrajputin

If you find this thread helpful, please like and retweet the first tweet below:

• • •

Missing some Tweet in this thread? You can try to force a refresh
　

Keep Current with Vikas Rajput

Vikas Rajput Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @vikasrajputin

Vikas Rajput Profile picture
Jul 3
As a backend engineer, mastering docker can give you a competitive edge.

But, docker is super intimidating in the beginning.

Here're 8 crucial terms to help you quickly started with docker:
1. Docker Image

Image is a lightweight package contains A-Z thing needed to run an application independently.

For example, think it like a zip file, containing all the required folders, files, dependencies, libraries, etc. required for your application to run independently.
2. Docker Container

Container is nothing but a runtime instance of a docker image.

You can even run multiple container from a single image.

For example, you can unzip a zip file as many times you want with different names.
Read 10 tweets
Vikas Rajput Profile picture
Jun 23
Top 6 github repository, to kick-start your programming journey:🧵
1. OSSU:

Open Source Society University is an exceptional curriculum designed to help you become a self-taught computer scientist. From algorithms to operating systems, you'll find it all.

github.com/ossu/computer-…
2. Project-based Learning:

Learn by doing! Explore this curated list of project-based tutorials that cover various programming languages and technologies.

github.com/tuvtran/projec…
Read 18 tweets
Vikas Rajput Profile picture
Jun 21
More than 97% of candidates fail to answer this question in a Java interview

What's the logic of using public getter/setter methods to access private fields in Java POJO?

Can't we remove getter/setter methods by making fields public?

Here's the best way to answer this:🧵👇
1. Understand the Trick Behind

- There's no logic(from a security point of view) in accessing private fields via the public getter/setter method

- Here, the interview wants to know the significance of using the getter and setter method in a Java POJO Class
2. Use this Example

- A POJO Class called Account, with two fields:

1) accountName (to show name)
2) accountBalance (to show the remaining balance in the account)

- As usual, both fields are private & the public getter and setter method are being defined to access them

Eg: Image
Read 11 tweets
Vikas Rajput Profile picture
Jun 19
No matter if you're learning SQL for Data Science or Software Development.

You should master SQL "Normalization".

Here's a simple guide to get you started:🧵
1. Introduction

Normalization is a process to eliminate redundant data, prevent data anomalies, and ensure data integrity.

It makes your life super easy to manage, store and query data effectively in longer run!

Normalization happens in multiple stages:

1NF, 2NF, 3NF
2. Realworld Example

To understand normalization, let's consider a simple restaurant database example.

We have one table "Orders" with columns: OrderID, CustomerName, Dish, Chef, DishType, Price. Image
Read 11 tweets
Vikas Rajput Profile picture
Jun 16
Quick tutorial to get started with Docker:🧵

(build your first "hello world" example in docker)
1. Install Docker

Here's the official guide to install docker as per your platform:
docs.docker.com/desktop/

Once the docker is install run below command:
"docker version"

It should return docker version without any issues.
2. "docker pull"

It fetches the docker image from a remote registry.

By default, it fetches image from docker hub.

Imagine docker hub as a Playstore/Appstore on your phone to install available apps on your device.

Let's pull "nginx" image from the hub using below command. Image
Read 10 tweets
Vikas Rajput Profile picture
Jun 14
Before you start coding in languages like Java, Python, Javascript, etc.

You should master OOP concepts.

Here's a Dead Simple Guide to Understand It:
There are six different concepts in OOP:

1. Object
2. Class
3. Inheritance
4. Encapsulation
5. Abstraction
6. Polymorphism
1. Object

Every real-world entity is an object.

An object has Behaviour (things it does or performs) and Attributes (things that describe it).

For eg: A Chair object can have behaviour like Movement, Height Adjustment & Attributes like Color, Make & Model, and Price.
Read 10 tweets

Did Thread Reader help you today?

Support us! We are indie developers!

This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!

Send Email!

:(