Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

SQL Intro

Avatar for Nedval Nedval
September 24, 2013
Technology
110
0

SQL Intro

Avatar for Nedval

Nedval

September 24, 2013

More Decks by Nedval

See All by Nedval
if else statement
Avatar for Nedval nedval
0
60
C 程式語言 I
Avatar for Nedval nedval
0
120
軟體測試與驗證—CI & CU
Avatar for Nedval nedval
0
85

Other Decks in Technology

See All in Technology
LTのテーマ どうきめてる？〜5つの型と私のやり方〜
Avatar for Yuuki Yamashita yama3133
1
110
顧客に向き合う開発組織へ。リアーキテクチャとフィーチャーチーム化で挑む組織改革
Avatar for セーフィー safie
0
2.1k
その Lambda、8分で 管理者権限まで奪われます
Avatar for k1nakayama k1nakayama
6
3.1k
AI 時代のスタートアップエコシステ厶から考究する技術的負債との向き合い方
Avatar for memory m3m0r7
PRO
3
2.3k
AIエージェントの権限管理 3:  Agentic RAG の Fine grained access control 編
Avatar for Renya Kujirada ren8k
0
130
30座EKS, 180次升級淬煉的EKS Upgrade Skill 的歷程
Avatar for Eric eric8230
0
180
aws-iot-platform-architecture-use-cases.pdf
Avatar for Kohei "Max" MATSUSHITA ma2shita
0
350
【技術的負債conf】事業成長に伴う技術的負債の説明責任とAIによるモニタリング、認知的負債について
Avatar for Masato Ishigaki / 石垣雅人 i35_267
3
1.8k
あるけみー式LTスライド作成術
Avatar for Ryotaro Harada alchemy1115
2
220
AIは推し活である。
Avatar for くらず / Kurazu kurazuuuuuu
1
810
Reactの設計論
Avatar for uhyo uhyo
24
14k
越境するなら専門用語を使うな高校校歌 / If you wanna cross border, you shouldn't use jargon
Avatar for VTRyo vtryo
0
150

Featured

See All Featured
Design of three-dimensional binary manipulators for pick-and-place task avoiding obstacles (IECON2024)
Avatar for konakalab konakalab
0
590
BBQ
Avatar for Matthew Crist matthewcrist
89
10k
Navigating Weather and Climate Data
Avatar for Ryan Abernathey rabernat
0
520
Future Trends and Review - Lecture 12 - Web Technologies (1019888BNR)
Avatar for Beat Signer signer
PRO
0
3.7k
The World Runs on Bad Software
Avatar for Brandon Keepers bkeepers
PRO
72
12k
Automating Front-end Workflow
Avatar for Addy Osmani addyosmani
1369
210k
Are puppies a ranking factor?
Avatar for Jono Alderson jonoalderson
2
3.9k
YesSQL, Process and Tooling at Scale
Avatar for Rocio Delgado rocio
174
15k
Technical Leadership for Architectural Decision Making
Avatar for Kenny Baas-Schwegler baasie
3
570
Efficient Content Optimization with Google Search Console & Apps Script
Avatar for Katarina Dahlin katarinadahlin
PRO
1
870
Avoiding the “Bad Training, Faster” Trap in the Age of AI
Avatar for Mike Taylor tmiket
0
240
Making the Leap to Tech Lead
Avatar for Ryan Cromwell cromwellryan
135
10k

Transcript

  1. INTRO 2013/09/23 Tuesday, September 24, 13

  2. 認識資料庫相關名詞 Tuesday, September 24, 13

  3. SQL Tuesday, September 24, 13

  4. SEQUEL Tuesday, September 24, 13

  5. Structured English QUEry Language Tuesday, September 24, 13

  6. SQL Tuesday, September 24, 13

  7. Structured Query Language Tuesday, September 24, 13

  8. DBMS vs. DB Tuesday, September 24, 13

  9. DataBase Management System vs. DataBase Tuesday, September 24, 13

  10. DataBase Tuesday, September 24, 13

  11. DataBase DBMS Tuesday, September 24, 13

  12. 認識各家 DBMS Tuesday, September 24, 13

  13. Tuesday, September 24, 13

  14. SQL Server Tuesday, September 24, 13

  15. SQL Server IBM DB2 Tuesday, September 24, 13

  16. ORACLE SQL Server IBM DB2 Tuesday, September 24, 13

  17. MySQL ORACLE SQL Server IBM DB2 Tuesday, September 24, 13

  18. MySQL PostgreSQL ORACLE SQL Server IBM DB2 Tuesday, September 24,

    13

  19. Tuesday, September 24, 13

  20. SQL 基本指令 part I Tuesday, September 24, 13

  21. SHOW DATABASES SHOW DATABASES; Tuesday, September 24, 13

  22. CREATE DATABASE CREATE DATABASE `mydbname_db` DEFAULT CHARACTER SET `utf8` DEFAULT

    COLLATE `utf8_unicode_ci`; Tuesday, September 24, 13

  23. USE USE `mydbname_db`; Tuesday, September 24, 13

  24. CREATE TABLE CREATE TABLE `students` ( `sid` CHAR(7) NOT NULL,

    `name` VARCHAR(20) NOT NULL, `mobile` VARCHAR(20) NOT NULL, `sex` CHAR(1), `birth` DATE, `address` VARCHAR(255) ); Tuesday, September 24, 13

  25. § 實作時間 § Tuesday, September 24, 13

  26. SQL 基本指令 part ][ Tuesday, September 24, 13

  27. I. S. U. D. Tuesday, September 24, 13

  28. Insert Select Update Delete Tuesday, September 24, 13

  29. INSERT INTO INSERT INTO `students` ( `sid`, `name`, `mobile` )

    VALUES ( '1003800', '無名仕', '0987654321' ); Tuesday, September 24, 13

  30. SELECT FROM WHERE SELECT * FROM `students` WHERE `sid` =

    '1003800'; Tuesday, September 24, 13

  31. UPDATE SET WHERE UPDATE `students` SET `name` = '⾦金城武', `mobile`

    = '0988776655' WHERE `sid` = '1003800'; Tuesday, September 24, 13

  32. DELETE FROM WHERE DELETE FROM `students` WHERE `sid` = '1003800';

    Tuesday, September 24, 13

  33. § 實作時間 § Tuesday, September 24, 13