Master Microsoft SQL Server 2022

Files Included :

1 Create databases with SQL Server.mp4 (46.76 MB)
MP4
2 Prerequisites - What you should know.mp4 (14.87 MB)
MP4
1 Introduction to Functions.mp4 (14.19 MB)
MP4
10 Generate Series Function.mp4 (22.39 MB)
MP4
11 IIF Function.mp4 (19.29 MB)
MP4
12 Case Statements.mp4 (23.39 MB)
MP4
2 String Functions.mp4 (26.91 MB)
MP4
3 Text Concatenation.mp4 (44.6 MB)
MP4
4 Mathematical Function.mp4 (30.81 MB)
MP4
5 Greatest and Least Functions.mp4 (18.86 MB)
MP4
6 Date Functions.mp4 (49.75 MB)
MP4
7 Format Function.mp4 (21.18 MB)
MP4
8 Group Dates.mp4 (18.29 MB)
MP4
9 NEWID Function.mp4 (25.62 MB)
MP4
1 USE Keyword.mp4 (17.3 MB)
MP4
10 Creating Parameterized Stored Procedures.mp4 (67.36 MB)
MP4
11 Handling NULL Parameters in Stored Procedures.mp4 (26.52 MB)
MP4
12 Common Table Expressions.mp4 (22.85 MB)
MP4
13 Transactions in SQL Server.mp4 (24.45 MB)
MP4
14 Triggers.mp4 (38.45 MB)
MP4
2 Comments.mp4 (34.7 MB)
MP4
3 Using Rectangular Brackets.mp4 (24.21 MB)
MP4
4 Views.mp4 (49.98 MB)
MP4
5 Introduction to Indexes.mp4 (20.55 MB)
MP4
6 Creating Indexes using T-SQL.mp4 (23.41 MB)
MP4
7 Exploring Built-in Functions.mp4 (17.21 MB)
MP4
8 Exploring User Defined Functions.mp4 (30.98 MB)
MP4
9 Introduction to Stored Procedures.mp4 (32.34 MB)
MP4
1 Exploring SubQueries.mp4 (29.1 MB)
MP4
2 Correlated Subqueries.mp4 (35.72 MB)
MP4
3 PIVOT the result set.mp4 (28.01 MB)
MP4
1 Create and use variables in a Query.mp4 (32.6 MB)
MP4
2 Create a counter for a looping statement.mp4 (23.5 MB)
MP4
3 Cursors.mp4 (33.67 MB)
MP4
4 Break and Continue.mp4 (19.42 MB)
MP4
5 Try and Catch.mp4 (25.32 MB)
MP4
1 Combine results with Union.mp4 (18.53 MB)
MP4
2 Return Records with Except and Intersect.mp4 (13.98 MB)
MP4
1 Using CAST.mp4 (13.81 MB)
MP4
2 Using Convert.mp4 (21.99 MB)
MP4
1 Working With JSON Data.mp4 (99.58 MB)
MP4
1 Create Full Backup.mp4 (29.65 MB)
MP4
2 Create Differential Backup.mp4 (22.82 MB)
MP4
3 Restore Database using Backup.mp4 (18.8 MB)
MP4
1 Data Encryption.mp4 (53.96 MB)
MP4
2 Create New User Accounts.mp4 (17.5 MB)
MP4
3 Database Schema.mp4 (36.75 MB)
MP4
4 Dynamic Data Masking.mp4 (35.8 MB)
MP4
5 User Roles and Permissions.mp4 (19.54 MB)
MP4
1 Database Console Commands.mp4 (67.12 MB)
MP4
2 Dynamic Management Views.mp4 (47.79 MB)
MP4
3 Role of System Databases.mp4 (24.72 MB)
MP4
4 Preventing Excessive TempDB autogrowth.mp4 (21.55 MB)
MP4
5 Review the SQL Server error Log.mp4 (22 MB)
MP4
1 Core Concepts.mp4 (54.16 MB)
MP4
2 SQL Server Editions.mp4 (22.29 MB)
MP4
3 Install SQL Server and Management Studio.mp4 (35.6 MB)
MP4
4 Enable Feature with Configuration Manager.mp4 (24.07 MB)
MP4
1 Seek Vs Scan.mp4 (61.09 MB)
MP4
10 Parameter Sniffing.mp4 (48.63 MB)
MP4
11 Understanding Partionting.mp4 (100.27 MB)
MP4
12 Partition Elimination.mp4 (29.46 MB)
MP4
13 Do's and Don'ts.mp4 (13.77 MB)
MP4
2 Statistics Time and IO.mp4 (46.51 MB)
MP4
3 Spooling.mp4 (54.54 MB)
MP4
4 Hash Match.mp4 (43 MB)
MP4
5 Key Lookup or Bookmark Lookup.mp4 (31.53 MB)
MP4
6 Bad Views.mp4 (39.12 MB)
MP4
7 Sub Queries Minimization.mp4 (21.76 MB)
MP4
8 Non Sargability.mp4 (22.53 MB)
MP4
9 Implicit Conversion.mp4 (22.69 MB)
MP4
1 User Permissions and Authentication.mp4 (22.35 MB)
MP4
2 Login using Management Studio.mp4 (38.64 MB)
MP4
3 Enabling System Administrator Account.mp4 (22.46 MB)
MP4
1 Creating Database.mp4 (45.36 MB)
MP4
10 Install a sample Database.mp4 (34.34 MB)
MP4
2 Database Configuration Options.mp4 (42.56 MB)
MP4
3 Introduction to Tables.mp4 (31.02 MB)
MP4
4 Tables.mp4 (41.05 MB)
MP4
5 Alter or Edit Table.mp4 (23.76 MB)
MP4
6 Insert Data in a Table.mp4 (27.06 MB)
MP4
7 Importing Data.mp4 (44.18 MB)
MP4
8 Using SQL Bulk Copy.mp4 (41.2 MB)
MP4
9 Create Tables from Flat Files.mp4 (27.49 MB)
MP4
1 Data Types.mp4 (20.38 MB)
MP4
10 Create Relationship between Tables.mp4 (31.07 MB)
MP4
2 SQL Server Data Types.mp4 (44.75 MB)
MP4
3 Auto assign record identities.mp4 (37 MB)
MP4
4 Primary Key.mp4 (18.4 MB)
MP4
5 Setting a Default Value.mp4 (27.54 MB)
MP4
6 Check Constraints.mp4 (37.85 MB)
MP4
7 Unique Constraints.mp4 (32.12 MB)
MP4
8 Foreign Keys.mp4 (40.32 MB)
MP4
9 Create Foreign Keys.mp4 (26.93 MB)
MP4
1 What is SQL - Structured Query Language.mp4 (21.9 MB)
MP4
10 Delete Records Statement.mp4 (36.36 MB)
MP4
11 Update Records Statements.mp4 (33.01 MB)
MP4
12 Remove Table Records and Table.mp4 (50.47 MB)
MP4
2 Types of SQL Statements.mp4 (26.76 MB)
MP4
3 Introduction to Query Editor.mp4 (52.78 MB)
MP4
4 Create Table Statement.mp4 (54.68 MB)
MP4
5 Insert Data Statement.mp4 (30.84 MB)
MP4
6 Select Statement.mp4 (46.75 MB)
MP4
7 Filter Records using Where clause.mp4 (52.4 MB)
MP4
8 Order By Clause.mp4 (45.17 MB)
MP4
9 Column Aliases.mp4 (38.29 MB)
MP4
1 Limit Results with TOP.mp4 (45.12 MB)
MP4
2 Remove Duplicates with DISTINCT.mp4 (20.42 MB)
MP4
3 Comparison Operators.mp4 (34.58 MB)
MP4
4 Limit Result Set with OFFSET FETCH.mp4 (21.56 MB)
MP4
5 Understand NULL values.mp4 (39.07 MB)
MP4
6 Match Text with Like and Wildcards.mp4 (38.27 MB)
MP4
1 Table joins and relationships.mp4 (26.11 MB)
MP4
2 Inner Join.mp4 (24.18 MB)
MP4
3 Left, Right and Full outer join.mp4 (22.4 MB)
MP4
4 Cross joins.mp4 (25.35 MB)
MP4
5 Equi or Self Join.mp4 (37.38 MB)
MP4
1 Understand Record Grouping.mp4 (17.68 MB)
MP4
2 Use GROUP BY and COUNT.mp4 (36.42 MB)
MP4
3 Aggregate Functions.mp4 (36.2 MB)
MP4
4 Explore data with SUM.mp4 (41.05 MB)
MP4
5 Filter Groups with HAVING.mp4 (21.34 MB)
MP4