🚨 Time is Running Out: Reserve Your Spot in the Lucky Draw & Claim Rewards! START NOW
watching now
4 Students

Description

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.

Requirements

  • You need to have Visual Studio (for driver and file lectures).
  • NFT Certificate
  • 27 Lessons
  • Beginner
  • English
  • +100 XP

Share Course on Social media

Curriculum

Course consist of total 4h 13min of content, in total.

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

About the Instructor

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.

See All Instructor Courses

BitDegree platform reviews