Microsoft SQL Server
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.
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
02_Configure VM For Labs
-
11
01_intro To Virtualization
-
12
05_Hardware required for network
-
13
6_AD_Domain Controller
-
14
07-ServiceAccount
-
15
08_Preping your PC for VM
-
16
09_Configuring virtual Network
-
17
10_Creating VM for DC
-
18
11_Installing OS
-
19
12_configuring the VM
-
20
13_configuring Network Switches and IP
-
21
14_Renaming DC-VM
-
22
15_Installing DNS Server and AD
-
23
16_Promoting as Domain Controller
-
24
17_Verifying the DC
-
25
18_Creating SQLTEST VM
-
26
19_Configuring OS on SQLTEST
-
27
20_Configuring SQLTEST
-
28
21_Verifying SQLTEST Configuration
-
29
22_Configuring SQLDEV
-
30
23_Partitioning SQLTEST Drives
-
31
24_Partitioning SQLDEV Drives
-
32
25_Creating Service Accounts
-
33
26_Granting Permission to a Service Account
03_SQL Install and SSMS
04_Database Design
-
39
01_Understanding_SystemDatabases_Part1
-
40
02_SystemDatabases_Part2
-
41
03_SystemDatabases_Part3
-
42
04_System_Databases_Demo
-
43
05_DataFile_And_LogFile
-
44
06_Creating a Database_Demo
-
45
07_Files_And_FileGroups
-
46
08_Files_Filegroups_Demo
-
47
09_Attach_And_Detached
-
48
10_Detached_And_Attach_Demo
-
49
11_DatabaseRecoveryModel
-
50
12_DatabaseRecoveryModel_Demo
-
51
13_Restoring_Adventureworks
05_TableDesign
06_Views
07_Data Compression
-
66
01_Introduction to Compression
-
67
02_What you can compress
-
68
03_Types of Compression
-
69
04_Data types Affected by Compression
-
70
05_Page Compression Intro
-
71
06_Page Compression Illustration
-
72
07_Estimating Compression Savings
-
73
08_Row Compression Demo
-
74
09_Page Compression Demo
-
75
10_Benefits of Compression
08_Table Partitioning
-
76
01_Table Partitioning Agenda
-
77
02_Intorduction to Table Partitioning
-
78
03_Types of Tartitioning
-
79
04_How Table Partitioning Works
-
80
05_use Cases for Table Partitioning
-
81
06_Implementing Table Partitioning
-
82
07_Best practices On Table partitioning
-
83
08_Setting up Table Partitioning Steps
-
84
09_Understanding Partition Scheme
-
85
10_Demo_Creating Filegroups for Partitioning
-
86
11_Demo_Creating Table Partitioning
-
87
12_Demo_ Partitioning an Index
-
88
13_Conclusion
09_Select Statement
-
89
01_Introduction to Select Statement
-
90
02_select Statement_Demo
-
91
03_Sorting Result of a query
-
92
04_Where Clause_ComparisonOperator
-
93
05_Using Between Operator
-
94
06_Using where clause with Multiple Conditions
-
95
07_searching for a List of values
-
96
08_Using Wildcard Search
-
97
09_Creating Aliases
-
98
10_Using Join Operator
-
99
11_JoinPart2
-
100
12_OUTER JOIN
-
101
13_Other types of join
-
102
14_Limiting Data returned
-
103
15_Using Distinct and NUll
-
104
16_Using Union Query
-
105
16_Using Union Query
Be the first to add a review.
Please, login to leave a review
Bulk Purchase Available For Groups & Enterprises
Microsoft SQL Server