SQL Server Database Administration (DBA)
100
Lessons
All
Skill Level
9:59h
course Duration
English
Audio
Eng & Esp
Subtitles
Overview
Do you want to gain practical experience in Database Administration in SQL Server? Welcome.
In this course, learn some of the skills that Microsoft want you to know, and add another tool to your CV or resume, and even go for the official Microsoft certification.
SQL Server is one of the main database tools that is requested in the job market, and the ability to being able to do DBA for SQL Server could be very useful for your current work, and your next job hunt.
The course will take around 10 hours to complete, but completing this will enable you to versed in Database Administration tasks, giving you hands-on experience.
In this course, we will only do activities that require one computer, instead of multiple servers or virtualization.
The course is fairly relaxed – there will be a few “wrong turns”, so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual DBA will be at a basic level, and I’ll introduce every component as we go on.
No knowledge of T-SQL is required, as I’ll demonstrate everything I can through the GUI (Graphical User Interface) as well as T-SQL. However, if you are going to go for the official Microsoft exam, the equivalent knowledge as per the first two sessions in my T-SQL course is essential.
At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and continue your preparations for the official Microsoft certifications.
Completing this course will help you:
- Create Backups and Restore Databases, understanding the different recovery models
- Manage logins and server roles, and import and export data
- Implement and maintain indexes, and manage and configure databases, including compression and concurrency problems
- Manage SQL Server Agent and audit SQL Server instances
- Collect and analyse troubleshooting data
- Plan and install SQL Server and related services, including implementing a migration strategy
Who is the course for?
Learning Path
- How to generate T-SQL,
- Backing up and Restoring,
- Changing Recovery models,
- Different backup models,
- Point in Time recovery,
- Recover from a corrupted drive.
- Create login accounts,
- Manage access to the server, and secure SQL server,
- Create and maintain user-defined server roles,
- Create Database User Accounts,
- Fixed and User Database-Level Roles,
- Creating and Using Schemas,
- Creating access to server/database with least privilege,
- Protect objects from being modified
- Indexes,
- Fragmentation,
- Fill factor,
- Optimise indexes,
- Identify unused indexes,
- Statistics
- Transfer data,
- Bulk insert,
- Import and Export data,
- Jobs and alerts,
- RAISERROR,
- Adding operators.
- Database configuration,
- Design multiple file groups,
- Manage file space with new filegroups,
- Partitioning,
- Managing a multi-TB database,
- Log file growth,
- DBCC,
- Contained databases and logins
- Page and Row Data Compression,
- Spare columns,
- Columnstore indexes,
- Blocking, live locking and deadlocking,
- Monitoring.
- SQL Server Profiler,
- XEvents (Extended Events),
- System Monitor,
- Bottlenecks,
- Server audits,
- Elevated privileges,
- Track who modified an object.
- Choosing the right hardware,
- Scale-up versus scale-out,
- Windows-Level and Service Level Security,
- Default and named instances,
- Planning the installation of SQL Server,
- Testing connectivity,
- Configuring an O/S disk.
- Restore versus detach/attach,
- Migrate security, systems and data from other sources,
- Full-text indexing,
- Security,
- Filestream and Filetable.
