{"id":121572,"date":"2023-12-04T16:13:09","date_gmt":"2023-12-04T15:13:09","guid":{"rendered":"https:\/\/www.academy-tu.berlin\/?post_type=product&#038;p=121572"},"modified":"2023-12-06T06:32:26","modified_gmt":"2023-12-06T05:32:26","slug":"relational-databases-and-data-queriying06-12-2024-07-12-202413-12-2024-14-12-2024","status":"publish","type":"product","link":"https:\/\/academy.techiecraft.de\/en\/shop\/relational-databases-and-data-queriying06-12-2024-07-12-202413-12-2024-14-12-2024\/","title":{"rendered":"RELATIONAL DATABASES AND DATA QUERYING<br><span style=\"color: #000078;\">06.12.2024-07.12.2024+13.12.2024-14.12.2024<\/span>"},"content":{"rendered":"<p>Data fuels the contemporary world, serving as a cornerstone for virtually every business, be it an emerging startup or an established multinational corporation. The organization and utilization of this data in relational databases hinges on a particular programming language known as Structured Query Language or SQL. Mastering the ability to manipulate and retrieve data from databases using SQL is a crucial skill in data-centric roles and beyond.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data fuels the contemporary world, serving as a cornerstone for virtually every business, be it an emerging startup or an established multinational corporation. The organization and utilization of this data in relational databases hinges on a particular programming language known as Structured Query Language or SQL. Mastering the ability to manipulate and retrieve data from [&hellip;]<\/p>\n","protected":false},"featured_media":114699,"template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":""},"product_cat":[108],"product_tag":[127],"acf":{"ZEITRAUM":"COURSE DATES<br><br>\r\n06.12.2024-07.12.2024 + 13.12.2024-14.12.2024","KURSDAUER":"COURSE DURATION<br><br>\r\n3 days\r\n","SPRACHE":"LANGUAGE<br><br>\r\nEnglish","STANDORT":"LOCATION<br><br>\r\nOnline","ABSCHLUSS":"CERTIFICATE<br><br>\r\nCertificate of Participation","LERNFORMAT":"FORMAT<br><br>\r\nOnline ","LEHRENDE*R":"LEHRENDE*R<br><br>","KOSTEN":"PRICE<br><br>\r\n1400 \u20ac<br><br>\r\nRecognized as Bildungszeit","Lernziele":"<h3 style=\"text-transform:uppercase\">Learning goals<\/h3>\r\nUpon completion of the course, participants will have explored the basic concepts of Relational Databases (RDBs) and have delved into best practices for modeling them. They will learn how to formulate various types of SQL queries to create, organize, update and query data tables in an RDB, as well as extracting valuable business insights.   ","INHALT":"<h3 style=\"text-transform:uppercase\">Content<\/h3>\r\nIntroduction to Relational Databases:\r\n<ul>\r\n<li>Definition of an RDB and applications<\/li>\r\n<li>MySQL Server and Workbench installation<\/li>\r\n<li>Difference between a RDB Server and RDB Management System<\/li>\r\n<li>Entity Relationship Model (ERM) and Cardinality<\/li>\r\n<li>Primary and Foreign Keys<\/li>\r\n<li>RDB Normalization<\/li>\r\n<\/ul>\r\nFundamental SQL Queries\r\n<ul>\r\n<li>Create, update and delete databases and tables<\/li>\r\n<li>Basic structure of an SQL query<\/li>\r\n<li>Limiting and Sorting<\/li>\r\n<li>Filtering<\/li>\r\n<li>Joining tables<\/li>\r\n<li>Aggregation functions<\/li>\r\n<li>Saving results in flat files<\/li>\r\n<\/ul>\r\nAdvanced SQL Queries\r\n<ul>\r\n<li>CASE statements<\/li>\r\n<li>Correlated Subqueries<\/li>\r\n<li>Nested Subqueries<\/li>\r\n<li>Common Table Expressions<\/li>\r\n<li>Window functions<\/li>\r\n<li>Saving results in Views<\/li>\r\n<\/ul>\r\n<br>\r\nThroughout the course, participants will use the Northwind Traders database as a case study. The primary software tools used in this course will be MySQL Server and MySQL Workbench. ","Zielgruppe_":"<h3 style=\"text-transform:uppercase\">Target group<\/h3>\r\nProfessionals and researchers interacting with Relational Databases and interested in learning how to perform data analyses and prepare reports using SQL.\r\n<br><br>\r\nThis course is suitable for beginners in SQL and Data Analysis.\r\n<br><br>\r\nThis course is recognized as Bildungszeit according to paragraph \u00a7 10 (5) of the Berliner Bildungszeitgesetz (BiZeitG).","Teilnahmevoraussetzungen":"<h3 style=\"text-transform:uppercase\">Prerequisites<\/h3>\r\n<ul>\r\n\t<li>English level of at least B1 (according to the European Framework)<\/li>\r\n\t<li>Laptop (no specific operating system required) + headset with microphone<\/li>\r\n<\/ul>","Termine":"<h3 style=\"text-transform:uppercase\">Dates<\/h3>\r\nDecember 06 \u2013 07, 2024 and December 13 \u2013 14, 2024 (virtual classroom sessions).\r\n<br><br>\r\nExpected hours on Fridays from 15:00 - 19:00 (CET) and on Saturdays from 10:00 - 18:00 (CET).\r\n<br><br>\r\nThis course will also be offered in <a href=\"\/laden\/relational-databases-and-data-queriying07-06-2024-08-06-202414-06-2024-15-06-2024\/\">June 2024<\/a>.","lehrende-r-place-holder":"<h3>LECTURER<\/h3>","LEHRENDE*R-foto":121554,"LEHRENDE*R-info":"<h3>LEHRENDE*R<\/h3>","Interessiert":"Interested in signing up for this course?","Kurse-teilen":"","Pdf-download":121574,"Fragen":"Or do you have other questions?"},"_links":{"self":[{"href":"https:\/\/academy.techiecraft.de\/en\/wp-json\/wp\/v2\/product\/121572"}],"collection":[{"href":"https:\/\/academy.techiecraft.de\/en\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/academy.techiecraft.de\/en\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/academy.techiecraft.de\/en\/wp-json\/wp\/v2\/media\/114699"}],"wp:attachment":[{"href":"https:\/\/academy.techiecraft.de\/en\/wp-json\/wp\/v2\/media?parent=121572"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/academy.techiecraft.de\/en\/wp-json\/wp\/v2\/product_cat?post=121572"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/academy.techiecraft.de\/en\/wp-json\/wp\/v2\/product_tag?post=121572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}