English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 172 lectures (7h 39m) | 3.54 GB
A One Week Comprehensive Introduction to SQL and Microsoft SQL Server Management Studio!
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 values
- Analyze thousands of rows of data – real world data
- Prepare data for visualizations such as PowerBI, Tableau, etc.
- Design Entity Relationship Diagrams
- Aggregate, format, and modify data using SQL operators and functions
- Gain experience with Big Data and solving complex questions using data
- Learn SQL Joins – working with multiple tables and databases
- Practice, 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!
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!
Table of Contents
Day One Getting Started
1 Video Course Introduction
2 READ ME Welcome!
3 Video What is a Server
4 Article Cloud Based vs. On-Premises Servers
5 Video What is a Database
6 Article Database Management Systems
7 Video Introduction to SQL
8 Article Understanding SQL Command Categories
9 Link Downloading Microsoft SQL Server
10 Optional Article E.F. Codd – A Relational Model of Data for Large Shared Data
11 Video Downloading Microsoft SQL Server
12 Video Connecting to server in SSMS
13 Video SSMS Feature Demonstration
14 Video SQL Cheat Sheet
15 Article SQL Cheat Sheet
Day Two Databases & Tables
16 Video Day Two Introduction
17 Video Create Database
18 Code Create Database
19 Video Drop Database
20 Code Drop Database
21 Video Use Database
22 Code Use Database
23 Video Data Types
24 Article Data Types
25 Video Create Table
26 Code Create Table
27 Video Drop Table
28 Code Drop Table
29 Video Insert Data
30 Code Insert Data
31 Video Not NULL
32 Code Not NULL
33 Video Unique Values
34 Code Unique Values
35 Video Primary Keys
36 Code Primary Keys
37 Video Default Values
38 Code Default Values
Day Three Retrieving Data
39 Video Day Three Introduction
40 Code Syntax used in Day Three
41 Video Select & Top n
42 Code Select & Top n
43 Video Select Distinct
44 Code Select Distinct
45 Video Arithmetic Operators
46 Code Arithmetic Operators
47 Video Alias Names
48 Code Alias Names
49 Video Where Clause (=, , , =, =, )
50 Code Where Clause (=, , , =, =, )
51 Video Where Clause (And, Or, Not in, Between)
52 Code Where Clause (And, Or, Not in, Between)
53 Video Where Clause (Like, Null, Not Null)
54 Code Where Clause (Like, Null, Not Null)
55 Video Order by
56 Code Order by
57 Video Aggregate Function – Count
58 Code Aggregate Function – Count
59 Video Group by
60 Code Group by
61 Video Aggregate Functions – Sum, Min, Max, Avg
62 Code Aggregate Functions – Sum, Min, Max, Avg
63 Video Having
64 Code Having
65 Video Case Statements
66 Article SQL Order of Operations
67 Code Case Statements
Day Four Modifying Data
68 Video Day Four Introduction
69 Code Syntax used in Day Four
70 Video Updating Data
71 Code Updating Data
72 Video Truncating Data
73 Code Truncating Data
74 Video Deleting Data
75 Code Deleting Data
76 Video Alter Table
77 Code Alter Table
78 Video Select Into
79 Code Select Into
80 Video Inner Queries
81 Code Inner Queries
82 Video Temporary Tables
83 Code Temporary Tables
84 Video Common Table Expressions (CTEs)
85 Article Inner Queries, Temp Tables, and CTEs
86 Code Common Table Expressions (CTEs)
Day Five Building a Sample Database
87 Video Day Five Introduction
88 Video Introduction to Summit Database
89 Video Summit Sporting Goods Data Dictionary
90 Video Relational Databases
91 Article Understanding Relational Databases
92 Code Summit Sporting Goods Database
93 Video Creating Summit Database Dimension Tables
94 Video Creating Summit Database Fact Table
95 Video Foreign Keys
96 Article Primary & Foreign Keys
97 Video Creating Summit Database Relationships
98 Troubleshooting Loading Summit Database via Backup File
99 Video Joining Data Tables in SQL
100 Article Joining Data Tables in SQL
101 Video Inner Joins
102 Code Inner Joins
103 Video Left Joins
104 Code Left Joins
105 Video Right Joins
106 Code Right Joins
107 Video Full Outer Joins
108 Code Full Outer Joins
Day Six Other Functions
109 Video Day Six Introduction
110 Video Concatenation
111 Code Concatenation
112 Video Replace
113 Code Replace
114 Video IsNull
115 Code IsNull
116 Video Coalesce
117 Code Coalesce
118 Video NullIf
119 Code NullIf
120 Video Round
121 Code Round
122 Video Cast and Convert
123 Code Cast and Convert
124 Video Format
125 Code Format
126 Video Upper and Lower
127 Code Upper and Lower
128 Video Left and Right
129 Code Left and Right
130 Video Trim
131 Code Trim
132 Video Len
133 Code Len
134 Video DateAdd
135 Code DateAdd
136 Video DateDiff
137 Code DateDiff
138 Video Rollup
139 Code Rollup
Practice and Beyond!
140 Video Day Seven Introduction – What’s Next
141 Article Questions 1 – 10 (without answers)
142 Code Question 1
143 Video Question 1 Explanation
144 Code Question 1 Answer
145 Code Question 2
146 Video Question 2 Explanation
147 Code Question 2 Answer
148 Code Question 3
149 Video Question 3 Explanation
150 Code Question 3 Answer
151 Code Question 4
152 Video Question 4 Explanation
153 Code Question 4 Answer
154 Code Question 5
155 Video Question 5 Explanation
156 Code Question 5 Answer
157 Code Question 6
158 Video Question 6 Explanation
159 Code Question 6 Answer
160 Code Question 7
161 Video Question 7 Explanation
162 Code Question 7 Answer
163 Code Question 8
164 Video Question 8 Explanation
165 Code Question 8 Answer
166 Code Question 9
167 Video Question 9 Explanation
168 Code Question 9 Answer
169 Code Question 10
170 Video Question 10 Explanation
171 Article What’s Next
172 Code Question 10 Answer
Resolve the captcha to access the links!