Learn Microsoft SQL server and T-SQL
4.2 (148 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,830 students enrolled

Learn Microsoft SQL server and T-SQL

Learn MSSQL using SQL server 2019
4.2 (148 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,830 students enrolled
Last updated 5/2020
English
English [Auto-generated]
Current price: $22.99 Original price: $34.99 Discount: 34% off
1 day 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

The course will teach you all you need to know to use sql server databases and features that come with them. We will start with the system setup and then we will move on further to basics.


With the general information, you will also learn how to use some very useful features - such as jobs and vulnerability assessments.

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