Best SQL Server Courses

Find the best online SQL Server Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free SQL Server Courses.

Microsoft SQL Server Development for Everyone!

Learn the fundamentals of database design, development and querying using Microsoft SQL Server 2017

Created by Trevoir Williams - Mr.

"]

Students: 86276, Price: $129.99

Students: 86276, Price:  Paid

Overview

This is a zero to hero course on Microsoft SQL Databases and Querying. There are no pre-requisites for this course. This course provides you with fundamental SQL Server training and is enough to get you started at a Database Developer or Junior Database Administrator.

Why Learn Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications

We will explore best practices in database development using SQL Server Express 2017 (Free Edition) and will be building a small school management system database.

All you need is a windows machine and we will walk through setting up an environment, to creating a database, creating your first table and writing queries.

At the end of this course, you should be comfortable writing queries for multiple situations and reports.

What you’ll learn

  • Install SQL Server and SQL Server Management Studio

  • Connect to a Database Instance

  • Create a Database

  • Create Tables

  • Run Queries against Tables

  • General use of the Management Studio

  • Create Relationships (Normalization)

  • Use Aggregate functions to do quick mathematical operations

  • Export data to Excel using the Management Studio

  • Practical use of SQL

  • Creating and Managing Database Views

  • Creating and Managing Custom Functions; Table Triggers and Stored Procedures

  • How to Backup and Restore Databases

Are there any course requirements or prerequisites?

  • A Windows PC (or Windows running on a Virtual Machine if using Linux/Mac)

Who this course is for:

  • This course is for beginners with absolutely no experience.

  • This course is for you if you are already comfortable with basic database operations.

  • This course is for you if you feel a bit 'rusty' and need to refresh your knowledge.

  • This course is for you if you want to understand design principles in database development.

  • This course is for you if you are proficient in Microsoft Access and want to learn a new Database Management System

  • This course is for EVERYONE!

Content and Overview

This is a complete course. Over 6 hours of premium content, all put together to ensure that you get up and running with becoming a Database Developer and/or Administrator. I take you through various scenarios and techniques to write queries, build a database and further administrate, then we touch more advanced topics that are in great demand in the workplace.

By the time you have finished the course you will have moved around in Microsoft SQL Manager Studio so much, that it will become second nature for you when interacting with your databases, found on different servers. This will put your new learned skills into practical use and impress your boss and coworkers.

The course is complete with working files and scripts, making it easy for you to replicate the code being demonstrated. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course.

Clicking the Take This Course button could be the best step you could take towards quickly increasing your income and marketability! Also, remember that if you don't think the course is worth what you spent, you have a full 30 days to get a no questions asked refund!

It's time to take action! This deal will not be available forever!

See you in the course!

SQL for Data Analysis: Weekender Crash Course for Beginners

Using MySQL but applicable to Oracle SQL, Microsoft SQL Server, and PostgreSQL. Taught by a Data Scientist and PM.

Created by A Course You'll Actually Finish - A Course Series

"]

Students: 65932, Price: $124.99

Students: 65932, Price:  Paid

Buff up your resume/CV and become interview-ready by learning real-world SQL in this course.

This SQL course has been taken by fine marketing folks at Google, Facebook, Amazon, Lyft, and Udemy.

Your Story:

Bill was looking to move into a more analytical role and saw SQL as a requirement in the job listings he saw.  He wanted to add "SQL" as a skill to his resume/CV with a clean conscience and back it up if any questions arose in the interview.  But getting there would take forever. Better to just "fake it til' you make it"... right?

Joe was working in a marketing position at a small company. He had a bunch of creative ideas but sometimes felt like he was shooting in the dark and guessing at what customers were doing. If only he had some insights about user behavior so he could be a more data-driven marketer. But data analysis is only for technical folks… right?

Our Story:

David and Pete joined Udemy with little to no technical experience. But after a lot of trial and error, headaches, and help from their friends, they got good enough to uncover unique insights for themselves, their team, and their company using SQL. They were able to discover interesting things about user behavior, create dashboards to track and measure progress on team goals, pull data for the exec team to use in investor pitch decks, and get data driven about decisions they made. They've since helped many team members buff up their data analysis skills and helped students land jobs!

What You'll Learn:

If you have no technical background, don't be afraid! We've distilled our knowledge and experience using SQL into a short course so that by the end, you'll have the raw skills to do some real data analysis for your company using SQL - a language virtually EVERY company uses. Note: this courses teaches you real-world SQL - not just the theory in abstract, but real skills you can use to get more data-driven in your current job. 

How This Course is Structured:

  • In this course we'll be pretending we're a real business (i.e. Blockbuster) so the stuff you learn will be easy to apply to your own situation/company. No abstract/theoretical mumbo jumbo.
  • We'll go through queries a real business would run while also teaching you the raw skills undergirding those queries so you can adapt those skills to create custom queries for your own specific purposes
  • To reinforce learning, we have exercises and quizzes scattered throughout the course so you can learn by doing
  • We'll have a bonus section where new lectures will be added occasionally (including student-requested lectures, more advanced topics, strategies for getting unstuck, etc.)
  • We'll be actively involved in the discussion board answering any questions you might have! Don't be afraid to ask!

A Note About Pedagogy:

We know what it's like to buy a book, feel good about yourself, never finish it and have nothing to show for it. We don't want that to happen with this course. We want this to be a course you'll actually finish. We believe half of learning is motivation and engagement, so we've tried extra hard to make this course fun, relevant, entertaining, and punchy - no frills, no dragging things out, just the good stuff. Heck, you might even find yourself skipping a party to spend time with your new best friends (i.e. us)!

FAQs:

  1. Do I need to purchase any software to take this course? Nope! Everything we use to do data analysis with MySQL is completely free. We'll walk you through the installation and set-up of any software we'll be using.
  2. Can I take this course with Linux? The set-up and installation lectures we've created are for Windows and Mac, and we don't currently have specific installation lectures for Linux.

The Ultimate Guide in Becoming a SQL Server DBA

Everything you wanted to know about becoming a SQL Server DBA but were afraid to ask

Created by Raphael Asghar - Production SQL Database Administrator

"]

Students: 61017, Price: Free

Students: 61017, Price:  Free

The primary purpose of this course is to give the student a sample of what the SQL Server 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 SQL Administration part 1, SQL Administration part 2, SQL Administration part 3, SSRS part 1, SSRS part 2, Learn T-SQL and SSIS. Collectively, it's all that a SQL dba needs to secure a job.

Learn ETL using SSIS

Microsoft SQL Server Integration Services (SSIS) Training

Created by Rakesh Gopalakrishnan - Over 260,000 Students

"]

Students: 52667, Price: Free

Students: 52667, Price:  Free

Start from an absolute beginner to writing and deploying production quality packages.

In this course we will learn about the basic and advanced concepts of SQL Server Integration Services or SSIS. We will walk through the different tools provided by SSIS to Extract, transform and Load data into various databases. This course can followed along with me, provided you have Windows OS or a Windows VM. There are no-prerequisites to the course. At the end of this course, you will be comfortable building an ETL package, moving data around systems, Transforming data using SSIS controls like Fuzzy Lookup, Web service tasks, Email Tasks etc. and configuring and deploying production quality packages with tasks like SSIS logging and checkpoint tasks. Hope you enjoy the course.

How To Begin Your Career As a SQL Server DBA

Your First Step In Becoming A Production SQL Server DBA

Created by Mike West - Chief Data Janitor

"]

Students: 52024, Price: $19.99

Students: 52024, Price:  Paid

"One of the best courses I have taken on Udemy. Short and straight to the point. I have been trying to get into DBA job and have been watching long videos and this by far is THE best course to understand DBA jobs before going into more depth."  -- Lopsang Gurung

Welcome to the Course

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!!!

Microsoft SQL for Beginners

A comprehensive course to teach you how to complete SQL queries using Microsoft SQL Server and the T-SQL language.

Created by Brewster Knowlton - Business Intelligence Expert

"]

Students: 50710, Price: $44.99

Students: 50710, Price:  Paid

Do you want to learn a skill that can help you earn nearly $100,000 per year? If so, then this course is for you!

SQL (Structured Query Language) is the language we use to interact with databases that store data. This allows us to retrieve data with ease and simplicity. As terms like business intelligence and big data become more familiar, businesses will need more people to learn the SQL language.

This course will teach you how to use the SQL language within Microsoft SQL Server, one of the most popular database engines in the world.

You will have plenty of video lessons to teach you the majority of the content. Each section includes practice problems or additional e-books to help reinforce what you learn in the video tutorials.

70-461, 761: Querying Microsoft SQL Server with Transact-SQL

From Tables and SELECT queries to advanced SQL. SQL Server 2012, 2014, 2016, 2017, 2019, exams 70-461 and 70-761

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 38912, Price: $129.99

Students: 38912, Price:  Paid

Previously available as seven separate courses, now presented in one big course.

Reviews

"The instructor explain the things in great details. Very easy to follow." - Linda Shen

"Excellent course, valuable lessons, very well taught at a great pace." - Shane Tanberg

"Must get tutorial. Love it" - Hayford I Osumanu

"Perfect step by step guide to learning. Best I've seen." - Charles Schweiger

"This course is very well thought out. Its one of the better 70-461 courses on Udemy." - Isrrael M

-------------------------

This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012" and 70-761 "Querying Data with Transact-SQL".

Session 1

The basics presented are: how to install SQL Server, and how to create and drop tables.

We then try to create a more advanced table, but find that we need to know more about data types - so we go into some detail about data types and data functions, the foundation of T-SQL.

Session 2

We'll create tables which use these, and then INSERT some data into them. Then we'll write queries which will retrieve and summary this data, using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.

We'll then JOIN these tables together to find where we are missing data and where we have inconsistent data. We'll then UPDATE and DELETE data from the tables. This will allow up to fully complete objective number 1 from the 70-461 exam.

Session 3

We'll now use that data to create views, which enable us to store these SELECT queries for future use, and triggers, which allow for code to be automatically run when INSERTing, DELETEing or UPDATEing data.

We'll look at the database that we developed in session 2, and see what is wrong with it. We'll add some constraints, such as UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY constraints, to stop erroneous data from being added some data. By doing this, we will complete objectives 2, 3, 4 and 5 from the 70-461 exam

Session 4

We will further encapsulate our routines by creating procedures, allowing us to EXECUTE parameterised commands with just one statement, and we'll add some error handling with TRY, CATCH and THROW.

We'll also combine datasets together, by looking at UNION and UNION ALL, INTERSECT and EXCEPT, CASE, ISNULL and Coalesce, and the mighty MERGE statement. By doing this, we will complete objectives 11, 12, 13 and parts of 6 and 18 from the 70-461 exam.

Session 5

We'll will now be creating aggregate queries, working through objective 9 of the exam 70-461. We'll be reviewing the ranking functions ROW_NUMBER, RANK, DENSE_RANK and NTILE. We'll look at the 8 analytic functions news to SQL Server 2012, such as LAG, LEAD, FIRST_VALUE and LAST_VALUE.

We'll look at alternative ways of grouping and adding totals, using ROLLUP, CUBE, GROUPING SETS and GROUPING_ID. If you want to take the 70-461 exam, we'll also look at the geometry and geography data types, plotting locations on a grid, together with functions and aggregates.

Session 6

We'll will now be creating sub-queries, working through objectives 7b-e of the exam 70-461. We'll be created correlated subqueries, where the results of the subquery depend on the main query. We'll be looking at Common Table Expressions using the WITH statement, and we'll be using what we have learned to solve a common business problem.

We'll be looking at functions (objective 14), including the three different types of User Defined Functions (UDF): scalar functions, inline table functions, and multi-statement table functions. We'll then complete objective 6 by looking at synonyms and dynamic SQL, and objective 8 by looking at the use of GUIDs. We'll also look at sequences.

We'll have a look at XML. Finally, for SQL Server 2016 and later (exam 70-761), we'll examine JSON and Temporal Tables.

Session 7

In this session we'll be looking at transactions, seeing how to explicitly start and end them, and finding out how they can block other users in the database. Then we'll see about how to indexes and their role in optimising queries. 

We'll also see how we can use Dynamic Management Views to see how we can improve our use of indexes. We'll then look at how to write a cursor, and when to use this row-based operation, and the impact of using scalar UDFs.

No prior knowledge is required - I'll even show you how to install SQL Server on your computer for free!

There are regular quizzes to help you remember the information.

Once finished, you will know what how to manipulate numbers, strings and dates, and create database and tables, create tables, insert data and create analyses, and have an appreciation of how they can all be used in T-SQL.

Microsoft SQL Server – An Introduction (2018 edition)

A quick tour of T-SQL, DBA and SSRS (all part of Microsoft SQL Server)

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 27199, Price: Free

Students: 27199, Price:  Free

This course is a brief presentation of SQL Server.

We will install a version of SQL Server Express for free, install it, and create a database and table.

We'll also add some data and retrieve it.

We'll then look at the SELECT statement with its 6 main clauses (SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY).

Following this, we'll create SQL Views and Procedures, connect it to Excel, and have a brief look at SSRS (SQL Server Reporting Services) and backup and restore a database.

No prior knowledge is required - just a willingness to learn.

See you on the course.

SQL Tutorial for Beginners – Learn SQL using 30 scenarios

A comprehensive course to teach you SQL on Mac and Windows using Azure Data Studio, Microsoft SQL Server and T-SQL

Created by Valuetech Academy - Learn SQL skills efficiently

"]

Students: 26188, Price: Free

Students: 26188, Price:  Free

SQL Tutorial for Beginners in 2020- Learn SQL quickly using 30 Scenarios on Mac and Windows

A comprehensive course to teach you SQL on Mac and Windows.

If you are looking for a complete SQL tutorial for beginners, this tutorial is a great way to learn SQL using 30 real-time scenarios.

You will be able to write SQL queries confidently by just practicing the 30 scenarios in this SQL Tutorial.

You can learn SQL on Mac and Windows from this SQL Tutorial. This SQL Tutorial will cover all the topics of Structured Query Language(SQL) starting from scratch. This tutorial is great for beginners who want to learn SQL and for professionals who want to brush up their SQL Skills.

Structured Query Language(SQL) is supported by various database management systems(DBMS).

In this SQL Tutorial, we will be using SQL Server to learn SQL on both Mac and Windows.

Microsoft's SQL Server is one of the most popular database management systems(DBMS) in the world and learning SQL using SQL Server can help you earn nearly $100,000 per year.Even if you use a different DBMS like MySQL, you can benefit a lot from this SQL Tutorial as more than 90% of the SQL skills you learn in this tutorial is easily transferable to other database management systems(DBMS).

What you'll learn from this SQL Tutorial:

1.Start from scratch installing SQL Server on Mac and Windows in 2020.

2.Learn SQL quickly using 30 real world Scenarios

3.Learn SQL using Azure Data Studio on Mac and Windows

4.Download and Restore a sample database(AdventureWorks) to SQL Server on Mac and Windows

5.Download and Install Azure Data Studio on Mac and Windows

6.Model real-world scenarios and write SQL queries across multiple tables

This beginner's course is for you if you want to learn SQL Skills in Mac or Windows.

SQL for Data Analysis – with SQL Server

The most direct path to mastering the SQL skills you'll actually use on the job

Created by Travis Cuzick - Data Solutions Engineer

"]

Students: 25161, Price: $44.99

Students: 25161, Price:  Paid

If you spend a lot of time extracting, transforming, or analyzing data from databases, - or you're aiming for one of the many highly paid career paths that rely heavily on this skill - then this course is for you.

Learning to query databases with SQL is a substantial part of highly paid careers such as Data Analyst and Business Intelligence Analyst, but also provides a strong foundation for even more exotic roles like that of a Data Scientist. Experienced Data Scientists will tell you that the majority of their time isn't spent tuning machine learning algorithms, but rather preparing and cleaning data for use by those algorithms - something SQL does exceptionally well.

In this course, I have tried to avoid simply regurgitating an encyclopedia of facts about SQL, an approach that is all too common in introductory books and courses on programming. Instead, I carefully curated certain concepts and techniques that I have found to provide the most "bang for your buck" over my decade of experience as a data professional.

This enabled me to condense a complete course on SQL into just 36 instructional videos, averaging less than 10 minutes in length. So if you can commit to a video a day, in just over one month you’ll have added an extremely valuable and lucrative skill to your arsenal (and just as importantly, your resume!).

And to make sure all that knowledge sticks, I’ve included exercises...LOTS of exercises. Unlike most courses, which only feature sporadic opportunities to practice what you’ve learned, this course has practice problems after almost every video - so you can reinforce concepts right away.

Take it from someone who has built their career almost entirely on self-taught technical skills: it’s worth the effort. Several recent surveys have shown that SQL is actually the MOST in-demand tech skill sought after by recruiters!

In short, learning SQL can change your life, if you put in the work Let me be your guide to this next step in your career - I think you’ll find the journey a lot less daunting, and maybe even a little more fun, than you would have ever expected.

SQL for beginners with :( PostgreSQL, MySQL, SQL Server )

Master the basics of querying databases and manipulating data

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 24454, Price: $69.99

Students: 24454, Price:  Paid

SQL is a standard language for accessing and manipulating databases.

SQL is one of the most  in-demand tech skill used across many industries.

What is SQL?

SQL stands for Structured Query Language

What Can SQL do?

  • SQL lets you access and manipulate databases

  • SQL can execute queries against a database

  • SQL can retrieve data from a database

  • SQL can insert records in a database

  • SQL can update records in a database

  • SQL can delete records from a database

  • SQL can create new databases

  • SQL can create new tables in a database

  • SQL can create stored procedures in a database

  • SQL can create views in a database

  • SQL can filter data returned from a database

  • SQL can sort data returned by a database.

  • SQL can be used to truncate and drop tables.

PostgreSQL is a powerful, open source object-relational database system.

PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying.

PostgreSQL is a highly stable database backed by more than 20 years of development by the open-source community.

PostgreSQL is used as a primary database for many web applications as well as mobile and analytics applications.

MySQL is a relational database management system based on SQL – Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications. The most common use for mySQL however, is for the purpose of a web database.

SQL SERVER is a relational database management system (RDBMS) developed by Microsoft. It is primarily designed and developed to compete with MySQL and Oracle database.

SQL Server supports ANSI SQL, which is the standard SQL (Structured Query Language) language. However, SQL Server comes with its own implementation of the SQL language, T-SQL (Transact-SQL).

T-SQL is a Microsoft propriety Language known as Transact-SQL. It provides further capabilities of declaring variable, exception handling, stored procedure, etc.

SQL Server Management Studio (SSMS) is the main interface tool for SQL Server, and it supports both 32-bit and 64-bit environments.

Microsoft SQL for beginners : ( MS-SQL Server,T-SQL, SSMS )

Practical Hands-on Data Query and Manipulation with SQL

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 20785, Price: $59.99

Students: 20785, Price:  Paid

The volume of data available is huge and increasing daily. Structured Query Language -SQL (pronounced as sequel) is the standard language used to communicate and interact with data stored in relational management database systems like Microsoft  SQL Server Oracle, PostgreSQL,MySQL etc.

Different database management systems have their own proprietary  version of the SQL language  but they all conform to using some commands in SQL the same way.   Microsoft SQL Server's version of SQL is known as Transact-SQL  (T-SQL).    In this course you will learn the basics of the SQL language and Transact-SQL since  both use certain commands in the same way.

T-SQL is also popularly referenced to as T-Sequel .In this course you will learn all the basics of T-SQL. We will discuss the T-SQL features step by step. We will be using SQL Server Express 2014 (which is a free download). As a sample, we will use AdventureWorks 2014 as our database. Along the way, we will be creating our own t-SQL queries to get data into a database and also out of a database.  But AdventureWorks 2014 will be our main focus. As far as T-SQL, we will start with the simple select statements and add new features as we go. I will introduce you to the data types available so you can make the appropriate selection when creating a column. Then, we will talk about joins, functions, tables, procedures, triggers, indexes, and much more. By the time you are done with this course, you will be very comfortable using T-SQL.
This course will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures. You will also be familiar with SQL Server Management Studio 2014 also known in the tech industry as SSMS. This is the tool you will use to write and see the output of your T-SQL queries.

What You will learn includes:

  • Installing SQL Server

  • Install SSMS

  • Basic Database  Concepts

  • Creating Database

  • Creating Table

  • Creating Views

  • Creating stored procedures

  • Reading data from a database

  • Updating database records

  • Backing up database

  • Deleting Records

  • Truncating Table

  • Dropping Table

  • Dropping Database

  • Restore Database

  • Query Multiple Database Tables

  • Change query output column names using case expressions

  • Perform Various table joins

  • Filter records and remove duplicates

  • Write basic T-SQL Statements

  • Understand T-SQL TOP Command

  • Understand Normalisation

  • Know how to use SSMS

  • Create Views

  • Create Stored Procedures

  • Understand NULL Values

  • Data Types

  • Functions

SQL Server Crashes and Critical Failures

A Step By Step Approach To Recovering The Most Critical SQL Server Databases

Created by Mike West - Chief Data Janitor

"]

Students: 20712, Price: Free

Students: 20712, Price:  Free

Software crashes. WE can't stop that. What WE can do is prepare ourselves through education and practice to be able to act quickly and resolve these critical issues.

In the early days of SQL Server many support calls were server down issues that ended up being bugs in SQL Server. While this still happens, today many of those calls aren't the fault of SQL Server.

For example. On Microsoft's case history of database corruption 99% of ALL database corruption can be traced back to the IO subsystem.

Either way, when SQL Server crashes it can be a traumatic experience for a DBA. If a production box crashes during core hours WE need to know what steps to take to resolve the problem as quickly and as cleanly as possible.

This course will take US beyond where to look. WE will cover RECOVERY INTERNALS and the fundamentals of how to analyze, diagnose and resolve critical errors.

WE will cover the SQL Server Error Logs in great detail. One of the first places as SQL Server DBAs WE look to diagnose critical failures is the SQL Server Error logs.

WE will cover server startup failures and analyze SQL Server stack dumps. Additionally, we will analyze several commonly occurring exception signatures.

WE will create a troubleshooting task list as use it as a template for resolving these crashes and critical errors.

While this course has no prerequisites a strong background in SQL Server is highly recommended.

SQL Server Baby Step: Installation and Configuration

An absolute beginner’s tutorial to quickly learn how to setup Microsoft SQL Server practice environment on your machine.

Created by Rashid Khan - Microsoft Certified-Business Intelligence Consultant

"]

Students: 18786, Price: Free

Students: 18786, Price:  Free

Scope of this course is confined to the following learning objectives ONLY:

  • Start from scratch by installing Microsoft SQL Server Express edition

  • Requirements for installing Microsoft SQL Server

  • Discussion around some of the basic configuration option, including "sa" login

  • Making use of Adventure Works sample database

  • More in depth coverage of relational database in general, and Microsoft SQL Server in particular, in my another course

Mastering SQL Server 2016 Integration Services (SSIS)-Part 1

Learn How to Create SSIS Packages From Scratch Step By Step

Created by Kameswara Sarma Uppuluri - Microsoft Certified Trainer

"]

Students: 17918, Price: $49.99

Students: 17918, Price:  Paid

SSIS is an enterprise-level Extract,Transform and Load (ETL) Development tool.

SSIS is one of the most powerful application for moving data in and out of various databases and files.


This course provides developers with a thorough knowledge in developing SSIS Packages with SQL Server 2016.

In this course by development expert Kameswara Sarma Uppuluri, you'll learn essential concepts that you need to know to build SSIS Packages from scratch.

This course provides step-by-step walk-throughs and demos that you're encouraged to practice along with to enhance the learning process.

This course is broken down into 21 Modules with each module providing source code so that you can follow along with Kameswara Sarma Uppuluri.


Data Warehouse Developer-SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL

Develop and Implement a Data Warehouse Solution Step by step

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 17582, Price: $39.99

Students: 17582, Price:  Paid

This course describes how to  design and implement a data warehouse solution.
students will learn how to create a data warehouse with Microsoft SQL Server implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

The Primary responsibilities of a data warehouse developer include:
Implementing a data warehouse.
Developing SSIS packages for data extraction, transformation, and loading.
Enforcing data integrity by using Master Data Services.
Cleansing data by using Data Quality Services.

Prerequisites :

Experience of working with relational databases, including:
Designing a normalized database.
Creating tables and relationships.
Querying with Transact-SQL.
Some exposure to basic programming constructs (such as looping and branching).
An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

Students will learn how to :

••Deploy and Configure SSIS packages.
••Download and installing SQL Server
••Download and attaching AdventureworksDW database
••Download and installing SSDT
••Download and installing Visual studio
••Describe data warehouse concepts and architecture considerations.
••Select an appropriate hardware platform for a data warehouse.
••Design and implement a data warehouse.
••Implement Data Flow in an SSIS Package.
••Implement Control Flow in an SSIS Package.
••Debug and Troubleshoot SSIS packages.
••Implement an ETL solution that supports incremental data extraction.
••Implement an ETL solution that supports incremental data loading.
••Implement data cleansing by using Microsoft Data Quality Services.
••Implement Master Data Services to enforce data integrity.
••Extend SSIS with custom scripts and components.
••Databases vs. Data warehouses
••Choose between star and snowflake design schemas
••Explore source data
••Implement data flow
••Debug an SSIS package
••Extract and load modified data
••Enforce data quality
••Consume data in a data warehouse

The volume of data available is huge and increasing daily. Structured Query Language -SQL (pronounced as sequel) is the standard language used to communicate and interact with data stored in relational management database systems like Microsoft  SQL Server Oracle, PostgreSQL,MySQL etc.

Different database management systems have their own proprietary  version of the SQL language  but they all conform to using some commands in SQL the same way.   Microsoft SQL Server's version of SQL is known as Transact-SQL  (T-SQL).

You will learn the basics of the SQL language and Transact-SQL since  both use certain commands in the same way.

What You will learn includes:

  • Installing SQL Server

  • Install SSMS

  • Basic Database  Concepts

  • Creating Database

  • Creating Table

  • Creating Views

  • Creating stored procedures

  • Reading data from a database

  • Updating database records

  • Backing up database

  • Deleting Records

  • Truncating Table

  • Dropping Table

  • Dropping Database

  • Restore Database

Microsoft SQL Server 2012 Certification Training Exam 70-461

To Study And Pass The Microsoft 70-461 Exam and Gain Certification For MCSA or MCSE

Created by Infinite Skills - High Quality Training

"]

Students: 15850, Price: $49.99

Students: 15850, Price:  Paid

This Microsoft SQL Server 70-461 Exam training course by Infinite Skills teaches you everything you need to know to pass the Querying Microsoft SQL Server 2012 exam. It is required that you pass the 70-461 Exam in order to earn your MCSA: SQL Server certification from Microsoft.

The course takes you through each of the topics that you will need to master in order to pass the SQL Server 2012 70-461 exam. Throughout this video tutorial, you will learn how to setup the interface, create and alter tables using T-SQL, and understand SQL queries. You will learn about SELECT statements, how to modify data, and use joins and subqueries. This course will teach you about triggers and different trigger types, how to work with XML, and how to optimize queries. Finally, you will run through the exam basics and what you can expect from the exam.

Once you have completed this computer based training course for the Microsoft SQL Server 70-461 exam, you will have developed the knowledge and skills necessary to pass the Querying Microsoft SQL Server 2012 Exam and continue towards earning your SQL Server MCSA certification.

How to take the Microsoft 70-461 Exam:

1. Find a test center near you to take the SQL Server 70-461 certification exam, their will provide details on test center locations and schedules. This exam is typically priced around $150 dollars.

2. Study the required material to pass the 70-461 examination. This course covers the material that is within the 70-461 certification exam, and will help put you in a great position to succeed in the exam

3. Pass your exam!

4) Take our Microsoft Windows Server 70-462 and 70-463 courses which will prepare you for the 70-462 and 70-463 exams. Upon passing the 70-461, 70-462, and 70-463 exams you will become a Microsoft Solutions Certified Associate in Microsoft SQL Server 2012.

5. Tell your friends how easy passing the Microsoft 70-461 exam was using Infinite Skills training courses

The information laid out above is given in good faith, we are not endorsing and third party company by offering a link to their site. You should always do your own research prior to making a purchase or using any service linked to via this website. Prices or details may alter and any information listed can not be guaranteed to be accurate. Note: While this course is comprehensive in regards to covering material on the exam, we do recommend using other aids to guide your study.

SQL Server Administration Part1

SQL Education with a purpose

Created by Raphael Asghar - Production SQL Database Administrator

"]

Students: 15195, Price: $19.99

Students: 15195, Price:  Paid

The following course will introduce to you the foundation of SQL Server Administration Part 1 as it's practiced in the production real world situations. I have designed this course for the beginner but at the same time introduced elements that are practiced in the real world, so the student gains a faster understanding of the requirements in the production server. Anyone interested in understanding, configuring, managing or is responsible for SQL Server systems will benefit from this course. My first course T-SQL, while not mandatory, should be taken so you gain a better understanding of this course. All software, SQL Scripts and documentation is provided for you. All you need is a desire to learn and fullfill you future goals. These courses will give you that direction.

70-462: SQL Server Database Administration (DBA)

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

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 15122, Price: $124.99

Students: 15122, Price:  Paid

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.

We'll download and install for free SQL Server Developer, which gives you all of the capabilities of the full-cost Enterprise edition (though without being able to use it for commercial purposes). We'll start by downloading a demonstration database, and learning how to backup and restore this database, and what recovery models are appropriate for other databases, to enable you to offer Point in Time recovery.

We'll manage logins and server roles, so you can control who gets access to what data, implement and maintain indexes, so you can speed up searches, and import and export data. We'll look at managing SQL Server Agent, so you can automate routine tasks, and also be alerted to problems, we'll manage and configure databases, and look at compression, both of which aids with administrating big databases. And much more.

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.

The course increases in difficulty slowly, so you'll manually backup a database, but then later we'll use SQL Server Agent to automate this. 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 my first two courses in 70-461 T-SQL 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.

The course is recorded on SQL Server 2017, but will also work fully in 2016, 2014 and 2012, and mostly in 2008R2 and 2008.

The Comprehensive SQL Course 2021

A bootcamp designed to help you master SQL and work with databases like Oracle, MySQL and Microsoft SQL Server

Created by Malvik Vaghadia - Data and BI specialist

"]

Students: 14766, Price: $59.99

Students: 14766, Price:  Paid

Want to learn one of the most in-demand skills in the business and technology sector?

Then this course is for you!

SQL skills are highly marketable everywhere, especially in companies like Netflix, Facebook, Amazon, Google… the list goes on and on… The simple fact is that if you want to do any work involving data, then the chances are that you need to know SQL!

This course has been designed for:

  • Individuals with no prior experience in SQL and looking to make that step to develop their skills in this highly sought after programming language

  • Those with some experience looking to brush up on their SQL knowledge

No downloads or software installation required! We will be using Oracle APEX which is a web-based application – you will be set up with your own virtual database hosted on the cloud! Although we will be using Oracle APEX the course has been designed to highlight key differences between some of the main Database Management Systems such as MySQL and Microsoft SQL Server, so what you learn in this course can be applied across all platforms supporting SQL.

The lectures in this course are arranged into short, bite-sized chunks. The course is designed to be comprehensive, but also concise in order to make the learning experience as easy as possible. Every technical section of the course will be rounded off with quizzes / assignments and give you an opportunity to develop your practical skills.

The course will provide students with an extensive Question Bank section which is full of questions and walkthroughs designed to emulate real world scenarios and combine together all of the different SQL clauses, operations and commands taught in this course!

In this course you will learn about:

  • Data Definition Language Commands such as CREATE, DROP, TRUNCATE, ALTER and RENAME

  • Data Query Language Commands using the SELECT statement

  • Data Manipulation Commands such as INSERT, UPDATE and DELETE

  • Data Control Language Commands such as GRANT and REVOKE

  • Transaction Control Language commands such as COMMIT and ROLLBACK

  • Data Types

  • Qualifying Column Names

  • Aliasing Columns and Tables

  • Row Level Functions

  • Aggregation Functions

  • The Where Clause

  • The Group By and Having Clauses

  • The Order By Clause

  • Single Table and Multiple Table Joins

  • SET Operators

  • Subqueries

  • Database Constraints

  • Relational Databases and Data Model Design including STAR and SNOWFLAKE Schemas

  • Views

SQL Server Integration Services (SSIS) – An Introduction

Learn the basics of SQL Server Integration Services (SSIS) - with Practical Activities. Useful for 70-763 certification.

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 14696, Price: $99.99

Students: 14696, Price:  Paid

Reviews:

"Instructor is easy to follow. He gives very clear examples. Course moves quickly enough to be engaging without skipping over material." -- Sarah Hale

"This course works for me because it progresses with a level of detail that will be useful as I think through each step necessary to execute my own integration packages. There are several courses to choose from and I'm glad I chose this one." -- David McNickle

"Very good introductory course. Didn't really know what SSIS was until recently. Working through the course opened my eyes to past projects that would have benefited from an SSIS ETL package or two." -- Stephen Benton

Welcome to this course about SQL Server Integration Services.

In this course you'll be downloading and installing the latest 2016 SQL Server Developer – a full version for free, so that you can use it on your machine. And previous versions of SQL Server Developer have previously retailed for around $100, and now it’s free.

 

So what is SSIS? It’s a way to automate in the importing and exporting and data – or ETL: extract, transform and load. It’s a very visual part of SSIS, using tasks, components and flowcharts, so it’s easy to learn the basics of it.

 

We’ll start by extracting some data, and then loading it into another table. I’ll take nice as slow as we start to introduce transformations, such as aggregation, conditional split, merging and auditing. There’ll be plenty of practice activities too, so you can get to practice your new-found skills.

By the end of this course, you'll be confident in using the main Data Flow components and Control Flow tasks, and would be able to use it in your own work.

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

Created by Raphael Asghar - Production SQL Database Administrator

"]

Students: 12979, Price: $19.99

Students: 12979, Price:  Paid

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.

Microsoft SQL Server Reporting Services (SSRS)

Build reports in MS SQL Server Reporting Services (SSRS): Implement report layouts, add interactivity.

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 12783, Price: $99.99

Students: 12783, Price:  Paid

Reviews:

"Brilliant! This tutorial will definitely save you hours of figuring out things yourself." -- Koos ten Bras

"Excellent course, well presented and clear examples." - Peter Cawthorne

This course is all about creating reports in SQL Server Reporting Services (SSRS). No prior knowledge is needed, but some knowledge of T-SQL would be useful.

We will download a version of SQL Server which includes SSRS - for free. We'll also download a database called AdventureWorks, which we will use in our reports.

We'll create various reports, developing our skills bit by bit. As part of designing a report, we will:

  • Select report components (matrix, table, chart and other data visualisation component),

  • Identify the data source and parameters,

  • Design a grouping structure,

  • Create drilldown reports and drillthrough reports.

As part of implementing a report layout, we will:

  • Find out how to format, including formatting colours, dates and numbers;

  • Configure the page;

  • Implement headers and footers;

  • Implement matrices, tables, chart, images, indicators, maps and groupings in reports;

  • Create a range of reports using different data regions;

  • Define custom fields;

  • Implement global collections;

  • Define expressions; and

  • Implement data visualisation components.

As part of implementing interactivity in a report, we will:

  • Create drilldown reports;

  • Create drillthrough reports;

  • Add interactive sorting;

  • Investigate parameters, including multi-value parameters;

  • Create dynamic reports in SSRS using parameters;

  • Implement show/hide property;

  • Add actions (jump to report and URL);

  • Add Fixed headers and a document map.

By the end of this course, you should be confident in creating your own reports in SSRS.

SQL Server Administration Part 2

Learn how to optimize, improve performance, review and analysis statistics, use monitoring tools, and create indexes

Created by Raphael Asghar - Production SQL Database Administrator

"]

Students: 10728, Price: $19.99

Students: 10728, Price:  Paid

SQL Administration Part 2 will benefit the student by providing the necessary guide lines for enhancing SQL Server performance by utilizing indexes, reviewing DMVs for analysis, and setting up performance counters for gathering resource metrics; and also I will explain a handful of utilities to gather information about SQL Server internals, such as SQL Profiler, Database Tuning Advisor (DTA), Extended Events, SQL performance monitor, Activity monitor, and teach about partitions, creating contained database for recovery, reviewing SQL server logs and by installing SQL Server 2014 as the newer SQL version.The student will not only add to the knowledge gained bur SQL Administration Part 1, but get prepared for the next course SQL Administration Part 3 – the high availability solutions.

Microsoft SQL Server 2014 Database Administration

Learn the Basics about SQL Server from Installing to Updating Data. Starting step to becoming a SQL Developer.

Created by Tarang B. Patel - Web Developer and CEO at ValsadMarket

"]

Students: 9304, Price: Free

Students: 9304, Price:  Free

Learn the Basics about SQL Server from Installing to Updating Data. Starting step to becoming a SQL Developer.

  • General knowledge of what a Database is.

  • Different versions of SQL Server 2014

  • How to install SQL Server Express 2014

  • Create a database in SQL Server

  • Create tables in SQL Server

  • Add data into tables in SQL Server

  • Set foreign key relationships between tables

  • Delete data from tables

  • Update data in tables.

  • backup and restore database

SQL Server Administration Part 3

Learn High Availability Solutions like Log Shipping, Database Mirroring, Replication and Always On Availability Group

Created by Raphael Asghar - Production SQL Database Administrator

"]

Students: 8797, Price: $19.99

Students: 8797, Price:  Paid

This SQL Server Administration Part 3 course is designed for the student who has already taken or is taking Part 1 and Part 2, which are prerequisite courses.  This course will cover High Availability solutions such as log shipping, database mirroring, replication, peer to peer replication and always on availability group technologies. Upon completing this course, the student will be well versed in configuring, managing, and monitoring virtually all tasks that a SQL SBA does in his daily, weekly and monthly duties.  The materials that the student will need such as documents and SQL scripts will be provided via a zip file that the student requests via email.  Upon completion of this course, the student will have the training, education and knowledge that a college provides in their courses about SQL Server Administration.

SQL Server Performance Tuning Part 1

Detail building blocks of SQL performance tuning

Created by Raphael Asghar - Production SQL Database Administrator

"]

Students: 8263, Price: $19.99

Students: 8263, Price:  Paid

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

Upsize Your MS Access Business Information to MS SQL Server

Easily upsize your business information in just a few and easy steps

Created by Microvio Online Training - Online Trainers Specialised on Marketing and Management

"]

Students: 8068, Price: Free

Students: 8068, Price:  Free

MS Access is one of the most used business productivity tools around.

Businesses of all sizes use it - you can find it on home and small businesses as well as on medium and big businesses alike.

It can be used to manage small tasks or projects but it can also be used to manage an entire business day to day operation.

Whatever the case there will probably come a time when your business will outgrow the technical capabilities of a MS Access database or application.

When that time comes you'll probably want to transfer your business information into a more powerful database management system (SQL Server) - but at the same time you'll still want to keep on using your familiar forms and reports (MS Access).

This course is precisely aimed at helping and teaching you how to make this migration/upsizing, by guiding you through a few easy steps, alongside a handful of tutorials.

Hope You Enjoy The Course - See You Inside!

SQL Server For Beginners – Part 1

Sql Server querying essentials and concepts

Created by Bytescout Academy - Bytescout Learning Academy

"]

Students: 8019, Price: Free

Students: 8019, Price:  Free

In this course we'll cover basics of SQL querying and concepts with SQL Server. We'll start with basics and essentials of SQL Server, followed by SQL syntax and lastly we'll delve into SQL joins and set operators.

Following is the manifest we'll be covering. Each course video is designed to be short and concept wise complete.

  1. Introduction and Essentials

    • Introduction - Part 1

    • Introduction - Part 2

    • Introduction - Part 3

    • Introduction - Part 4

SQL Server SSAS (Multidimensional MDX) – an Introduction

Create cubes from databases, analyse them in Excel, SSRS etc. using SSAS MDX (a Business Intelligence tool)

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 7801, Price: $79.99

Students: 7801, Price:  Paid

Reviews:

"Good Stuff Overall!!! In my opinion, the instructor did great with the "How-tos" which helped for sure in grasping the whole concept of how to create cubes, set up data source and source views, dimensions, add attributes etc." -- Lakeside David-Debo

"A fantastic course which gets you rolling very quickly and comfortably, thanks for the short and condensed knowledge delivery. Thanks, Phillip you made SSAS very simple for me." - Anup Kale

"This is really the perfect course for beginners! Easy to learn and very inspirational for further investigations in SSAS. Thank you very much, Phillip!" - Marina Barinova

Welcome to this course on SQL Server SSAS and MDX Cubes – an Introduction.

You may have become experienced with creating SQL statements in SQL Server Management Studio. Building databases is ideal when you want to quickly add data – that’s why they are called OLTP – Online Transaction Processing – they are designed for speed for adding transactions.

 

But what if you want to get to get information about? OLTP databases are not based designed for this. What you need instead is a process whereby data is pre-aggregated – in other words, a lot of the calculations you may write have been calculated before you ask for them. It saves a lot of time. It would also be useful if the end user didn’t have to bother with SQL queries, and could use something a bit more hands-on, although retaining something more advanced for advanced users. That’s where cubes come in, full of pre-aggregated data, and SQL Server Analytical Services– or SSAS – (Online Analytical Processing) allows you to make these cubes.

 

This course is designed for the complete beginner in Multidimensional cubes, or someone who wants to refresh their memory. We’ll create a cube to start with from an ordinary database, and then I’ll ask you to create one from a special database known as a Data Warehouse. We’ll export our cube in SQL Server Management Studio, and into SSRS – and we’ll even have a bit of a look at the more advanced way of querying that is MDX.