watching now
5 Students
18 Lessons
Beginner

What Will You Learn?

  • How to set up a database server
  • Basic SQL queries and commands
  • How a relational database works

Curriculum

3h 3m
Section 1: Introduction
09:31
Download and Install SQL Server 2017
05:22
Section 2: Manipulating Tables and Data
1:50:44
Connect to Database Instance and Create a Database
05:55
Drop or Remove Database
04:17
What is a Database Table?
02:09
Create an SQL Database Table
31:40
Insert Data into the Table with SQL Script
15:03
Insert Data into the Table with Management Studio
04:34
Select Data from the Table with SQL Script
09:20
More Advanced Select Queries Part 1
17:51
Update Data in the Table
09:50
Update Data in the Table with Management Studio GUI
02:14
Delete Data from the Table with SQL Script
06:27
Delete Data from the Table with Management Studio GUI
01:24
Section 3: Relationships and Foreign Keys
1:03:14

Description

Requirements

  • No prior knowledge is required

About the Instructor

Reviews 0
Students 1
Courses 1

Trevoir Williams is a passionate software and system engineer with a strong drive to share the best of his knowledge with students around the globe. His educational achievements include a Master’s degree in Computer Science (major in Software Development). His impressive work experience includes software consulting, software engineering, database development, cloud system, and server administration, lecturing, and he’s also a musician! Trevoir enjoys teaching IT and development skills and guides students in gaining the latest knowledge with practical application in the modern industry.

On BitDegree, Trevoir Williams offers an opportunity to learn the fundamentals of database design and development with Microsoft SQL Server. He’ll guide you through what you need to learn how to create and run basic SQL queries and commands, and how to set up a database server. Join Trevoir Williamson’s course if you want to become a database professional – one of the occupations that will bring a decent salary to you for many years to come.

BitDegree platform reviews

Our students say Excellent
4.5 out of 5
trustpilot logo 1 trustpilot logo