- Introduction
- INTRODUCTION TO SQL SERVER ADMINISTRATION
- SQL SERVER APPLICATION
- INSTALL SSMS AND ADVENTUREWORKS2019 DB
- CREATING A DATABASE AND TABLE
- SELECT AND WHERE STATEMENTS
- UPDATE STATEMENT
- DELETE STATEMENT
- BACKUP AND RESTORE DATABASE
- INSTALL VISUAL STUDIO 2019
- CREATE A SSRS REPORT
- CREATE A SSIS PACKAGE
- BONUS VIDEO LIST OF COURSES
What you'll learn
- At the end of this course, the student will have most of his/her questions answered as to what it takes to become a SQL DBA and the courses that will help them get a career in SQL Server environment. Note: This course is an update to how to install, configure SQL Server 2019 Developer Edition
Description
This course is an UPDATE to The Ultimate Guide in Becoming a SQL Server DBA.
The primary purpose of this course is to give the student a sample of what the SQL Server 2019 Developer Edition administration is about, what are the requisites courses in becoming a SQL DBA, some guidelines as to what to expect from the job, and get some hands on experience in installing and navigating through SQL Server management studio. The course will provide a summary of courses needed that will enable the student to prepare for the real-world IT industry. These courses are Learn T-SQL, SQL Administration part 1, SQL Administration part 2, SQL Administration part 3, SSRS part 1, SSRS part 2, and SSIS. Collectively, it's all that a SQL dba needs to secure a job.
Other Courses
10 Steps to Stop Living Someone Else's Dream:
Make your own dreams a reality by developing the same mindset as the most successful people in history, starting today.
IoT - Turn a light on with your iPhone
IoT course providing students required knowledge to create BLE / iOS 9 apps using XCode and the Swift programming
Freelance Ninja: The secrets of successful start
All you need to know to start freelancing with zero stress+ I personally will review your profile and a cover letter!
How to Get a Book Published by a Traditional Publisher?
Sell the rights of your self-published book to a Publisher
Do You Make These Mistakes in Local SEO?
22 Mistakes commonly made in Local SEO that you can avoid
About the instructors
- 4.51 Calificación
- 145976 Estudiantes
- 27 Cursos
Raphael Asghar
Production SQL Database Administrator
Worked as a Production SQL Database Administrator and developer for over 15 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA. I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.
Student feedback
Course Rating
Reviews
Amazing
Thank you so much
excellent course
I really enjoyed the online course. To be honest, this was my first online course.I am looking forward to taking more online classes. The experience of this class has been nothing but positive. I really enjoyed this class and the format it was presented in.
Very VERY frustrating. I am supposed to be learning SSRS part 1, but that uses back versions of everything, and there is not a one-to-one correspondence with anything on my computer. The instructor said to take this free course, but again nothing matches what I have. Very time consuming, very frustrating.