Home > Uncategorized > Newly launched #Udemy course for Microsoft #SQL server.

Newly launched #Udemy course for Microsoft #SQL server.

This is my first Udemy course that I’ve published. It teaches you pretty much all I know about SQL server in 6 hours of videos, right from absolute beginner, to expert.

If you’re interested in finding out more about the course, please click the link below;

https://www.udemy.com/course/sql_server/?referralCode=8FFD23693EFA04445F99

If you ask nicely, I have a limted number of coupons available, if you contact me personally.

Here are the course contents;

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.

What you’ll learn

  • Students will learn how to use the Microsoft SQL server database platform

Are there any course requirements or prerequisites?

  • Students will require a Windows PC that meets the minimum specifications for installing Microsoft SQL server

Who this course is for:

  • Students interested in learning about the Microsoft SQL server database platform

 

Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: