{"id":228768,"date":"2026-05-02T13:40:09","date_gmt":"2026-05-02T13:40:09","guid":{"rendered":"https:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/"},"modified":"2026-05-02T13:40:09","modified_gmt":"2026-05-02T13:40:09","slug":"how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17","status":"publish","type":"post","link":"https:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/","title":{"rendered":"How to Create a Database and Table using SQL Query | DBMS Tutorials | Part 17"},"content":{"rendered":"<div class=\"youtubomatic-video-container\"><iframe loading=\"lazy\" width=\"580\" height=\"380\" src=\"https:\/\/www.youtube.com\/embed\/KBf9emteT5s?autoplay=1&#038;controls=1&#038;hl=en\" frameborder=\"0\" allowfullscreen><\/iframe><\/div>\n<p>Welcome to Part 17 of the Database Systems series! Now that we have explored the graphical interface, it is time to write our very first SQL scripts.<\/p>\n<p>In this lecture, we transition from using the SSMS GUI to writing raw SQL code. We dive into Data Definition Language (DDL) and learn the exact commands used by database professionals to build database structures from scratch.<\/p>\n<p>\ud83d\udccc In this video, you will learn:<\/p>\n<p>What Data Definition Language (DDL) is and why it matters.<\/p>\n<p>How to open a new query window and write your first SQL script.<\/p>\n<p>The CREATE DATABASE command and its syntax.<\/p>\n<p>The CREATE TABLE command, defining columns, and assigning data types.<\/p>\n<p>How to execute scripts and verify your new structures in the Object Explorer.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Welcome to Part 17 of the Database Systems series! Now that we have explored the graphical interface, it is time to write our very first SQL scripts. In this lecture, we transition from using the SSMS GUI to writing raw SQL code. We dive into Data Definition Language (DDL) and learn the exact commands used by database professionals to build database structures from scratch. \ud83d\udccc In this video, you will&#8230;<\/p>\n","protected":false},"author":1,"featured_media":228769,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"","tve_custom_css":"","tve_user_custom_css":"","tve_globals":{},"tcb2_ready":0,"tcb_editor_enabled":0,"tve_landing_page":"","_tve_header":"","_tve_footer":""},"categories":[1],"tags":[],"class_list":["post-228768","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Create a Database and Table using SQL Query | DBMS Tutorials | Part 17 - UshopWell.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create a Database and Table using SQL Query | DBMS Tutorials | Part 17 - UshopWell.com\" \/>\n<meta property=\"og:description\" content=\"Welcome to Part 17 of the Database Systems series! Now that we have explored the graphical interface, it is time to write our very first SQL scripts. In this lecture, we transition from using the SSMS GUI to writing raw SQL code. We dive into Data Definition Language (DDL) and learn the exact commands used by database professionals to build database structures from scratch. \ud83d\udccc In this video, you will...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/\" \/>\n<meta property=\"og:site_name\" content=\"UshopWell.com\" \/>\n<meta property=\"article:published_time\" content=\"2026-05-02T13:40:09+00:00\" \/>\n<meta name=\"author\" content=\"UShopWell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"UShopWell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\\\/\"},\"author\":{\"name\":\"UShopWell\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/person\\\/6fd1f9e0ff932e534c86c70d5acff0fc\"},\"headline\":\"How to Create a Database and Table using SQL Query | DBMS Tutorials | Part 17\",\"datePublished\":\"2026-05-02T13:40:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\\\/\"},\"wordCount\":135,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/228768\\\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\\\/\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\\\/\",\"name\":\"How to Create a Database and Table using SQL Query | DBMS Tutorials | Part 17 - UshopWell.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/228768\\\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17.jpg\",\"datePublished\":\"2026-05-02T13:40:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\\\/#primaryimage\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/228768\\\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17.jpg\",\"contentUrl\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/228768\\\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17.jpg\",\"width\":480,\"height\":360,\"caption\":\"How to Create a Database and Table using SQL Query | DBMS Tutorials | Part 17\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create a Database and Table using SQL Query | DBMS Tutorials | Part 17\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#website\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/\",\"name\":\"UshopWell.com\",\"description\":\"The Premiere Online Marketplace\",\"publisher\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#organization\",\"name\":\"UshopWell\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/pandaSwea.png\",\"contentUrl\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/pandaSwea.png\",\"width\":365,\"height\":359,\"caption\":\"UshopWell\"},\"image\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/person\\\/6fd1f9e0ff932e534c86c70d5acff0fc\",\"name\":\"UShopWell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g\",\"caption\":\"UShopWell\"},\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/author\\\/kburnettu\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Create a Database and Table using SQL Query | DBMS Tutorials | Part 17 - UshopWell.com","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:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/","og_locale":"en_US","og_type":"article","og_title":"How to Create a Database and Table using SQL Query | DBMS Tutorials | Part 17 - UshopWell.com","og_description":"Welcome to Part 17 of the Database Systems series! Now that we have explored the graphical interface, it is time to write our very first SQL scripts. In this lecture, we transition from using the SSMS GUI to writing raw SQL code. We dive into Data Definition Language (DDL) and learn the exact commands used by database professionals to build database structures from scratch. \ud83d\udccc In this video, you will...","og_url":"https:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/","og_site_name":"UshopWell.com","article_published_time":"2026-05-02T13:40:09+00:00","author":"UShopWell","twitter_card":"summary_large_image","twitter_misc":{"Written by":"UShopWell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/#article","isPartOf":{"@id":"https:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/"},"author":{"name":"UShopWell","@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/person\/6fd1f9e0ff932e534c86c70d5acff0fc"},"headline":"How to Create a Database and Table using SQL Query | DBMS Tutorials | Part 17","datePublished":"2026-05-02T13:40:09+00:00","mainEntityOfPage":{"@id":"https:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/"},"wordCount":135,"commentCount":0,"publisher":{"@id":"https:\/\/ushopwell.com\/ublog\/#organization"},"image":{"@id":"https:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/#primaryimage"},"thumbnailUrl":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2026\/06\/228768\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/","url":"https:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/","name":"How to Create a Database and Table using SQL Query | DBMS Tutorials | Part 17 - UshopWell.com","isPartOf":{"@id":"https:\/\/ushopwell.com\/ublog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/#primaryimage"},"image":{"@id":"https:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/#primaryimage"},"thumbnailUrl":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2026\/06\/228768\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17.jpg","datePublished":"2026-05-02T13:40:09+00:00","breadcrumb":{"@id":"https:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/#primaryimage","url":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2026\/06\/228768\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17.jpg","contentUrl":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2026\/06\/228768\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17.jpg","width":480,"height":360,"caption":"How to Create a Database and Table using SQL Query | DBMS Tutorials | Part 17"},{"@type":"BreadcrumbList","@id":"https:\/\/ushopwell.com\/ublog\/how-to-create-a-database-and-table-using-sql-query-dbms-tutorials-part-17\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ushopwell.com\/ublog\/"},{"@type":"ListItem","position":2,"name":"How to Create a Database and Table using SQL Query | DBMS Tutorials | Part 17"}]},{"@type":"WebSite","@id":"https:\/\/ushopwell.com\/ublog\/#website","url":"https:\/\/ushopwell.com\/ublog\/","name":"UshopWell.com","description":"The Premiere Online Marketplace","publisher":{"@id":"https:\/\/ushopwell.com\/ublog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ushopwell.com\/ublog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ushopwell.com\/ublog\/#organization","name":"UshopWell","url":"https:\/\/ushopwell.com\/ublog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/logo\/image\/","url":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2018\/01\/pandaSwea.png","contentUrl":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2018\/01\/pandaSwea.png","width":365,"height":359,"caption":"UshopWell"},"image":{"@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/person\/6fd1f9e0ff932e534c86c70d5acff0fc","name":"UShopWell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g","caption":"UShopWell"},"url":"https:\/\/ushopwell.com\/ublog\/author\/kburnettu\/"}]}},"_links":{"self":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/posts\/228768","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/comments?post=228768"}],"version-history":[{"count":0,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/posts\/228768\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/media\/228769"}],"wp:attachment":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/media?parent=228768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/categories?post=228768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/tags?post=228768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}