Q&A - Database Administrator | What they do

Поделиться
HTML-код
  • Опубликовано: 22 июл 2024
  • In this episode, I break down and explain what a Database Administrator does.
    Thanks for Watching!
  • НаукаНаука

Комментарии • 227

  • @DBpro83
    @DBpro83 5 лет назад +43

    Great video. 10 years as a DB professional and still challenged on a daily basis. We are living in the golden age of data management and there is still so much more to learn.

  • @crs12decoder
    @crs12decoder 3 года назад +5

    DBAs are not overlooked. As a software developer which also plans and sometimes executes deployments in a huge and critical production environment I ALWAYS had very high respect for how important a DBA's work is and I always take their advice. I honestly think the DBAs are the most important piece from a critical infrastructure and I salute them. Talking with DBAs to me is always a great pleasure and I have a lot to learn from them (even though they never want to hear of my application side :) ). They are very smart and always have to put up with all the crap that business throws at them. For a developer is quite simple, you work a bit overtime, you always have the option to deliver crap and fix later. But for a DBA, they cannot mess up. It's data we are talking about. Last few days someone from the development team added some queries to be executed automatically during deployment and I, and everyone else overlooked them. Those queries were long updates on a critical table and the person executing them had internet issues when executing the deployment script (which was executing the SQL query during that period). The transaction was not rolled back sadly and the table was locked. The person tried to execute the query again but with no luck. When rollback (which includes db restore) was requested the DBAs were there to help. They went through all sorts of RMAN bugs until they successfully restored the DB. DBAs are truly worth their weight in gold.

  • @nickd8524
    @nickd8524 5 лет назад +14

    Loved the video! I'm graduating in December with a degree in Information Systems. Can't wait!

    • @jesayjulie2828
      @jesayjulie2828 3 года назад

      ruclips.net/video/i2BjvSNJprA/видео.html

  • @Dunkster23
    @Dunkster23 4 года назад +2

    Thanks for the informative video. I have exposure to DB admin (MS Access, some SQL and virtualization). This has spurred me to go and get my certification. Thanks again!

  • @bartorpieli7264
    @bartorpieli7264 3 года назад +2

    You are a king! You Helped me a lot . I'm IT specialist. And this infromation helped me a lot .thank you.

  • @nicholasmurner7523
    @nicholasmurner7523 4 года назад +2

    You're the man for making this! I'm in IT sales and this is proving immediately helpful to my job

    • @learnitfromwilliam
      @learnitfromwilliam  4 года назад

      wow, didn't think this would apply to sales in I.T.. Glad it helped nevertheless.

    • @jesayjulie2828
      @jesayjulie2828 3 года назад

      ruclips.net/video/i2BjvSNJprA/видео.html

  • @fsaifi2209
    @fsaifi2209 3 года назад +1

    loved this video it has a lot of information for new students who wants to join in into IT fields thank you very much !

  • @desislavaandreeva4359
    @desislavaandreeva4359 5 лет назад +24

    You cleared all my doubts with this video! I’m currently on service desk role, however the manager offered additional training for Linux, MySQL, bash and process....Once I get these exams passed I can think about my next step in IT - database administrator! Many thanks for the vid!

    • @learnitfromwilliam
      @learnitfromwilliam  5 лет назад

      Awesome. Thanks for watching!

    • @mickalotz
      @mickalotz 4 года назад

      I would like to know what is the length of course and how many practicals did you do to actually get the grip of skill?

    • @jesayjulie2828
      @jesayjulie2828 3 года назад

      ruclips.net/video/i2BjvSNJprA/видео.html

  • @atampuri69
    @atampuri69 5 лет назад +3

    Thank you so much for this video. You did a great job explaining.

  • @shakurburton9358
    @shakurburton9358 5 лет назад +2

    I always though about working with databases and this sounds great as an opportunity. However, I'm not too big on programming, unless it involves SAL, since I only use Java as a hobby. What should I do???

  • @sethfrady9334
    @sethfrady9334 6 лет назад +2

    Very good and informative video! Thanks!

  • @bartorpieli7264
    @bartorpieli7264 3 года назад +1

    DBA main job and essence is actually to maintaining configuring and manipualting computing actions on the DB analytics,operations and the software that runs the DB on it ..as you said..for instance :migrating ,replications,updating..etc..DBA responsible for make sure the DB will run and always works properly. DBA job is divided to two section: 1) DBA Application-their duty is to controlling the data and software(app-in that case -the DB) runs on the hardware of the virtual or physical server (operating system):such us: Linux,Esxi,Windows.
    2)DBA infrastructure-their duty is to managing monitoring and fixing and solving hardware and software issues,mistakes,errors and problems in the server that runs the DB on it,for the DB functionality will be perfect. best regards. Bar

  • @absolute3112
    @absolute3112 4 года назад

    HOLY SH!T, 9 RUclips videos, trying to figure out what the hell a DBA is (looking for 2nd career) and thank the heavens I found this!!!!
    Plain, simple, informative... straightforward video, truly explaining the nuts-n-bolts of wtf a DBA even is. THANK YOU.
    Sick to death, of these other 'Vanity' RUclipsrs with fancy graphix, music... annoying voices and overly animated hand gestures, giving me anxiety. Im here to learn, not be entertained.
    Thank you again, great video.

    • @learnitfromwilliam
      @learnitfromwilliam  4 года назад

      This makes me so happy. I think I have a pretty good knack at breaking down difficult stuff into more simpler terms and you've confirmed that. And yes, I'm probably THE most boring non-fancy you tube channel around. As you can see I do Zero editing. I turn the camera on, start talking, then upload. Back in the day I used to add a few popups here and there but no more. I know it hurts the channel from growing, but I don't care. I just want to provide the info so ppl like you can get the info and have something to take away. Just like you said, I'm obviously not an entertainer :)

  • @abdullahsayed5906
    @abdullahsayed5906 6 лет назад +1

    Hi! I'm in the last year of my bachelor's degree I want become a database administrator, what is the process of becoming one like how long is the training or the course of database administrator?

  • @keirra041288
    @keirra041288 5 лет назад +8

    bing watching your videos...thank u!!!

  • @eduardoquiroga6804
    @eduardoquiroga6804 3 года назад +1

    thank you for your time.

  • @JBS439
    @JBS439 5 лет назад +1

    Hello and thank you for this video.I am a banker with 11 years experience and will like to try my hand in IT.I Have been told DB is something good to start with.Please where can I find resources to start as a beginner?

  • @khojizabikhullaev7106
    @khojizabikhullaev7106 4 года назад +1

    Thank you so much for very helpful information!

    • @jesayjulie2828
      @jesayjulie2828 3 года назад

      ruclips.net/video/i2BjvSNJprA/видео.html

  • @drikashanelle5468
    @drikashanelle5468 4 года назад

    Hi thanks so much for this video. I have no experience in DBA however in my city my local technical school is offering DBA certificate programs. The course is only 2 semesters long and I am considering taking the program. This would be something completely new for me. I was hoping to get some advice, being that this is completely new for me i was wondering is more education needed like a bachelor degree vs. just a certificate ?

  • @mrleonardgonzalez
    @mrleonardgonzalez 5 лет назад +1

    very useful. Thank you

  • @shimik11
    @shimik11 5 лет назад +1

    Hi, I'm starting my DBA courses next month, would someone as myself (who has experience in hardware programming using Arduino Uno, even though i struggled a bit to "understand" the programming language but no issue in writing it and followed courses for Windows Access) be a good candidate for a job in the DBA field? The program im following makes me able to work as an intern for a company and then transition into working full time into it coming out of college but i'm wondering about the *after* if i move on to another company... Thanks for the reply.
    *EDIT* : I should mention that i live in Canada (Quebec more specifically) and the college program ill be studying in gives me an AEC (a degree in which you dont have any maths or other "regular" classes but only the main course (Database Admin.)).

  • @Relytxz
    @Relytxz 7 лет назад +2

    Hi, I just have one question. I took a computer programming class, and I didn't do well in it. I'm not very good at understanding computer languages. Would I still be able to do this job?

    • @learnitfromwilliam
      @learnitfromwilliam  7 лет назад +3

      It depends..there are DB admins and then DB developers. If you don't feel comfortable with programming, then a DB developer might be difficult for you. But a DB admin may work out for you since you're not actually writing the scripts, etc...

  • @QueenNSim
    @QueenNSim 2 года назад +1

    You have a great voice and great personality your video was soo easy to understand and watch. Thank you so much

  • @sjspstudio9524
    @sjspstudio9524 6 лет назад +1

    hi there!
    my DB basics are clear, so should i go with Hadoop or first do certification on Oracle and then Hadoop

    • @learnitfromwilliam
      @learnitfromwilliam  6 лет назад +2

      Great question. I had to google Hadoop cuz I've never heard of it. Based on the little that I read, I'd say learn it "on the side" but go for either Oracle or M/S SQL certs. That gets more visibility at this point.

  • @davidadeogun1630
    @davidadeogun1630 5 лет назад

    Good video.Now,what's the best way to learn DBA?Online or on-site?If online,any links?

  • @alvinmarful-sau5362
    @alvinmarful-sau5362 6 лет назад +2

    great stuff. thanks!

  • @blue5had0w
    @blue5had0w 6 лет назад

    What do you think about Baker Online College's computer science degree? They have concentration in database technology.

  • @camara0
    @camara0 5 лет назад +1

    Great video man. Thanks.

  • @harinderdeepsingh1122
    @harinderdeepsingh1122 5 лет назад +1

    Good points thanks 👍

  • @Piccolo_Re
    @Piccolo_Re 3 года назад +2

    So to be a DB Admin you have to be good at coding? A lot of career tests I’ve taken recommend that career to me because I am highly organized, but I’m terrible at coding and programming, so I’m just curious.

    • @learnitfromwilliam
      @learnitfromwilliam  3 года назад

      You don’t have to know code. But you should be familiar with some of the basic database language. Ie Sql

  • @deizalnuncio
    @deizalnuncio 7 лет назад +1

    Hello ..i just recently got my oca certification. now I'm job searching but everyone wants experience. While I'm waiting on my big break what skills should a jr dba definitely have. what should i be practicing. I have two databases that i can use for practice. Thanks

    • @learnitfromwilliam
      @learnitfromwilliam  7 лет назад +1

      Hiya William. I thought I replied to this comment but it's not showing...I would start learning about the different Operating Systems the DB's run on. You'll need a good amount of knowledge on that. I would also learn a bit about networking because you might get tasked on those type of issues when they come up.

  • @davida6146
    @davida6146 4 года назад +8

    This is what I’m studying and I’m interviewing for some related jobs such as records coordinator.... Originally I intended of going the data analyst role, but DBA is more my thing atm....

  • @jessicavorster8209
    @jessicavorster8209 5 лет назад +3

    I’ve been in IT for a while and have been dabbling with databases. I’m just not sure is I should do the MCSE SQL 2016 Developer or the SQL 2016 Administrator course? If anyone has some advice please let me know :)

    • @learnitfromwilliam
      @learnitfromwilliam  5 лет назад +1

      Depends on how involved you want to get with SQL. If you like the development part of it, then go for that, otherwise stick with Admin work.

    • @nixonlauture7337
      @nixonlauture7337 5 лет назад +2

      If you have been working with databases for a while and you have a bachelor degree in computer science or data analytics. You don’t need to go waste money on certifications. You need to practice more and sharpen your skills. Some recruiters don’t really care if you have a certification you need to be able to explained things and do things. Hope that helps.

  • @bharath.vkumar5941
    @bharath.vkumar5941 4 года назад

    Still I was in confusion to select my career....
    I think it will be get me clear to select right one

  • @Truthseeker1515
    @Truthseeker1515 7 лет назад

    This is interesting, I have been working as the BA (so no database experience)on a new user interface accessible across regions (US, Europe, APAC) that consumes data from an upstream system. I created the high level BRD. The problem has been the design of the database associated with the user interface. And the translation of key field values from the files consumed upstream to the local time zone for each region. This had never been brought up by the developers and during UAT we could not reconcile against the existing MS Macro report output used in Production. It is so important to have competent and experienced teams offshore (especially India) And also capable of working in an Agile environment!....Otherwise, better to use an off-the-shelf package via a vendor.

    • @learnitfromwilliam
      @learnitfromwilliam  7 лет назад

      DB design and development in general is a big deal. Takes a ton of persistence and patience as well as the know how to get things done. But if you can do that work, you can pretty much write your own ticket in today's IT marketplace.

  • @trevor2102
    @trevor2102 3 года назад +1

    I'm going into college to be a DBA and the most bluntly I would put it is basically the librarian for a company's data
    Data librarian

  • @pankaj8286
    @pankaj8286 7 лет назад +1

    hi which one is the best field for long career point of view cisco networking(ccna,ccnp) or ms sql dba. because some people says there will be no scope of networking due to cloud computing . is it true ?

    • @learnitfromwilliam
      @learnitfromwilliam  7 лет назад +1

      Hi. They are both important parts of IT and will be around for many years to come. It just really depends on which one interests you more. By the way, they both pay very well if you get good at them.

  • @roddydrayy3213
    @roddydrayy3213 5 лет назад

    What is the biggest challenges, and the biggest roles a DB admin has?

  • @shakurburton9358
    @shakurburton9358 5 лет назад +1

    I meant to say SQL... I recently tried to go into software engineering, but I didn't like it that much, nor did I feel comfortable with it, compared to database or technician work. Any suggestions?

    • @learnitfromwilliam
      @learnitfromwilliam  5 лет назад

      You can still work with SQL and not have to program. You can be an admin and like I said in the video, it's not all programming at all. I'd suggest to dig into some SQL material and see if you like it.

  • @HA-kh3bt
    @HA-kh3bt 6 лет назад +1

    Hi Sir, I would appreciate your advise on this please :I am interested in learning Oracle 12 cSQL DBA and taking the certification, however I have heard that the future is for clouding. Do you recommend me to take the course( knowing that I had no experience in DBA, my area of experience is in IT Field support)? and do you think that having a Oracle DBA certificate will help to get into clouding in the future? or would you recommend to go to web developer such as Java script?
    Thank you

    • @jesayjulie2828
      @jesayjulie2828 3 года назад

      ruclips.net/video/i2BjvSNJprA/видео.html

  • @christiventer6559
    @christiventer6559 5 лет назад +8

    I'm currently Self Studying SQL DBA, and find it extremely daunting the deeper I go into it, but I'm also surprised that it's also very understandable. Currently I have a job as a Finance Administrator - (from admin clerk), but I've basically been pulled into the job straight after high school before I could actually make proper plans for actual studies in what I'm interested in.
    I like the fact that this is one of the things that you can study on your own pace and the information on it is freely available. Thank you for your video, it makes me even more determined to finish my studies and to pass the exams!

    • @learnitfromwilliam
      @learnitfromwilliam  5 лет назад

      Databases are a different beast. It’s basically like learning a programming language. I’m glad you found it understandable because it’s def not that easy for me 😃. I can do the basics but that’s about it. Wish you lots of success.

    • @davidadeogun1630
      @davidadeogun1630 5 лет назад

      Interesting.Do you rely mainly on RUclips videos or some other forms of resources?I really want to start a career in DBA.Thanks

    • @christiventer6559
      @christiventer6559 5 лет назад +1

      I'm working through Microsoft Virtual Acadamy which is free, and received a Database Fundamentals pdf handbook from one of my coworkers.
      I'm also working through exam dumps and W3schools (practice platform). There is also a Microsoft website called Channel 9. Channel9.msdn.com

    • @christiventer6559
      @christiventer6559 5 лет назад

      @@learnitfromwilliam Thank you!

    • @aprilainsworth3897
      @aprilainsworth3897 5 лет назад

      @@christiventer6559 I am on the same learning curve, studying with a friend for a few months now. We are currently using a textbook and preparing for exam 70-764 next. It can be done as self-study, but hearing people talk online about it is really helpful... it enhances the solitude of reading and practicing a great deal. BTW if you have not found SQL PASS yet, please look it up. They host free SQL Saturday events all around the world... a great way to meet DBAs and learn from them. Best of luck!

  • @djwizekile
    @djwizekile 5 лет назад +1

    Thank you!

  • @The19923
    @The19923 6 лет назад +1

    How interactive is your job as a DBA ? are you doing any consulting while on the job? Also do DBAs travel for work?

    • @learnitfromwilliam
      @learnitfromwilliam  6 лет назад +1

      Not sure what you mean by interactive. I'm guessing you are referring to interactive with peers in the company? I'm sure there are consulting jobs for DBA's but most of the time you'll be working for one company since you're responsible for their systems. Travel would be required if you're a true consultant.

  • @michelledudley2021
    @michelledudley2021 7 лет назад +3

    I want to take a class that will help me pass A+ certification. I need to get experience to get into helpdesk support. I'm
    seeking an accredited college where I can use tuition reimbursement. Do.you have any information?

    • @learnitfromwilliam
      @learnitfromwilliam  7 лет назад

      Hi Michelle. So you want to take classes to assist with the A+ cert? If you want to get tuition reimbursement, you'd have to check with your employer to see what they require. Once you know that, then you can look for the appropriate school.
      Don't forget that you can also self-study for that exam if you have the patience to do it.

  • @mmmmgoood3
    @mmmmgoood3 4 года назад +2

    Thanks for all the good info! I have a question.... I'm wanting to find a job I can do remotely. Based on what you have said here, I get the impression you may not feel this work lends itself well to being done remotely. Is that correct?
    And if so, can you recommend any variations of the DBA that would... or individuals you know who are exceptions and what factors allow it to work for them?
    I need to reunite with family in Ireland and Portugal and will need to be mobile between both countries.
    Nice Presentation!!! ;-)))

    • @learnitfromwilliam
      @learnitfromwilliam  4 года назад +2

      I don't quite remember what I said in the video but a DBA can definitely work remote without issue. The difficulty is finding a company that supports remote work. Alot of the smaller IT companies are moving to remote work but the bigger corps are still lagging behind. There are reasons for both. I will say this, if you are new to the industry, chances of you finding a 100% remote job are very slim. Remote work in the I.T. field is a privilege that has to be earned. And the fact that you want to live in two diff parts of the world to work...good luck with that. You might get away with that if you're working for yourself but working for a company is going to be very difficult to find. Sorry to give you the bad news, but it's just what I do...Hope you understand.

    • @slicker1260
      @slicker1260 2 года назад

      @@learnitfromwilliam would u say u need a degree to become a dba? how is the job security and salary for this position ?

  • @chinthadasaidilip
    @chinthadasaidilip 7 лет назад +2

    I am in b.tech last semister i have good academics skills in database. But to get a foreign job for database administration which
    certification needed. I have checked oracle 12c in oracle 12c which specific course is recommended to get good payscale and challengeble career.(Sir I am fresher to world). and what is the hirerchy of doing courses (role database adminstrator).

    • @learnitfromwilliam
      @learnitfromwilliam  7 лет назад +1

      Hello. It depends on which database software you plan to work with. Microsoft or Oracle. Each of them have different certification paths and you can find them on their websites.

  • @thompielumerio7529
    @thompielumerio7529 3 года назад

    is it true that in the near future the database administrator will be replaced by self healing database software? which means it will decrease the number of db admin? can anyone enlighten me, by the way im a student only. Thank you!

  • @vishnuumakanthan9583
    @vishnuumakanthan9583 5 лет назад +3

    I am trying to get into a sql developer job , I do have some skills in writing sql queries , do i have to get a certification to get a foot in the door?

  • @ulysses1904
    @ulysses1904 5 лет назад +4

    Good video. I passed the MS 70-461 for writing SQL queries and am currently studying for the 70-462 DBA exam. This was a helpful overview of the job I hope to have.

    • @learnitfromwilliam
      @learnitfromwilliam  5 лет назад

      Nice!! Keep going. You will succeed in this industry if you keep persistent.

  • @colinrhee98
    @colinrhee98 3 года назад +3

    I feel like DBAs are always overlooked 😭😭

  • @robinm521
    @robinm521 7 лет назад +15

    Do you recommend a BS in computer & information technology degree to become a DBA ? Because I've heard a degree in computer science is more for programming engineers and developers. I just don't seem as interested in creating scrips and codes as I would managing the database.
    Thanks for the video. I'm getting really excited to go back to school for this major. I'm 26, but my wife motivates me everyday to go back. Better late than never.

    • @learnitfromwilliam
      @learnitfromwilliam  7 лет назад +15

      Hello Robin. You don't need a BS degree to be a DBA. And yes, a CS degree is not gonna get you there either.
      You will need to understand the basics/intermediate of SQL queries, statements, stored procedures, etc which is a type of "code/programming language". So if that seems out of your realm or not interesting, you probably do not want to pursue the DBA path. Just wanted to get that out there first.
      Do you know if you want to get into Microsoft SQL server or Oracle or both? Those are the two biggest players out there. Once you decide, you can find online courses to take that will get you certified. That's what I suggest as a starting point.

    • @robinm521
      @robinm521 7 лет назад

      I don't mind learning the code/program languange. I guess I should of rephrased it and said I don't want to write the code and make up the codes for programs.
      The reason I wanted a BS was because every job I have searched for in DBA seems to require a BS. I don't know if I want to do Microsoft SQL or orcale since I haven't researched them enough so see which would be more interesting but I'm sure learning both would be ideal.

    • @learnitfromwilliam
      @learnitfromwilliam  7 лет назад +4

      The fact is that most IT jobs have a BS as a requirement in the job listing. However, it's not always necessary. I don't have a BS and can get a job that has it listed as a requirement based on my experience. If you can find a BS degree with a concentration in DB work, then go for it but I don't think there are specific degrees for that. However, I'm saying to not get a BS. If that's what you want, then go for it.
      M/S SQL and Oracle are different but the concepts are the same. So once you learn all the fundamentals about DB's, you can do both eventually but that will take awhile to get there.

    • @robinm521
      @robinm521 7 лет назад +1

      Awesome. Now what certifications do you recommend from Microsoft ? I looked them up and wow there is tons of certifications, a little overwhelming. I commend you for learning all fundamentals and functions of sql and everything In between of IT on your own. Yeah for me I feel like going to school for it, is my way of getting introduced into all things of IT. Also I just wanna say thanks for all the videos and replies. It means a lot helping me with my new interests and god willing future career.

    • @sievpaobun
      @sievpaobun 4 года назад +1

      cheer up bro
      u are never too late to fulfill ur dream

  • @tapan1008
    @tapan1008 6 лет назад +1

    Which degree you would prefer me to become Database administrator? Computer science or Computer information Technology?

    • @learnitfromwilliam
      @learnitfromwilliam  6 лет назад

      I'm really not sure. You'd have to review the curriculum for both degrees and decide. Also keep in mind you can take other classes online even to learn about DBA work.

  • @pankaj8286
    @pankaj8286 7 лет назад +2

    thanks to clear my doubts sir

  • @silvacodex
    @silvacodex 7 лет назад +8

    Sir,I am in my final year in highschool,and I want to go for database admin where should I start from?

    • @AndrewFalwell
      @AndrewFalwell 7 лет назад +1

      Sylvernus Akubo you are in the right place. You just keep reading about these videos and maybe apply to intern or temp with a company that hires local it peopl

    • @AndrewFalwell
      @AndrewFalwell 7 лет назад

      Consider looking at your local school district or university

    • @petocean5978
      @petocean5978 7 лет назад

      Sir you are right

  • @petraslobodova4979
    @petraslobodova4979 4 года назад

    Thank you for the video :)

  • @janicesmith1137
    @janicesmith1137 3 месяца назад

    Thank you.

  • @jonesbijoy1321
    @jonesbijoy1321 5 лет назад +2

    I have a Major in computer science and I was wondering if I could get this job
    Edit: How much is the pay for it in Australia?

    • @learnitfromwilliam
      @learnitfromwilliam  5 лет назад +1

      Get which job? I have no idea about salaries outside of the US.

  • @lnfsg5136
    @lnfsg5136 5 лет назад +2

    I have a question, sir. As a DBA, do i also have to know languages like java, c++, or python? And do i have any chance of using fancy algorithms?

    • @learnitfromwilliam
      @learnitfromwilliam  5 лет назад

      You wouldn’t use those languages. I’m not sure what type of algorithms you’re referring to.

    • @azucenabustos1078
      @azucenabustos1078 5 лет назад

      If your working backend for software or website

  • @tushibhaque863
    @tushibhaque863 7 лет назад +1

    which is going to be more demanding in future...MS SQL or Oracle?

    • @learnitfromwilliam
      @learnitfromwilliam  7 лет назад

      BOTH. Neither of those companies are going anywhere anytime soon. You'd be safe with either.

  • @troywood22
    @troywood22 4 года назад

    I'm 33 and have been working a warehouse job my entire adult life. I have no IT experience and very little computer knowledge. Would a career as Database administrator be feasible? I'm currently thinking about applying for school.

    • @learnitfromwilliam
      @learnitfromwilliam  4 года назад +1

      You'd really need to like working with databases to consider something like this. But that's an advanced type of position. You will have to work your way up the chain for that. And as you work up the chain, you may find something else that interests you. The main question is do you really want to get into IT and then make a decision to hit it hard with the studies. You also have to be OK with working in front a computer all day. That is the opposite of what you're doing and might be a difficult transition. But kudo's to you for considering scaling up your career.

  • @robbiefazle7802
    @robbiefazle7802 3 года назад +2

    I'm going to become a Database Administrator too. Thanks for the video, it helped. It's a good job.

  • @emmanuelletshilumba8957
    @emmanuelletshilumba8957 3 года назад +1

    Great explanation thank you so much. Next year I will graduate in information technology management I would like to know as dB administrator do I need only sql for programming part or I have to master python for instance

    • @learnitfromwilliam
      @learnitfromwilliam  3 года назад +1

      I would definitely recommend understanding SQL at a high level. Python is not necessary.

    • @emmanuelletshilumba8957
      @emmanuelletshilumba8957 3 года назад

      @@learnitfromwilliam thank you so much

  • @lonnieherbals
    @lonnieherbals 5 лет назад

    Is age an issue with DBA? I've been doing general IT admin work since 1998, but loved it when I got to manage and program for an SQL database at my last gig. Lately I've been growing tired of Network Admin work and looking for a change, but am scared my age will be a factor at getting a DBA job. Is 40 old for this field? My twin went into java programming and found discrimation due to his age, so I've been kind of scared to make the jump. Can you give me any incite? I don't know any DBAs to ask directly, but I manage two SQL servers at my current job. I'm not being paid DBA wades right now though.

    • @learnitfromwilliam
      @learnitfromwilliam  5 лет назад +1

      I wouldn’t be concerned about your age specifically because you’ve been in the field for so long AND already working with SQL now. You’d basically just be changing job title and role. I’m 43 and just changed positions and had no issue. Your sibling just needs to tell those harassing idiots to take a hike and shove it. Appreciate you watching!

    • @lonnieherbals
      @lonnieherbals 5 лет назад

      @@learnitfromwilliam Cool thanks. From your experience do these jobs normally require an degree? I've noticed a lot of job postings require a bachelor's degree. Unfortunately I only have experience, but could pick up some certifications.

  • @frownless
    @frownless 6 лет назад +2

    How do I go about getting certifications any good site

    • @learnitfromwilliam
      @learnitfromwilliam  6 лет назад +1

      Depends on the type of certification. Most of them you can self study but there are also tons of places you can find resources and even classes if you need the face to face with an instructor.

  • @SergioUrrutiaOyer
    @SergioUrrutiaOyer 6 лет назад

    Hi William! First time watcher and I really enjoyed your video. First time actually doing research on what managing a database looks like and this is super helpful. I have a couple of questions, and a bit of a philosophical question for you in the spirit of my own career search:
    - In your experience, how common are part-time database management positions? Are there situations where you can create your own hours as long as you are doing your DB due-diligence every week (excluding on-call emergencies if the DB goes down)?
    - How common is it for DB managers or programmers, part-time OR full-time, to have enough free time to pursue other entrepreneurial avenues? I know there is a strong part of me that could enjoy and succeed in this field; but to be honest, I'm a bit worried about getting too caught up in being too detail-oriented and worrying too much about every little detail in the system. For someone who REALLY enjoys creating a microcosm of a world to perfect, especially with computers, could this field potentially eat up the rest of my interests relative to the workload?

    • @learnitfromwilliam
      @learnitfromwilliam  6 лет назад +1

      Hello Sergio. Thanks for watching the video and taking the time to ask questions. I'll do my best.
      In general, the IT world doesn't offer part-time positions unless you're in the entry level type roles. So I wouldn't bank on that as an option.
      Most companies will expect you to work a regular shift (whatever that is for them). You're talking more about a freelance type thing and in most cases you won't find DB admin work as a freelancer. I'm sure it can be done but it'll be difficult to find that work.
      If you're entrepreneurial and can't go 100% on your own deal, then you'll have to work a regular job and work on your own gig after hours. It's called "hustle" :)
      Being detail oriented is not a bad thing in I.T. In fact there's plenty of what we do that requires details and paying close attention to what you're doing. But you have to control it and not be consumed and obsessed by it.

    • @SergioUrrutiaOyer
      @SergioUrrutiaOyer 6 лет назад +1

      That was most excellent, thank you!! That is good to know - I won't bank on a higher-paid part time position then (excluding the varied world of freelancing). It must be the hustle life I believe I'll be eventually be involved in (and/or creating my own field). That's something I really have to come to terms with.
      That sounds right for the detail orientation.....I think I just need to continue seeing my therapist for that one...but I'm confident I can make it work.
      I've been looking into startups as fairphone.com, which is what I'd feel most ethically proud of if I did go full on into the tech industry, as an eventual landing point after working at places I align less with. I realise that I want to change the industry more than I feel good in my gut providing my skills for the general force, even if I love doing the processes. So that's something for me to chew on.
      I appreciate your answer very much! This was super helpful......will probably be watching more of your stuff in the future

    • @learnitfromwilliam
      @learnitfromwilliam  6 лет назад +1

      Glad it helped. Follow Gary Vaynerchuck for inspiration regarding your entrepreneurial interests (if you don't already). Dude is a beast and will enlighten you on that topic.

  • @dev.antunes
    @dev.antunes 5 лет назад

    Nice video :D!

    • @dev.antunes
      @dev.antunes 5 лет назад

      I'm having database classes in my high school (3° and 4° year), it's cool :)! maybe one day I'll try work with this, idk.

  • @kheranjal
    @kheranjal 6 лет назад +2

    Love this video, thanks a lot, I've made up my mind on DBA(goin for MS sql since i'm already good at it, self taught). I'm more a thinker than doer...Is this job stressful? Or is it enjoyable? Thats the last hitch i have in choosing this field..Thanks! and hope you reply to my "Query" (see what i did there xd)

    • @learnitfromwilliam
      @learnitfromwilliam  6 лет назад

      Glad the video helped. Is it stressful? Well, in any type of job there will be times of stress and pressure of some sort. The important part is how you manage it. Enjoyable? Well, you better like working with databases otherwise you'll be bored to death and hate it. You also need to be good with working in a team environment. I think I mentioned that in the vid.

    • @kheranjal
      @kheranjal 6 лет назад +1

      Very helpful, and i made my decision to get into IS or db/sys admin etc. You're very helpful thankya, I subscribed! =D

    • @learnitfromwilliam
      @learnitfromwilliam  6 лет назад

      awesome, wish you lots of success!

    • @illusion7223
      @illusion7223 4 года назад

      Can anyone without a computer background master this course?

  • @pankaj8286
    @pankaj8286 7 лет назад +1

    hi it is very informative , i have a doubt is it required a knowledge of tsql progamming or sql query for becoming dba

    • @learnitfromwilliam
      @learnitfromwilliam  7 лет назад

      Thanks for watching. TSQL is more of the "baby-brother" of SQL. So most admins will already know how to use TSQL. So it would be best that you do understand it.

    • @mesfinmade1672
      @mesfinmade1672 5 лет назад

      It's very important information thanks for sharing please I need more video

  • @usamakhan294
    @usamakhan294 4 года назад

    Please guide regarding it's jobs availability, I had a conversation with one professional, the told me Most of the companies doesn't require DBA, there the work of the DBA is done by the software developers.
    He told in very rare cases the company hires DBA to maintain there database, So you please en-light this matter.
    Thanks.

  • @susetsantos7720
    @susetsantos7720 5 лет назад +2

    Hi! I have a bachelor in IT, but no experience. Do you know which Certifications I have to get, so I can get a job as a Database administrator?

    • @learnitfromwilliam
      @learnitfromwilliam  5 лет назад +1

      First you have to figure out what database platform you’d like to work with. The two top players out there are Microsoft SQL and Oracle. Both of which have certifications.

    • @susetsantos7720
      @susetsantos7720 5 лет назад

      @@learnitfromwilliam SQL

    • @learnitfromwilliam
      @learnitfromwilliam  5 лет назад

      @@susetsantos7720 Seek out the Microsoft certs for SQL server and start there. If you can, setup a server and install SQL and start messing with it.

  • @charles8784
    @charles8784 7 лет назад +2

    As a follow up to your videos which am following, can you tell me the difference between database developer and administrator??

    • @learnitfromwilliam
      @learnitfromwilliam  7 лет назад +1

      Hello Peter, I thought I mentioned it in this video, no?

    • @charles8784
      @charles8784 7 лет назад +1

      Actually i did not see it...but i did understanding your differences between the computer science and computer engineer which is giving me an idea on what a database developer is all about..

    • @learnitfromwilliam
      @learnitfromwilliam  7 лет назад +1

      ah...just reading the title...watch the video and let me know if that addresses your question.

  • @TopJoo7
    @TopJoo7 7 лет назад +2

    informative

  • @kwakuboateng7525
    @kwakuboateng7525 6 лет назад

    Hello, kindly send me more resources on MS SQL DBA, and Developer. Need to knows, and walkthrough on the actual Management Studio. Thanks

  • @obedmonari4882
    @obedmonari4882 7 лет назад

    very informative clip. I am interested in database management and I am just out of high school, where can I get the course outline or the scope of things that i need to cover?

    • @learnitfromwilliam
      @learnitfromwilliam  7 лет назад

      Hello Obed. Do you plan on going to university for a degree or want to go straight into I.T. by obtaining certifications, etc?

    • @obedmonari4882
      @obedmonari4882 7 лет назад

      I just want to get into IT and get certifications without necessarily enrolling to a degree course

  • @syedsaqibaftab19
    @syedsaqibaftab19 6 лет назад +2

    Hello Sir, I'm really confused can I get a sql database developer job with just oracle certifications or a BS degree is requirement for it? Thankyou.

    • @learnitfromwilliam
      @learnitfromwilliam  6 лет назад

      Hello. It really depends. If you have the experience and no degree, I'd say you can probably get a job. But it also depends on the country you live in. Many countries do require college degrees.

  • @walterwhite2023
    @walterwhite2023 5 лет назад +3

    I'm a construction worker and I hate it. Where should I start to become a database administrator?

    • @learnitfromwilliam
      @learnitfromwilliam  5 лет назад

      Why do you hate construction? Shit ton of money in that field if you’re good. Anyway, do you have any experience on IT at all?

    • @walterwhite2023
      @walterwhite2023 5 лет назад

      Honestly no I don't have any IT experience. I attended a computer science 101 course at community college. It was a rip off.

    • @walterwhite2023
      @walterwhite2023 5 лет назад +2

      And construction is tough, I work for an excavation company hot weather, cold weather, breathing dust, saws, trip hazards, asbestos , heavy machines operated by sketchy people. And I can handle all of that but what I hate is I'm 32 now and everyone over 40 is miserable they hate it and they're so bitter. Even the guy's that are making big money. Anyways sorry for writing a book in your comments section,
      I just feel like paying a college isn't necessarily the best route and I'm looking for advice from someone that works in this field as opposed to the instructor that I payed to teach me binary and tell me "it's like cursive you'll never use it". $700 course plus $200 book we didn't use. Thanks for any response.

    • @learnitfromwilliam
      @learnitfromwilliam  5 лет назад +3

      I hear you. Construction is a tough industry. Sounds like your mindset is much different than those ppl you referenced which is great. If you’re a motivated person, you can self study and. There are also online specialty courses that you can look into.

  • @annerushani4867
    @annerushani4867 3 года назад +2

    Which is better, Database Administration or Cyber Security?

    • @learnitfromwilliam
      @learnitfromwilliam  3 года назад +1

      Well, they are two diff careers but I would suggest cyber security is the better of the two just because of the direction technology is moving towards.

    • @annerushani4867
      @annerushani4867 3 года назад +2

      @@learnitfromwilliam Thank you sir!

  • @SupremeGaia4
    @SupremeGaia4 7 лет назад +1

    Hi, I'm studying for my 220-902 exam and I want to know what are some places I work or volunteer to gains some more experience in IT? Thank you very much

    • @learnitfromwilliam
      @learnitfromwilliam  7 лет назад

      Hello. What is your current experience?

    • @SupremeGaia4
      @SupremeGaia4 7 лет назад

      I took an A+ class where I learned about the inner hardware of a computer and took it apart also have software knowledge and outside of school I'm mostly software such as using maintenance tools,microsoft products like word, excel, access, and powerpoint,

    • @learnitfromwilliam
      @learnitfromwilliam  7 лет назад

      SupremeGaia4 Ok, then focus on getting some certifications because that will look good on a resume/CV. Then you can start looking for work. For volunteer work, you can go to non-profit organizations, churches, friends, family, and anywhere you can find opportunity to get experience.

  • @alicemukototsi3884
    @alicemukototsi3884 4 года назад +1

    Just going to start the program in two weeks time😘

  • @muame5225
    @muame5225 2 года назад

    Hay quá

  • @micjakes1
    @micjakes1 5 лет назад

    Am looking at an associate degree in database administration. Is that worth anything?

    • @learnitfromwilliam
      @learnitfromwilliam  5 лет назад

      Possibly. As long as the curriculum is super focused on database work and not useless classes.

  • @dorian1689
    @dorian1689 6 лет назад +3

    To learn DBA would you suggest buying a Udemy course????

    • @learnitfromwilliam
      @learnitfromwilliam  6 лет назад +1

      +dorian wright I haven’t seen any of the courses on udemy but am familiar with that site. It’s hit and miss from what I’ve seen. Do you have any experience or knowledge of database admin type work ?

    • @lonnieherbals
      @lonnieherbals 5 лет назад +2

      Udemy is great, but you have to watch a few of the previews before hand. Some of the teachers are good, and some are bad. I learned picked up new Linux skills and applied them at my job from that site. I also learned how to write a video game in Unity.

  • @teddytechilo
    @teddytechilo 5 лет назад

    How much can one make as a DBA at an entry level position and what's the most one can make with 5 to 10 years of experience?
    thank you in advance!

    • @learnitfromwilliam
      @learnitfromwilliam  5 лет назад +1

      I can only estimate for the US. I’m also varies depending on the state. But let’s assume it’s a major metropolitan city, entry level probably at 40k and after5 yrs upward 100k. Don’t quote me on these numbers. Just estimates.

    • @teddytechilo
      @teddytechilo 5 лет назад

      @@learnitfromwilliam Thank you....i understand !

  • @halimmaouche1922
    @halimmaouche1922 7 лет назад +1

    I want to learn sql dba, can you post more videos please ...Thanks!

  • @misternormL
    @misternormL 7 лет назад +29

    1.5x video speed is still approaching normal speaking speed lol

    • @mostafaelmadany8046
      @mostafaelmadany8046 5 лет назад +4

      1.25 enough

    • @augustoliver351
      @augustoliver351 5 лет назад +3

      Sounded great to me. No need to speed it up. I actually liked the video. Thanks for your time. 😉

    • @jesayjulie2828
      @jesayjulie2828 3 года назад

      ruclips.net/video/i2BjvSNJprA/видео.html

  • @PrettyBoyJC18
    @PrettyBoyJC18 7 лет назад +3

    Sir, Can you do a tutorial on a real display server? Meaning can you show me what one looks like since I've never seen one before please? and why is that ignored by IT professionals/professors? It just seems like in school they beat the content learning of it all into our heads and ignore the showing of the equipment hardware of it all besides the computer and it angers me.
    Thanks in advance

    • @learnitfromwilliam
      @learnitfromwilliam  7 лет назад

      +Jason Cannon Not sure what you mean by real display server.

    • @PrettyBoyJC18
      @PrettyBoyJC18 7 лет назад

      Information Technology Q & A Show
      An actual Server of what it looks like. Sorry about that. I've only seen a server in my textbook or only in Google.

    • @learnitfromwilliam
      @learnitfromwilliam  7 лет назад

      So you've never had access to an actual Windows Server for example?

    • @PrettyBoyJC18
      @PrettyBoyJC18 7 лет назад +1

      Information Technology Q & A Show 😂😂No sir I haven't.

    • @PrettyBoyJC18
      @PrettyBoyJC18 7 лет назад

      Information Technology Q & A Show Besides the computer and a few cables I've never seen a lot of the pc hardware IT pro's such as yourself are talking about.

  • @The19923
    @The19923 6 лет назад

    How many DBAs are usually working on a server?

    • @learnitfromwilliam
      @learnitfromwilliam  6 лет назад +1

      Can't really answer that because it depends on how large the company is, how many DB servers they have, how many DBA's, etc.

    • @The19923
      @The19923 6 лет назад +2

      Information Technology Q & A Show
      cool, I'm going back to school for MIS and I'm just wondering if I'll have some guidance/mentorship after I hopefully get an entry level DBA job.

    • @learnitfromwilliam
      @learnitfromwilliam  6 лет назад

      Ah, I didn't really understand the context of your question but that makes sense now.

  • @swirlandtwirl5417
    @swirlandtwirl5417 4 года назад

    Salamat

  • @paulinoborono8881
    @paulinoborono8881 6 лет назад +2

    Hello sir i do love your video session. i believe that it's so informative. Well i just graduate in Network and System Administration (A.A.S) and i am really interested in DBA carrier. What are your recommendation?

    • @learnitfromwilliam
      @learnitfromwilliam  6 лет назад

      Congrats on the AAS. I would say just do self study or take classes on database administration.

  • @dbloyd2
    @dbloyd2 4 года назад +1

    It is hard to explain that role. You say what really happens then goes over people’s head. If you simplify it, it sounds like an easy job. That explanation was kinda how a programmer would explain it to an end user based on what they observed and using the sql server / windows prospective.

    • @jesayjulie2828
      @jesayjulie2828 3 года назад

      ruclips.net/video/i2BjvSNJprA/видео.html

  • @Atameow
    @Atameow 6 лет назад

    uh, uh , uh "think of it as a uhh , uhh" without getting to deep into it
    This is like watching a high school student presenting a project on database admin, and doing it the night before.

    • @learnitfromwilliam
      @learnitfromwilliam  6 лет назад

      Mike J sorry you feel that way. Hopefully you can find better videos on this topic.

  • @xorben1981
    @xorben1981 4 года назад

    Last Point: Always telling the customer, that we are no developers.

  • @The19923
    @The19923 6 лет назад +1

    Also what is the best entry-level position to be a DBA?

    • @learnitfromwilliam
      @learnitfromwilliam  6 лет назад

      Good question. I'd say first getting familiar with server systems both hardware and software (Ie, windows, linux, etc) since those are the platforms that support the database applications. Then start becoming familiar with the DB applications and move up from there.

  • @ravindrakumara.
    @ravindrakumara. 5 лет назад

    Bro
    try to improve presentation.
    Your confuse!

  • @unchainedbeast
    @unchainedbeast 5 лет назад

    lol train wreck explication

    • @learnitfromwilliam
      @learnitfromwilliam  5 лет назад +1

      Sorry to waste your time watching it. I’d love to see YOUR explanation video on this topic. Send me the link.

  • @4thdemz829
    @4thdemz829 6 лет назад +4

    well you dont look like a nerd so maybe i can learn DBA

    • @learnitfromwilliam
      @learnitfromwilliam  6 лет назад +5

      I guess you are classifying everyone in I.T. as nerds? That's very old school. Most of us are not nerds, me especially. Thanks for watching.

  • @thanhthao2894
    @thanhthao2894 Год назад

    Hay quá