Excel SQL Query Mastery: Build SQL Queries with Excel from scratch | Full Course

Learn to build SQL queries from scratch using Excel. Unleash the potential of structured query language effortlessly. Unleashing the Power of Databases  | Database and Excel Unleashed: A Step-by-Step Guide
  
DATABASE SETUP

0:00:00    -  Introduction.
0:02:39    -  What is Oracle.
0:06:36    -  Install Oracle  Database Server.
0:14:39    -  Unlock Sample Schema.
0:20:11    -  Installing TOAD.
0:25:33    -  Connect TOAD to Oracle Database.

MICROSOFT EXCEL SETUP

0:30:57    -  Office 365 Setup.
0:44:19    -  Activating Office 365 Apps.
0:47:56    -  Logging into Office 365.

BUILD BULK SQL QUERIES USING EXCEL\

0:53:33    -  Introduction.
0:54:49    -  Sample Excel Data.
0:59:10    -  Create a Table.
1:07:10    -  Prep the data.
1:12:32    -  Build Bulk INSERT SQL Queries_ Part 1.
1:21:05    -  Build Bulk INSERT SQL Queries_ Part 2.
1:30:21    -  Build Bulk  UPDATE SQL Queries_ Part 1.
1:38:05    -  Build Bulk  UPDATE SQL Queries_ Part 2.
1:42:54    -  Build Bulk DELETE SQL Queries_ Part 1.
1:48:03    -  Build Bulk DELETE SQL Queries_ Part 2.
1:55:18    -  Conclusion.
    
#excel #sql