How to Become a Database Administrator | Database Administrator Skills | Intellipaat

hey guys welcome to this life buy-in telepath I am wrong and I'll be covering the topic into his life so today we'll be discussing how to become a database administrator now before we get into it guys please subscribe and hit the bell icon so that you don't miss any for future updates also one more thing guys if you stay till the end of the life then I have a surprise for you ok now let's take a quick look at our agenda so the first thing we'll have we'll have an introduction to database administration so our whole point of this life is to learn how to become a database administrator so I will give you a few steps but basically I will give you the fundamentals and you can then go ahead and try it on your own so first introduction will have an introduction to database administration what it is why do we need to learn it who our database administrator's then in the second topic then we'll discuss what are the different skills a database are mr. must have to become better then we'll discuss all the different roles and responsibilities of a database administrator then we'll discuss is deduce administration the right path for you and then finally we will conclude by having by telling you what kind of learning path can you take when you starting to learn about database administration ok so this is the agenda now we'll start with the introduction okay so let's introduce what database the administration is but before that let's get to know what databases and what DBMS is now I know a lot of you may be freshest a lot of you may be people who are looking to change the field in business you're working maybe you're working in the support field and you are you know satisfied with the work you're doing and you want to become you know choose a better field so that's what you clicked on this slide so I have I'm assuming that not everyone knows what a database is or what DBMS is so let me start with that so a database is basically a storage location like let's take an example if you had a hard drive and in that hard drive you're storing a lot of data let your personal information so then that hard drive can be construed as a database similarly when businesses operate right they produce a lot of data like customer data their internal operations data and all of this data needs to be stored somewhere and that's what we have database these databases are used to store and manage large amounts of data especially for big organizations so if you ever thought about Amazon or Microsoft or Walmart or flip card or you know any other big organization all of them have databases like multiple databases which they use to store multiple different types of data so what is DBMS so we know what a database is it's basically a storage place for storing data so DBMS is basically like different sets of programs that basically help you to retrieve this data manipulate this data and represent this data so you know that you already have your data inside your database but you want to you know mess with it or you want to use it then you need to use DBMS DBMS full formals database management systems these systems will help you to take this data from the DB or the database and then manipulate it basically change it and once you have changed it or you've you know selected the data then you can do whatever you want with it and you can represent it you can give it to whoever wants it etcetera etcetera now today almost every organization has morphed itself into a data-driven organization because you have to do that in today's world data is power if you have it's like saying information is knowledge like information is knowledge right I mean like information is power so in the same way data is power these days anyway go organization that has a wide reach is collecting data and is using that data to make better decisions that's what it analytics comes in so to store all of this data people have come devised multiple different methods to store the data and this is like database comes in and this is why every organization will have a database and a DBMS and you know several rules associated with handling all these things okay so now we know what a database is and what are dbmss now let's talk about what data administration is so data administration refers to the whole set of activities performed by a database administrator to ensure that the database is always available when needed or the me task of a database administrator is to maintain the integrity of database so in database administration if we were to define it again you're basically taking care of the database that's administration it's not the exact words as a system administrator but in a way you are administrating the database you are managing it you're making sure that is available you're making sure that's healthy you're monitoring it all the time it's like a baby database is like a baby and in database administration you basically take care of it so who is a database administrator so a database administrator is a person who basically performs all these roles like taking care of the database he is the one whom a database admin state is the person who maintains a successful database environment by directing or performing all related activities to keep the data secure and to keep the data stable maintain its integrity so a database administrator will do everything in his right to make sure that the databases data is available at all times to whoever wishes it and he makes sure that this data is secure so we'll discuss all these different roles of a database administrator later in this life so if you wanted a basic idea for who a database admin status he is a person who takes care of databases or incense key takes care of the data all right so let's now discuss why is there a need or what is the need of a database administrator so a database is admin administrator is very it's a very important role because you know it helps in keeping the data stable it makes sure that the data is always accessible it keeps the idea here he helps keep the data secure and he helps in planning future endeavors all right so this is why you need database administrator these are all the different important things you need to do with your databases and let's discuss the salary of a dated sadness reader so if you are looking to change your field or if you are a fresher who wants to look at a lucrative field where you can earn a lot of money it to be a sadness it is again that kind of fear but you might need a lot of like you might need some experience when you getting into this field you cannot just start as database administrators state away you will have to you know slowly slowly approach this particular field but there are some companies that do accept junior database administrators who are just come out of college and want to work on database so if you looked at this average salaries in India let's focus on India right now in India a junior database administrator will be earning around five lakhs per annum so as a fresher that's pretty good salary okay it's not as impressive as I eighty and salary where they're earning 80 lakhs per annum but not everyone can expect that much so as a freshman file X per annum is pretty good and if you get gained some experience you keep on going through this field if you're after two three years you earn around ten laps per annum and that's only after two three years you will become a senior database administrator but once you are in this field for long term maybe you're in this field for ten years more you'll be earning around sixty eighty the same as anyone else has been in this particular field so it pays off in the end that's what matters even a junior database administrator in u.s. will earn seventy thousand dollars I mean it's a lot more but then the standards of living in America a lot more and a senior database administrator living in u.s. earns around hundred thousand dollars which is a six-figure salary so can you imagine that earning a six-figure salary that's like a lot of money and you'll have comfort for the rest of your life all right so that's discussing the salary of a native sadness reader now let's move on let's discuss the different skills a database administrator must have all right so the first skill is having excellent communication skills since you'll be dealing with the database and you'll be disc you'll be communicating with a lot of different teams you know communicating with the operations team with the infrastructure team if the development team the database designing team there are so many different teams be talking to since you are the administrator you have all of the control and since you have all of the control you make sure that you're the person responsible for making sure that this particular person gets the access because your admin so in that way you have to keep a good interaction or keep your relationship with other teams very professional and have very good communication skills you have an idea you want to discuss it or you have some thoughts you want to discuss you need to be able to tell them very well then problem-solving obviously as a database admin you'll be you know trying to fix a lot of crashes or collapses or any problem that comes up so you need to be able to problem-solve you need to think on your feet and you need to do it a bit fast also I mean this is where this is true with any job even with the developer you need to have problem-solving skills so if you think that you can solve problems then this is a good job for you then you need to have good familiarity with query languages basically no SQL SQL is very very very important if you're working with database so if you think you can't work with SQL then just don't think about this look for something else but if you think you're good at SQL or if you think that you can get better than desk you'll then this is really good for you practice more learn more get really good with SQL try out hacker rank try many questions practice practice practice become very good at SQL and then you can get a really good job in database and if you're good at database all SQL already as a college student then you won't have a problem getting a junior database administrator job then we then you need to know basic understanding of Windows or Linux since you're going to be an administrator you going to be handling the database as a whole so you not gonna be creating the database or you're not gonna be developing it you're not going to be designing it or developing the database but you'll be handling it so to handle it you need to know on which particular host this particular database has been established so if it's a Linux based server on visit databases running you need to know how Linux works what are the different commands that are necessary to handle database and what if you're working with Windows based OS then you need to know though similar commands to work with the data based on that particular so so make sure you're good with Linux and Windows at least the basics if you have a basic understanding of how to use either of these operating systems then you're good to go you always learn more on the job so if you are scared that you don't know a lot it's all right not everyone knows everything in a start they learn slowly slowly they gain more experience then you need to have good knowledge about database design and theory okay you're not going to be designing the database but you still need to know about the database design because you'll be handling it and you need to know the ins and outs of the particular thing you're working handling so let's take an example like if you had a baby and you know you want to take care of it well it's not a really good and all analogy let's think about okay you have you have to handle a car so a person who knows the ins and outs of a car needs to know how the car works because otherwise he can't maintain it himself if his job is to maintain that car then he needs to know the ins and outs of that car similarly if you are going to be handling this database you need you need to know all the different concepts that are involved in creation of this database the design of the database and then database theory also like how does it work you can't just go into database administration and not know about how databases work how's the data stored how is the data index how do you query everything those kind of details you need to know them when you are working as a database administrator then you need to have knowledge in DBMS now you can pick any DBMS software and then have some can basic knowledge in it so you just use MySQL or ms SQL Postgres SQL just has some kind of knowledge in them and then again knowledge in the tools that are associated with the DBA already to be sadness data now there are a few tools but the thing with the tools is there a catch you can't just know one tool because you know in industry there are lot of tools being used so as you can see the lot of tools listed here and the best way to be a good database administrator is to know the basics and fundamentals if you know that basics and fundamentals you can jump across adapt to any tool that is listed over here with a lot of ease because they mostly work in the same manner is this that they have a few specifications that differ like most lot of companies use like Oracle database is one of the most popular database that is used out there so if you do know how to use it then it's a plus but even if you don't know how to use it you're good at MySQL but you're applying for a job in a company that uses Oracle they you know they won't look past the fact that you know my skill already they they will first and foremost Han assume that you know how to work with SQL and all the database concepts thoroughly then they will look at what care tool you know and they might even get impressed by your knowledge in database concepts and theories before even look at the tool that you know but if you do know the tool that they're using then it's a good plus then you have so let me talk about the different tools they like Oracle database - field workbench Dell spotlight which is a monitoring tool then you have SCO M that system center operations manager that is made by Microsoft that is used to manage the databases then you have Microsoft SQL Server and then told all these different tools are basically used to manage the data sets or manage the data that is available in the databases alright so let's move on let's look at the roles and responsibilities of a database administrator or database administration now this is the most important thing because this is what's going to be forming your fundamentals and basics as a database administrator okay fine now let's look at them so there are few of them let's discuss them one by one so what are the first responsibilities of a database administrator is to you know be able to is to make sure that there is database availability now database availability let us talk about that we've talked about this like few minutes back but let me tell you again so when you have your application this application let's take an example if you have like swiggy or if you have Amazon yeah so if you take Amazon's example again so they handle a millions and millions of interactions every day and they need to store this data somewhere and they use databases for this all they use some other method they need they just store that data and this the app for Amazon it needs to access this data anytime it wants the axis here is important because if the application cannot access the data if the Amazon app cannot access its own database then it can't provide the customers the necessary information if you have like different cell you know items product items on your like if you look up a particular if you look up a new laptop on Amazon you see a lot of list of different laptop will different sellers now this application this Amazon dot in application or the amazon.com application cannot display these items unless it has access to database and this is where database apple availability comes in as a database administrator you need to you need you will need to make sure that this database is available at all times so that there is no issue when the application wants to access this data so basically data availability without the database the application cannot remain online and it is one of the key responsibilities of a DBA so as a DBA this will be one of your most key important role or your responsibility to make sure that the data is available then data backup now you know what happens right when your hard drive crashes and you have a lot of data on it you have a lot of photos like childhood photos and you can't access it because your you know the hard drive has crashed and you forgot to back it up because you thought you know what's the user I don't want to back it up backing up will take a lot of time and I'm pretty sure that my heart I won't crash but it does crash so you regret that moment but companies already know this they need the offers you know door this analysis so in that backing of the data comes in handy because you're backing the data up so if something happens to the database that is irreparable at that particular moment then you have the data backed up at least till some some point you can't always just backup instantly all the data you'll have weekly backs or backups on monthly backups etc etcetera it is important to make a backup of existing database every single day I mean every single day depends on where you're working some companies do it differently it all depends on that all right so then database restore restoring is a process of building a database from a backup copy so backup is done to protect the data from data corruption hardware media failure or natural catastrophe time and again database administrators are required to restore the database from a backup to practice restoring process so because you know you'd be practicing it beforehand because if something really happens if there's a fire in the office and you hadn't backed it up to the cloud then you'll be in trouble because the data is gone the company is going to be going to be in loss because you can't access the data etc if the backup has been done then they can restore this back up and use the data then comes database design now this isn't very important for an administrator because this is again designing a database to be efficient and cost effective but if a DBA knows how to you know how a database has in design then they can always consult the developer or the thing is if you know database design then when the developers creating a new database then you can always consult them because as a database admin later you'll have some business logic also you know some business logic and accordingly you can consult with the developer and inform him how it has to be created especially in early designing processes then data move so a lot of organizations you know move the data here and there for particular purposes so as a the database administrator you need to know how you can move this data from one particular location to another if you're migrating to a cloud suppose you used you're working in a company that has been established for a pretty long time and they're still using on-premise hardware for database servers instead of using clouds like a lot of recent companies do and your company has a new CEO and he thinks that the new direction is to make everything cloud which is true so you need to be able to know how you're going to move this data obviously this is just a very specific example you'll need to know how to move it in world and different scenarios a lot of frequent requests for data moving can come from the development team they want the data database to be moved from production data production environment to the development environment so that it can be tested and you know so that the application can be tested using the database for all possibilities then comes data upgrade now we know how everything gets upgraded these days you get Windows you know you get a new Windows every other week well that's a no that's exaggeration it's every other four years but in at least in software like your applications for your phones they get updated every other week some applications even every other day so updates and not something new to a today's market everything gets upgraded and so do a lot of data bases software for those databases or the Oasis on visit those databases are running so a new really so for example a new version of the OS is released and the notification to upgrade comes in then you have to go ahead and upgrade that particular server to the newest and the newer version covers all of most of the problems which are older version Hanan so you don't have to worry of the old problems but it may add new problems so you need to think about that so similarly like again in detail as a database administrator you're required to upgrade the database to a newer version also this can't just be the with the OS you will the other components of the database also alright let's knock out database patching no patching is basically is a concept where not everything is perfect even after you upgrade something it's not perfect because it comes with a new bug that the testers were not able to find so you need to be able to patch your database also then we didn't talk about database security which is again a very important role of a database administrator security is a top priority for any company your data is your asset and you need to protect it as you know and you need to make sure it's as secure as possible so that no one else can take it because you can use the data to make better decisions and increase your profits alright so a DBA or a database administrator should always work with the security team to make sure to ensure they are in compliance and a DB secure for both external attacks and internal attacks creating a database user account with minimum privilege is one way to protect and obviously you'll be having a lot of user access so you need to make sure that you don't make any human errors there give the access to those who only need it etc then comes capacity planning no capacity planning is basically talking about growth future growth now as if you took an example your suppose you had a food delivery company and you're seeing an exponential growth so as a DBA you need to be ready for this kind of exponential growth you need to plan out how you can increase the disk space the memory the processing power the bandwidth to support your company's growth it is always good to overestimate then underestimate because if you overestimate you can you know you won't have any problems because you've made sure that there won't be any errors but in under estimating you know if you underestimate the bandwidth or the memory you need you won't be you know you lose a lot of data here and there so it's always better to overestimate well that's just suggestion for you guys so this is again another responsibility of a database manager do plan for the future and then comes database monitoring now this is important monitoring is done to ensure that the database is running without any problems now you monitor everything you normally as a in thesis everything is monitored an application will be monitored at all of its components this database it's back in is the servers the API everything will be monitored the performance will be monitored you know their health will be monitored everything so monitoring is done to ensure that the database is running without any problems normally monitoring a DB you can run complex queries building normally you can monitor the DB when complex queries you're being run or indexes are being built or data is being moved so you make sure that everything's being performed perfectly monitoring can be done to identify any problems or any problem queries so this is again you know during monitoring you can test a few things out also now each database comes with a tool to monitor it now depends on what kind of database you're using if you're using Oracle it is a suite of you know it has a suite of tools you can use to obviously have its own monitoring tool also and same way with MySQL and ms SQL Microsoft's SQL etc etc then last responsibility will be error log review so error logs are where the logs are spit out and every database management system has it so you know everything produces logs your application produces logs your system produces logs your server produces logs so similarly even database produce logs and if you want to debug if you want to see how your what's happened to your database suppose it crashed and you want to figure out what happened to it then you will go through the logs and you'll have a separate tool for that also but what's important here is that you need to review the logs and figure out what the problem is where why did the crash happen find the source of the problem fix it and then plan for future so that this problem never happens again so these were the responsibilities of a database administrator I hope you guys understood all right so let's look at some job descriptions over here so we have erickson now erickson is very big company so let's look at the job Catania so we can see that you need to be able to install configure and upgrade Oracle service service Oracle server software and related products good understanding of RAC and its services understanding active and passive active active well different OS few important commands to check with the server load partitioning so you need to know what are the different OSS you need to know indexing which is the important concept of database you need to work with very big databases 100 plus TV etc etc and key qualifications if you look at that you can see a good knowledge and physical database designed so they need you to know that design of the database like I said ins and out of 32 base you need to know that has a database administrator a good understanding of underlying operating system so on which operating system it's working on it suppose it's working on Linux or Windows you need to know how to use those particular operating operating systems well then great interpersonal skills that means you need to have good communication skills again I'm repeating this as a database administrator you need to be able to communicate everything properly because you'll be at the center of lot of problems and if you can't communicate things properly a few more errors can happen so you need good communication skills and excellent problem-solving approach again that's a part of every job description you need to know problem-solving and work as a part of the team and provide 24/7 support when required so you need to be on-call sometimes and you need to work with the team in synergy so that was Ericsson as you can see there are a lot of concepts you might not get in the start itself but if you take a certification or you get to get very knowledgeable in handling databases then you will get to understand all this also you will need some experience you can't this is this job profile actually is for a person who has some kind of job he have he has had a lot of experience for at least 2 3 years in this particular field and over you get paid accordingly also let's take another look we have Capgemini over here which is another MNC so in this the requirements are infrastructure specialist in Oracle database server installing and creating 10 G 11 G databases according to ofa model installing imaging Oracle 10g 11g receipt databases so as you can see a lot of companies are here are using Oracle as their database servers database and there are different versions of it and how to work with them you need to know that now again need to get some experience otherwise no I mean people don't usually take freshers and these job descriptions as you can see for people with a lot of experience like as you can see here it's 4 to 6 years so around this time you'll be earning a lot of money and you'll have a lot of this knowledge already because we the experience comes a lot of knowledge also you know and you really let's move on so these are the job descriptions alright so let's discuss this is database administration right for you so after me talking for 20 minutes or so what did you get what kind of idea did you get do you think it's right for you I mean you might be a fresher or you might be someone who's looking to change or you might be someone who's just watching this while eating because you know they just want to do something well think about it if you think database admin station is right for you after I discuss all the skills all the responsibility is the salary why it's important if you think it's right for you then go ahead and follow you you know follow the direction you have created for yourself and if you want to get into it I'll be providing a learning path in a few minutes okay if you do not still get what you want to do if you still not sure if you if you know if you don't understand what I do you give a sadness it does still or if you don't know if it's the right career path for you then don't worry we hear it in telepath we provide a kind of like counseling like it's it's not counseling but it's more like career advising so if you're a person who needs some advising in their career then go ahead and call us at these numbers if you're from India this is the number over here and in the left and if you're from us this is the number in the right go ahead call us we will give you a free session where you can just talk to a career advisor talk about what you like like if maybe you like SQL but you're not sure if BB is correct for you maybe you want to become a developer or a designer then you can talk to us and maybe we'll help you figure out what you actually want to do okay all right so let's move on so a learning path for database administration if you wanna if you think you can do this then this could be a learn in the this is the learning path for you so first you'll need to know how to install databases so if you're working with Oracle then you need to install it and configure it you need to know that and you need to know SQL now SQL is very important again one more advice for you guys if you're still not sure what kind of path you want to take my suggestion for you is choose SQL what I mean by choosing SQL is take a scale-up learn learn learn practice it as much as you can because SQL forms the core of every database rule or courier or path if you if you talk to anyone who's been in this field for like four to six years they'll be very good doesn't matter what role they're choosing they'll be very very good at SQL now SQL is a query language which is used to query of the data there is in the database so just open SQL up you can type in SQL Intel path we have a free course so we have a free course online on our channel here you can use it learn it and then you know go to a hacker rank do all the questions on SQL there or if you're still not satisfied then take up a few projects we here at NJPAC provide a lot of projects you can choose them so make sure that you're good at SQL if you think you want to go to the database field then choose SQL but if you're not sure about database itself call us okay all right then we talked about the database concepts so you know how to install and configure database you're very good at SQL now and once you've done that you need to be very good at all the database concepts how to design it what is the database theory what is indexing all those things you need to be very good at them well not very good so you know them at least the basics have fundamentals to become to go into the entry level of a database administrator or database domain itself you need to know the basic fundamentals of database concepts okay all right then practice practice practice so this is the mantra you should be doing with everything don't worry if you feel like you don't have any talent or if you feel like you know you're not that good at studies or if you know that good academics but you know you have some kind of skill you want to pursue you can always do it people who practice practice always become better that particular thing so just choose one thing that you like keep on practising on that particular thing does it matter it's cure this is a life advice for you if you like you know if you want to play cricket then keep on practicing you know you eventually get better at it all right so follow this mantra practice practice and again online training so let's talk about you know minimum do you go for an interview oh how will people actually look at what are things they look at so the thing is even though you might be a fresher or if you're a person who is just in school they want you to have at least some kind of degree I mean like in CS background like if you have a degree in CS background you'll be preferred over those who don't but don't be discouraged if you don't have the degree in CS if you are from EC or mechanical background that doesn't matter and if you are experienced in the particular field or if you have done good enough projects then people will still take you actually they will definitely take you if you have good projects and good experience if you do interview well okay but if you don't have a degree in CS if you don't have a proper degree at all then you what you can do is you can try out online certifications and diplomas or you can just get a diploma in this particular thing and online certification can be very helpful so I'll talk about what kind of certification be provided if you are looking for online certification then don't worry we do provide one and we will help you out at every step okay all right so how you can start so you can check out our blogs we have a lot of blogs on this particular topic or you can check out the channel on our channel and we have a lot of free content on this particular thing well it's not free like if you want to learn more then you definitely have to put a lot of effort into it what you can do is you can come to our website so this is a website over here and I've typed in here already be be a database administrator you have a lot of different courses here if you want to become an Oracle DBA or ms SQL DBA then we do provide those particular courses as you can see we have instructor-led training as well as self-paced training or like videos and we have lot of exercises and so on projects similar with ms SQL we have instructor-led training and self-paced videos also so if I go to Oracle DBA you can see a lot of things over here so if I looked at what will be taught to you you can see the code DB concepts which is very important you need to know the basics and fundamentals then role of a database administrator you'll be caught all of these things again like you know in more detail then you'll learn about SQL and pl/sql concepts then the physical and logistics structure of database introduction to tablespace configuring managing or local network so all the important things that you'll need to know to become a database administrator for Oracle and as you can see with the GDS I provided you that a lot of companies look for Oracle database administrator or if you're looking for a niche field you want to go for ms SQL Server DBA then we do provide that also I mean it's not a nice feel a lot of people use ms SQL also so choose which one you want or if you are not sure about it call our course advices or a career advices and we will help you out okay guys and if you want to be taught by actual industry veterans we have instructor-led training in inserted led training you will talk to the instructor the instructor will help you out with the doubts you have he will clear all the doubts you and you know he will give you all the industry idea about how everything works okay so once you get this certification it should be a very good boost to your resume that you have a certification on this particular topic in this case DBA as a database administrator alright so that was it guys and whoever's waited till the end or you know who people who just joined in the middle and we watched it till the end this is the surprise you basically get a you to 30 code on all of our courses so it's a flat thirty percent off you apply this code and you will get flat thirty percent off on all our courses you just have to visit in telepath comm type in DBA choose the particular course you want to choose then apply this offer code and buy the course alright well guys so thank you so much for watching I hope I helped you in some way I will see you guys in the next life

Channel: Intellipaat

Views: 132,092

Keywords: how to become database administrator, database administrator skills, databases, relational databases for beginners, relational database tutorial, database management system, introduction to databases, database fundamentals, databases tutorial, databases for beginners, oracle database, oracle dba tutorial for beginners, oracle dba certification, oracle dba jobs, oracle dba salary, oracle database tutorial, oracle database architecture, intellipaat

Id: e2oj-xgpiH0

Length: 39min 16sec (2356 seconds)

Published: Mon Feb 03 2020