How To Begin Your Career As a SQL Server DBA

Visit Tutorial Page ( Report)
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!!!
  • What Does A SQL Server DBA Do? Let's Define The Various Roles.
    • This Course Is About How To Start Our DBA Journey

      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.

    • Is This Course For You? Should You Take This Course?

      Let's discuss if this course is for you.

    • I've Been A Production DBA For Over A Decade. Let Me Show You How To Start.

      A little about me.

    • The Truth About Your First Job. Think Windows Administrator or Developer.

      This is where you start.

    • What Is A Relational Database? How Do The Tables Relate To One Another?

      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.

    • The ACID Properties. Pay Attention Here. Memorize The Bolded Definition.

      There's no shortcut on these. In order to understand relational databases we have to fully understand the ACID properties. It's one of the pillars relaional databases are built on.

    • The Various Jobs That Fall Under The SQL Server DBA Umbrella.
    • A Look Into The Daily Routine. A Day In The Life Of A Production DBA.
    • What Interest's You? The Two Forks In The Road.
    • Let's Wrap Up This Section. A Brief Summary of What We've Learned.

      Just a quick overview of what we covered in the first section.

  • Installation and Configuration. Let's Talk About Versions and Do An Install.
  • Working With The Table Object. Let's Talk About The Most Important Object.
  • Transact-SQL. The Language of SQL Server. We Need To Speak It.
  • Security. Let's Talk About The Fundamentals of SQL Server Security.
  • Backing Up and Restoring. The Most Important Thing You'll Do as a DBA
  • Conclusion. Let's Talk About What We've Learned.
Write Your Review