Lock in $30 Savings on PRO—Offer Ends Soon! ⏳

SQL Intro

Avatar for Nedval Nedval
September 24, 2013
Technology
0
100

SQL Intro

Avatar for Nedval

Nedval

September 24, 2013
Tweet

More Decks by Nedval

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

Other Decks in Technology

See All in Technology
New Relic 1 年生の振り返りと Cloud Cost Intelligence について #NRUG
Avatar for PLAY, inc. play_inc
0
180
Amazon Connect アップデート！ AIエージェントにMCPツールを設定してみた！
Avatar for Yosuke Suzuki ysuzuki
0
120
AWS re:Invent 2025 re:Cap LT大会 データベース好きが語る re:Invent 2025 データベースアップデート/セッションの紹介
Avatar for Cold-Airflow coldairflow
0
150
Bedrock AgentCore Evaluationsで学ぶLLM as a judge入門
Avatar for ShichijoYuhi shichijoyuhi
0
130
20251222_next_js_cache__1_.pdf
Avatar for sutetotanuki sutetotanuki
0
130
シニアソフトウェアエンジニアになるためには
Avatar for KNOWLEDGE WORK / 株式会社ナレッジワーク kworkdev
PRO
3
230
2025年 開発生産「可能」性向上報告 サイロ解消からチームが能動性を獲得するまで/ 20251216 Naoki Takahashi
Avatar for SHIFT EVOLVE shift_evolve
PRO
2
210
AI時代の新規LLMプロダクト開発: Findy Insightsを3ヶ月で立ち上げた舞台裏と振り返り
Avatar for Dakuon dakuon
0
400
_第4回__AIxIoTビジネス共創ラボ紹介資料_20251203.pdf
Avatar for AIxIoTビジネス共創ラボ iotcomjpadmin
0
110
SQLだけでマイグレーションしたい！
Avatar for MakKi makki_d
0
1.2k
ハッカソンから社内プロダクトへ AIエージェント「ko☆shi」開発で学んだ4つの重要要素
Avatar for そのだ sonoda_mj
6
1.4k
AWSインフルエンサーへの道 / load of AWS Influencer
Avatar for WHIsaiyo whisaiyo
0
190

Featured

See All Featured
Future Trends and Review - Lecture 12 - Web Technologies (1019888BNR)
Avatar for Beat Signer signer
PRO
0
3.1k
GitHub's CSS Performance
Avatar for Jon Rohan jonrohan
1032
470k
Save Time (by Creating Custom Rails Generators)
Avatar for Garrett Dimon garrettdimon
PRO
32
1.8k
The #1 spot is gone: here's how to win anyway
Avatar for Tamara Novitovic tamaranovitovic
1
860
Agile Actions for Facilitating Distributed Teams - ADO2019
Avatar for Mark Kilby mkilby
0
88
Accessibility Awareness
Avatar for Sarah Abderemane sabderemane
0
21
Scaling GitHub
Avatar for Zach Holman holman
464
140k
How to optimise 3,500 product descriptions for ecommerce in one day using ChatGPT
Avatar for Katarina Dahlin katarinadahlin
PRO
0
3.4k
Bootstrapping a Software Product
Avatar for Garrett Dimon garrettdimon
PRO
307
120k
How to Align SEO within the Product Triangle To Get 
Buy-In & Support - #RIMC
Avatar for Aleyda Solis aleyda
1
1.3k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
Avatar for Marc Duiker marcduiker
35
2.3k
<Decoding/> the Language of Devs - We Love SEO 2024
Avatar for Nikki Halliwell nikkihalliwell
0
99

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