Master Sql Basics In 7 Days! | Learn Sql Server (Ssms)

A One Week Comprehensive Introduction to SQL and Microsoft SQL Server Management Studio!

What you'll learn

Master the basics of Microsoft SQL Server Management Studio.

Understand the basics to SQL - SELECT, INTO, FROM, WHERE, GROUP BY, HAVING, ORDER BY.

Learn how to INSERT, UPDATE and DELETE data.

Retrieve and filter data using conditions, sorting, and grouping techniques.

Learn to join multiple tables and understand relationships between data.

Create and manage databases, tables, and views in Microsoft SQL Server Management Studio (SSMS).

The fundamentals of database design and how to ensure efficient data management.

Hands-on practice with real-world exercises to reinforce SQL skills and build confidence.

Become a data expert and add SQL to your resume. Gain applicable experience that will elevate your career!

Requirements

No prior knowledge of SQL or databases is required—this course is designed for beginners.

A desire to learn and dedicate one hour a day for seven days to master the basics of SQL.

Basic computer literacy, including familiarity with using files and software applications.

A Windows-based computer to install and use Microsoft SQL Server Management Studio (SSMS).

Description

Welcome to "Master SQL Basics in 7 Days! | Learn SQL Server (SSMS)," your fast-track introduction to SQL and Microsoft SQL Server Management Studio (SSMS). Designed for beginners, this comprehensive course takes you through the essentials of SQL in just seven days. Whether you're a complete novice or looking to strengthen your foundational knowledge, this course will guide you step-by-step through the key concepts of SQL and provide hands-on experience using SSMS, one of the most powerful tools for managing databases.In just one week, you'll learn how to query databases, retrieve and manipulate data, and create your own databases—all essential skills for anyone looking to dive into data analysis, business intelligence, or database management. Each lesson is designed to be approachable and simple yet detailed, ensuring you gain both theoretical knowledge and practical, real-world application. No prior coding or database experience is required; all you need is the desire to learn!Throughout this course, you will:Gain the confidence to navigate and use SQL and Microsoft SQL Server Management Studio like a data pro.Understand the basics of SQL, including SELECT, INSERT, UPDATE, DELETE, and JOIN operations.Learn how to create and manage databases, tables, and relationships within SSMS.Write efficient queries to retrieve and manipulate data.Explore advanced topics such as indexing, views, and stored procedures.Create Databases and inserting thousands of valuesAnalyze thousands of rows of data – real world dataPrepare data for visualizations such as PowerBI, Tableau, etc.Design Entity Relationship DiagramsAggregate, format, and modify data using SQL operators and functionsGain experience with Big Data and solving complex questions using dataLearn SQL Joins – working with multiple tables and databasesPractice, Practice, Practice.And much more!The course is divided into seven bite-sized modules, each building on the last, ensuring a smooth learning curve. You’ll complete each lesson with practical exercises, allowing you to immediately apply what you’ve learned and solidify your skills. By the end of the week, you'll have a solid understanding of SQL and how to use SSMS to interact with databases efficiently.In this course, the instructor will guide you through the step-by-step process of installing Microsoft SQL Server Management Studio on a Windows operating system. It is strongly recommended that you have access to a Windows-based computer before enrolling.Whether you're looking to advance your career, gain new technical skills, or simply understand the language of databases, this course will provide you with the tools you need to succeed. Start your journey to mastering SQL today!

Overview

Section 1: Day One: Getting Started

Lecture 1 Video: Course Introduction

Lecture 2 READ ME: Welcome!

Lecture 3 Video: What is a Server?

Lecture 4 Article: Cloud Based vs. On-Premises Servers

Lecture 5 Video: What is a Database?

Lecture 6 Article: Database Management Systems

Lecture 7 Video: Introduction to SQL

Lecture 8 Article: Understanding SQL Command Categories

Lecture 9 Optional Article: E.F. Codd - A Relational Model of Data for Large Shared Data..

Lecture 10 Link: Downloading Microsoft SQL Server

Lecture 11 Video: Downloading Microsoft SQL Server

Lecture 12 Video: Connecting to server in SSMS

Lecture 13 Video: SSMS Feature Demonstration

Lecture 14 Video: SQL Cheat Sheet

Lecture 15 Article: SQL Cheat Sheet

Section 2: Day Two: Databases & Tables

Lecture 16 Video: Day Two Introduction

Lecture 17 Video: Create Database

Lecture 18 Code: Create Database

Lecture 19 Video: Drop Database

Lecture 20 Code: Drop Database

Lecture 21 Video: Use Database

Lecture 22 Code: Use Database

Lecture 23 Video: Data Types

Lecture 24 Article: Data Types

Lecture 25 Video: Create Table

Lecture 26 Code: Create Table

Lecture 27 Video: Drop Table

Lecture 28 Code: Drop Table

Lecture 29 Video: Insert Data

Lecture 30 Code: Insert Data

Lecture 31 Video: Not NULL

Lecture 32 Code: Not NULL

Lecture 33 Video: Unique Values

Lecture 34 Code: Unique Values

Lecture 35 Video: Primary Keys

Lecture 36 Code: Primary Keys

Lecture 37 Video: Default Values

Lecture 38 Code: Default Values

Section 3: Day Three: Retrieving Data

Lecture 39 Video: Day Three Introduction

Lecture 40 Code: Syntax used in Day Three

Lecture 41 Video: Select & Top n

Lecture 42 Code: Select & Top n

Lecture 43 Video: Select Distinct

Lecture 44 Code: Select Distinct

Lecture 45 Video: Arithmetic Operators

Lecture 46 Code: Arithmetic Operators

Lecture 47 Video: Alias Names

Lecture 48 Code: Alias Names

Lecture 49 Video: Where Clause (=, >, <, >=, <=, <>)

Lecture 50 Code: Where Clause (=, >, <, >=, <=, <>)

Lecture 51 Video: Where Clause (And, Or, Not in, Between)

Lecture 52 Code: Where Clause (And, Or, Not in, Between)

Lecture 53 Video: Where Clause (Like, Null, Not Null)

Lecture 54 Code: Where Clause (Like, Null, Not Null)

Lecture 55 Video: Order by

Lecture 56 Code: Order by

Lecture 57 Video: Aggregate Function – Count

Lecture 58 Code: Aggregate Function – Count

Lecture 59 Video: Group by

Lecture 60 Code: Group by

Lecture 61 Video: Aggregate Functions – Sum, Min, Max, Avg

Lecture 62 Code: Aggregate Functions – Sum, Min, Max, Avg

Lecture 63 Video: Having

Lecture 64 Code: Having

Lecture 65 Video: Case Statements

Lecture 66 Code: Case Statements

Lecture 67 Article: SQL Order of Operations

Section 4: Day Four: Modifying Data

Lecture 68 Video: Day Four Introduction

Lecture 69 Code: Syntax used in Day Four

Lecture 70 Video: Updating Data

Lecture 71 Code: Updating Data

Lecture 72 Video: Truncating Data

Lecture 73 Code: Truncating Data

Lecture 74 Video: Deleting Data

Lecture 75 Code: Deleting Data

Lecture 76 Video: Alter Table

Lecture 77 Code: Alter Table

Lecture 78 Video: Select Into

Lecture 79 Code: Select Into

Lecture 80 Video: Inner Queries

Lecture 81 Code: Inner Queries

Lecture 82 Video: Temporary Tables

Lecture 83 Code: Temporary Tables

Lecture 84 Video: Common Table Expressions (CTEs)

Lecture 85 Code: Common Table Expressions (CTEs)

Lecture 86 Article: Inner Queries, Temp Tables, and CTEs

Section 5: Day Five: Building a Sample Database

Lecture 87 Video: Day Five Introduction

Lecture 88 Video: Introduction to Summit Database

Lecture 89 Video: Summit Sporting Goods Data Dictionary

Lecture 90 Video: Relational Databases

Lecture 91 Article: Understanding Relational Databases

Lecture 92 Code: *****Summit Sporting Goods Database*****

Lecture 93 Video: Creating Summit Database Dimension Tables

Lecture 94 Video: Creating Summit Database Fact Table

Lecture 95 Video: Foreign Keys

Lecture 96 Article: Primary & Foreign Keys

Lecture 97 Video: Creating Summit Database Relationships

Lecture 98 Troubleshooting: Loading Summit Database via Backup File

Lecture 99 Video: Joining Data Tables in SQL

Lecture 100 Article: Joining Data Tables in SQL

Lecture 101 Video: Inner Joins

Lecture 102 Code: Inner Joins

Lecture 103 Video: Left Joins

Lecture 104 Code: Left Joins

Lecture 105 Video: Right Joins

Lecture 106 Code: Right Joins

Lecture 107 Video: Full Outer Joins

Lecture 108 Code: Full Outer Joins

Section 6: Day Six: Other Functions

Lecture 109 Video: Day Six Introduction

Lecture 110 Video: Concatenation

Lecture 111 Code: Concatenation

Lecture 112 Video: Replace

Lecture 113 Code: Replace

Lecture 114 Video: IsNull

Lecture 115 Code: IsNull

Lecture 116 Video: Coalesce

Lecture 117 Code: Coalesce

Lecture 118 Video: NullIf

Lecture 119 Code: NullIf

Lecture 120 Video: Round

Lecture 121 Code: Round

Lecture 122 Video: Cast and Convert

Lecture 123 Code: Cast and Convert

Lecture 124 Video: Format

Lecture 125 Code: Format

Lecture 126 Video: Upper and Lower

Lecture 127 Code: Upper and Lower

Lecture 128 Video: Left and Right

Lecture 129 Code: Left and Right

Lecture 130 Video: Trim

Lecture 131 Code: Trim

Lecture 132 Video: Len

Lecture 133 Code: Len

Lecture 134 Video: DateAdd

Lecture 135 Code: DateAdd

Lecture 136 Video: DateDiff

Lecture 137 Code: DateDiff

Lecture 138 Video: Rollup

Lecture 139 Code: Rollup

Section 7: Practice and Beyond!

Lecture 140 Video: Day Seven Introduction - What's Next?

Lecture 141 Article: Questions 1 - 10 (without answers)

Lecture 142 Code: Question 1

Lecture 143 Video: Question 1 Explanation

Lecture 144 Code: Question 1 Answer

Lecture 145 Code: Question 2

Lecture 146 Video: Question 2 Explanation

Lecture 147 Code: Question 2 Answer

Lecture 148 Code: Question 3

Lecture 149 Video: Question 3 Explanation

Lecture 150 Code: Question 3 Answer

Lecture 151 Code: Question 4

Lecture 152 Video: Question 4 Explanation

Lecture 153 Code: Question 4 Answer

Lecture 154 Code: Question 5

Lecture 155 Video: Question 5 Explanation

Lecture 156 Code: Question 5 Answer

Lecture 157 Code: Question 6

Lecture 158 Video: Question 6 Explanation

Lecture 159 Code: Question 6 Answer

Lecture 160 Code: Question 7

Lecture 161 Video: Question 7 Explanation

Lecture 162 Code: Question 7 Answer

Lecture 163 Code: Question 8

Lecture 164 Video: Question 8 Explanation

Lecture 165 Code: Question 8 Answer

Lecture 166 Code: Question 9

Lecture 167 Video: Question 9 Explanation

Lecture 168 Code: Question 9 Answer

Lecture 169 Code: Question 10

Lecture 170 Video: Question 10 Explanation

Lecture 171 Code: Question 10 Answer

Lecture 172 Article: What's Next?

Beginners who have no prior experience with SQL or databases but want to learn.,Students and recent graduates seeking a foundational understanding of SQL to boost their career prospects.,Career switchers interested in exploring opportunities in data analytics, business intelligence, or database administration.,Anyone with a busy schedule who wants to learn SQL quickly and efficiently, with just one hour a day.