{"id":3838,"date":"2021-04-21T12:43:18","date_gmt":"2021-04-21T05:43:18","guid":{"rendered":"https:\/\/belogix.com\/?p=3838"},"modified":"2021-04-21T12:43:21","modified_gmt":"2021-04-21T05:43:21","slug":"oracle-database-12c-sql-fundamentals","status":"publish","type":"post","link":"https:\/\/belogix.com\/index.php\/2021\/04\/21\/oracle-database-12c-sql-fundamentals\/","title":{"rendered":"Oracle Database 12c : SQL Fundamentals"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"1024\" src=\"https:\/\/belogix.com\/wp-content\/uploads\/2021\/04\/Promo-Berkah-Ramadhan-12C-SQL-FUNDAMENTALS-1024x1024.png\" alt=\"\" class=\"wp-image-3839\" srcset=\"https:\/\/belogix.com\/wp-content\/uploads\/2021\/04\/Promo-Berkah-Ramadhan-12C-SQL-FUNDAMENTALS-1024x1024.png 1024w, https:\/\/belogix.com\/wp-content\/uploads\/2021\/04\/Promo-Berkah-Ramadhan-12C-SQL-FUNDAMENTALS-300x300.png 300w, https:\/\/belogix.com\/wp-content\/uploads\/2021\/04\/Promo-Berkah-Ramadhan-12C-SQL-FUNDAMENTALS-150x150.png 150w, https:\/\/belogix.com\/wp-content\/uploads\/2021\/04\/Promo-Berkah-Ramadhan-12C-SQL-FUNDAMENTALS-768x768.png 768w, https:\/\/belogix.com\/wp-content\/uploads\/2021\/04\/Promo-Berkah-Ramadhan-12C-SQL-FUNDAMENTALS-750x750.png 750w, https:\/\/belogix.com\/wp-content\/uploads\/2021\/04\/Promo-Berkah-Ramadhan-12C-SQL-FUNDAMENTALS-400x400.png 400w, https:\/\/belogix.com\/wp-content\/uploads\/2021\/04\/Promo-Berkah-Ramadhan-12C-SQL-FUNDAMENTALS-250x250.png 250w, https:\/\/belogix.com\/wp-content\/uploads\/2021\/04\/Promo-Berkah-Ramadhan-12C-SQL-FUNDAMENTALS-75x75.png 75w, https:\/\/belogix.com\/wp-content\/uploads\/2021\/04\/Promo-Berkah-Ramadhan-12C-SQL-FUNDAMENTALS.png 1080w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Durasi : 3 Hari @2 Jam<\/li><li>Harga : Rp. 525.000<\/li><\/ul>\n\n\n\n<p>Deskripsi :<\/p>\n\n\n\n<p>Training ini membahas perintah-perintah SQL yang merupakan bahasa untuk berinteraksi atau mengakses ke database. Dengan mengikuti training ini diharapkan peserta mampu menggunakan perintah SQL untuk membuat tabel, mengisi data ke tabel, melakukan modifikasi data, melakukan pengaturan transaksi serta menampilkan berbagai informasi dari dalam database.<br>Training ini merupakan materi dasar atau prasyarat untuk memahami manajemen database Oracle atau training Oracle tingkat lanjut lainnya.<\/p>\n\n\n\n<p>Tinjauan Materi:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Introduction<\/li><li>Rerieving Data using the SQL SELECT Statement<\/li><li>Restricting and Sorting Data<\/li><li>Using Single-row Function to Customized Output<\/li><li>Using Conversion Function and Conditional Expression<\/li><li>Reporting Aggregate Data using Group Function<\/li><li>Displaying Data from Multiple Tables<\/li><li>Using Subqueries to Solve Queries<\/li><li>Using the Set Operators<\/li><li>Manipulating Data(Insert, Update, Delete, Commit and Rollback)<\/li><li>Using DDL Statments to Create and Managed Tables<\/li><li>Creating Others Schema Objects<\/li><li>Controlling User Access<\/li><li>Managing Objects withs Data Dictionary<\/li><li>Manipulating Large Data Sets<\/li><li>Retrieving Data using Subqueries<\/li><\/ul>\n\n\n\n<p>Manfaat Bagi peserta :<\/p>\n\n\n\n<p>Dengan mengikuti webinar ini diharapkan peserta mampu menggunakan perintah SQL untuk membuat tabel, mengisi data ke tabel, melakukan modifikasi data, melakukan pengaturan transaksi serta menampilkan berbagai informasi dari dalam database.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<div class=\"wp-block-file\"><a href=\"https:\/\/belogix.com\/wp-content\/uploads\/2021\/04\/DB-1321-Oracle-Database-12c-SQL-Fundamentals-email.pdf\">Silabus Oracle Database 12c : SQL Fundamentals<\/a><a href=\"https:\/\/belogix.com\/wp-content\/uploads\/2021\/04\/DB-1321-Oracle-Database-12c-SQL-Fundamentals-email.pdf\" class=\"wp-block-file__button\" download>Download<\/a><\/div>\n\n\n\n<p>Untuk Pendaftaran, klik tombol dibawah ini :<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\"><\/div>\n\n\n\n<hr class=\"wp-block-separator is-style-wide\"\/>\n","protected":false},"excerpt":{"rendered":"<p>Durasi : 3 Hari @2 Jam Harga : Rp. 525.000 Deskripsi : Training ini membahas perintah-perintah SQL yang merupakan bahasa untuk berinteraksi atau mengakses ke database. Dengan mengikuti training ini diharapkan peserta mampu menggunakan perintah SQL untuk membuat tabel, mengisi data ke tabel, melakukan modifikasi data, melakukan pengaturan transaksi serta menampilkan berbagai informasi dari dalam [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3838","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/belogix.com\/index.php\/wp-json\/wp\/v2\/posts\/3838","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/belogix.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/belogix.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/belogix.com\/index.php\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/belogix.com\/index.php\/wp-json\/wp\/v2\/comments?post=3838"}],"version-history":[{"count":0,"href":"https:\/\/belogix.com\/index.php\/wp-json\/wp\/v2\/posts\/3838\/revisions"}],"wp:attachment":[{"href":"https:\/\/belogix.com\/index.php\/wp-json\/wp\/v2\/media?parent=3838"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/belogix.com\/index.php\/wp-json\/wp\/v2\/categories?post=3838"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/belogix.com\/index.php\/wp-json\/wp\/v2\/tags?post=3838"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}