23:51

All about IDENTITY property in SQL Server (Deep Dive)

43:08

Deep dive: Using JSON with SQL Server

03:59

Read JSON data from a table and parse it to rows and columns

11:25

Store JSON data in SQL Table using IsJSON() CHECK constraint

10:36

Parse JSON string with nested elements in SQL Server

09:02

Import JSON string to SQL tabular row-column format

10:18

Convert rows from a SQL Query or Table to JSON format

11:20

Download SQL Server 2019 for free (with SSMS)

09:40

Connect SQL Server on Linux Azure VM from SSMS

13:46

Install SQL Server on Linux Azure VM

10:14

Create a Ubuntu Linux VM on Microsoft Azure

15:22

Download and Install SQL Server 2017 and SSMS

04:54

Import multiple Record sets from an Excel sheet to SQL Server

02:25

Import data from Excel to SQL Server table

05:38

Export a Table or Query results from SQL Server to Excel

05:35

Move master database to another drive in SQL Server

05:08

Move tempdb to another drive in SQL Server

06:36

Move user Database (.mdf and .ldf files) to another drive in SQL Server (DBA stuff)

10:21

Detach and Attach a Database in SQL Server

05:38

Run SQL Query with Date Range filter in Excel

05:16

Call Stored Procedure with multiple parameters from Excel

03:26

Create Parametrized SQL Reports in Excel

04:00

Create Pivot Table report in Excel by connecting SQL Server

03:22

Call Stored Procedure from Excel and show results

07:01

Connect SQL Server from Excel and retrieve data

04:13

Download & Install SQL Server Management Studio (SSMS) 2016

06:15

Install SQL Server 2016 RTM

01:53

Polybase - Install JRE 7 Update while installing SQL Server 2016/2017

07:55

CHOOSE() and IIF() functions in SQL Server 2012

09:13

FORMAT() function in SQL Server 2012

10:30

CONCAT() function in SQL Server 2012

10:17

HAVING clause and difference with GROUP BY & WHERE clause in SQL statement

25:01

GROUP BY with Aggregate functions in SQL statement

12:54

SQL Server 2016 new feature - IF EXISTS with ALTER TABLE and DROP stmts

06:10

new STRING_SPLIT() function in SQL Server 2016

15:55

WHERE clause in SQL Server (DML, Filter table rows)

14:01

SELECT statement in SQL Server (DML, DQL, Query table data)

09:35

DDL, DML, DCL & TCL statements in SQL (Database basics)

10:00

Candidate, Primary, Alternate, Super and Composite key types in DBMS (SQL)

09:51

Table Variables in SQL Server (Pound Tables)

08:42

Temporary Tables in SQL Server (Hash Tables)

16:55

NOT NULL, DEFAULT, CHECK Constraints in SQL Server (Domain Integrity in DBMS)

07:15

Backup and Restore Database in SQL Server

15:12

Foreign Key (FK) Constraint in SQL Server (Referential Integrity in DBMS)

07:29

Install SQL Server 2014 Analysis Service Tabular Model (SSAS - ROLAP)

06:50

Install SQL Server Reporting Service (SSRS 2014)

05:00

Install SQL Server Analysis Services (SSAS, MOLAP 2014)

06:50

Install SQL Server Integration Service (SSIS 2014)

08:51

Install SQL Server Named Instance

12:14

Unique Key (UK) Constraint in SQL Server

18:04

Primary Key (PK) Constraint in SQL Server (Entity Integrity in DBMS)

10:37

Computed Columns (Persisted and Non Persisted) in SQL Server

05:14

Integrity Constraints (Key, Referential, Domain) in SQL Server Database & DBMS

10:14

IDENTITY property (Part 3/3) More about IDENTITY in SQL Server

05:43

IDENTITY property (Part 2/3) Check and ReSeed IDENTITY value in SQL Server

10:33

IDENTITY property (Part 1/3) of a Column in SQL Server

06:46

Alter or Change DataType of a Column in SQL Server

18:40

Data Types in SQL Server

15:17

Add or Remove/Drop Columns in a Table in SQL Server

17:53

Create Table in SQL Server