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

SQL Intro

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
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
65
C 程式語言 I
Avatar for Nedval nedval
0
120
軟體測試與驗證—CI & CU
Avatar for Nedval nedval
0
85

Other Decks in Technology

See All in Technology
アウトプット初心者、半年間のふりかえり
Avatar for aoi 4o1sobblue
0
430
AI駆動開発の時代になったのでトヨタ生産方式から見直す
Avatar for terurou terurou
7
6k
サブエージェントと Claude Mods で作る独自 Advisor ツールの話
Avatar for Kenichi Odo kenichiodo
2
160
「事実」を「計測」して、「解釈」する 〜AWS Lambdaのメモリ最適解の見つけ方〜
Avatar for maimyyym maimyyym
0
170
JAWSUG TOHOKU 青森支部 「LoGoチャット」のAWS移行で 乗り越えたこと
Avatar for たけだ taketakekaho
0
330
AIカンパニーへの転換を支えた、エンジニアの仕事の再定義
Avatar for KNOWLEDGE WORK / 株式会社ナレッジワーク kworkdev
PRO
2
1.2k
Claude の新機能を、 出た日に触って社内に届けるまで
Avatar for ふくだ（fukuda ryu） rfdnxbro
1
170
分析の民主化を支えるメタデータ整備の実践
Avatar for KAKEHASHI kakehashi
PRO
4
1.4k
UniFi（ユニファイ）AIカメラの現場活用
Avatar for ludicmind ludicmind
1
440
スプシの手作業からの解脱 ~更新はClaude Codeに、見せ方と使い方はGASアプリに任せる~
Avatar for KentaroFujii kentarofujii
0
150
二歩目のフロントエンド・ウェブアクセシビリティ
Avatar for KAMIHARA Takumi camiha
2
570
コンテナ運用におけるネットワーク・コンテナコストの削減方法／How to Reduce Network and Container Costs in Container Operations
Avatar for モブエンジニア masakiokuda
1
150

Featured

See All Featured
Winning Ecommerce Organic Search in an AI Era - #searchnstuff2025
Avatar for Aleyda Solis aleyda
2
2.2k
How GitHub (no longer) Works
Avatar for Zach Holman holman
316
150k
Beyond borders and beyond the search box: How to win the global "messy middle" with AI-driven SEO
Avatar for David Carrasco davidcarrasco
3
280
Effective software design: The role of men in debugging patriarchy in IT @ Voxxed Days AMS
Avatar for Kenny Baas-Schwegler baasie
1
570
SEO in 2025: How to Prepare for the Future of Search
Avatar for Michael King ipullrank
3
3.9k
Kristin Tynski - Automating Marketing Tasks With AI
Avatar for Tech SEO Connect techseoconnect
PRO
0
550
Dealing with People You Can't Stand - Big Design 2015
Avatar for Cassini Nazir cassininazir
367
27k
<Decoding/> the Language of Devs - We Love SEO 2024
Avatar for Nikki Halliwell nikkihalliwell
1
360
How to make the Groovebox
Avatar for あそなす asonas
2
2.5k
How to Talk to Developers About Accessibility
Avatar for Jason CranfordTeague jct
2
580
Navigating Weather and Climate Data
Avatar for Ryan Abernathey rabernat
0
560
HU Berlin: Industrial-Strength Natural Language Processing with spaCy and Prodigy
Avatar for Ines Montani inesmontani
PRO
0
750

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