skills logo

Explore

  1. Courses
  3. SQL Server Tutorial For Beginners

SQL Server Tutorial For Beginners

skills

BEGINNER

Project

Updated 1 year ago

About

Modules

M:1

Getting started with SQL Server

9 Lessons

|

1 Hr, 21 Min

The SQL Server module enables developers to seamlessly install, and interact with Microsoft SQL Server databases, making it a valuable tool for database-driven applications.

  • SQL Server Management Studio Install & Tips

    15:04

  • CREATE & DROP Database

    5:40

  • Set Up A Dummy Database

    4:40

  • CREATE Table

    10:43

  • INSERT Statement

    5:39

  • UPDATE Statement

    4:02

  • SELECT & FROM Statements

    10:21

  • WHERE Statement and Filtering Data

    18:20

  • ORDER BY Sorting Keyword

    7:29

M:2

Introduction Joining Table

7 Lessons

|

54 Min

Joining tables is a fundamental concept in relational databases, including SQL Server. It involves combining data from multiple tables based on common columns to retrieve meaningful information. In SQL Server, various types of joins (e.g., INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN) are used to combine data from different tables.

  • Normalization

    9:25

  • Primary and Foreign Keys

    11:57

  • JOINS

    2:16

  • LEFT JOINS

    7:03

  • RIGHT JOINS

    8:52

  • Aggregate Functions [COUNT, MAX, MIN, AVG, SUM]

    6:27

  • GROUP BY & HAVING [Aggregate Functions]

    8:45

Project:
Basic Banking System Database

Create a simple database system for a bank that includes tables for customers and loans. The project involves designing the database schema, adding sample data, and creating SQL queries to retrieve useful information.

Instructors:

Details not provided...

Preview this course

This course includes:

  • 2 Hr, 16 Min on-demand video
  • Lifetime access
  • Milestone budges
5 star
4 star
3 star
2 star
1 star
★★★★★

instinctHublogo

Powered by instinctHub

© 2025 All right reserved

  • Privacy Policy
  • Terms & Condition