Download Career Academy - SQL Server DBA by Samuel Gayle torrent or any other torrent from Other Applications category. How To Begin Your Career As a SQL Server DBA. If you are thinking about a career as a SQL Server DBA or developer then this course is for you.
Problem How did you learn SQL Server? This is a question that has been asked of me a few times over the last few months.
I have also been asked how someone can get up to speed with SQL Server very quickly and become productive. Check out this tip to get some suggestions to learn SQL Server and help benefit your career. Solution If I was new to SQL Server where would I start? How you learn SQL Server, or anything for that matter, depends a great deal on the person and how they learn. Some folks like to read about the topic to gain a baseline understanding, others like to jump in and be hands on, other people like to take classes. Let me break down some options to see what could make sense for you.
SQL Server Career Choices Before getting too far into the process, you need to understand the product, industry and professions a little bit. Here are some resources to consider:. On a related note, it would also make some sense to try to determine what sort of career path you may want to pursue. The career paths could include:. SQL Server Database Administrator (DBA).
Microsoft - Sql Server Integration Services
SQL Server Developer. SQL Server Business Intelligence (BI) Developer. Or all of the above.NET Developer. Network Administrator.
Analyst Learning SQL Server Once you get past the general questions about SQL Server, I guess one path would be starting off by installing the since it is free and has a number of core items to start learning about the technology. Alternatives would be an MSDN download from your company, the Developer edition or an (which will time out). Once you have SQL Server Express Edition installed, I would then spend time learning how each of the tools worked.
I would start off with. Browse around the tool and check out the menus, interfaces, etc. In many respects, this will probably be the tool you are using 80% of the time when working with SQL Server. From there I would install the. Once I have the databases in place I would review the.
I would want to understand the tables, columns, data types, NULL, Primary Keys, Foreign Keys. Then I would want to learn about.
I would want to learn the about Once I had a basic understanding of the data, I would start to query it with the. I would begin to include, etc. Clauses and understand what each of them do. The next step would be.
After the SELECT statement, I would research the, UPDATE and DELETE statements to understand how you would modify the data. Once you have these down pat, we can continue to learn more about the database engine and additional products that make-up the SQL Server suite of tools. Here are a few items to consider:.
SQL Server Books Online Visit your local book store or maybe even your library to see what they have on the shelf to learn SQL Server. Sitting down with a book might give you a good sense of your path to learn the technology. If you cannot find what you are looking for, visit your favorite online book store to see what books they have. In terms of free book resources, another option is SQL Server Books online.
Some people can read it from cover to cover and other people use it for specific topics, but it is a great free resource. Here are the current versions:. SQL Server Training Options For some people, spending the time and money going to training is the best way to get started. For those lucky enough to get their employer to pay for training, take advantage of it, ask a million questions and make the most out of it. Even if your employer does not pay for training, do not be afraid to make the investment in yourself. You may take a different path, but it could be the right building block for your career.
Here are some training options to consider from paid to free options:. (classroom and online). SQL Server (SQL PASS, SQL Connections, etc.).
Seminars from local vendors or online. SQL Server User Groups ( and ). Next Steps.
Learning SQL Server can be a daunting task, but take one day at a time and focus your learning on a particular aspect of SQL Server. Once you find your niche with the product, begin to deepen your knowledge in that area. There are a lot of hyperlinked tips included in the recommendations above, be sure to check them out to help grow your career. Let us know how you learned SQL Server in the tip comments (see above).
Your insight might be beneficial to other aspiring SQL Server professionals. Stay tuned for additional career development tips. Until then, check out these tips:. Last Update: 2011-10-02. Post a comment or let the author know this tip helped.
All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (.).Name.Email Notify for updates. NOTE. If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a text editor like NotePad before copying the code below to remove the SSMS formatting.
Send me SQL tips. Monday, May 23, 2016 - 11:52:17 PM - Mendil I went to school and I can say That I passed the beginners level in regards to sql server 2012(DBA). I practice daily with SSMS, quering and creating function and stored procedures. My question is now that I m on my quest to find job, I would appreciate if you could list what are the common task of an entry level DBA that I need to focus on? Plus what other thing that I need to learn besides SQL that will give me leverage as a Junior DBA?In the job postings I ve seen.net, VB, VS, hadoop,java and much more that you need to know besides your sql skills.Which ones is or are a priority to learn?
Thank you very much Wednesday, July 17, 2013 - 8:45:31 AM - Jeremy Kadlec Vishnu, I am not familiar with a 'database MNC'. What is that? Thank you, Jeremy Kadlec Community Co-Leader Thursday, March 07, 2013 - 8:02:43 AM - VISHNU PRASAD K.V Hi Sir, How much years of experience required for me as a DBA to get an entry to a database MNC? Monday, March 04, 2013 - 9:12:07 PM - Jeremy Kadlec Guddi, I would suggest learning about SSRS and SSAS. Check out these resources: HTH. Thank you, Jeremy Kadlec Community Co-Leader Tuesday, February 26, 2013 - 8:08:51 PM - Guddi Kaur Hello, I came across this article and it is very relevant to me at this time as I am thinking of taking some SQL Server training.
I have an IT business analyst background and want to move into data analyst kind of roles. I must say I am a bit blurred on what SQL Server path/training would be the best for me for transitioning from generic BA into data analyst/BI analyst/reporting analyst/technical BA sort of roles. My decision to move to data analyst kind of roles is based on market demand for these kind of roles. Any leads on how I should start with SQL sever in my circumstances would be very much appreciated.
Kind Regards, Guddi Wednesday, November 21, 2012 - 4:51:01 AM - VISHNU PRASAD K.V Hello Sir, I am interested in doing research oriented work in databases, rather than the administration. Can i have the oppurtunity for it. Tuesday, October 30, 2012 - 2:53:12 AM - VISHNU PRASAD K.V Thank you very much Monday, October 29, 2012 - 8:58:13 AM - Jeremy Kadlec Vishnu, That is a good question. I would check out these tips and I may see if I can provide an additional tip for you: HTH. Thank you, Jeremy Kadlec Monday, October 29, 2012 - 5:59:29 AM - VISHNU PRASAD K.V Sir I'm working as a junior DBA in an IT company. Actually, I'm interested in working as dba.
Here, I finds that the db related job limits to schema modifications, backups and restoration of databases only. Can u say the career of a DBA?
Tuesday, October 09, 2012 - 1:40:50 PM - Justin What a great 'article'. Thanks much for taking the time to post it! Tuesday, November 23, 2010 - 8:51:34 PM - Jeremy Kadlec FQR, Thank you for sharing your experiences. Thank you, Jeremy Kadlec Tuesday, November 23, 2010 - 7:24:51 PM - FQR First you need to know the fundamentals: SQL, Relational Database theory at least the how and why of normalization and the difference and fundaments of OLTP and OLAP. After you have a grasp on these fundamentals you should learn T-SQL which you can do simultaneously while learning and using SQL Server. Thursday, November 04, 2010 - 1:02:28 PM - Jeremy Kadlec Christian, Thank you for sharing your experience.
It is something to consider when you are starting out. Thank you, Jeremy Kadlec Thursday, November 04, 2010 - 10:53:56 AM - Christian Bahnsen My advice to someone serious about learning SQL is to spend the $50 to get the Developer Edition.
For the time and effort you'll be spending to learn SQL, the Developer Edition is dirt cheap and gives you the full Enterprise Edition feature set. I started out with Express Edition and got frustrated because many features aren't included.