{"id":72,"date":"2019-03-24T00:49:19","date_gmt":"2019-03-24T08:49:19","guid":{"rendered":"https:\/\/db2tutorial.com\/?page_id=72"},"modified":"2020-04-11T07:00:13","modified_gmt":"2020-04-11T15:00:13","slug":"db2-sample-database","status":"publish","type":"page","link":"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/","title":{"rendered":"DB2 Sample Database"},"content":{"rendered":"\n<p><strong>Summary<\/strong>: in this tutorial, we will introduce you to the Books DB2 sample database for practicing with DB2 tutorials.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Introduction to Books DB2 sample database<\/h2>\n\n\n\n<p>The <code>Books<\/code> database is a simple sample database designed for learning and practicing DB2. It consists of six tables:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;<code>books<\/code> table stores book data including title, total pages, rating, ISBN, and published date.<\/li><li>&nbsp;<code>publishers<\/code> table stores publisher names.<\/li><li>&nbsp;<code>authors<\/code> table stores books&#8217; authors.<\/li><li>&nbsp;<code>book_authors<\/code> table stores the relationship between books and authors. A book can be written by one or more authors, and one author may have one or many books.<\/li><li>&nbsp;<code>genres<\/code> table stores book&#8217;s genres. Genres data is hierarchical which is specified by values in the parent_id column<\/li><li>&nbsp;<code>book_genres<\/code> table stores the relationship between books and genres. A book may belong to one or more genres and a genre may have one or many books.<\/li><\/ul>\n\n\n\n<p>The following database diagram illustrates the tables and their relationships:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"760\" height=\"372\" src=\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/DB2-Sample-Database.png\" alt=\"DB2 Sample Database\" class=\"wp-image-73\" srcset=\"https:\/\/www.db2tutorial.com\/wp-content\/uploads\/2019\/03\/DB2-Sample-Database.png 760w, https:\/\/www.db2tutorial.com\/wp-content\/uploads\/2019\/03\/DB2-Sample-Database-300x147.png 300w\" sizes=\"auto, (max-width: 760px) 100vw, 760px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Database Tables<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Table publishers<\/h3>\n\n\n\n<p>The &nbsp;<code>publishers<\/code> table has two columns that store publisher identification and name.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLE<\/span> publishers(\n  publisher_id <span class=\"hljs-built_in\">INT<\/span> <span class=\"hljs-keyword\">GENERATED<\/span> <span class=\"hljs-keyword\">BY<\/span> <span class=\"hljs-keyword\">DEFAULT<\/span> <span class=\"hljs-keyword\">AS<\/span> <span class=\"hljs-keyword\">IDENTITY<\/span> <span class=\"hljs-keyword\">NOT<\/span> <span class=\"hljs-literal\">NULL<\/span>, \n  <span class=\"hljs-keyword\">name<\/span>         <span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">255<\/span>) <span class=\"hljs-keyword\">NOT<\/span> <span class=\"hljs-literal\">NULL<\/span>,\n  PRIMARY <span class=\"hljs-keyword\">KEY<\/span>(publisher_id)\n);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"181\" height=\"94\" src=\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/publishers.png\" alt=\"\" class=\"wp-image-80\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Table books<\/h3>\n\n\n\n<p>The <code>books<\/code> table has 7 columns that store book identification, title, total pages, ISBN, published date, and the identification of the publisher. Each book belongs to a publisher and a publisher may have one or many books. If the value in the publisher column is NULL, it means the publisher is unknown at the time of recording the book.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLE<\/span> books(\n  book_id        <span class=\"hljs-built_in\">INT<\/span> <span class=\"hljs-keyword\">GENERATED<\/span> <span class=\"hljs-keyword\">BY<\/span> <span class=\"hljs-keyword\">DEFAULT<\/span> <span class=\"hljs-keyword\">AS<\/span> <span class=\"hljs-keyword\">IDENTITY<\/span> <span class=\"hljs-keyword\">NOT<\/span> <span class=\"hljs-literal\">NULL<\/span>, \n  title          <span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">255<\/span>) <span class=\"hljs-keyword\">NOT<\/span> <span class=\"hljs-literal\">NULL<\/span>, \n  total_pages    <span class=\"hljs-built_in\">INT<\/span> <span class=\"hljs-literal\">NULL<\/span>, \n  rating         <span class=\"hljs-built_in\">DECIMAL<\/span>(<span class=\"hljs-number\">4<\/span>, <span class=\"hljs-number\">2<\/span>) <span class=\"hljs-literal\">NULL<\/span>, \n  isbn           <span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">13<\/span>) <span class=\"hljs-literal\">NULL<\/span>, \n  published_date <span class=\"hljs-built_in\">DATE<\/span> <span class=\"hljs-literal\">NULL<\/span>, \n  publisher_id   <span class=\"hljs-built_in\">INT<\/span> <span class=\"hljs-literal\">NULL<\/span>, \n  PRIMARY <span class=\"hljs-keyword\">KEY<\/span>(book_id),\n  <span class=\"hljs-keyword\">CONSTRAINT<\/span> fk_publisher \n    <span class=\"hljs-keyword\">FOREIGN<\/span> <span class=\"hljs-keyword\">KEY<\/span>(publisher_id) \n    <span class=\"hljs-keyword\">REFERENCES<\/span> publishers(publisher_id)\n);\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"181\" height=\"194\" src=\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/books.png\" alt=\"\" class=\"wp-image-81\"\/><\/figure>\n\n\n\n<p>The following picture illustrates the relationship between&nbsp; <code>books<\/code> and <code>publishers<\/code> tables:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"450\" height=\"207\" src=\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/books-and-publishers.png\" alt=\"\" class=\"wp-image-74\" srcset=\"https:\/\/www.db2tutorial.com\/wp-content\/uploads\/2019\/03\/books-and-publishers.png 450w, https:\/\/www.db2tutorial.com\/wp-content\/uploads\/2019\/03\/books-and-publishers-300x138.png 300w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Table authors<\/h3>\n\n\n\n<p>The &nbsp;<code>authors<\/code> table has 4 columns that store author identification, first name, middle name, and last name.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLE<\/span> <span class=\"hljs-keyword\">authors<\/span>( \n  author_id   <span class=\"hljs-built_in\">INT<\/span> <span class=\"hljs-keyword\">GENERATED<\/span> <span class=\"hljs-keyword\">BY<\/span> <span class=\"hljs-keyword\">DEFAULT<\/span> <span class=\"hljs-keyword\">AS<\/span> <span class=\"hljs-keyword\">IDENTITY<\/span> <span class=\"hljs-keyword\">NOT<\/span> <span class=\"hljs-literal\">NULL<\/span>,\n  first_name  <span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">100<\/span>) <span class=\"hljs-keyword\">NOT<\/span> <span class=\"hljs-literal\">NULL<\/span>, \n  middle_name <span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">50<\/span>) <span class=\"hljs-literal\">NULL<\/span>, \n  last_name   <span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">100<\/span>) <span class=\"hljs-literal\">NULL<\/span>,\n  PRIMARY <span class=\"hljs-keyword\">KEY<\/span>(author_id)\n);\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"194\" height=\"131\" src=\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/authors.png\" alt=\"\" class=\"wp-image-82\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Table book_authors<\/h3>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLE<\/span> book_authors (\n  book_id   <span class=\"hljs-built_in\">INT<\/span> <span class=\"hljs-keyword\">NOT<\/span> <span class=\"hljs-literal\">NULL<\/span>, \n  author_id <span class=\"hljs-built_in\">INT<\/span> <span class=\"hljs-keyword\">NOT<\/span> <span class=\"hljs-literal\">NULL<\/span>, \n  PRIMARY <span class=\"hljs-keyword\">KEY<\/span>(book_id, author_id), \n  <span class=\"hljs-keyword\">CONSTRAINT<\/span> fk_book \n    <span class=\"hljs-keyword\">FOREIGN<\/span> <span class=\"hljs-keyword\">KEY<\/span>(book_id) \n    <span class=\"hljs-keyword\">REFERENCES<\/span> books(book_id) <span class=\"hljs-keyword\">ON<\/span> <span class=\"hljs-keyword\">DELETE<\/span> <span class=\"hljs-keyword\">CASCADE<\/span>, \n  <span class=\"hljs-keyword\">CONSTRAINT<\/span> fk_author \n    <span class=\"hljs-keyword\">FOREIGN<\/span> <span class=\"hljs-keyword\">KEY<\/span>(author_id) \n    <span class=\"hljs-keyword\">REFERENCES<\/span> <span class=\"hljs-keyword\">authors<\/span>(author_id) <span class=\"hljs-keyword\">ON<\/span> <span class=\"hljs-keyword\">DELETE<\/span> <span class=\"hljs-keyword\">CASCADE<\/span>\n);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Each author has one or many books while each book is written by one or multiple authors. The relationship between books and authors is many to many as described in the following picture:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"695\" height=\"221\" src=\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/books-and-authors.png\" alt=\"\" class=\"wp-image-75\" srcset=\"https:\/\/www.db2tutorial.com\/wp-content\/uploads\/2019\/03\/books-and-authors.png 695w, https:\/\/www.db2tutorial.com\/wp-content\/uploads\/2019\/03\/books-and-authors-300x95.png 300w\" sizes=\"auto, (max-width: 695px) 100vw, 695px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Table genres<\/h3>\n\n\n\n<p>The genres table has three columns that store genre identification, genre, and the relationship between genres.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLE<\/span> genres (\n  genre_id  <span class=\"hljs-built_in\">INT<\/span> <span class=\"hljs-keyword\">GENERATED<\/span> <span class=\"hljs-keyword\">BY<\/span> <span class=\"hljs-keyword\">DEFAULT<\/span> <span class=\"hljs-keyword\">AS<\/span> <span class=\"hljs-keyword\">IDENTITY<\/span> <span class=\"hljs-keyword\">NOT<\/span> <span class=\"hljs-literal\">NULL<\/span>,\n  genre     <span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">255<\/span>) <span class=\"hljs-keyword\">NOT<\/span> <span class=\"hljs-literal\">NULL<\/span>, \n  parent_id <span class=\"hljs-built_in\">INT<\/span> <span class=\"hljs-literal\">NULL<\/span>, \n  PRIMARY <span class=\"hljs-keyword\">KEY<\/span>(genre_id),\n  <span class=\"hljs-keyword\">CONSTRAINT<\/span> fk_parent \n    <span class=\"hljs-keyword\">FOREIGN<\/span> <span class=\"hljs-keyword\">KEY<\/span>(parent_id) <span class=\"hljs-keyword\">REFERENCES<\/span> genres(genre_id)\n);\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>The following picture shows the <code>genres<\/code> table:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"236\" height=\"119\" src=\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/genres.png\" alt=\"\" class=\"wp-image-77\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Table book_genres<\/h3>\n\n\n\n<p>The <code>book_genres<\/code> table stores the relationship between books and genres by using two columns: <code>book_id<\/code> and <code>genre_id<\/code>.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLE<\/span> book_genres(\n  book_id  <span class=\"hljs-built_in\">INT<\/span> <span class=\"hljs-keyword\">NOT<\/span> <span class=\"hljs-literal\">NULL<\/span>, \n  genre_id <span class=\"hljs-built_in\">INT<\/span> <span class=\"hljs-keyword\">NOT<\/span> <span class=\"hljs-literal\">NULL<\/span>, \n  PRIMARY <span class=\"hljs-keyword\">KEY<\/span>(book_id, genre_id), \n  <span class=\"hljs-keyword\">CONSTRAINT<\/span> fk_book \n    <span class=\"hljs-keyword\">FOREIGN<\/span> <span class=\"hljs-keyword\">KEY<\/span>(book_id) \n    <span class=\"hljs-keyword\">REFERENCES<\/span> books(book_id) <span class=\"hljs-keyword\">ON<\/span> <span class=\"hljs-keyword\">DELETE<\/span> <span class=\"hljs-keyword\">CASCADE<\/span>, \n  <span class=\"hljs-keyword\">CONSTRAINT<\/span> fk_genre \n    <span class=\"hljs-keyword\">FOREIGN<\/span> <span class=\"hljs-keyword\">KEY<\/span>(genre_id) \n    <span class=\"hljs-keyword\">REFERENCES<\/span> genres(genre_id) <span class=\"hljs-keyword\">ON<\/span> <span class=\"hljs-keyword\">DELETE<\/span> <span class=\"hljs-keyword\">CASCADE<\/span>\n);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>The relationship between books and genres are many-to-many:<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-76 size-full\" src=\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/books-and-genres.png\" alt=\"\" width=\"704\" height=\"277\" srcset=\"https:\/\/www.db2tutorial.com\/wp-content\/uploads\/2019\/03\/books-and-genres.png 704w, https:\/\/www.db2tutorial.com\/wp-content\/uploads\/2019\/03\/books-and-genres-300x118.png 300w\" sizes=\"auto, (max-width: 704px) 100vw, 704px\" \/><\/p>\n\n\n\n<p>In this tutorial, you have learned about the books DB2 sample database for practicing with DB2. In the next tutorial, you will learn how to create the <code>Books<\/code> sample database and load data into it.<\/p>\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful ?<\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"72\"\n\t\t\t\tdata-post-url=\"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/\"\n\t\t\t\tdata-post-title=\"DB2 Sample Database\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"72\"\n\t\t\t\tdata-post-url=\"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/\"\n\t\t\t\tdata-post-title=\"DB2 Sample Database\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This tutorial introduces you to the Books DB2 sample database for practicing with DB2 in the subsequent tutorials.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":35,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-72","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Introduction to Books DB2 Sample Database<\/title>\n<meta name=\"description\" content=\"This tutorial introduces you to the Books DB2 sample database for practicing with DB2 in the subsequent tutorials.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introduction to Books DB2 Sample Database\" \/>\n<meta property=\"og:description\" content=\"This tutorial introduces you to the Books DB2 sample database for practicing with DB2 in the subsequent tutorials.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/\" \/>\n<meta property=\"og:site_name\" content=\"DB2 Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-11T15:00:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/DB2-Sample-Database.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/\",\"url\":\"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/\",\"name\":\"Introduction to Books DB2 Sample Database\",\"isPartOf\":{\"@id\":\"https:\/\/www.db2tutorial.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/DB2-Sample-Database.png\",\"datePublished\":\"2019-03-24T08:49:19+00:00\",\"dateModified\":\"2020-04-11T15:00:13+00:00\",\"description\":\"This tutorial introduces you to the Books DB2 sample database for practicing with DB2 in the subsequent tutorials.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/#primaryimage\",\"url\":\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/DB2-Sample-Database.png\",\"contentUrl\":\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/DB2-Sample-Database.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.db2tutorial.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Getting Started with Db2\",\"item\":\"https:\/\/www.db2tutorial.com\/getting-started\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DB2 Sample Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.db2tutorial.com\/#website\",\"url\":\"https:\/\/www.db2tutorial.com\/\",\"name\":\"DB2 Tutorial\",\"description\":\"A Comprehensive DB2 Tutorial\",\"publisher\":{\"@id\":\"https:\/\/www.db2tutorial.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.db2tutorial.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.db2tutorial.com\/#organization\",\"name\":\"Db2 Tutorial\",\"url\":\"https:\/\/www.db2tutorial.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.db2tutorial.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/favicon.png\",\"contentUrl\":\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/favicon.png\",\"width\":500,\"height\":500,\"caption\":\"Db2 Tutorial\"},\"image\":{\"@id\":\"https:\/\/www.db2tutorial.com\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Introduction to Books DB2 Sample Database","description":"This tutorial introduces you to the Books DB2 sample database for practicing with DB2 in the subsequent tutorials.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/","og_locale":"en_US","og_type":"article","og_title":"Introduction to Books DB2 Sample Database","og_description":"This tutorial introduces you to the Books DB2 sample database for practicing with DB2 in the subsequent tutorials.","og_url":"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/","og_site_name":"DB2 Tutorial","article_modified_time":"2020-04-11T15:00:13+00:00","og_image":[{"url":"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/DB2-Sample-Database.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/","url":"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/","name":"Introduction to Books DB2 Sample Database","isPartOf":{"@id":"https:\/\/www.db2tutorial.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/#primaryimage"},"image":{"@id":"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/#primaryimage"},"thumbnailUrl":"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/DB2-Sample-Database.png","datePublished":"2019-03-24T08:49:19+00:00","dateModified":"2020-04-11T15:00:13+00:00","description":"This tutorial introduces you to the Books DB2 sample database for practicing with DB2 in the subsequent tutorials.","breadcrumb":{"@id":"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/#primaryimage","url":"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/DB2-Sample-Database.png","contentUrl":"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/DB2-Sample-Database.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.db2tutorial.com\/getting-started\/db2-sample-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.db2tutorial.com\/"},{"@type":"ListItem","position":2,"name":"Getting Started with Db2","item":"https:\/\/www.db2tutorial.com\/getting-started\/"},{"@type":"ListItem","position":3,"name":"DB2 Sample Database"}]},{"@type":"WebSite","@id":"https:\/\/www.db2tutorial.com\/#website","url":"https:\/\/www.db2tutorial.com\/","name":"DB2 Tutorial","description":"A Comprehensive DB2 Tutorial","publisher":{"@id":"https:\/\/www.db2tutorial.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.db2tutorial.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.db2tutorial.com\/#organization","name":"Db2 Tutorial","url":"https:\/\/www.db2tutorial.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.db2tutorial.com\/#\/schema\/logo\/image\/","url":"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/favicon.png","contentUrl":"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/favicon.png","width":500,"height":500,"caption":"Db2 Tutorial"},"image":{"@id":"https:\/\/www.db2tutorial.com\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.db2tutorial.com\/wp-json\/wp\/v2\/pages\/72","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.db2tutorial.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.db2tutorial.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.db2tutorial.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.db2tutorial.com\/wp-json\/wp\/v2\/comments?post=72"}],"version-history":[{"count":3,"href":"https:\/\/www.db2tutorial.com\/wp-json\/wp\/v2\/pages\/72\/revisions"}],"predecessor-version":[{"id":1110,"href":"https:\/\/www.db2tutorial.com\/wp-json\/wp\/v2\/pages\/72\/revisions\/1110"}],"up":[{"embeddable":true,"href":"https:\/\/www.db2tutorial.com\/wp-json\/wp\/v2\/pages\/35"}],"wp:attachment":[{"href":"https:\/\/www.db2tutorial.com\/wp-json\/wp\/v2\/media?parent=72"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}