Complete in-depth Prep Guide for CS Fundamentals🔥 | How to learn OS DBMS CN OOPs SQL?🔥

Summary

In this video, Aishwara Mahapatra emphasizes the importance of computer science fundamentals for clearing online assessments and interviews. He provides a step-by-step preparation guide for subjects like OS, DBMS, CN, OOPs, and SQL, recommending resources like Knowledge Gate, Gate Smashers, and beginner's book for OOPs. Aishwara also suggests using GeeksforGeeks for articles and quizzes, and HackerRank for SQL practice. He shares personal experiences to highlight the significance of in-depth knowledge and offers a shortcut resource for last-minute preparation.

Takeaways

• 😀 CS fundamentals are crucial for clearing online assessments and interviews, as they often carry equal weight with coding questions.
• 🕒 A two to three-month preparation plan is recommended for in-depth study of CS fundamentals, allocating half the study time to these topics.
• 🎥 For subjects like OS and DBMS, video playlists from channels like 'Knowledge Gate' and 'Gate Smashers' are suggested as a starting point.
• 📄 After videos, the articles section of GeeksforGeeks (GFG) should be utilized, with a curated list provided to focus on essential subtopics.
• 💻 For Computer Networks (CN), the importance may vary by role, but it's advised to cover key topics from GFG or through 'Gate Smashers' videos.
• 📝 Practice quizzes on GFG to assess understanding and reinforce learning of the subjects.
• 🔍 For Object-Oriented Programming (OOPs), 'Beginnersbook.com' is highlighted as a comprehensive and interactive resource.
• 📊 To prepare for SQL, W3Schools is recommended for concept clarity, followed by practical question practice on HackerRank.
• 🏆 In-depth knowledge of CS fundamentals can provide a competitive edge in interviews, impressing interviewers with detailed understanding.
• ⏰ For last-minute preparations or time constraints, Striver's SD course sheet is suggested as a shortcut, offering a list of important concepts to cover.

Q & A

Why are computer science fundamentals important for online assessments and interviews?

Computer science fundamentals are crucial because they often carry equal weight with coding questions in online assessments, and many companies assess coding skills in the initial rounds and then focus on in-depth CS fundamentals during interviews.

What is the recommended preparation strategy for CS fundamentals according to the video?

The video suggests dedicating half of your study time in the two to three months leading up to interviews to CS fundamentals. It also provides a step-by-step guide for preparing subjects like OS, DBMS, and CN, including watching specific video playlists, reading articles, and practicing quizzes.

Which channels are recommended for learning OS and DBMS according to the video?

The video recommends 'Gate Smashers' for OS and 'Knowledge Gate' for DBMS.

What is the role of GeeksforGeeks (GFG) articles in the preparation strategy?

GFG articles serve as a revision tool and provide additional details that might have been missed in video lectures. They also cover crucial concepts not included in the video playlists.

What is the recommended resource for Object-Oriented Programming (OOPs) preparation?

The video suggests using 'Beginnersbook.com' for OOPs preparation, as it provides concise and interactive explanations of concepts.

How should one prepare for SQL as per the video?

The video recommends starting with the concepts on W3Schools, then practicing SQL questions on HackerRank, and finally revising by practicing top interview questions found through a Google search.

What is the significance of in-depth knowledge of CS fundamentals during interviews?

In-depth knowledge of CS fundamentals can impress interviewers and give candidates an edge, as it demonstrates a strong foundation and understanding of the subject matter.

What alternative resource is suggested for those with limited time to prepare for CS fundamentals?

For those with limited time, the video suggests using Striver's SD course sheet, which curates a list of important concepts for quick revision.

What is the recommended approach to learning CS fundamentals if you have less than a month before interviews?

If time is limited, the video advises focusing on the most important topics and using resources like Striver's SD course sheet for quick revision.

How can the audience engage with the content creator for more information or specific topic requests?

The audience can engage by commenting on the video with specific topic requests or questions, and the content creator encourages such interaction.

Outlines

00:00

💻 CS Fundamentals Preparation Strategy

Aishwara Mahapatra introduces a video discussing a step-by-step guide for preparing computer science fundamentals. He emphasizes the importance of CS fundamentals in online assessments and interviews, suggesting that candidates should allocate half of their study time to these topics a few months before interviews. He proposes a strategy involving watching video playlists from channels like Knowledge Gate and Gate Smashers, followed by reading articles on GeeksforGeeks (GFG) and practicing quizzes. He also provides a shortcut resource for those with limited time and discusses how to prepare for subjects like OS, DBMS, and CN.

05:02

📚 In-Depth CS Fundamentals and SQL Preparation

The speaker shares his experience with interviews that focused heavily on CS fundamentals, highlighting the need for in-depth knowledge. He provides resources for further study, such as beginnersbook.com for Object-Oriented Programming (OOPs) concepts and w3schools for SQL basics. He recommends practicing SQL questions on HackerRank and reviewing top interview questions before interviews. For those short on time, he suggests using Striver's SD course sheet as a quick reference.

10:02

🎉 Wrapping Up the Video

Aishwara concludes the video by encouraging viewers to like and subscribe for more content. He signs off with a friendly 'bye bye' and plays some closing music.

Keywords

💡CS Fundamentals

CS Fundamentals refers to the core concepts and principles that form the foundation of computer science. In the video, the speaker emphasizes the importance of mastering these fundamentals for success in online assessments and interviews, as they are often given equal weightage with coding questions. The video aims to provide a step-by-step guide for preparing these fundamentals, highlighting their relevance in the tech industry.

💡Online Assessments

Online assessments are digital evaluations used by companies to test candidates' knowledge and skills. The script mentions that these assessments often have a significant focus on CS fundamentals, indicating that a strong grasp of these basics is crucial for clearing such tests and progressing in the hiring process.

💡Coding Questions

Coding questions are problems that require writing computer programs to solve. The video script discusses how coding questions are commonly paired with CS fundamentals in assessments, suggesting that a well-rounded skill set that includes both coding and theoretical knowledge is necessary for success in the tech job market.

💡DSA (Data Structures and Algorithms)

DSA stands for Data Structures and Algorithms, which are essential components of computer science that deal with organizing data and designing efficient algorithms. The speaker mentions that many companies assess candidates on DSA during coding rounds, implying that a strong foundation in these areas is vital for performing well in technical interviews.

💡Interview Preparation

Interview preparation in the context of the video involves studying and practicing CS fundamentals to perform well in job interviews. The speaker provides a strategy for preparing for interviews by dedicating time to both CS fundamentals and coding questions, emphasizing the need for thorough preparation.

💡Resources

Resources in this video refer to the educational materials and platforms recommended for studying CS fundamentals. The speaker suggests specific channels like 'Knowledge Gate' and 'Gate Smashers' for video content, and 'Geeks for Geeks' (GFG) for articles, indicating that a combination of video lectures and written materials is an effective way to study.

💡OS (Operating Systems)

Operating Systems (OS) is a subject within CS that deals with the management and coordination of computer hardware and software resources. The video script includes OS as one of the key subjects to prepare for, suggesting that understanding the principles of OS is crucial for a comprehensive grasp of CS fundamentals.

💡DBMS (Database Management Systems)

DBMS stands for Database Management Systems, which are systems that allow for the creation, maintenance, and management of databases. The video highlights DBMS as an important subject to cover, indicating that knowledge of database systems is essential for a well-rounded understanding of CS fundamentals.

💡CN (Computer Networks)

Computer Networks (CN) is a field of computer science that focuses on the study of data exchange between computers and computer networks. The speaker mentions that while CN might not be as crucial for some roles, it's still important to be prepared, especially for system design roles, showcasing the broad applicability of CS fundamentals.

💡OOPs (Object-Oriented Programming)

OOPs, or Object-Oriented Programming, is a programming paradigm that uses objects and classes to design applications and improve code reusability. The video suggests 'Beginnersbook.com' as a resource for OOPs, indicating that understanding OOPs concepts is a key part of the CS fundamentals preparation.

💡SQL (Structured Query Language)

SQL is a domain-specific language used in programming and software engineering to manage data held in relational database management systems. The script recommends 'w3schools' for learning SQL concepts and 'HackerRank' for practice, highlighting the importance of SQL knowledge in tech interviews and assessments.

Highlights

CS fundamentals are crucial for clearing online assessments and interviews.

Companies often assess coding skills and CS fundamentals during interviews.

A step-by-step prep guide for in-depth CS fundamentals is provided.

The preparation strategy takes around two to three months.

Allocate half of the study time to CS fundamentals and the other half to coding questions.

For OS and DBMS, follow video playlists from Knowledge Gate and Gate Smashers.

Use the articles section of GFG for further study after videos.

A document is provided to guide which subtopics to cover and which to skip for OS and DBMS.

For CN, focus on specific important topics for system design roles.

Practice quizzes on GFG to assess learning progress.

Review last-minute notes on GFG before interviews.

GFG articles serve as a revision and may cover concepts missed in videos.

For OOPS, BeginnersBook.com is recommended for an interactive and concise learning experience.

For SQL, clear concepts with W3Schools and practice with HackerRank.

Review top interview questions on SQL from various sources before interviews.

In-depth knowledge of CS fundamentals can impress interviewers and give an edge.

Striver's SD course sheet is recommended for last-minute preparation.

The video offers a comprehensive strategy for preparing CS fundamentals.

Transcripts

hey everyone i am aishwara mahapatra and

welcome back to my channel so today in

this video we will be discussing the

step-by-step prep guide for cs

fundamentals now let's first discuss

that why cs fundamentals are even

important

to be honest i've seen a lot of online

assessments these days in which the

weightage of the coding questions and

the cs fundamentals are equal so if

you're really really good at cs

fundamentals then also you are very

likely to clear the online assessments

similarly i've seen many companies who

assess the candidates dsa in the coding

round itself and during the interviews

they tend to ask you questions on your

projects and then in-depth cs

fundamentals so all in all you need to

be good at cs fundamentals now in many

videos you might have seen people

telling you the best resources for cs

fundamentals or the most important

topics to be covered for cs fundamentals

but in this video i'm going to tell you

the step-by-step prep guide for an

in-depth preparation for cs fundamentals

now before going ahead with the video i

would like to tell you that the

preparation strategy that i'm going to

discuss in this video is going to take

you around two to three months right i'm

not asking you to give your whole study

time for solely preparing the cs

fundamentals but rather what i'm saying

is before two three months

of your interviews you should give half

of the time to the cs fundamentals

preparation and the rest half to your

coding questions right and this is the

best way to prepare the cs fundamentals

in the most effective way

right however if you don't have two

three months and you just have like a

month or even less remaining

before the interviews and you haven't

prepared anything for cs fundamentals

yet i do have

a resource for it uh which is kind of a

shortcut for you to prepare cs

fundamentals uh in the best way but for

that you have to wait till the end so

don't forget to watch the video till the

end so first i will be telling you that

how to prepare subjects like os dbms in

cs

so the first step is uh to go with the

video playlist right um i recommend

these very famous uh channels that is

knowledge gate and gate smashers right

and specifically for os and cn go with

gate smashers and for dbms go with

knowledge gate now once you're done with

all the videos of the playlist then you

can actually go to uh the articles

section of gfg for the corresponding

subjects right

uh however there are a lot of

sub topics present

under every subject right whether it be

os dbms or cn and you don't necessarily

need to go through all the

subtopics right so for os and dbms what

i've done is i've actually

created a talk right in which you will

find the specific uh sub topics that you

need to cover and the ones that you

don't really need to cover i have

actually skipped those right so you can

use that doc to see the topics or sub

topics that you need to definitely cover

and then you can

skip the ones that you

don't want to cover actually right

but for cn i would say that cn

if you are applying for st roles cn is

not that important right but however you

need to be on the safer side and that's

why i have actually mentioned some

really important topics that you should

know for cn and you can prepare those

topics from the gfg articles once again

right and in case you prefer videos then

as i earlier said you can definitely go

with gate smashers playlist for cn right

now once you are done with these

articles the third step is to actually

practice uh the quizzes okay so you can

find the quiz section in jfg itself

right and then you can um go and give

the quizzes to actually assess

how much you've learned so far right and

in this way you are preparing yourself

in a complete way for every subject

right and now you are fully prepared

all you need to do is just one to two

days before your interviews go through

the last minute notes of every subject

which is again available on gfg and that

is just enough for your preparation for

all these three subjects now a question

might have popped up in your head that

if you have already seen the videos and

learned all the concepts then why do we

even need to go through the jfg articles

once again

so i have a very simple reason for it in

fact i have two reasons for it so the

first reason is while going through the

gfg articles the concepts already

covered earlier in the videos will be a

revision for you through these articles

right and also in case uh there were

some details of the concepts missed

within those six to seven minutes of the

videos you might find those details

within these articles right and the

second reason is there might be some

concepts which were not even covered in

that playlist right and they are really

crucial for your understanding so you

will find all those concepts in these

articles so this was the whole

preparation strategy for all the three

subjects that is os dbms and cn but what

about the other subjects like oops and

sql they are equally important right so

for oops i found this one resource which

is the best and you don't need to go for

any other resource at all and it is

beginnersbook.com so you can actually

find the section within this site and

all the concepts of oops have been uh

explained in the best way possible in

the most interactive manner ever right

so you will actually have a lot of fun

going through all the concepts

secondly uh

it's it's been explained in a very

concise manner so the articles are not

really long right so before interviews

you don't need any last minute notes and

you can once again go through the same

resource quickly to revise all the

concepts so now let's talk about the

preparation strategy for sql so all you

need to do is first

before practicing questions you need to

clear your concepts and the best site

for it is w3schools so you can simply go

to the sql section of w3 schools and

then learn about all the concepts you

can also practice uh some of the

concepts there itself okay then once

you're done with it you now need to

practice some real questions of sql

which you may be asked in the interviews

and for it hacky rank is the best

platform so once again go to hackerrank

right and within it you will find this

sql section

and there you will find many questions

that are best for your practice

once you're done with this i think it's

enough for your sql

now just before the interviews all you

need to do is go to google and write top

interview questions on sql

so you will find articles like top 15

interview questions on sql or top 100

interview questions or sql or maybe just

stop 30 interview questions on sql right

so all you need to do is practice uh

these top interview questions from two

to three sites and then you're all set

for sql now you might once again have a

question in your head that is it really

important to learn the cs fundamentals

in so depth

to be honest yes it is important and

i'll tell you why

i literally have phased interviewers who

grilled me on cs fundamentals both

during the internship season and the

placement season

so there was this company

which is actually a startup

and during the interviews they didn't

even ask me a single coding question

because they had already assessed my dsa

during the oa itself

so they wanted to check my project

knowledge and cs fundamentals and that

guy for straight 45 minutes grilled me

on cs fundamentals on os and all the

concepts related to it as well as on

dbms right

and similarly

it happened to me

when d shaw came on campus

right during the interviews i had two

interviews uh and in both the interviews

they uh grilled me for half of the time

on cs fundamentals and just because i

had such an in-depth knowledge of the cs

fundamentals the interviewers were

really impressed that i could tell them

things that no one else could

okay and thus i had an edge over others

now in case you don't have much time to

prepare cs fundamentals then the best

resource that i can suggest you is

striver's sd course sheet now striver

has actually

curated a lot of lists

for different purposes and this is one

of the list for you know core subjects

and i personally believe in using the

resources available in the best way

possible instead of creating a new

resource right and this is again one of

the resources that you definitely can

use

um this list consists of all the

important concepts and all you need to

do is just google the answer to the

question which is uh included in this

list and then you're all set for your

your course subject however i don't

think that you are going to learn the

concepts in them but still it's it's a

good way around now i've got a

full-fledged preparation strategy for

fcs fundamentals and you don't need to

worry about it anymore in case you want

me to make a video on any specific topic

then you definitely can comment it down

below now before going ahead don't

forget to like this video subscribe to

my channel i'll meet you in the next

video till then bye bye

[Music]

you