Brief Introduction
Learn about Microsoft's most popular database platform, become an expert in managing and querying data.Description
Microsoft SQL server is the most popular database platform for Windows, and with this course, we will take you from absolute beginner to expert in just under six hours of hands-on experience.
We begin by teaching you how to install your own free copy of SQL server on your own machine, or if you prefer, to host SQL server on the cloud with Amazon Web Services or Microsoft Azure.
Following on, we teach you how to create tables, insert rows, update and delete them, and read them back. You'll quickly learn how to write queries to filter and sort data, to group and summarize data, to run statistical queries on the data.
Once you've mastered the basics, we show you how to create database triggers, to manage transactions, and how to wrap up complex code as simpler code using stored procedures and user defined functions.
But, it's not all about database development, we also teach you about database adminstration, how to backup and restore your database, and more importantly, transfer your backups to the cloud, like AWS S3 or Azure Blob storage.
We also teach you about database tuning, how to make your queries run faster, and make your system more performant, and about database security, how to protect your data, and comply with data protection laws like GDPR and CCPA.
And to wrap up, we teach you how to connect to SQL server from four different programming languages, Microsoft C# .NET Core, Node JS, Python and Java.
Requirements
- Requirements
- Students will require a Windows PC that meets the minimum specifications for installing Microsoft SQL server
MySQL for Beginners
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Learn how to Create, Use and Handle a MySQL Database from Scratch. Are you a Web Developer? An Application Developer? or A Programmer?...
Asp.Net Core : The Complete Guide To Build RESTful Api's
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Learn to build secure RESTful Api's with Asp. Net Core, Entity Framework and C# Welcome to the Complete Rest Api's course with Asp....
The Complete Oracle SQL Course
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Learn Oracle SQL: From Beginner to An Oracle Certified Associate - Helpful for Oracle Exam 1Z0-071 Quick Info: With FULL Subtitles for all the video lessons...
Microsoft Azure: From Zero to Hero - The Complete Guide
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Become an Azure Expert! Learn to design and build modern cloud apps from a certified Azure Architect Learn Microsoft Azure from a certified, experienced Azure Architect....
