How To Begin Your Career As a SQL Server DBA
- 1.5 hours on-demand video
- 4 mins on-demand audio
- 18 articles
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- A the end of this course you'll know what IT positions are starting roles for SQL Server DBAs
- You'll learn how to sift through job descriptions specific to your level of expertise.
- You learn what a day in the life of a DBA looks like.
- This course was designed for anyone with basic computer skills.
- There are no prerequisites for this course.
- All the materials for the course are free and will be downloaded as part of our lessons.
"One of the best courses I have taken on Udemy. Short and straight to the point. I have been trying to get into DBA job and have been watching long videos and this by far is THE best course to understand DBA jobs before going into more depth." -- Lopsang Gurung
Welcome to the Course
Congratulations are in order for having chosen to pursue the path of the DBA. YOU'VE made an EXCELLENT decision and one that I have no doubt will be very rewarding should you so wish.
As with any serious endeavor, YOU want to give YOURSELF the very best possible start in order to ensure things can move forward.
This course focuses on what YOU need to know in order to become a REAL WORLD SQL Server DBA.
SQL Server is one of the most complicated software offerings Microsoft has. It requires YOU have a foundation in networks, databases and programming. This wide range of skills is often difficult to obtain without rigorous learning and years of hands on experience.
The REWARDS YOU will OBTAIN are worth effort. Here are just a few. DBAs are very well compensated. YOU will get to work with some of the SMARTEST people in the IT world. You'll LEARN something EVERY DAY. The profession has been and will continue to be one of the highest growth professions.
SQL Server Database Administrators are responsible for the design, implementation, support and maintenance of SQL Server Databases. The role also includes architecting, building and scaling databases for future data growth and capacity.
DBA are also responsible for security, performance and availability of data to users and customers.
This course will give you some direction on how to begin your journey as a SQL Server DBA. I don't want to create any false promises. In addition to years of experience most Senior Level SQL Server resources have read a voluminous amount of product related material.
WE have to start somewhere and THIS COURSE will provide you with the REAL WORLD insight YOU need in order to start your journey.
If YOU are seriously interested in either starting out on the path to becoming a SQL Server Database Administrator the YOU'LL need two key ingredients. Experience and product knowledge. Experience might not be easy to get but it will be impossible if you don't have a very solid foundation in SQL Server.
ENROLL now. Let's get started!!!
- This course is a 101 level course. Anyone with basics computer skills can take this course.
- This course is not for accidental DBAs or junior level DBAs.
- If you are thinking about a career as a SQL Server DBA or developer then this course is for you.
Starting is often one of the hardest parts.
SQL Server is a massively complicated product.
Where do we start?
In this lecture we'll learn what's going to be covered in this course.
Let's discuss if this course is for you.
A little about me.
In it's most basic form a database is a collection of objects.
The most important being the table object.
The table object stores structured data.
Let's learn about the very basics in this lecture.
All versions of SQL Server have free versions that have limitations.
It gives those who want to learn SQL Server a chance to work with most of the same functionality of enterprise versions.
This version is called SQL Server Express.
In this lecture we are going to learn how to download and install it.
With each release of SQL Server Microsoft will often have different editions of SQL Server.
When you are deciding on which edition to choose make sure you find our what the editions are for each version.
There is no guarantee SQL Server 2014 will have the same editions as SQL Server 2016 or SQL Server 2018.
The fundamental unit of data storage in SQL Server is the page. The disk space allocated to a data file (.mdf or .ndf) in a database is logically divided into pages numbered contiguously from 0 to n. Disk I/O operations are performed at the page level. That is, SQL Server reads or writes whole data pages.