filmov
tv
How to Install the AdventureWorks SQL Server Sample Database
Показать описание
Here's a quick video to show you how to install Microsoft's AdventureWorks sample database in SQL Server using the SQL Server Management Studio. AdventureWorks is a useful database if you want to learn SQL. I use it extensively in my SQL tutorials.
00:00 - Downloading AdventureWorks
00:27 - Installing AdventureWorks
01:02 - Validating the install
01:20 - Alternative sample database
Note that you don't need to create a database for AdventureWorks. The installation script will create the new database for you.
Which sample database do you think is the best one? I prefer Northwind over AdventureWorks because Northwind is less complex and the tables contain less data. Also AdventureWorks contains dubious coding practices that will make your DBA angry, like making a view with 10 table joins!!!
If you found this video leave a LIKE and SUBSCRIBE for more coding videos.
00:00 - Downloading AdventureWorks
00:27 - Installing AdventureWorks
01:02 - Validating the install
01:20 - Alternative sample database
Note that you don't need to create a database for AdventureWorks. The installation script will create the new database for you.
Which sample database do you think is the best one? I prefer Northwind over AdventureWorks because Northwind is less complex and the tables contain less data. Also AdventureWorks contains dubious coding practices that will make your DBA angry, like making a view with 10 table joins!!!
If you found this video leave a LIKE and SUBSCRIBE for more coding videos.
0:05:12
0:06:26
0:06:05
0:10:20
0:02:55
0:07:08
0:06:33
0:01:37
0:08:23
0:03:28
0:04:48
0:05:27
0:05:52
0:06:20
0:03:51
0:04:35
0:04:07
0:03:12
0:03:41
0:01:36
0:04:11
0:04:53
0:08:14
0:10:51