Microsoft Sql Server: The Complete Bootcamp 2024

Mastering SQL Server: Dive into Database Design, Advanced Querying, Performance Optimization, & Advanced Capabilitieis

What you'll learn

Students will gain a comprehensive understanding of SQL Server 2022, from basic concepts to advanced features.

They will learn how to design databases, create and manage tables, and perform various database operations.

They will acquire skills in querying data using SQL, including advanced techniques such as joins, subqueries, and window functions.

They will understand how to implement and manage transactions, and triggers in SQL Server.

They will learn about data backup and restoration, user management, and performance optimization in SQL Server.

Requirements

This course is designed to be accessible for beginners, so no prior knowledge of SQL Server is required.

A computer with internet access is needed to download and install SQL Server and SQL Server Management Studio.

Basic computer skills and familiarity with Windows operating system would be beneficial.

An interest in learning about databases and SQL is a plus!

Description

Welcome to our comprehensive course on SQL Server . This course is designed to take you on a journey from the basics of SQL Server to its most advanced features. Whether you’re a beginner just starting out or an experienced professional looking to upgrade your skills, this course has something for you.We start with an introduction to SQL Server and the fundamentals of database design. You’ll learn about Entity-Relationship Diagrams (ERDs), normalization, and the different types of keys in SQL. We then move on to database operations, where you’ll get hands-on experience creating databases, tables, and performing various operations.As we progress, we delve into advanced querying techniques. You’ll learn about joins, subqueries, Common Table Expressions (CTEs), and window functions. We also cover indexes, data import and export, and user management.Towards the end of the course, we focus on performance and optimization, ensuring you know how to get the best out of your SQL Server databases. We wrap up with a deep dive into SQL Server’s advanced capabilities like working with JSON data, Triggers, Functions, Stored Procedures and many more.With plenty of practical examples and exercises, this course ensures you get hands-on experience working with SQL Server. Join us today and take the first step towards mastering SQL Server.

Overview

Section 1: Introduction

Lecture 1 Course Intro

Lecture 2 Introduction to SQL

Lecture 3 Installation

Lecture 4 Exploring SQL Server Management Studio

Section 2: Understanding Databases and Important Topics

Lecture 5 Important Topics

Lecture 6 Create, Delete and Choose Database Path

Lecture 7 DataTypes and Tables

Section 3: Database Operations

Lecture 8 Table Creation and Deletion

Lecture 9 Inserting and Retrieving Records

Lecture 10 Updating Records

Lecture 11 Deleting Records

Section 4: Table Design

Lecture 12 Keys in SQL

Lecture 13 Primary Key

Lecture 14 Identity Specification

Lecture 15 Unique Key

Lecture 16 Default Value

Lecture 17 Check Constraints

Lecture 18 Computed Columns

Section 5: Transact-SQL

Lecture 19 Importing Data

Lecture 20 Schemas & Commenting

Lecture 21 Truncate, Distinct, Aliases, IsNull

Lecture 22 Coalesce, NulliF, Cast

Lecture 23 Convert, Case

Lecture 24 String agg, XML, Substring

Lecture 25 Replace, Stuff, Translate

Lecture 26 Working with non English Characters

Section 6: Working with Dates & Times

Lecture 27 Getdate, DateAdd, DateDiff, DatePart, DateName

Lecture 28 SysDateTime, Convert

Section 7: Database Design and ERD Diagrams

Lecture 29 Introduction

Lecture 30 One-to-One Relationship

Lecture 31 Relationship Rules

Lecture 32 One-to-Many Relationship

Lecture 33 Many-to-Many Relationship

Section 8: Joins

Lecture 34 Introduction, Inner & Left Joins

Lecture 35 Right & Full Joins

Lecture 36 Self & Cross Joins

Lecture 37 Advanced Joins

Section 9: Necessary SQL Functions

Lecture 38 Manipulation & Searching Functions

Lecture 39 Arithmatic Functions

Lecture 40 Aggregate Functions

Section 10: Advanced Querying

Lecture 41 Order By & IN Operator

Lecture 42 Subquries, Correlated Subqueries & Relational Operators

Lecture 43 Logical & Between Operators

Lecture 44 Like Operator & Group By

Lecture 45 Having Clause

Lecture 46 CTEs

Lecture 47 PIVOT & UNPIVOT

Lecture 48 Union & Union All

Lecture 49 Except & Intersect

Lecture 50 Offset & Pagination

Section 11: Window Functions

Lecture 51 Row_Number & Rank

Lecture 52 Dense Rank

Lecture 53 NTile

Lecture 54 Lag

Lecture 55 Lead

Lecture 56 First_Value & Last_Value

Section 12: Views

Lecture 57 Introduction to Views

Lecture 58 Creating and Modifying Views

Lecture 59 Updatable Views

Lecture 60 Schema Binding

Lecture 61 With Check Option

Section 13: User-Defined Functions

Lecture 62 Intro to User-Defined Functions

Lecture 63 Scalar-Valued UDFs 01

Lecture 64 Scalar-Valued UDFs 02

Lecture 65 Table-Valued UDFs 01

Lecture 66 Table-Valued UDFs 02

Section 14: Stored Procedures

Lecture 67 Intro to Stored Procedures

Lecture 68 Creating Complex Stored Procedures

Lecture 69 Outputing Data with Stored Procedure

Section 15: Triggers

Lecture 70 Intro to Triggers

Lecture 71 After Insert & Delete

Lecture 72 After Update & Update Function

Lecture 73 Instead of Trigger

Section 16: Transactions

Lecture 74 Intro to Transactions

Lecture 75 Transactions in Detail

Section 17: Data Import & Export

Lecture 76 Backup & Restoration

Lecture 77 Data-tier Functionalities

Lecture 78 Generating Database Script

Lecture 79 Detach, Attach, Offline & Online

Lecture 80 Data Transfer with MS Excel

Lecture 81 Data Transfer with MS Access

Lecture 82 Data Transfer with Flat Files

Section 18: Permissions & User Management

Lecture 83 Create Logins

Lecture 84 Granting Access to Login

Lecture 85 Users Permissions Management

Lecture 86 Grant Permissions to Specific Object

Section 19: Working with JSON Data

Lecture 87 Storing JSON Data

Lecture 88 Fetching & Modifying JSON Data

Lecture 89 Import JSON Data from Other Resources

Lecture 90 Joining JSON Data

Lecture 91 With Statement in JSON Data

Lecture 92 Convert SQL Table into JSON Format

Section 20: Conclusion

Lecture 93 Conclusion

This course is ideal for anyone interested in learning about SQL Server, whether they’re complete beginners or have some prior experience.,It’s perfect for IT professionals who want to upgrade their skills, students studying computer science or related fields, and anyone interested in data management.,The course is also suitable for developers who want to understand how to interact with databases using SQL.