SQL server - from setup to execution
3.9 (152 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
19,833 students enrolled

SQL server - from setup to execution

Learn MSSQL using SQL server 2019
3.9 (152 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
19,833 students enrolled
Last updated 5/2020
English
English [Auto]
Current price: $23.99 Original price: $34.99 Discount: 31% off
23 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 1 Practice Test
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • SQL server setup
  • SQL queries
  • SQL server agent
Course content
Expand all 28 lectures 04:23:44
+ Basic queries
7 lectures 26:59
INSERT
04:01
SELECT
06:59
UPDATE
03:20
DELETE
02:51
Filter and sort
04:03
Variables
01:44
Logic
04:01
Basics test
5 questions
+ Security
3 lectures 21:01
Authentication
08:03
Connection strings
07:59
Vulnerability assessment
04:59
+ MSSQL and different drivers
4 lectures 01:03:18
Stored procedure
10:08
Example: attendee registry
11:33
c#
27:54
Python
13:43
+ Files
3 lectures 45:38
File table
09:19
Stored procedures
14:45
Insert and retrieve file using C#
21:34
+ General
7 lectures 58:07
Functions
08:16
Import data
03:28
Export data
05:54
Jobs
18:17
Backup
09:40
Database email
08:19
Job notifications
04:13
Requirements
  • visual studio (for driver and file lectures)
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.

Who this course is for:
  • Programmers who want to learn SQL server