Complete Microsoft SQL Server from Scratch: Bootcamp

Name: Complete Microsoft SQL Server from Scratch: Bootcamp
Rating: 4.2 (91 reviews)

Build Your Business Intelligence Career With Real World SQL Exercises - by Microsoft Certified Professional

Created byMetla Sudha Sekhar

Last updated 11/2025

English

What you'll learn

Learn to use Microsoft SQL professional way, learn new SQL!
Know how to prepare data structures
Create basic SQL language to writing queries
Create JOINS of Inner, left, right and full for multiple table data
Know how to simplify reports like spreadsheets! with huge data sets
You will learn to create secure user logins
Protect your data by doing backup and restore methods!
Learn about SSMS GUI tool for Microsoft SQL server
Create advanced built-in function SQL Queries
Create new tables, alter existing tables in Databases
Learn What is Generative AI / Gen AI
Participate in Practice test to test your learning skills
Discover and use the top AI tools that every professional should know

Course content

15 sections • 67 lectures • 9h 21m total length

Introduction3:54
you will know the course introduction
Course Curriculum overview4:23
in this lecture, you will know the course curriculum overview, don't skip this lecture you will know the training program road map
Overview of Databases8:56
you will learn an overview of databases on how to choose and what are the types
What is Source code8:47
you will learn about file extensions and source code
Learn What is Generative AI / Gen AI14:06
Generative artificial intelligence is artificial intelligence capable of generating text, images, videos, or other data using generative models, often in response to prompts. best ai tools are chatgpt, tabnine for developers, and more
Best Practices for Learning Online Course5:14
You will learn how to learn online courses in a more productive way.

Microsoft SQL Server Installation27:19
you will learn Microsoft SQL Server in your local system from scratch step by step and installation procedure to choose the windows and SQL users while installation.
Microsoft SQL Management Studio Installation (SSMS)7:50
in this lecture, you will learn Microsoft SQL Server Management Studio installation all steps
Connecting to MS-SQL (Windows Authentication)4:40
in this lecture, you will learn how to connect Microsoft SQL using Windows Authentication and its features
Connecting to MS-SQL (SQL Server Authentication)5:34
you will learn How to connect Microsoft SQL Server using SQL User authentication and its security enhancements using user-based authentication

Overview of Challenges2:38
you will learn overview of challenges, how you will ask you challenge and solutions for it
SQL Statement Basic12:54
you will learn SQL statement basic
SELECT Statement16:28
you will learn SELECT statement with real-world example
SELECT DISTINCT16:53
you will learn SELECT distinct keyword usage in SQL statements with real-world queries
Column AS Statement9:12
you will learn what is AS statement and its usage
COUNT9:41
you will learn count function usage in SQL query statement
Practice Test on SQL Query

Overview of GROUP BY8:12
you will learn overview of group by statement
Aggregation Function – SUM()11:51
you will learn Aggregation function of SUM, its usage on query execution
Aggregation Function – MIN()-MAX()8:21
you will learn Aggregation functions of MIN and MAX how to use on SQL query statement with real-world data
GROUP BY – One(theory)10:54
you will learn what is a group by in theorically
GROUP BY – Two(practical)13:54
in this lecture, you will learn group by clause how to apply and grouping the real-world data
HAVING on SQL Statement14:45
you will learn SQL query to applying having clause

Overview of JOINS6:39
you will learn overview of JOIN on SQL
Introduction to JOINS7:08
you will know introduction to joins in SQL
AS Statement (table)3:44
you will learn AS statement for table names and accessing columns within the table by applying As name
INNER Join12:20
you will cleary learn inner join don't skip this lecture you will know many things here
Full Outer Join7:23
you will learn full outer join
Left Outer Join5:58
you will learn left outer join on query statement of mssql
Right Outer Join7:51
you will learn right outer join in SQL query statements
Union7:24
you will learn union on sql query statement
Assessment Test 20:01
download and solve your problem statement
Solution for Assessment Test 20:02
find the Solution for Assessment Test 2

Basic of Advanced SQL Commands4:20
you will know basic of advanced SQL commands
Timestamp11:39
you will learn timestamp in MS SQL
Extract from Timestamp6:21
you will learn how to extract from timestamp DateTime format-independent items
Mathematical Scalar Functions11:07
you will learn mathematical scalar functions here
String Functions16:39
you will learn what are the most popular string bulti-in functions
SubQuery7:09
you will learn sub / inner query on SQL statement

Requirements

No programming experience needed. You will learn everything you need to know
No prior technical experience is required! All you need a computer with internet access!
No software is required in advance of the course (all software used in the course is free)

Description

Unlock the full potential of database management with "Complete Microsoft SQL Server from Scratch: Bootcamp." This all-inclusive course is designed to take you from a beginner to an expert in Microsoft SQL Server, one of the most powerful and widely used database systems in the world.

You’ll start with the fundamentals, learning about relational databases, setting up SQL Server, and creating your first database. As you progress, you’ll dive into essential topics like writing SQL queries, managing tables, and performing operations. You’ll also explore advanced features such as query optimization techniques.

update: Learn the top AI tools every professional needs to boost productivity

This bootcamp goes beyond the basics, teaching you how to design efficient databases, manage transactions, and secure your data. You’ll gain practical experience through hands-on projects and real-world scenarios, ensuring you’re well-prepared to apply your skills in professional environments. Additionally, the course covers integrating SQL Server with tools like Microsoft Power BI and programming languages, enabling you to build end-to-end solutions.

learn to take notes, practice Queries regularly, and use real life data queries makes you master in SQL

By the end of this course, you’ll have a deep understanding of Microsoft SQL Server, empowering you to take on roles in database administration, development, and data analysis. Start your SQL Server journey today and elevate your career!

Who this course is for:

Anybody who wants to learn Microsoft SQL
Anybody who wants to better understand how databases work
Anybody who wants to enhance their Data Science career
People who want to become a professional on SQL
Anyone who wants to build business intelligence reports

Complete Microsoft SQL Server from Scratch: Bootcamp

What you'll learn

Explore related topics

Course content

Course Introduction6 lectures • 45min

Future Essential AI Tools for Every Professional1 lecture • 5min

MS SQL Environment Setup4 lectures • 45min

SQL Statement Basics6 lectures • 1hr 8min

Filtering Data Rows2 lectures • 17min

SQL Operators5 lectures • 49min

GROUP BY Statements6 lectures • 1hr 8min

Assessment Test 13 lectures • 2min

JOINS10 lectures • 59min

Advanced SQL Commands6 lectures • 57min

Requirements

Description

Who this course is for: