toshiki-notebook/assets/academic_cis105_cis105-l12-lecture-note.md.8f22ad29.js

import{_ as o}from"./chunks/PageInfo.vue_vue_type_script_setup_true_lang.65c6b98c.js";import{_ as i,o as l,c as s,k as t,a as n,E as r,O as c}from"./chunks/framework.c989bd33.js";import"./chunks/commonjsHelpers.725317a4.js";const I=JSON.parse('{"title":"CIS105: Computer Applications & Information Systems Lect. 12","description":"","frontmatter":{},"headers":[],"relativePath":"academic/cis105/cis105-l12-lecture-note.md","filePath":"academic/cis105/cis105-l12-lecture-note.md","lastUpdated":1726418622000}'),d={name:"academic/cis105/cis105-l12-lecture-note.md"};function u(m,e,h,p,f,S){const a=o;return l(),s("div",null,[e[0]||(e[0]=t("h1",{id:"cis105-computer-applications-information-systems-lect-12",tabindex:"-1"},[n("CIS105: Computer Applications & Information Systems Lect. 12 "),t("a",{class:"header-anchor",href:"#cis105-computer-applications-information-systems-lect-12","aria-label":'Permalink to "CIS105: Computer Applications & Information Systems Lect. 12"'},"​")],-1)),r(a,{readTime:"1",words:"150"}),e[1]||(e[1]=c('<h2 id="chapter-12-introduction-to-sql" tabindex="-1">Chapter 12: Introduction to SQL <a class="header-anchor" href="#chapter-12-introduction-to-sql" aria-label="Permalink to &quot;Chapter 12: Introduction to SQL&quot;">​</a></h2><h3 id="_12-1-sql-getting-started" tabindex="-1">12.1: SQL Getting Started <a class="header-anchor" href="#_12-1-sql-getting-started" aria-label="Permalink to &quot;12.1: SQL Getting Started&quot;">​</a></h3><ul><li>Capture the data <ul><li>Point of Sale, Scanning, etc</li></ul></li><li>Get the data into a database <ul><li>Import from other systems</li><li>Direct input from forms</li></ul></li><li>Extract the data <ul><li>SQL</li></ul></li><li>Use the data <ul><li>Analysis systems</li><li>Reporting systems</li></ul></li><li>SQL: The language of relational databases <ul><li>Structured query Language</li></ul></li></ul><p>If you plan to analyze data for a business, there is a good chance it&#39;s stored in a data warehouse, and you will need to learn how to retrieve it yourself.</p><h3 id="_12-2-sql-statement" tabindex="-1">12.2: SQL Statement <a class="header-anchor" href="#_12-2-sql-statement" aria-label="Permalink to &quot;12.2: SQL Statement&quot;">​</a></h3><ul><li><code>SELECT</code>: What <strong>fields</strong> (column) you want <ul><li><code>fieldname</code>: If the name is used in only one table</li></ul></li><li><code>FROM</code>: What table or tables contain the fields</li><li><code>ORDER BY</code>: Sorting</li><li><code>DISTINCT</code>: Use after <code>SELECT</code> when you only want to show each vale of the selected field(s) once</li><li><code>LIMIT</code>: Use when you want to limit the number of records produced</li></ul>',6))])}const _=i(d,[["render",u]]);export{I as __pageData,_ as default};