π Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?video=aqVb9N9ocmE
π Master SQL Fundamentals: https://databasestar.mykajabi.com/sql-simplified/?video=aqVb9N9ocmE
If you need to generate a lot of random data in SQL, don't use a spreadsheet. You can use SQL directly.
In this video, you'll learn:
- several methods to generate a random set of rows
- how to do it in Oracle, SQL Server, MySQL, and PostgreSQL
- how each method performs at different volumes of data, all the way up to generating 10 million rows.
β± TIMESTAMPS:
00:00 - Oracle
08:56 - SQL Server
14:46 - MySQL
19:18 - PostgreSQL
π VIDEO LINKS:
SQL scripts for this video: https://github.com/bbrumm/databasestar/tree/main/videos/187_generate_millions
Download
0 formats
No download links available.
How to Generate 10 MILLION Sample Rows in SQL | NatokHD