From the course: Complete Guide to Advanced SQL Server

What you should know - SQL Server Tutorial

From the course: Complete Guide to Advanced SQL Server

Start my 1-month free trial Buy for my team

What you should know

“

In this Complete Guide to Advanced SQL Server, we're going to tackle a number of topics that will help bring your SQL Server knowledge to the next level. To keep things organized, I've split the content into five main sections. First, we'll take a look at programming SQL Server databases using a number of different objects. This includes creating views for your data tables, writing custom functions and stored procedures, and working with transactions to protect the consistency of data, reads and writes. Section 2 is all about triggers. Triggers will bring a level of automation to your databases and allow them to react to specific conditions as they occur. In Section 3, I'll introduce SQL Server Ledger, which is a feature that can be used in auditing and verification scenarios to prove that data has not been tampered with. Section 4 dives into machine learning through an integration with the Python scripting language. Here, we'll see how to run Python commands directly on the server, so that data doesn't need to be exported first and moved outside of the secure envelope. Finally, we'll wrap up the course with a comprehensive firewall project in Section Number 5. To get the most out of this course, I'll expect that you have some familiarity with SQL Server and the Graphical Interface Management Studio. You should be able to write Transact-SQL commands, and have an understanding of how tables and keys work in a relational database. Finally, it'll be easiest to follow along if you're working on a free Developer Edition server where you have administrative level access, as we'll need to go in and adjust some settings and perform other tasks that require elevated permissions. If you feel like you need an introduction or a refresher on SQL Server, then I'd highly recommend that you take a look at my course: SQL Server 2022 Essential Training, as it'll give you everything that you need to be successful here. That course also has videos on installing SQL Server Developer Edition if you need to take care of that before we get started.

Contents