Home
Videos uploaded by user “Database by Doug”
SQL Server Management Studio Intro
 
07:46
A brief introduction to SQL Server Management Studio, for beginners. Covers the main user interface windows, and some basic tasks.
Views: 80807 Database by Doug
SQL Server Caching
 
06:21
Indexing on Index Cards This is part 1 of a series to help people better understand storage, caching, and ultimately indexing in SQL Server. The concepts are applicable to any modern relational database, and most non-relational databases. This video covers caching, logical and physical IO, dirty pages, and checkpointing.
Views: 3612 Database by Doug
The SQL EXISTS clause
 
08:52
How to use the EXISTS clause in SQL. For beginners.
Views: 23229 Database by Doug
Clustered Indexes and DB Caching
 
09:23
Second in the series of "Indexes on Index Cards", this video covers clustered index read operations and how the cache works on these operations in a relational database. Various queries and cache situations are covered, pointing out the logical and physical for each query and situation.
Views: 1576 Database by Doug
Simple Recursion in SQL
 
15:15
A simple example of recursion using SQL Server and Common Table Expressions (CTEs). Thanks to +Nikola Gujanicic for the request.
Views: 22754 Database by Doug
Whats slow on my database server?
 
10:07
Investigation of the relative speed of network, disk IO, and CPU on SQL Server. See the code on the blog post here: http://douglaskline.blogspot.com/2015/10/whats-slow-on-my-database-server.html
Views: 8434 Database by Doug
The LIKE operator in SQL
 
09:31
An introduction to using LIKE in the WHERE clause of your SQL SELECT statements. For beginners.
Views: 2693 Database by Doug
Simple Scalar Subquery
 
06:50
Demonstrating simple scalar subqueries in structured query language (SQL).
Views: 1486 Database by Doug
SQL Server Diagramming Intro
 
07:26
Brief introduction to using diagrams in SQL Server Management Studio.
Views: 852 Database by Doug
Quick! What's the difference between RANK, DENSE_RANK, and ROW_NUMBER?
 
01:47
Short videos showing the difference in the RANK(), DENSE_RANK(), and ROW_NUMBER() ranking functions.
Views: 295 Database by Doug
Can I use NULL with the IN operator in SQL?
 
04:22
In SQL, can you use NULL in the list of items for an IN operator? The short answer is no, but why? I demonstrate that it doesn't work, then dig deeper into the query plans and talk about the IS comparison operator.
Views: 160 Database by Doug
Group By Part 2: Null Handling and Count
 
06:22
Aggregation in SQL, how NULLs are handled, and the COUNT function
Views: 782 Database by Doug
Using the IN Operator in SQL
 
08:25
Demos of using IN in the WHERE clause using SQL Server. For beginners.
Views: 1133 Database by Doug
Simple SQL WHERE clause
 
10:44
How to use simple WHERE clause in a SELECT statement.
Views: 935 Database by Doug
The SQL ORDER BY clause
 
09:35
For beginners. How to use the ORDER BY clause in the SELECT statement. Covers multiple sort keys, ascending, descending, how NULLs are handled, and best practice.
Views: 1042 Database by Doug
The SQL INSERT statement
 
11:58
An introduction to the INSERT statement.
Views: 329 Database by Doug
Dates and Times in SQL
 
08:35
An introduction to working with dates and times in SQL Server.
Views: 531 Database by Doug
Group By Part1: Introduction
 
09:57
An introduction to aggregation and using Group By in SQL.
Views: 574 Database by Doug
Time Zones and the DATETIMEOFFSET data type in SQL
 
09:24
Get the code here: https://douglaskline.blogspot.com/2018/10/time-zones-and-datetimeoffset-data-type.html
Views: 189 Database by Doug
String Expressions in SQL
 
09:34
Beginner video on String Expressions in Structured Query Language (SQL). See full code here: http://douglaskline.blogspot.com/2018/10/string-expressions-in-sql.html
Views: 256 Database by Doug
Group By Part 3: uniquess and multi-column grouping
 
08:55
Making sure that group by specifies a unique grouping, and how to specify multi-column groups.
Views: 636 Database by Doug
The HAVING clause in SQL
 
10:56
How to use the HAVING clause in SQL.
Views: 512 Database by Doug
Finding UnMatched Records in SQL
 
05:21
Short video for finding unmatched records using the LEFT JOIN ... WHERE IS NULL pattern. Get the code here: https://douglaskline.blogspot.com/2018/10/finding-unmatched-records-in-sql.html
Views: 165 Database by Doug
ANY and ALL in SQL Server
 
09:41
Basic use of the ANY and ALL comparison modifiers in Structured Query Language. Comparison operators (equals, less than, etc.) which compare one single value with another single value can be modified with ANY or ALL to compare one single value with all the values in a single-column table. Get the code here: https://douglaskline.blogspot.com/2018/10/using-any-and-all-in-sql.html
Views: 175 Database by Doug
SQL Ranking Functions: Part 1 The Over Clause
 
08:51
Overview of the SQL Ranking functions, focusing on the OVER clause, which must have an ORDER BY part, and might also have a PARTITION BY part.
Views: 455 Database by Doug
The UPDATE statement in SQL
 
10:17
Brief introduction to UPDATE statement in SQL.
Views: 363 Database by Doug
The bit data type in SQL Server
 
07:32
Does bit act like an exact numeric or like a boolean. Well, neither.
Views: 3126 Database by Doug
Understanding Relational Division in SQL
 
14:13
Intermediate level SQL on Relational Division using GROUP BY, COUNT, HAVING, and a correlated subquery or common table expression (CTE). A simple example, stripped-down example of Job Applicants with certain Skills, and Jobs that require certain skills is provided to teach the concept of relational division. Here is the script to create the example JobSkills database, with data. https://douglaskline.blogspot.com/2018/11/jobskills-database-schema-and-data-for.html Here is the code used in the example. https://douglaskline.blogspot.com/2018/11/understanding-relational-division-in-sql.html
Views: 289 Database by Doug
Big Data: How to make your results grid bigger in SQL Mgmt Studio
 
02:02
The default results grid font in SSMS is 8 point, which makes it hard to read for demonstrations on a projector (and for youtube videos). Here's how to make it bigger.
Views: 269 Database by Doug
The SQL FROM Clause
 
11:06
Beginner Structured Query Language (SQL). Get the code here: http://douglaskline.blogspot.com/2018/08/the-from-clause-in-sql.html
Views: 224 Database by Doug
Simple Indexing Intro
 
13:24
Very simple indexing demonstration. Looking at the IO statistics, and discussing what to focus on when looking at database performance.
Views: 211 Database by Doug
The DELETE statement in SQL
 
09:32
Introduction to using the DELETE statement in structured query language using MS SQL Server.
Views: 197 Database by Doug
SQL Ranking Functions: Part 2 Rank, Row_Number, and Dense_Rank
 
08:07
How to use the ranking functions ROW_NUMBER(), RANK(), and DENSE_RANK().
Views: 317 Database by Doug
Foreign Keys in Relational Databases
 
12:41
Beginner video on Foreign Keys in relational databases. Foreign keys allow for "lookups" between two tables. To ensure that these "lookups" are valid, we can enforce referential integrity, which makes sure that all foreign key values actually exist in the primary key table. Although referential integrity is specified as a constraint on the foreign key table, both tables involved check data changing operations to ensure all foreign key values are always valid. Primary Keys are always UNIQUE and NOT NULL, but Foreign Keys are generally not UNIQUE, and can be NULL. See the full code here: http://douglaskline.blogspot.com/2018/10/foreign-keys-in-relational-databases.html
Views: 135 Database by Doug
Primary Keys in Relational Databases
 
16:15
Beginner video - an introduction to primary keys in relational databases. Primary Keys need to be UNIQUE and NOT NULL, but not really anything else. This makes sure that all records are accessible by at least one field (the primary key). See the code here: http://douglaskline.blogspot.com/2018/10/primary-keys-in-relational-databases.html
Views: 139 Database by Doug
Using the CAST function in SQL
 
09:30
Using CAST() to convert from one data type to another in SQL. See the code here: https://douglaskline.blogspot.com/2018/10/using-cast-function-in-sql.html
Views: 184 Database by Doug
NoTableSELECT
 
08:08
Very simple SQL SELECT statements without a table. No FROM clause! For beginners. Covers renaming a column, selecting number and string literals, simple math expressions, string concatenation, and column ordering.
Views: 1387 Database by Doug
Structuring Data
 
12:15
Beginner level. Basic rules for structuring your data and making it easy to work with. See the code on my blog here: http://douglaskline.blogspot.com/2018/07/structuring-data-in-tables.html
Views: 161 Database by Doug
Using DISTINCT in SQL
 
08:53
A brief beginner's introduction to the DISTINCT operator in SQL. DISTINCT creates a set of unique records, based on field values. In other words, duplicates records, based on field values, are removed. DISTINCT is often used with COUNT, to achieve a count of distinct values. Be aware that NULL is treated as a distinct value in terms of records, but COUNT ignores NULLs. See the full code here: https://douglaskline.blogspot.com/2018/10/using-distinct-in-sql.html
Views: 90 Database by Doug
Numeric Expressions in SQL
 
11:15
A beginner video on numeric expressions in Structured Query Language. See full code here: http://douglaskline.blogspot.com/2018/10/numeric-expressions-in-sql.html
Views: 174 Database by Doug
Introduction to Outer Joins
 
10:17
An introduction to outer joins in SQL.
Views: 403 Database by Doug
LIKE, advanced
 
11:00
Advanced things to do with the LIKE operator in SQL.
Views: 654 Database by Doug
Tables and their parts
 
06:03
Beginner level terminology for tables in relational databases. See the code on my blog here: http://douglaskline.blogspot.com/2018/07/tables-and-their-parts.html
Views: 160 Database by Doug
Introduction to JOINs
 
11:45
An introduction to using SELECT to display columns from multiple tables using JOINs.
Views: 757 Database by Doug
Model Building: The Big Picture
 
10:16
A big picture look at the model building process for data analytics, statistics, data science, etc. In honor of a great professor I had in PhD school! Table of Contents: 00:00 - Introduction 00:00 - Marker 1 00:10 - Slide 2 00:28 - Slide 3 00:57 - Slide 4 01:17 - Slide 5 01:41 - Slide 6 02:03 - Slide 7 02:28 - Slide 8 02:58 - Slide 9 03:21 - Slide 8 03:27 - Slide 9 03:29 - Slide 10 03:44 - Slide 11 03:46 - Slide 12 03:55 - Slide 13 04:27 - Slide 14 05:54 - Slide 15 06:16 - Slide 16 06:41 - Slide 17 07:04 - Slide 18 08:13 - Slide 19 08:34 - Slide 20 09:26 - Slide 21
Views: 27 Database by Doug
IN versus EXISTS - are they the same?
 
08:25
Intermediate level video on Structured Query Language. The IN and EXISTS operators are sometimes viewed as "equivalent". They serve a similar purpose and are sometimes used to produce the same records. However, their underlying mechanisms are quite different. This example using the Northwind database demonstrates how NULLs are treated differently when using NOT IN versus NOT NULL.
Views: 76 Database by Doug
Using the SwitchOffset function for Time Zones
 
09:31
SwitchOffset is a function that will shift a time in one time zone to the correct time in another time zone. It takes a DATETIMEOFFSET data type, and produces a DATETIMEOFFSET data type. Get the code here: https://douglaskline.blogspot.com/2019/01/the-switchoffset-function.html
Views: 15 Database by Doug