Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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
54
C 程式語言 I
Avatar for Nedval nedval
0
110
軟體測試與驗證—CI & CU
Avatar for Nedval nedval
0
83

Other Decks in Technology

See All in Technology
第４回Snowflake 金融ユーザー会 Snowflake summit recap
Avatar for Makoto tamaoki
1
330
20250708オープンエンドな探索と知識発見
Avatar for Sakana AI sakana_ai
PRO
4
660
LLM時代の検索
Avatar for shibuiwilliam shibuiwilliam
2
620
SREの次のキャリアの道しるべ 〜SREがマネジメントレイヤーに挑戦して、 気づいたこととTips〜
Avatar for coconala_engineer coconala_engineer
1
840
Delta airlines®️ USA Contact Numbers: Complete 2025 Support Guide
Avatar for ape1422 airtravelguide
0
350
QuickSight SPICE の効果的な運用戦略～S3 + Athena 構成での実践ノウハウ～/quicksight-spice-s3-athena-best-practices
Avatar for emi emiki
0
250
AWS CDKの仕組み / how-aws-cdk-works
Avatar for k.goto gotok365
10
770
DatabricksにOLTPデータベース『Lakebase』がやってきた！
Avatar for Takeru Ino inoutk
0
150
united airlines ™®️ USA Contact Numbers: Complete 2025 Support Guide
Avatar for yasam flyunitedhelp
1
470
20250707-AI活用の個人差を埋めるチームづくり
Avatar for shnjtk shnjtk
6
4.1k
ポストコロナ時代の SaaS におけるコスト削減の意義
Avatar for izzii izzii
1
190
Four Keysから始める信頼性の改善 - SRE NEXT 2025
Avatar for ozaki-kota ozakikota
0
160

Featured

See All Featured
Save Time (by Creating Custom Rails Generators)
Avatar for Garrett Dimon garrettdimon
PRO
31
1.3k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
Avatar for Rebecca Miller-Webster rmw
34
3.1k
VelocityConf: Rendering Performance Case Studies
Avatar for Addy Osmani addyosmani
332
24k
Designing for Performance
Avatar for Lara Hogan lara
610
69k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
Avatar for soudai sone soudai
PRO
181
54k
The Web Performance Landscape in 2024 [PerfNow 2024]
Avatar for Tammy Everts tammyeverts
8
700
Git: the NoSQL Database
Avatar for Brandon Keepers bkeepers
PRO
430
65k
Automating Front-end Workflow
Avatar for Addy Osmani addyosmani
1370
200k
Optimizing for Happiness
Avatar for Tom Preston-Werner mojombo
379
70k
Why Our Code Smells
Avatar for Brandon Keepers bkeepers
PRO
336
57k
Building Flexible Design Systems
Avatar for Yesenia Perez-Cruz yeseniaperezcruz
328
39k
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
Avatar for Tammy Everts tammyeverts
53
2.9k

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