Write awesome SQL DDL using Excel
Did you know you can implement database tables quickly by generating SQL Data Definition Language (DDL) code in Microsoft Excel? You can, it's awesome, and #ThisIsHowYouDoIT!
0:00 Introduction
0:07 CSV or Excel Data format
1:17 Creating the DDL
3:48 Running the DDL
4:05 Writing INSERT statements in Excel
9:21 How to be more awesome
10:00 Writing a more efficient INSERT statement in Excel
Video about datatypes coming soon!
#SQL #Database #Implementation #DDL #Education #databasedesign #PostgreSQL #Oracle #mssqlserver #excel