Best T Sql Courses

Find the best online T Sql 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 T Sql Courses.

Introduction to Databases and SQL Querying

A step by step introduction to the concept of Databases and Introduction to SQL Querying.

Created by Rakesh Gopalakrishnan - Over 260,000 Students

"]

Students: 379414, Price: Free

Students: 379414, Price:  Free

This is an introductory course on Databases and SQL Querying. There are no pre-requisities for this course. If you are looking to get acquainted with the concept of Databases and Queries for maybe your next interview as an analyst, this is the right course for you. All you need is a windows machine and we will walk through step by step, right from setting up your environment to creating your first table to writing your first query. This course is structured in a way that you can follow along with me. At the end of this course, you should be comfortable writing simple queries including queries related to Dates, String manipulation, Aggregation etc.

Advanced Databases and SQL Querying

Learn advanced T-SQL Querying concepts. Go from a beginner SQL programmer to writing complex SQL Queries.

Created by Rakesh Gopalakrishnan - Over 260,000 Students

"]

Students: 198265, Price: Free

Students: 198265, Price:  Free

This course is an advanced TSQL Querying course. The course expects that student are already aware of basic database concepts and are comfortable writing basic TSQL queries like SELECT, JOINS etc. Students are expected to have taken my previous course (Introduction to databases and Querying). This course cover advanced concepts like Views, Triggers, Dynamic Queries etc. The TSQL Scripts for all demos are uploaded. The course about 2+hours and has assignments at the end of each concept.

If you looking for your next database job or trying to improving your existing database knowledge and apply in your projects, this is the course for you.

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.

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.

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

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

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 And T-SQL Course For Beginners

Learn benefits of SQL, how SQL Server stores data and how to use T-SQL in SQL Server Management Studio to query data.

Created by Avetis Ghukasyan - Web Developer

"]

Students: 12369, Price: $99.99

Students: 12369, Price:  Paid

Microsoft SQL Server also known as SQL Server is a mature technology which can be used not just by developers but by marketers, sales teams, product managers and much more - it is a query language that allows you to ask questions from securely stored data.

Think of it this way - any business on this planet makes money with data. The fancy user interfaces, cool animations are nice but that's not what makes the money. Think about it... when you go to Facebook or Instagram do you care about the fancy animations and user interface or do you care to see your friends, what they are up to, check out events and be part of the goings on of that entire digital ecosystem?

Of course it is the second choice... the fancy user interfaces are cool and make the experience pleasant but in the end you care about your friends and what they are up to, you care about being part of the ecosystem...

Now your friends, followers, events, what everyone is up to is data and as I mentioned before that is what makes companies money.

Microsoft SQL Server (SQL Server) is one of the most mature technologies that allows companies to handle data, store it securely, access it quickly and much more.

Now if you know about Microsoft SQL Server (SQL Server) and you know how to create database objects, how to normalize tables, how to retrieve data, prepare reports, insert and delete data safely and you know about best practices then you are an amazingly valuable asset to the company.

If you have a business that you are trying to grow and have data which you are trying to handle then Microsoft SQL Server (SQL Server) is a great choice which is another reason for you to learn this skill.

Now guess what? All of those things we will be learning in this course and MUCH more!

Take my advice and learn this valuable skill, you will not regret it. After dedicating only a few days and really focusing you can acquire this valuable skill and set a new course for your life.

Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW)

Learn SQL Developer Skills from Scratch(SSRS, SSIS, SSAS,T-SQL,Data Warehouse(DW))

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 8945, Price: $129.99

Students: 8945, Price:  Paid

SQL developers are expected to have a variety of skills that will enable them perform tasks such as: design, implementation and maintenance of structured query language (SQL) databases. They may work as database or web developers, depending on the specific position. SQL developers often spend many work hours seated in front of computers.

As an SQL developer, you should have strong analytical, communication, and problem-solving skills. A knowledge of SQL servers, SQL Server Analysis Services -SSAS, SQL Server integration services (SSIS) and server reporting services (SSRS) is also important.
This course is Hands-on  and by the end of the course you will have experience  of working with relational database management systems like Microsoft SQL Server .

Some of what you will learn on the  course includes following:
How to implement a data warehouse solution
Debug and Troubleshoot SSIS packages.
Cleansing data by using Data Quality Services.
Extend SSIS with custom scripts and components.
How to create ETL (Extract,Transform, Load) process
How to deploy SSIS Package
How to create SSIS package using SQL Server Integration Services
How to download and install SQL Server Data Tools
How to perform data analysis with SQL Server Analysis Server - SSAS
How to create reports using SQL Server Reporting Services
How to download and install SQL Server
Introduction to T-SQL basics
How to implement Table Joins
Using Aggregate functions

Introduction to Transact SQL

Introduction to Transact SQL

Created by QuickStart Learning Inc. - QuickStart Learning Inc.

"]

Students: 8367, Price: Free

Students: 8367, Price:  Free

This free course is only an introduction of Transact SQL, to give you an idea about how Transact SQL database queries are performed in Visual Studio. This course is not intended to make you an expert in Transact-SQL, instead the course is designed to give you a basic idea to help you plan your future learning and project.

Transact SQL or T-SQL is a standardized computer language for querying, altering and defining relational databases, using declarative statements. While this course is specifically focused on Microsoft product, most of what you learn will be applicable to any SQL based database including Oracle, DB2, MySQL etc.

This course does not assume that you have any prior knowledge of T-SQL. If you understand relational database concepts it will be a benefit, however it is not a prerequisite.

SQL Beginner’s Level Course

Learn T-SQL using Microsoft SQL Server Environment

Created by Alexander Shafe - Data Consultant

"]

Students: 7262, Price: Free

Students: 7262, Price:  Free

This course takes you from having little or no knowledge of SQL towards becoming proficient in coding with SQL.

Knowing SQL is highly important if you intend working with data and the demand for SQL skills is ever growing.

You will learn SQL in a server environment which is most likely how you would use SQL in the real world. Not only would you learn SQL but you get to experience working with SQL in a real life setting.

This course is hands-on with practice tasks which allows you get comfortable and familiar with querying in SQL.

Course Requirement or Prerequisites

This course does not require any prior knowledge or specific academic background. The only requirement is having a laptop or desktop computer. All applications necessary for learning the course would be downloaded free from the internet.

Who is this course for?

Anyone looking to work with data personally or professionally.

Looking into a career as Data Analyst, Data Scientist, Business Analyst, Report Analyst, ETL Specialist, BI Consultant, Data Engineer or any Data related field.

Learn Advanced T-SQL For SQL Server Administrator

Getting to understand stored procedures

Created by Raphael Asghar - Production SQL Database Administrator

"]

Students: 3312, Price: $19.99

Students: 3312, Price:  Paid

The student will learn about stored procedures, If Else, While Loop, cursors, derived tables, CTEs, sproc permissions, temp tables, sproc parameters and much more.  The student at the end of this course will gain valuable information about sprocs and how to read and follow them in the production environment.  In addition, the student will be given examples of block statements, transactions commands, recursive CTEs, error handling, variables, and much more.  This course will greatly help those students that want to understand how to read, modify, and execute from simple to complex stored procedures.  By creating stored procedures, the developer has greater control in the execution of SQL commands, permissions, and greater flexibility in updating the sproc.

70-461 Session 4: Querying Microsoft SQL Server (T-SQL)

Using TSQL, merge databasets together, create procedures & incorporate error handling. SQL Server 2012-2017, inc. 70-761

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

"]

Students: 2650, Price: $49.99

Students: 2650, Price:  Paid

If you are in UfB, welcome.

If you are not, don't buy this course. Instead, please look at my 70-461 Session 1-7: Querying Microsoft SQL Server (SQL code) course instead, which includes this course and 6 other courses.

This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012".

In Session 1, we learned all about dates, strings and number data types, and in Session 2 we constructed SELECT queries, JOINed multiple tables together and used DML commands, and in Session 3 we created views, constraints and triggers to encapsulate language and improve security.

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.

No prior knowledge other than what we covered in Sessions 1 to 3 is required. However, prior experience with Excel or Access would be beneficial.

There are regular quizzes to help you remember the information.

Once finished, you will know what how to write procedures, add error handling, and combine datasets together, and we'll have expanded on our current knowledge of T-SQL.

T-SQL Training with Real World Scenarios:Tricks of the Trade

Transact SQL Query Programming & Developer Advanced Microsoft SQL Server Online Video Training Course by Vikas Munjal

Created by Vikas Munjal - SQL Server | MSBI Microsoft Certified Trainer & Consultant

"]

Students: 1793, Price: $99.99

Students: 1793, Price:  Paid

In this online T-SQL training course , a lot of real life scenarios are included which i learnt by practicing on Microsoft SQL Server Technology over the years. I believe this Transact SQL Programming & Development video tutorial will deepen the understanding on T-SQL developer and participant will feel more confident in handling real life scenarios. I have covered not only the course contents but also i have covered the real life situations for every topic.

Real Life situations are as follow

How to view the structure of a table 

How to create your own shortcuts in SSMS

Dropping multiple tables in one go having a fixed pattern

Guidelines while performing DML Operations

How to create Solution File in SSMS and what is the need for it

How to insert a row with old identity value which was deleted

How to reset table identity

How to delete duplicate records from a table

How to select only duplicate records from a table

How to produce Date Dimension using Recursive CTE Query

How to Merge New Changes to an Existing Table

What are the advantages of Stored Procedure

BEGIN AND COMMIT TRANSACTION IS NOT SUFFICIENT

How to produce running totals or cumulative totals using sql server query

How to compare current year sales with the previous year sales 

How to compare current year sales since the start of the business year sales

How to switch between different SQL Servers within a query window in SSMS

How to use a single sql script file for different SQL Servers

Reducing Roundtrips using Table Valued Stored Procedure

Pagination in SQL Server using OFFSET-FETCH

BEGIN AND COMMIT TRANSACTION IS NOT SUFFICIENT

Relevance of Batch in SQL Server

How to create and store customized errors

Guidelines of writing a Stored Procedure

Following are the major topics covered 

Deep dive into Window Functions

Ranking Functions - (Rank, Dense_Rank Row_Number, NTile )

Aggregate Functions - (Sum,Min,Max,Avg,Count)

Analytical Functions-(Lead , Lag, First_Value, Last_Value)

Stored Procedures

    Input Parameters

    Output Parameters

    Default Parameters

    Return

    Table Valued Parameters

Common Table Expressions

Recursive Common Table Expressions

Synonyms

Identity Columns

Transactions

Raiserror/Throw

Error Handling (Try….Catch)

Introduction to SQL

Learn T-SQL in MS SQL Server

Created by Michael Da Costa - Business Analyst

"]

Students: 1569, Price: Free

Students: 1569, Price:  Free

What Is This Course: Introduction to SQL

An introduction to the Structured Query Language. Although based around T-SQL this course is suitable for other variations of the language.

_________________________________________________________________________

What’s Included In This Course:

· Practice Examples: Each topic includes easy to follow examples.

· Real World Scenarios: Scenarios taken from real examples

· High Quality Content: Over 3+ hours of high quality videos.

· Support: On hand support to cover everything introduced in the course.

_________________________________________________________________________

What You Will Learn In This Course:

What are servers, databases and tables and why do we use them.

What is SQL and how can it be used to manipulate data within a database table.

What is a SQL query

How can we create, edit and remove database tables.

What types of SQL queries can we use to interrogate a database table

A look at how we can install a database and associated components in both a Windows PC environment as well as MAC OS environment

The basics of using operators which we can then use to construct more complex queries

The various SQL constraints are introduced and we look at how and why these are used and how we can use them within our queries to ensure data integrity.

The practice questions and scenarios provide a useful way to test what you have learnt in each module and consolidate your knowledge. These increase in difficulty and refer back to previous tutorials so you build on your existing knowledge.

_________________________________________________________________________

I hope this course is able to provide all you need to begin your experience of SQL.

Michael Da Costa

SQL Server: The 28 hour Masterclass course (9 courses in 1)

Learn how to become a future developer, or either a future DBA, or a performance expert on SQL Server with 80 exercices!

Created by O.Thuillier | SQL | Postgres | Powershell| MySQL | Administration,TSQL, and SQL Server performance. - Join the masterclass SQL Server course !

"]

Students: 311, Price: $89.99

Students: 311, Price:  Paid

Welcome to the richest and most comprehensive course on the Udemy platform about SQL Server.

This course lists the 9 courses in my catalogue:

  1. SQL Server for complete beginners (7 hours of practice + 80 practical exercises)

  2. Learn the in-demand job of developer SQL

  3. The complete course about BACKUP and RESTORE

  4. Detecting and Correcting Database Corruption

  5. SQL Server: Configuring and modifying a database on SQL

  6. SQL Server: The complete course on Indexes

  7. Learn the in-demand job of DBA SQL Server

  8. SQL Server: Security and Privilege Management

  9. Prepare your future interview on SQL Server (with these 40 questions and 40 answers ! )

I challenge you to find in a single course these 3 very important chapters on SQL Server :

***********  Chapter 1 : Transact SQL for the absolute beginner and also experienced developers (10 hours of class) **********

  • Let's start by installing SQL Server and management studio on your workstation.

  • The creation and definition of a database and a table.

  • Let's start playing with data with SELECT,UPDATE,INSERT and DELETE

  • Discover the column aliases and tackle the specificity and secrets of LIKE and TOP.

  • Learn how to remove duplicates with the DISTINCT and discover the Comparison operators = != and Copying a table with the SELECT INTO.

  • Let's talk about the IN, NOT IN, IS and IS NOT operators, and Sort your data with ORDER BY.

  • Discover aggregate functions with MIN MAX and AVG and the two operators AND,OR.

  • Let's discover the specificity of COUNT and SUM and how to SELECT a range of data with the BETWEEN and Group several results with the GROUP BY

  • A long chapter of 1h30 minutes on JOINS with  INNER JOIN,LEFT/RIGHT JOIN FULL OUTER JOIN and so on..

  • Let's discover the specificity of UNION and UNION ALL, and the LEFT and RIGHT function.

  • Let's go even further with Transact SQL with the IIF,CASE WHEN,OFFSET FETCH NEXT ROWS and CHOOSE.

  • Let's look at the conversion functions through CAST and CONVERT, TRY_CAST and TRY_CONVERT.

  • Let's approach the DATE type functions with DATEADD,DATEDIFF,GETDATE (), EOMONTH ...

  • Let's deepen our knowledge of TSQL even more With IF/ELSE, STRING SPLIT,STUFF,MERGE…

  • The creation and definition of a view and Stored Procedure,function, schéma and trigger.

  • A very long chapter of 1h30 minutes on RANKING functions such as ROW_NUMBER, OVER and PARTITION BY, ROWS /RANGE UNBOUNDED PRECEDING, FIRST and LAST VALUES, LAG and LEAD,ROW_NUMBER, DENSE _RANK, RANK, NTILE.

  • We will discover a one hour course on CTE (common table expression). So powerful and so little known (I still don't understand by the way) and the derived table.

  • Do you know the difference between Temporary tables, Variable tables and Global tables?

***********   Chapter 2: The complete administration of a SQL Server (11 hours of class)  *********** 

  • Tackle BACKUP and RESTORE for 3 hours, we will see in detail in this course, how to set up a robust and reliable strategy, to guarantee your data on a production server.

  • In another 2 hour course, we will learn how to detect and repair corruption on a database. Did you know that Microsoft logs over 1000 support cases per day regarding corruption! And you, how would you react in case of corruption?

  • We will also discuss during 3 hours, the configuration and modification of your database on SQL. Did you know that a bad Autogrow set on your database, can make you lose 60% of your performance? Do you know the TRUSTWORTHY or DB_CHAINING option? Everything is covered in this course, and believe me, you will be surprised at the number of options on a DB that SQL Server offers.

  • Administration rhymes with precaution, and therefore of course with security. We will discuss security and privilege management during 2 hours. We will learn how to set up a robust and secure SQL server.

  • We will cover a long chapter on the different isolation modes (READ COMMITED, SERIALIZABLE, SNAPSHOT...), we will also see the different types of constraints (PK,FK,CHECK,UNIQUE...), as well as SEQUENCES, and IDENTITY.

  • We will also discuss the change data capture (CDC), many new features released on SQL Server 2016 such as Row Level Security, Dynamic Data Masking (DDM), Temporal Data.

*******  Chapter 3: How to improve performance on your production SQL server (4 hours) *******

  • If we are talking about performance, we will of course be talking about indexes. This is a good thing because it will be covered in this chapter for 4 hours. A good implementation of your indexes can really save your performance on your SQL server. I strongly advise you to look at this chapter, to perhaps avoid going into huge costs of buying servers, which may not be necessary.

  • Do you know SARGABLE queries? I let you discover it in this chapter, to rewrite your SQL queries, in a better way, and thus of course, better performance.

******* Chapter 4: Come and take a virtual interview through these 40 questions and 40 theoretical answers.*******

  • Start out more confident by tackling all these theoretical questions, so that you can face an interview on SQL.

  • You are a Java developer or Python for example, you go to an interview, you don't really know what to review beforehand, this is a summary of the most frequently asked questions.

  • For example : What is a primary key ?  what is an index?  What is the difference between OLAP and OLTP ? Do you know the COALLESCE function ? or how do you remove duplicates with your query ?

There will be many new sections added in 2021, of course if you have already purchased this course, these new modules will be free for you :

  • How to administer your SQL server with powershell? (3 hours of class)

  • Improve the performance of stored procedures  (2 hours of class)

  • Let's go together on SQL Azure ! (3 hours of class)

  • Of course there are more than 100 exercises and corrections in this course.

This course will have an estimated duration of between 30 and 40 hours once completed.