{"id":3743,"date":"2021-10-21T20:24:24","date_gmt":"2021-10-21T20:24:24","guid":{"rendered":"https:\/\/avantgardenigeria.com\/?post_type=product&#038;p=3743"},"modified":"2024-12-11T17:37:56","modified_gmt":"2024-12-11T17:37:56","slug":"database-system-designs-tools-and-techniques-mysql","status":"publish","type":"product","link":"https:\/\/avantgardenigeria.com\/index.php\/product\/database-system-designs-tools-and-techniques-mysql\/","title":{"rendered":"DATABASE SYSTEM DESIGNS TOOLS AND TECHNIQUES: MySQL"},"content":{"rendered":"<h3>Objective<\/h3>\n<p>In this workshop, participant will be introduced to database design and administration. You will gain an understanding of core database concepts, creation of database objects, manipulation of data, data storage and administration of database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><strong>Content<\/strong><\/p>\n<p><strong>\u00a0<\/strong><strong>Core Database Concepts<\/strong><\/p>\n<ul>\n<li>Database Concepts<\/li>\n<li>Data Manipulation Language (DML)<\/li>\n<li>Data definition Language (DDL)<\/li>\n<\/ul>\n<p><strong>Creating Database Objects<\/strong><\/p>\n<ul>\n<li>Data Types<\/li>\n<li>Creating and Using Tables<\/li>\n<li>Creating Views<\/li>\n<li>Creating Stored Procedures<\/li>\n<\/ul>\n<p><strong>Manipulating Data<\/strong><\/p>\n<ul>\n<li>Using Queries to Select Data<\/li>\n<li>Using Queries to Insert Data<\/li>\n<li>Updating data and Databases<\/li>\n<li>Deleting and Sorting Data<\/li>\n<\/ul>\n<p><strong>Data Storage<\/strong><\/p>\n<ul>\n<li>Normalizing a Database<\/li>\n<li>Primary, Foreign and Composite Keys<\/li>\n<li>Clustered and Non-Clustered Indexes<\/li>\n<\/ul>\n<p><strong>SQL Query<\/strong><\/p>\n<ul>\n<li>Fundamentals of SQL queries<\/li>\n<li>Accessing the Database with SQL queries<\/li>\n<\/ul>\n<p><strong>Administering a Database<\/strong><\/p>\n<ul>\n<li>Ensuring Data Integrity<\/li>\n<li>Securing Databases<\/li>\n<li>Backup and Restoring Databases<\/li>\n<\/ul>\n<p><strong>FOR WHOM: <\/strong>Chief Information Officers, Database Administrators, IT Professionals, Systems Administrators, IT Managers and others who work in environments where databases play a key role in their primary job responsibilities or develop applications that deliver content from databases.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>DATE:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 7th &#8211; 9th May, 2025<\/strong><\/p>\n<p><strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 5th &#8211; 7th November, 2025<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/avantgardenigeria.com\/index.php\/registration\/\"><img decoding=\"async\" class=\"alignnone wp-image-3464\" src=\"https:\/\/avantgardenigeria.com\/wp-content\/uploads\/2017\/12\/register-1.jpeg\" alt=\"\" width=\"202\" height=\"67\" \/><\/a><\/p>\n","protected":false},"featured_media":3494,"comment_status":"open","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}}},"product_cat":[33],"product_tag":[],"class_list":{"0":"post-3743","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-ict-workshop","7":"desktop-align-left","8":"tablet-align-left","9":"mobile-align-left","11":"first","12":"instock","13":"shipping-taxable","14":"purchasable","15":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/product\/3743","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/comments?post=3743"}],"version-history":[{"count":4,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/product\/3743\/revisions"}],"predecessor-version":[{"id":4870,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/product\/3743\/revisions\/4870"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/media\/3494"}],"wp:attachment":[{"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/media?parent=3743"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/product_cat?post=3743"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/product_tag?post=3743"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}