Seize the opportunity to gain new skills and reshape your career!

Choose a free learning path and get valuable insights from first-rate courses
watching now
4 Students
27 Lessons
Beginner

What Will You Learn?

  • How to set up the MS SQL server database.
  • The basics to start using the MS SQL server.
  • The common features of MS SQL server such as authentication, drivers, file-management, and useful functions.

Curriculum

4h 13m
Section 1: Introduction
02:19
Section 2: Setup
47:06
SQL server setup
28:10
SQL server management studio
03:38
Databases and tables
15:18
Section 3: Basics
27:06
SELECT
07:00
UPDATE
03:21
Sorts
04:04
Variables
01:45
Logic
04:02
Section 4: Security
21:03
Authentication
08:03
Connection strings
08:00
Vulnerability assessment
05:00
Section 5: MSSQL and different drivers
51:45
Stored procedure
10:08
c# ado.net
27:54
Python
13:43
Section 6: Files
45:39
File table
09:20
Procedures
14:45
Insert and retrieve file using C#
21:34
Section 7: Other features
08:17
Functions
08:17
Section 8: General
49:55
Import data
03:29
Export data
05:55
Jobs (SQL server agent)
18:18
Backup
09:41
Database email
08:19
Job notifications
04:13

Description

Requirements

  • You need to have Visual Studio (for driver and file lectures).

About the Instructor

100% of students rated this instructor as excellent!
Reviews 0
Students 16
Courses 3

Meet a businessman with a solid background in software development – Taurius Litvinavicius. His expertise covers .NET core, MSSQL, C++, and other powerful technology. Taurius has collected a great deal of experience working in various technology-related and other projects, taking different roles from software development to project management. Whatever the project, Taurius accepts challenges with great courage and says that “the best way in any task is the straightforward way.”

Taurius Litvinavicius has experienced good and bad moments in a formal education setting, therefore, in his courses, he only presents the most necessary tools and topics skipping the theoretical surplus. He has achieved success in both business and technology, so Taurius’s view is that an all-rounder in both areas is something to work for, and he’s the embodiment of his idea!

On BitDegree, you’re welcome to tap into Taurius’s knowledge and practical experience by learning to deal with API requests and responses, building your own authentication system along the way with .NET Core. You may also get the essentials of the SQL server setup and also become more than familiar with Blazor. Taurius Litvinavicius will take care of your progress so that you can develop into a better version of yourself as a coder.

BitDegree platform reviews

Our students say Excellent
9.5 out of 10
trustpilot logo 1 trustpilot logo