07:20

How can I learn how to use SQL on the Internet (Azure SQL Database, Managed Instance, SQL Server VM)

13:20

STRING_SPLIT: Splitting strings into multiple rows using SQL Server using a delimiter or separator

12:22

Install Visual Studio 2022 and the SQL Server Analysis Services (SSAS) extension (front-end)

12:28

Practice Activity: What rows in an SQL Server table are not included in a second table?

08:49

Can I do a certification in SQL Server?

07:50

Combine Date and Time fields in SQL Server into one column?

09:35

FREE SQL Server Express or SQL Server Developer - which edition should you install?

06:45

Practice Activity - remove duplicate rows in SQL Server (three different ways)

10:57

Practice Activity: How to put "Odd" and "Even" on alternate rows in SQL Server - ROW_NUMBER and %

11:37

How to install for FREE Visual Studio 2022 and the SQL Server SSRS extension (front-end)

10:15

How to spread durations (in days) across years using PIVOT in SQL Server (Gantt chart)

12:25

Practice Activity - How to calculate the number of days per year for durations in SQL Server

14:32

Practice Activity - Creating a rolling total over the last 3 months in SQL Server

08:05

Calculating the first day of the week in SQL Server

13:01

SQL Server Practice Activity - Which orders have got both hot and cold items? Pivot and Subqueries

14:52

Practice Activity - Retrieving the last row for each group in a table in SQL Server

10:04

When to use a CROSS JOIN, and grouping rows of text together using the STRING_AGG function.

08:37

JOINing two datasets together, and merging columns together to get rid of nulls.

08:51

CROSS APPLY vs CROSS JOIN - when should I use JOINs, and when should I use APPLY?

08:20

My video course sale is now on!

15:25

How to install Oracle Database 21c Express Edition and SQL Developer on your computer - for FREE.

09:30

Different types of JOINs in SQL Server - INNER, LEFT, RIGHT, CROSS and FULL JOINs.

08:53

YouTubeSQL211209

09:26

Listing indexes using sys.indexes and index_columns, and using a derived query in the FROM clause

09:24

Listing columns using sys.columns, and creating a SELECT statement JOINing three tables

05:49

Retrieving a list of SQL Server objects (constraints, tables, views, functions) using sys.objects

09:16

Install SQL Server 2014 Express (for 32-bit Windows), which includes SSMS

09:06

A brief overview of T-SQL (Microsoft's SQL Server dialect)

09:19

Convert strings into numbers and dates in SQL Server using the PARSE and TRY_PARSE functions

09:30

Convert numbers and dates into strings in SQL Server using the CONVERT and TRY_CONVERT functions

07:14

Convert numbers and dates into strings in SQL Server using the CAST and TRY_CAST functions

03:02

Microsoft SQL Server, Error: 18456 (connecting to Azure)

06:56

Adding leading characters in SQL Server: REPLICATE, SPACE and REVERSE

08:35

Replacing text in SQL Server: REPLACE, STUFF and TRANSLATE

07:07

3 Changing case and trimming spaces in SQL Server: LOWER, UPPER, LTRIM, RTRIM and TRIM functions

08:23

Extracting parts of strings: LEFT, RIGHT, SUBSTRING, LEN and DATALENGTH

10:55

Converting numbers to strings in SQL Server: STR and FORMAT functions

11:50

Joining strings in SQL Server: +, CONCAT, CONCAT_WS and STRING_AGG

11:01

Searching for text in SQL Server: CHARINDEX and PATINDEX

06:23

SQL Server ASCII and CHAR functions, including tabs and carriage returns

12:45

Creating a running total in SQL Server, but restart it part way through the table.

08:26

Getting the current date and time in SQL Server, and using timezones with DateTimeOffset

04:57

Getting the First day and last day of a month in SQL Server

06:05

The FORMAT function in SQL Server - extracting single or multiple parts of a datetime

07:12

Extract parts of dates - using DATENAME, DATEPART, DAY, MONTH and YEAR functions in SQL Server

06:45

Convert numbers year, month and days and more to dates in SQL Server - with ...FROMPARTS functions

11:17

What is the difference between two dates using the DATEDIFF function

11:08

The different types of JOINs in Microsoft SQL Server - INNER, LEFT, RIGHT, FULL and CROSS

08:51

Creating tables and adding data in Microsoft SQL Server - using GUI and T-SQL code

07:25

How to add or subtract days or time in SQL Server using the DATEADD Function

09:28

How to import data from Microsoft Excel into Microsoft SQL Server

10:17

What is the difference between "standard" SQL and Microsoft's T-SQL query language?

12:06

What is the difference between Microsoft SQL Server and Microsoft Excel?

14:51

How to import data from Microsoft SQL Server into Microsoft Excel

08:38

How to best learn SQL Server

21:14

How to install SQL Server 2019 Developer and SQL Server Management Studio (SSMS) - for FREE

03:41

Installing SQL Server Data Tools (SSDT for SSAS, SSIS or SSRS) on Visual Studio 2017 or earlier

06:14

SQL Server certifications - February 2021 update

17:35

Creating a Microsoft Azure SQL Database (SQL Server in the Cloud)

05:12

How to install sample data (from AdventureWorks) on your SQL Server