Here’s the ERD of the sample bookstore database we’ll be looking at. You’ll need to know what a Create statement and Insert statement do, but other than that, you should be able to follow these steps. SQL Server Management Studio + SQL Server databaseĪ basic understanding of SQL.You can use any IDE you like (and I’ve got a full list here), but some common combinations are: Oracle cloud, Azure, GCP, AWS)Īn IDE to run SQL scripts. using Docker images (instructions for Oracle and SQL Server, MySQL and PostgreSQL are here).setting up a database on your computer directly (e.g.You won’t need much to get started with this data set.Īccess to an Oracle, SQL Server, MySQL, or PostgreSQL database. Run Script 13 to Populate Order History.Run Script 11 to Populate Customer Orders.Run Script 10 to Populate Customer Address.Run Script 04 to Populate the Lookup Tables.Run Script 03 to Populate the Publisher.Run Script 00 (Oracle Only) to Create a New User.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |