Back to Browse

How to Generate 10 MILLION Sample Rows in SQL

3.8K views
Sep 24, 2024
24:28

πŸ“ 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