TOP 10 Most Popular SQL Server Courses
TOP 10 Most Popular SQL Server Courses
TOP 10 Most Popular SQL Server Courses
- 1. 70-462: SQL Server Database Administration (DBA)
- 2. A 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course
- 3. SQL Server Analysis Services - SSAS, Data Mining & Analytics
- 4. Learn T-SQL From Scratch For SQL Server Administrator
- 5. SQL Server Reporting Services Part 1 (SSRS)
- 6. Microsoft SQL Server 2016 Certification (70-764)
- 7. Learn C# With Windows Forms and SQL Server
- 8. SQL Server Performance Tuning Part 1
- 9. SQL Server Reporting Services Part 2 (SSRS)
- 10. SQL Server High Availability and Disaster Recovery (HA/DR)
1. 70-462: SQL Server Database Administration (DBA)
Description
Please note: Microsoft has withdrawn the 70-462 exam. However, the information in this course is still relevant to DBA.
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.
2. A 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course
3. SQL Server Analysis Services - SSAS, Data Mining & Analytics
4. Learn T-SQL From Scratch For SQL Server Administrator
Description
These individual courses will take you step by step in learning what it takes to become a SQL Production Database Administrator and will teach you the skills, roles, tasks, and responsibilities a SQL Production Database Administrator does on a daily basis. The great benefit of these courses is that you can navigate to one site to learn all that is needed to manage your SQL Server Environment.
5. SQL Server Reporting Services Part 1 (SSRS)
6. Microsoft SQL Server 2016 Certification (70-764)
Description
Welcome to this course: Microsoft SQL Server 2016 Certification (70-764) - Administering a SQL Database Infrastructure. This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.
In this course, you'll learn:- Configure data access and auditing
- Manage backup and restore of databases
- Manage and monitor SQL Server instances
- Manage high availability and disaster recovery
At the end of this course, you will have developed the knowledge and skills necessary to pass the Administering a SQL Database Infrastructure Exam. So let's get started.
7. Learn C# With Windows Forms and SQL Server
Description
Update
8/3/2020: Replaced video 60 on exporting to Excel to clarify or improve some subtle technical details.
8/8/2020: Added video 63 on how to work with the identity_cache in SQL Server to avoid identity gaps
Thank you for stopping by.
Most important: Before enrolling, please take the time to read the course curriculum, and watch the free preview videos so you can be sure my way of presenting information is one that truly works for you. This will give you a strong indication of what to expect throughout the course. Please kindly do not enroll until you have done this. Also, please remember that I am only one person, and I cannot as one person think of everything that you might want covered. If that's the case, please send me a message and tell me what you feel should be added. Thank you.
8. SQL Server Performance Tuning Part 1
Description
This course is designed for any student that is interested in learning about how to fine tune their SQL Server and databases. Also, developers, SQL DBAs, IT staff and Network Administration
At the end of this course, the student will have extensive knowledge in the following areas:
Indexes, wait stats, fill factor, fragmentation, data and log file allocation, tempdb configuration, common performance issues, blocking, locking, database tuning advisor, execution plan, caching, virtualization and much more
You should have a good understanding of SQL Server Administration. I would highly recommend the following courses: Learn T-SQL from Scratch, SQL Administration part 1, SQL Administration part 2, SQL Administration part 3