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)

70-462: SQL Server Database Administration (DBA)
70-462: SQL Server Database Administration (DBA)
Beginner-Intermediate practical experience in Database Administration (DBA) SQL Server. Was for Microsoft exam 70-462.

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

A 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course
A 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course
Learn SQL, SQL Server, SSMS, ASP.NET, Visual Studio, C#, HTML and More!

Description

Who Should Join: 

1. Friends, please take the time to review the curriculum carefully before buying so you can see exactly whether this is the right course for you. Please kindly refrain from enrolling until this very important step is complete.

2. Please watch the free preview videos so you can see whether the presentation style works for you. Please remember  I am just one person, and I make my videos often after I have been working for many hours already. 

3. You are interested in real coding.

4. You enjoy detailed explanations at an introductory level. Please answer the questions in the quizzes based on the course content, and not external knowledge you might already have. This is very important in order for the quizzes to work correctly.

3. SQL Server Analysis Services - SSAS, Data Mining & Analytics

SQL Server Analysis Services - SSAS, Data Mining & Analytics
SQL Server Analysis Services - SSAS, Data Mining & Analytics
Develop SSAS cubes from data warehouse on Multidimensional & Tabular modes with Dimensional & Data Mining Models

Description

Top 4 Reasons to take this course:

1) You can learn SSAS, Data Mining and Analytics from scratch as well as ask questions directly to a Published Author, Microsoft MVP, and a Senior Technology Architect with more than 15 years of experience who actively practices Business Intelligence, Data Mining and Analytics in real-world client projects internationally.

2) In a single course, without any prior analytics experience - You can learn three query languages used for analytics - MDX, DAX and DMX. Along with this you learn SSAS in such detail that you can apply for a job of SSAS Developer / Admin / Architect, and also prepare yourself for Microsoft certification 70-768.

3) You get to train yourself for any SSAS, MDX, DAX, and Data Mining interview with more than 150+ interview questions. If you still have any questions, you can ask those questions to me.

4. Learn T-SQL From Scratch For SQL Server Administrator

Learn T-SQL From Scratch For SQL Server Administrator
Learn T-SQL From Scratch For SQL Server Administrator
All the information needed within the courses to set yourself for a successful career as a SQL Production DBA

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)

SQL Server Reporting Services Part 1 (SSRS)
SQL Server Reporting Services Part 1 (SSRS)
Learn how to create from simple to complex reports for your business decision making needs

Description

After completing this course, the student will be able to install SQL Server 2016, install Microsoft Visual Studio and create from scratch reports from simple to complex reports that aid in upper management in making important business decisions; and at the same time, aid the end user to view, interact with, and distribute reports in various platforms.  He will be versed in creating, formatting, designing, and submitting reports that the users will benefit from each business day.  The student will learn how to navigate through Microsoft visual Studio, learn how to to save .rdl files, create templates, render reports in various format, apply different methods of creating rich reports, help the end user with avoiding redundant input of data, examine ways to insure end user has aggregates for reports and be able to communicate the needs of the company via reports.  This knowledge will make the student become well versed in the ability to help the organization in moving forward with summary visual data.

6. Microsoft SQL Server 2016 Certification (70-764)

Microsoft SQL Server 2016 Certification (70-764)
Microsoft SQL Server 2016 Certification (70-764)
A comprehensive and practical course designed to help you pass the Microsoft SQL 2016 (70-764) exam.

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

Learn C# With Windows Forms and SQL Server
Learn C# With Windows Forms and SQL Server
With a real database project!

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

SQL Server Performance Tuning Part 1
SQL Server Performance Tuning Part 1
Detail building blocks of SQL performance tuning

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

9. SQL Server Reporting Services Part 2 (SSRS)

SQL Server Reporting Services Part 2 (SSRS)
SQL Server Reporting Services Part 2 (SSRS)
SQL Server Reporting Services Part 2 (SSRS): Deployment, Security, Report Builder, Mobile Report Publisher

Description

The following course SQL Server Reporting Services (SSRS) part 2 is designed for those individual that are in the IT industry, SQL DBAs, developers, or want to learn how to design, manage, and deploy rich interactive reports for their business needs.  This course is a follow up course to SQL Server Reporting Services (SSRS part 1), which is a requisite along with SQL Server Integration Services (SSIS) course.  The student at the end of this course will be able to deploy SSSR reports to the web portal for end users to view and interact with, build the easy to use report builder for the non techie individuals in the company to interact with, create and design complicated mobile reports that can be viewed not only on the PC computer but also on tablets and the phone.

10. SQL Server High Availability and Disaster Recovery (HA/DR)

SQL Server High Availability and Disaster Recovery (HA/DR)
SQL Server High Availability and Disaster Recovery (HA/DR)
Dive deep into how SQL Server works to implement an effective high availability and disaster recovery solution.

Description

This is a deep dive course on understanding how SQL Server works to effectively choose the right high availability and disaster recovery solution that will address every organization's need to protect digital assets. Packed with videos explaining concept and demos to reinforce the lessons, this course is what every IT professional needs to properly manage and protect a SQL Server database.

The course uses SQL Server 2012 for demonstrations. But the concepts still apply to later versions of SQL Server on Windows.