filmov
tv
SQL Tutorial - Creating a sample of data
Показать описание
Another video brought to you by BeardedDev, bringing you tutorials on Business Intelligence, SQL Programming and Data Analysis.
In this video I talk about how to create a sample set of data to work in Microsoft SQL Server. Creating a sample set of data can be extremely beneficial for development or testing, there is no need to wait minutes or hours for queries to run.
The techniques explored in this SQL Server Tutorial are:
Or for a full tutorial on CTEs check out this playlist:
SELECT * INTO
SQL Queries in the video:
WITH Number
AS
(
SELECT
CustomerId
, NTILE(1000) OVER(ORDER BY CustomerId) AS N
FROM dbo.Customers
)
,
TopCustomer
AS
(
SELECT
MAX(CustomerId) AS CustId
FROM Number
GROUP BY N
)
SELECT
C2.*
INTO dbo.CustomersSample
FROM TopCustomer AS C1
INNER JOIN dbo.Customers AS C2
ON C1.CustId = C2.CustomerId
SELECT * FROM dbo.CustomersSample
Please feel free to post comments.
In this video I talk about how to create a sample set of data to work in Microsoft SQL Server. Creating a sample set of data can be extremely beneficial for development or testing, there is no need to wait minutes or hours for queries to run.
The techniques explored in this SQL Server Tutorial are:
Or for a full tutorial on CTEs check out this playlist:
SELECT * INTO
SQL Queries in the video:
WITH Number
AS
(
SELECT
CustomerId
, NTILE(1000) OVER(ORDER BY CustomerId) AS N
FROM dbo.Customers
)
,
TopCustomer
AS
(
SELECT
MAX(CustomerId) AS CustId
FROM Number
GROUP BY N
)
SELECT
C2.*
INTO dbo.CustomersSample
FROM TopCustomer AS C1
INNER JOIN dbo.Customers AS C2
ON C1.CustId = C2.CustomerId
SELECT * FROM dbo.CustomersSample
Please feel free to post comments.
0:07:00
Learn How to Create a Database | First Steps in SQL Tutorial
0:44:57
SQL Tutorial for Beginners
0:17:40
Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3
0:06:45
SQL Tutorial for Beginners 2: Creating Your First Table
0:24:25
you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)
0:07:40
SQL Tutorial for Beginners 1: Installing PostgreSQL and Creating Your First Database
4:20:39
SQL Tutorial - Full Database Course for Beginners
3:10:19
SQL Course for Beginners [Full Course]
0:01:59
How to create data entry Form using SQL server Database with #csharp C# #shorts
0:15:36
SQL Create Table and Insert Data - A Complete Tutorial
0:09:37
SQL Basics Tutorial For Beginners | Installing SQL Server Management Studio and Create Tables | 1/4
0:02:48
How to Create a Table | SQL Tutorial for Beginners | 2021
0:00:13
How to create Database in SQL #sql #code #coding #how_to #tutorial #database
0:00:33
5 Best SQL Websites to Practice n Learn Interview Questions for FREE
0:15:58
SQL Database Design Tutorial for Beginners | Data Analyst Portfolio Project (1/3)
0:01:55
How to Create a Database | SQL Tutorial for Beginners | 2021
0:04:08
SQL indexing best practices | How to make your database FASTER!
0:07:48
SQL Tutorial - 9: Create Table Statement
0:00:11
Fastest Way To Learn SQL
2:45:17
SQL Querying for Beginners Tutorial
0:17:17
MySQL - The Basics // Learn SQL in 23 Easy Steps
0:16:54
Learn Basic SQL in 15 Minutes (PART 2/3) | Creating Tables | SQL Tutorial | Business Intelligence
0:00:18
create table as select in MySQL database #shorts #mysql #database
0:06:03
SQL Tutorial - Creating a managed database
Комментарии