The 2026 All-in-One Database Course Bundle

6 Courses & 22.5 Hours
Deal Price$24.99
Suggested Price
$199.94
You save 87%
The 2026 All-in-One Database Course Bundle
$24.99$199.9487% OFF

What's Included

  • Experience level required: All levels
  • Access 44 lectures & 5 hours of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

44 Lessons (5h)

  • Intro to the MS SQL Course?3:21
  • What is database?3:19
    RDBMS (Relational Database Management System)2:24
    What is SQL/Query?2:49
    FAQ about MS SQL
  • Normal Forms (NF)7:56
    Normalization2:58
  • Install MS SQL Server Express Edition 20194:35
  • Create, Alter and Drop Database8:46
    Starting To SSMS (SQL Server Management Studio)5:08
    Create, Rename and Drop Table13:42
    Data Types and Constraints5:52
    Foreign Key Constraint5:14
    Unique & Check Constraint5:31
    Quiz
  • Insert Data to Table10:05
    Update Data in A Table5:42
    Delete Data and AdventureWorks6:17
  • Select Statement and Alias7:09
    Where Clause and Operators10:49
    Quiz
  • Sorting and Grouping Data13:28
    Quiz
  • Like Clause8:03
  • Case Function4:37
  • Convert and Cast Function8:32
  • Left and Right Join7:29
    Inner Join7:05
    Full and Self Join6:02
  • Union Operators5:35
    Intersect and Except Operators6:25
  • Subqueries With Select Statement8:44
    Single Row & Multiple Row Subqueries5:25
    Insert, Update and Delete Statement7:23
  • DateTime Function14:39
    Converting DateTime7:39
  • String Functions8:58
  • Math Functions13:24
  • SQL Transactions6:10
    SQL Transactions Commands8:00
  • Create Logins8:42
    Users & User Permissions10:57
    Permissions & Roles18:10
  • What we have learned?6:57

Learn MS SQL Server from Scratch

OA
Oak Academy

Oak Academy | Long Live Tech Knowledge

4.4/5 Instructor Rating: ★ ★ ★ ★ ★ ★


Oak Academy is a group of tech experts who have been in the sector for years and years. Deeply rooted in the tech world, they know that the tech industry's biggest problem is the "tech skills gap" and their online course is their solution. They specialize in critical areas like cybersecurity, coding, IT, game development, app monetization, and mobile. Thanks to their practical alignment, they are able to constantly translate industry insights into the most in-demand and up-to-date courses.

Description

Create and Manage Databases with MS SQL Query

Anyone looking to master MS SQL Server from the ground up will benefit from this comprehensive course. You’ll gain hands-on experience in creating and managing databases using MS SQL queries. Whether you're new to databases or seeking to enhance your skills, this course covers everything you need to get started with MS SQL Server. Learn how to create databases, manage SQL databases, and understand key concepts in database management, all in a step-by-step approach designed to build your confidence and proficiency.

 

4.5/5 average rating: ★ ★ ★ ★ ★ ★

What you'll learn

  • Access 44 lectures & 5 hours of content 24/7
  • Learn the fundamentals of SQL & MS SQL Server
  • Use SQL Server Management Studio (SSMS)
  • Learn about data manipulation & basic select statements
  • Sort, group & use wildcard operations
  • Explore conditional logic & data conversion techniques
  • Retrieve data from multiple tables & perform set operations
  • Learn subqueries & various SQL functions (DateTime, string, math)
  • Understand SQL transactions & user management for data integrity

Who this course is for

  • Anyone who wants to start learning SQL Server Basics
  • Anyone who plans a career in Microsoft SQL Server Database

Specs

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Certificate of Completion ONLY
  • Updates included
  • Closed captioning NOT available 
  • Not downloadable for offline viewing
  • Have questions on how digital purchases work? Learn more about digital products
  • Learn more about what lifetime access means

 

Requirements

  • Computer with access to the internet

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Processing order...