Microsoft SQL Server
Similar to other RDBMS software, SQL Server is built on top of SQL, a standard programming language for interacting with relational databases.
- Description
- Curriculum
- Reviews
SQL Server is a relational database management system, or RDBMS, developed and marketed by Microsoft. Similar to other RDBMS software, SQL Server is built on top of SQL, a standard programming language for interacting with relational databases. SQL Server is tied to Transact-SQL, or T-SQL, the Microsoft’s implementation of SQL that adds a set of proprietary programming constructs. SQL Server works exclusively on the Windows environment for more than 20 years. In 2016, Microsoft made it available on Linux. SQL Server 2017 became generally available in October 2016 that ran on both Windows and Linux.
01_Overview Of SQL Server & Installs
-
1
01_Overview Of SQL Server_Intro -
2
02_Agenda_Overview of SQL Server
-
3
03_What is SQL Server
-
4
04_Edition of SQL Server
-
5
05_Component That depend on Database Engine
-
6
06_SQL Server Security
-
7
07_Administrative Tools
-
8
08_Adiministrative Tools in Details
-
9
09_Administrative Tools Details-B
-
10
10_HA-DR
-
11
Test Your Knowledge
02_Configure VM For Labs
-
12
01_intro To Virtualization
-
13
02_Domain Controller
-
14
03_ServiceAccount
-
15
04_Hardware required for network
-
16
05_Preping your PC for VM
-
17
06_Configuring virtual Network
-
18
07_Creating VM for DC
-
19
08_Installing OS
-
20
09_configuring the VM
-
21
10_Configuring Network Switches and IP
-
22
11_Renaming DC-VM
-
23
12_Installing DNS Server and AD
-
24
13_Promoting as Domain Controller
-
25
14_Verifying the DC
-
26
15_Creating SQLTEST VM
-
27
16_Configuring OS on SQLTEST
-
28
17_Configuring SQLTEST
-
29
18_Verifying SQLTEST Configuration
-
30
19_Configuring SQLDEV
-
31
20_Partitioning SQLTEST Drives
-
32
21_Partitioning SQLDEV Drives
-
33
22_Creating Service Accounts
-
34
23_Granting Permission to a Service Account
-
35
VM Quiz
03_SQL Install and SSMS
04_Database Design
-
41
01_Understanding_SystemDatabases_Part1
-
42
02_SystemDatabases_Part2
-
43
03_SystemDatabases_Part3
-
44
04_System_Databases_Demo
-
45
05_DataFile_And_LogFile
-
46
06_Creating a Database_Demo
-
47
07_Files_And_FileGroups
-
48
08_Files_Filegroups_Demo
-
49
09_Attach_And_Detached
-
50
10_Detached_And_Attach_Demo
-
51
11_DatabaseRecoveryModel
-
52
12_DatabaseRecoveryModel_Demo
-
53
13_Restoring_Adventureworks
-
54
11_Database Snapshot Part 1
05_TableDesign
-
55
01_DesigningTablesPart1
-
56
02_KeyComponentofTables
-
57
03_ Understanding Data Types
-
58
04_ Numeric Data Types
-
59
05_ String Data Types
-
60
06_Data and Time Data Types
-
61
07_Other Data Types
-
62
08_Primary Key and Constraints
-
63
09_Creating Tables Demo
-
64
10_Databases Schema
-
65
11_Creating Schema Demo
-
66
12_Altering Tables Demo
-
67
13_Assignment Table Design
06_Views
07_Data Compression
-
74
01_Introduction to Compression
-
75
02_What you can compress
-
76
03_Types of Compression
-
77
04_Data types Affected by Compression
-
78
05_Page Compression Intro
-
79
06_Page Compression Illustration
-
80
07_Estimating Compression Savings
-
81
08_Row Compression Demo
-
82
09_Page Compression Demo
-
83
10_Benefits of Compression
-
84
11_Database Snapshot Part 1
-
85
Database Snapshot Part2
-
86
DATABASE SNAPSHOT
08_Table Partitioning
-
87
01_Table Partitioning Agenda
-
88
02_Intorduction to Table Partitioning
-
89
03_Types of Tartitioning
-
90
04_How Table Partitioning Works
-
91
05_use Cases for Table Partitioning
-
92
06_Implementing Table Partitioning
-
93
07_Best practices On Table partitioning
-
94
08_Setting up Table Partitioning Steps
-
95
09_Understanding Partition Scheme
-
96
10_Demo_Creating Filegroups for Partitioning
-
97
11_Demo_Creating Table Partitioning
-
98
12_Demo_ Partitioning an Index
-
99
13_Conclusion
09_Select Statement
-
100
01_Introduction to Select Statement
-
101
02_select Statement_Demo
-
102
03_Sorting Result of a query
-
103
04_Where Clause_ComparisonOperator
-
104
05_Using Between Operator
-
105
06_Using where clause with Multiple Conditions
-
106
07_searching for a List of values
-
107
08_Using Wildcard Search
-
108
09_Creating Aliases
-
109
10_Using Join Operator
-
110
11_JoinPart2
-
111
12_OUTER JOIN
-
112
13_Other types of join
-
113
14_Limiting Data returned
-
114
15_Using Distinct and NUll
-
115
16_Using Union Query
-
116
16_Using Union Query
10 _ DML Statement
-
117
01_ Introduction to DML
-
118
02_ Inserting Data Into Tables
-
119
03_Inserting Into Demo
-
120
04_ Inserting Data Into Identity
-
121
05_ Inserting Multiple rows Into Tables
-
122
06_ Inserting Data Using Select Statement
-
123
07_ Inserting Data using Select Method
-
124
08_ Limitations of Using Select Into Method
-
125
09_ Updating Statement
-
126
10_ Deleting From Tables
-
127
11_ Update Statement Demo
-
128
12_ Adding Additional Filters
-
129
13 _ Updating Rows
-
130
14_ Deleting Rows From Tables Demo
-
131
15_ Truncating Data in Tables
-
132
16_ Merging Data
-
133
17_ Merging Data Demo
-
134
18_ Returning Output Data
-
135
19_ Outputing the Result of an Update Statement Demo
-
136
20_Inserting Output Data into a Table
-
137
21_ Summary of DML
11_ Advanced SQL Programming
12 _ User Defined Function
-
149
01_Intro to User Defined Functions
-
150
02_ Understanding UDF
-
151
03 _ Benefit of UDF
-
152
04 _ Demo on Creating User Defined Function
-
153
05 _ Alter and Deleting Functions
-
154
06 _ Demo on Altering and Deleting Function
-
155
07 _ Demo Calling Functions
-
156
08_ Scalar Vs Table Valued Functions
-
157
09_ Limitations of Functions
-
158
10_ Demo Scar Function
-
159
11_ Table Valued Functions
-
160
12_ Summary
13 _ Stored Procedure
-
161
01_Stored Procedure
-
162
02_Introduction to Stored Procedures
-
163
03_Benefits of Stored Procedures
-
164
04_Types of Stored Procedures
-
165
05_Executing Stored Procedures
-
166
06_Demo creating Stored Procedure
-
167
07_Demo Creating Stored Procedures 2
-
168
08_Parameterizing Stored Procedures
-
169
09_Demo of Parameterizing of Stored Procedures
-
170
10_Altering Stored Procedures
-
171
11_Alter Stored Procedure to add Parameter
-
172
12_Best practices in Stored Procedures
14 _ Temporary Objects
-
173
01_Temporary Objects
-
174
02_Introduction to Temporary Objects
-
175
03_Types of Temporary Objects
-
176
04_Intro to Common Table Expressions
-
177
05_Benefits of CTEs
-
178
06_Recursive CTEs
-
179
07_Intro To Table Variables
-
180
08_Scope and Usage of Table Variables
-
181
09_Performance Considerations
-
182
10_Best Practices
-
183
11_Intro to Temporary Tables
-
184
12_Scope and Lifetime
-
185
13_Temporary Tables vs Table Variables
-
186
14_Best Practices for Temporary Objects
-
187
15_Common Table Expressions Demo
-
188
16_Table Variables Demo
-
189
17_Temporary Tables Demo
-
190
18_Conclusion
15_ DML Triggers
-
191
01_DML Triggers Agenda
-
192
02_ Introduction to DML Triggers
-
193
03_ Types of Triggers
-
194
04_ Creating After Triggers
-
195
05_ Creating Instead of Triggers
-
196
06_Use Cases for DML Triggers
-
197
07_Best Practices
-
198
08_Demo Creating DML Triggers
-
199
09_Demo Altering DML Triggers
-
200
10_Dropping Triggers
-
201
11_Enabling and Disabling Triggers
-
202
12_Conclusion
16_ DDL Triggers
-
203
01_DDL Triggers Agenda
-
204
02_Introduction to DDL Triggers
-
205
03_How DDL Triggers work
-
206
04_Types of DDL Triggers
-
207
05_Creating DDL Triggers
-
208
06_Use Cases for DDL Triggers
-
209
07_DDL Triggers Scope
-
210
08_Best Practices
-
211
09_Creating DDL Triggers (Demo 1)
-
212
10_Creating DDL Triggers (Demo 2)
-
213
11_Altering DDL Triggers (Demo)
-
214
12_Enabling and Disabling DDL Triggers (Demo)
-
215
13_Dropping Triggers (Demo)
-
216
14_Conclusion
17_ SQL Server Indexes
-
217
01_SQL Server Indexes
-
218
02_Introduction to Indexes
-
219
03_B Tree Index Structure
-
220
04_Clustered and Non Clustered Structures
-
221
05_Types of Index Clustered
-
222
06_Non Clustered Index
-
223
07_Unique Index
-
224
08_Filtered Index
-
225
09_Full Text Index
-
226
10_Column Store Index
-
227
11_Other types of Indexes
-
228
12_Best Practices in SQL Server Practices
-
229
13_Query Optimization with Indexes
-
230
14_Monitoring and Maintaining Indexes
-
231
15_Limitations and Common Mistakes With Indexes
-
232
16_Indexing Tools and resources
-
233
17_Demo Creating Clustered Index
-
234
18_Demo Creating a Non Clustered Index
-
235
19_Adding Index Options to Make a New Video
-
236
20_Demo Adding Index Options
-
237
21_Demo Adding Included Columns To An Index
-
238
22_Demo Adding Filters To an Index
-
239
23_Demo Placing Indexes
-
240
24_Demo Disabling And Dropping Indexes
18 _ Managing Indexes and Statistics
-
241
01_Managing Indexes and Statistics Intro
-
242
02_Importance of Indexes and Statistics
-
243
03_Understanding Fragmentation
-
244
04_Rebuilding and Re-organizing Indexes
-
245
05_Demo Checking Fragmentation
-
246
06_Demo Re-organizing Indexes
-
247
07_Demo Rebuilding Indexes
-
248
08_Demo Index Usage Statistics
-
249
09_Updating Statistics
-
250
10_Demo Updating Statistics
-
251
11_Automating Maintenance Task
-
252
12_Summary SQL Server Indexes
19 _ Backup in SQL Server
-
253
01_Introduction to Backup in SQL Server
-
254
02_Backup in SQL Server Explained
-
255
03_ Backup in SQL Server Explained 2
-
256
04_Types of Backup in SQL Server 1
-
257
05_Types of Backup in SQL Server 2
-
258
06_Types of Backup in SQL Server 3
-
259
07_Tyes of Backup in SQL Server 4
-
260
08 Database Recovery model in SQL Server
-
261
09_BackupDatabase in SQL Server 1
-
262
10_Backup database in SQL Server2
-
263
11_Backup a database3 in SQL Server
-
264
12_Backup a Database4using T-SQL in SQL Serve
-
265
13_Backup Diff & Trans Log using T-SQL in SQL Server
-
266
14_Stripped Backup in SQL Server
-
267
15_Introduction to Restoring a Database in SQL Server
-
268
16_Introduction to restoring Database in SQL Server 2
-
269
17_Database Restore in SQL Server 1
-
270
18_Database Restore in SQL Server 2
20_ Maintenance Plans
21 _ Ola Script Deployment
22 _ SQL Server Agent
23 _ Database Mail
24 _ Resource Governor
25 _SQL Profiler
-
293
01_SQL Profiler
-
294
02_Introduction to SQL Profiler
-
295
03_Key Features of Profiler
-
296
04_Profiler use Cases
-
297
04_Profiler use Cases
-
298
05_Profiler Workflow
-
299
06_Profiler Monitoring Modes
-
300
07_Profiler Event Categories
-
301
08_Profiler Filtering Options
-
302
09_Profiler Trace Analysis
-
303
10_Profiler Trace Playback
-
304
11_Profiler Performance Tuning
-
305
12_Profiler Best Practices
-
306
13_Profiler Integration
-
307
14_Demo Creating Profiler 1
-
308
15_Filtering Traces Demo
-
309
16_Capturing Unknown Events Demo
-
310
17_Creating Trace Template Demo
-
311
18_Server Slide Trace Demo
-
312
04_Query Store Configuration
-
313
06_Analyzing Query Performance
26 _ Extended Events
27_Query Store
-
317
01_Query Store
-
318
02_Introduction To Query Store
-
319
03_Query Store Functionality
-
320
04_Query Store Configuration
-
321
05_Capturing Query Execution Data
-
322
06_Analyzing Query Performance
-
323
07_Tuning Queries with Query Store
-
324
08_Query Store Reporting
-
325
09_Query Store Best Practices
-
326
10_Query Store Demo part1
-
327
11_Query Store Demo part2
28_ Login Series
29 _ Dynamic Data Masking
30 _ TDE Learning
31 _ Always Encrypted
32 _ Row Level Security
33 _ Replication
34 _ Log Shipping
35 _ Always On
-
353
01_Understanding Always on
-
354
02_Why High Availability is Important
-
355
03_Causes of Downtime and Data Loss
-
356
04_Disaster Discovery
-
357
05_Calculating Availability
-
358
06_Disaster Recovery Plan
-
359
07_Intro to Always On
-
360
08_SQL Server Always On Solution
-
361
09_Summary of Module
-
362
10_Implementing Failover Cluster
-
363
11_Importance of WSFC
-
364
12_Overview of Failover Cluster
-
365
13_Importance of Failover Cluster
-
366
14_ Failover Cluster Configuration
-
367
15_Benefits and Limitations of Failover Cluster
-
368
16_Creating WSFC
-
369
17_Cluster Name Object
-
370
18_Required Permissions for WSFC
-
371
19_Creating a Failover Cluster Demo 1
-
372
20_WSFC Demo 2
-
373
21_Demo 3
-
374
22_Cluster Verification Demo
-
375
23_Configuring Witness Quorom
-
376
24_Quorom Models
-
377
25_Node Majority
-
378
26_No Majority or No Disk
-
379
27_Azure Cloud Witness
-
380
28_Dynamic Witness
-
381
29_Fileshare Quorom Witness
-
382
30_Configuration of Quorom Witness
-
383
31_Module Summary
-
384
32_Developing Availability Groups
-
385
33_Availability Groups Concepts
-
386
34_Active Secondary Replicas
-
387
35_Active Secondary Replicas 2
-
388
36_Availability Modes
-
389
37_Types of Failover
-
390
38_Maximum Availability Replicas
-
391
39_Maximum Availability Replicas 2
-
392
40_Availability Group Listener
-
393
41_Readwrite Connection Redirection
-
394
42_Scaling availability Groups
-
395
43_Basic Availability Groups
-
396
44_Availability Groups Topology
-
397
45_Standalone to FCI Topology
-
398
46_FCI to FCI Topology
-
399
47_Hybrid IT Topology
-
400
48_Azure Topology
-
401
49_Linux Topology
-
402
50_Distributed Availability Groups part1
-
403
51_Distributed Availability Group part2
-
404
52_Availability Pre-requisites part1
-
405
53_Availability Pre-requisites part2
-
406
54_Availability Groups Setup
-
407
55_Listener Setup
-
408
56b_ Troubleshooting Availability Groups
-
409
57_Availability Group Issue Resolution
-
410
58_Removing DBs from AG, Removing Secondary Replica and Adding Back to AG
-
411
59_Adding DBs to Availability Groups
-
412
60_Failing Over
-
413
61_How to Modify Availability Groups
Please, login to leave a review
