SQL server - from setup to execution

Learn MSSQL using SQL server 2019

4.45 (183 reviews)
Udemy
platform
English
language
Databases
category
SQL server - from setup to execution
19,866
students
4.5 hours
content
May 2020
last update
$49.99
regular price

What you will learn

SQL server setup

SQL queries

SQL server agent

Description

Everything you need to know to use SQL server is here. From setup on windows server, to various queries and stored procedures. And alongside these basics, you will also learn how to establish connections, how to establish them in C#, how to use file tables, how to create jobs and use other more advanced features of SQL server.

Content

Introduction

Introduction

Setup

SQL server setup
SQL server management studio setup
Databases and tables

Basic queries

INSERT
SELECT
UPDATE
DELETE
Filter and sort
Variables
Logic
Basics test

Security

Authentication
Connection strings
Vulnerability assessment

MSSQL and different drivers

Stored procedure
Example: attendee registry
c#
Python

Files

File table
Stored procedures
Insert and retrieve file using C#

General

Functions
Import data
Export data
Jobs
Backup
Database email
Job notifications

Reviews

Niels
February 21, 2020
Het lijkt erop dat de cursusgever af en toe ook niet weet of hij iets wel of niet aan moet zetten bij de installatie
Chetsada
January 5, 2020
this course is ok but don't have some example exercise even test database for practise. is not worth when you buy full price
Jakub
October 22, 2019
Installation options are not described, some settings are enabled just because it's better to enable everything.
Wai-Kit
September 25, 2019
Course was very good and has loads of information broken down into individual sections/categories with the right amount of time per video tutorial. Thank you!
Dirk
September 4, 2019
- Sommige besproken onderwerpen vallen buiten beeld (Te veel ingezoomd) - Sommige onderdelen zijn lastig zichtbaar en zouden beter ingezoomd kunnen worden weergegeven - Soms trage voortgang van de cursus doordat er lange laadtijden zijn, kan dit niet worden overgeslagen?
Adam
August 31, 2019
You can tell the instructor is knowledgeable, however he does not explain certain things clearly. In some of the lectures, it feels like there's a certain amount of knowledge of the subject pre-required, which I feel defeats the purpose of an introduction course such as this.
Mihail
April 14, 2019
Appreciate the course information that I received but the information was not clear at all. When making a tutorial for developers who does not have previous experience with data base systems everything should be shown step by step. Meanwhile I have noticed that the lecturer does not do that. In the beginning of the C# lesson the lecturer have been created Stored procedures and he is working the whole 50 min tutorial with them but never shown how to create them. I have just copied the code but it throws an error and I can clearly see that it's the same on his window and he does not even mention it. Also, cutting your screen and working with the cursor on area that you are not showing is not what a beginner course should be. Thanks.
Néstor
April 4, 2019
No pude disfrutar mucho del curso por terminos de tiempo, y ademas por el idioma era en ingles y pues no esta subtitulado en español entonces por eso hizo que no lo cursara de manera correcta viendo todos los videos. pero lo temas son muy buenos ya hablas de cosas un poco avanzadas y eso me hubiese agradado tenerlo en español.

Coupons

DateDiscountStatus
5/24/2019100% OFF
expired
8/27/2019100% OFF
expired
9/6/2019100% OFF
expired
9/16/2019100% OFF
expired
9/21/2019100% OFF
expired
11/17/2019100% OFF
expired

Charts

Price

SQL server - from setup to execution - Price chart

Rating

SQL server - from setup to execution - Ratings chart

Enrollment distribution

SQL server - from setup to execution - Distribution chart
2092488
udemy ID
12/17/2018
course created date
4/27/2019
course indexed date
Bot
course submited by