Short Course

Microsoft SQL Server for Everyone

Mastering SQL Server Database Design and Development with T-SQL, Foreign Keys, CRUD Operations, Views, Triggers, and Stored Procedures

9 Hours of video content

Beginner

Certificate of Completion Included

Check out Subscription Plans

Overview What You Will Learn Curriculum Instructor

Course Overview

Microsoft SQL Server?is a powerful and widely used database management system used by organizations of all sizes to store and retrieve data. This course teaches you how to use Microsoft SQL Server to design, implement, and maintain a database. You will learn key concepts such as database design, query writing, and stored procedure creation. You will have the opportunity to practice your skills through hands-on exercises and projects.

This is a zero-to-hero course on?Microsoft SQL Database development?and?querying techniques. This course provides you with fundamental SQL Server training and is enough to get you started as a Database Developer or Database Administrator. We will explore best practices in database development using?SQL Server?and will be building a small?school management system?database. All you need is a capable machine, and we will walk through setting up an environment, creating a database, creating your first table, and writing queries.

By the end of this course, you will have a strong understanding of how to use Microsoft SQL Server to manage and manipulate data and will be able to use it effectively in your projects. Whether you are new to database management or have some experience, this course is designed to provide a comprehensive overview of Microsoft SQL Server and help you become proficient in its use.

What You Will Learn

How to Install SQL Server and SQL Server Management Studio (Windows or Docker for Mac and Linux)
How to Connect to a Database Instance and create Databases and Tables
How to Use SQL Management Studio (SSMS)
How to develop entity relationship diagrams using visual design tools
How to normalize a database and create relationships and foreign keys
How to create and manage Functions
 Table Triggers
 and Stored Procedures
How to Backup and Restore Databases
How to manage users and database security

Program Curriculum

Understanding Types of Data and Storage
$7 Million Cybersecurity Scholarship by EC-Council
Chapter 1 Quiz

Download and Install SQL Server Express (Windows)
Install SQL Server on Mac and Linux
Chapter 2 Quiz

Explore SQL Server Management Studio
Explore Azure Data Studio
Explore Draw.io
Chapter 3 Quiz

Section Overview
Create a Database Using Management Studio
Create a Database Using SQL Script
How to Remove a Database?
How To Change the Database Name?
Section Review
Chapter 4 Quiz

What is a Database Table?
Create Entity Data Model
Create a Database Table Using Management Studio
What is SQL?
Create a Database Table Using SQL Script
Review Table Creation
Insert Data into the Table Using Management Studio
Insert Data into the Table Using SQL Scripts
Select Data from Tables - Simple Queries
Select Data from Tables - Adding Filtering
Select Data from Tables - Exporting Data
Update Data in Tables
Delete Data from the Tables
SQL Transactions
Review CRUD Operations
Chapter 5 Quiz

What are Relationships, Foreign Keys, and Normalization?
Normalizing Our Database
Creating a Relationship in SQL Server
Inserting Records in One-to-Many Related Tables
Inserting Records in Many-to-Many Related Tables
Using Inner Joins to Read Related Data
Understanding Left, Right, and Full Joins
Foreign Key Cascade Options
Section Review
Chapter 6 Quiz

Grouping Data Using SQL GROUP BY Clause
SQL COUNT Aggregate Function
SQL AVG (Average) Aggregate Function
SQL MAX and MIN Aggregate Functions
SQL SUM Aggregate Function
Filtering on Aggregate Values
Chapter 7 Quiz

Section Overview
Create and Manage Views
Scalar Valued Functions
Inline Table Valued Functions
Multi Statement Table Valued Functions
Stored Procedures
Table Triggers
Generating Database Scripts
Database Backup and Restore
Chapter 9 Quiz

Section Overview
Create an SQL User Login
Add Windows Authenticated Login
Add Server Logins with Script
Chapter 9 Quiz

Load more modules

Instructor

Trevoir Williams

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) and several Microsoft Azure Certifications. 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.

Buy this course now

$79.99

Get Immediate access for one year today!

Upgrade to Pro Plans and Get Full Access Today!

Get this course, along with 700+ courses and 50+ learning paths and more in one subscription. Learn more

Unlock All Access

Plans start from $33/mo. Cancel anytime.

Join over 1 Million professionals from the most renowned Companies in the world!

Empower Your Learning with Our Flexible Plans

Invest in your future with our flexible subscription plans. Whether you're just starting out or looking to enhance your expertise, there's a plan tailored to meet your needs. Gain access to in-demand skills and courses for your continuous learning needs.

Monthly Plans

Annual Plans

Save 20% with our annual plans!

Pro

Ideal for continuous learning, offering extensive resources with 600+ courses and diverse Learning Paths to enhance your skills.

^$ 499.00

Billed annually or $59.00 billed monthly

Get Started Now

Start your 7-day trial for $1

What is included

700+ Premium Short Courses
50+ Structured Learning Paths
Validation of Completion with all courses and learning paths
New Courses added every month

Early Access Offer

Pro +

Experience immersive learning with Practice Labs, CTF Challenges, and exclusive EC-Council certifications for comprehensive skill-building.

^$ 599.00

Billed annually or $69.00 billed monthly

Get Started Now

Start your 7-day trial for $1

Everything in Pro and

800+ Practice Lab exercises with guided instructions
150+ CTF Challenges with detailed walkthroughs
New Practice Labs and Challenges added every month
3 Official EC-Council Essentials Certifications¹ (retails at $897!)
Exclusive Bonus with Annual Plans

¹This plan includes Digital Forensics Essentials (DFE), Ethical Hacking Essentials (EHE), and Network Defense Essentials (NDE) certifications. No other EC-Council certifications are included.

Related Courses

Hands-on FortiGate Firewall

Short Course

Hands-on FortiGate Firewall

Security Architecture and Operations

Learn how to deploy the FortiGate NGFW and how to configure the most common features of FortiGate Next-Gen Firewalls

Learn how to deploy the FortiGate NGFW and how to configure t...

$99.99

Intermediate

3 hr 0 m

Hello
Hands-on SELinux

Short Course

Hands-on SELinux

Security Architecture and Operations

Learn SELinux Basics: Implement Security Policies, Troubleshoot, and Protect Linux Systems Effectively.

Learn SELinux Basics: Implement Security Policies, Troublesho...

$49.99

Beginner

5 hr 28 m

Hello
Complete Bash Shell Scripting

Short Course

Complete Bash Shell Scripting

Security Architecture and Operations

Automate repetitive tasks with Bash Shell Scripting to save valuable time

Automate repetitive tasks with Bash Shell Scripting to save v...

$79.99

Intermediate

18 hr 10 m

Hello
Installing and Mitigating Linux Rootkits

Short Course

Installing and Mitigating Linux Rootkits

Security Architecture and Operations

Understanding the threat posed by rootkits in Linux and potential mitigations.

Understanding the threat posed by rootkits in Linux and poten...

$59.99

Advanced

3 hr 0 m

Hello
Start Hacking and Making Money Today at HackerOne

Short Course

Start Hacking and Making Money Today at HackerOne

Security Architecture and Operations

Hack Legally and Get Paid for Your Findings

Hack Legally and Get Paid for Your Findings

$59.99

Beginner

1 hr 9 m

Hello
PowerShell Scripting Essentials: Anatomy of Logging – Developing a Logging Module

Short Course

PowerShell Scripting Essentials: Anatomy of Logging – Developi...

Security Architecture and Operations

How to write a PowerShell module that contains functions to do logging for our scripts

How to write a PowerShell module that contains functions to d...

$69.99

Intermediate

6 hr 1 m

Hello
Machine Learning for Application in Digital Forensics

Short Course

Machine Learning for Application in Digital Forensics

Security Architecture and Operations

Unlocking the Potential of Machine Learning: From Theory to Practice

Unlocking the Potential of Machine Learning: From Theory to P...

$99.99

Intermediate

4 hr 0 m

Hello
Applied Python Cryptography

Short Course

Applied Python Cryptography

Security Architecture and Operations

Securing your Python code and protecting your users private information by utilizing simple, powerful, and free cryptographic libraries

Securing your Python code and protecting your users private i...

$79.99

Intermediate

4 hr 0 m

Hello