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
Generative AI Japan 第一回生成AI実践研究会「AI駆動開発の現在地──ブレイクスルーの鍵を握るのはデータ領域」
Avatar for KoheiOgawa shisyu_gaku
0
300
会社紹介資料 / Sansan Company Profile
Avatar for Sansan, Inc. sansan33
PRO
6
380k
【実演版】カンファレンス登壇者・スタッフにこそ知ってほしいマイクの使い方 / 大吉祥寺.pm 2025
Avatar for Arthur arthur1
1
890
Platform開発が先行する Platform Engineeringの違和感
Avatar for KintoTech_Dev kintotechdev
4
580
RSCの時代にReactとフレームワークの境界を探る
Avatar for uhyo uhyo
10
3.5k
AI時代を生き抜くエンジニアキャリアの築き方 (AI-Native 時代、エンジニアという道は 「最大の挑戦の場」となる) / Building an Engineering Career to Thrive in the Age of AI (In the AI-Native Era, the Path of Engineering Becomes the Ultimate Arena of Challenge)
Avatar for JaeSoon Jeong jeongjaesoon
0
200
スマートファクトリーの第一歩 〜AWSマネージドサービスで 実現する予知保全と生成AI活用まで
Avatar for wanda ganota
2
240
Modern Linux
Avatar for oracle4engineer oracle4engineer
PRO
0
140
「何となくテストする」を卒業するためにプロダクトが動く仕組みを理解しよう
Avatar for kawabeaver kawabeaver
0
420
2つのフロントエンドと状態管理
Avatar for MIXI ENGINEERS mixi_engineers
PRO
3
110
【初心者向け】ローカルLLMの色々な動かし方まとめ
Avatar for Aratako aratako
7
3.5k
新アイテムをどう使っていくか？みんなであーだこーだ言ってみよう / 20250911-rpi-jam-tokyo
Avatar for Akira Ouchi akkiesoft
0
300

Featured

See All Featured
How To Stay Up To Date on Web Technology
Avatar for Chris Coyier chriscoyier
790
250k
Designing for Performance
Avatar for Lara Hogan lara
610
69k
Writing Fast Ruby
Avatar for Erik Berlin sferik
628
62k
Understanding Cognitive Biases in Performance Measurement
Avatar for Philip Tellis bluesmoon
29
1.9k
Save Time (by Creating Custom Rails Generators)
Avatar for Garrett Dimon garrettdimon
PRO
32
1.6k
Producing Creativity
Avatar for Steve Smith orderedlist
PRO
347
40k
Building a Modern Day 
E-commerce SEO Strategy
Avatar for Aleyda Solis aleyda
43
7.6k
The MySQL Ecosystem @ GitHub 2015
Avatar for Sam Lambert samlambert
251
13k
Code Reviewing Like a Champion
Avatar for maltzj maltzj
525
40k
Product Roadmaps are Hard
Avatar for C. Todd Lombardo iamctodd
PRO
54
11k
Context Engineering - Making Every Token Count
Avatar for Addy Osmani addyosmani
3
51
Fashionably flexible responsive web design (full day workshop)
Avatar for Andy Clarke malarkey
407
66k

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