Difference between revisions of "SQL Tutorial/ja"

From SQLZOO
Jump to navigation Jump to search
 
(15 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
__NOTOC__
 
__NOTOC__
<div style='position:absolute;right:5px'>{{Languages}}</div>
+
{{DISPLAYTITLE:SQL Zooへようこそ}}
<p class=slogan><span>SQL Server, Oracle, MySQL, DB2, PostgreSQL を使って SQL を学ぶ</span></p>
+
<div>SQL学習者のための実践練習と問題シリーズ {{Languages|SQL_Tutorial}}</div>
 
+
==フランスの首都は?==
 +
<div class='qu nonum'>
 +
<source lang='sql' class='def'>
 +
SELECT capital
 +
  FROM world
 +
WHERE name = 'France'
 +
</source>
 +
<div>
 +
あなたは首都<code>capital</code>や大陸<code>continent</code>や<code>population</code>人口を問えます。
 +
</div>
 +
<div>他の国も選べます。</div>
 +
</div>
 
<div class=tutblock>
 
<div class=tutblock>
==チュートリアル: SQL の学習ステージ==
+
==チュートリアル: SQL学習ステージ==
; [[SELECT basics|0 SELECT basics]]:手始めの簡単なクエリー
+
; [[SELECT basics/ja|0 SELECT basics]]:手始めの簡単なクエリー
; [[SELECT names|1 SELECT name]]:パターンマッチのクエリー
+
; [[SELECT names/ja|1 SELECT name]]:パターンマッチのクエリー
; [[SELECT from WORLD Tutorial|2 SELECT from World]]:世界各国のプロフィールのテーブルのクエリー
+
; [[SELECT from WORLD Tutorial/ja|2 SELECT from World]]:世界各国のプロフィールのテーブルのクエリー
; [[SELECT from Nobel Tutorial|3 SELECT from Nobel]]:ノーベル賞の授賞者のテーブルを使った基本事項の追加練習
+
; [[SELECT from Nobel Tutorial/ja|3 SELECT from Nobel]]:ノーベル賞の授賞者のテーブルを使った基本事項の追加練習
; [[SELECT within SELECT Tutorial|4 SELECT within SELECT]]:    クエリーを他のクエリーの中で使う
+
; [[SELECT within SELECT Tutorial/ja|4 SELECT within SELECT]]:    クエリーを他のクエリーの中で使う
; [[SUM and COUNT|5 SUM and COUNT]]:    In which we apply aggregate functions. [[The_nobel_table_can_be_used_to_practice_more_SUM_and_COUNT_functions.|more the same]]
+
; [[SUM and COUNT/ja|5 SUM and COUNT]]:    ここでは集計関数を扱う。/ さらに[[The_nobel_table_can_be_used_to_practice_more_SUM_and_COUNT_functions./ja|ノーベル賞テーブルを利用したSUMとCOUNT関数の練習も重ねて可能]]
; [[The JOIN operation|6 JOIN]]:    In which we join two tables; game and goals. [[Music_Tutorial |previously music tutorial]]
+
; [[The JOIN operation/ja|6 JOIN]]:    ここではgameとgoalsの2つのテーブルを結合する。/ [[Music_Tutorial/ja |以前の音楽チュートリアル]]はこちらに
; [[More JOIN operations|7 More JOIN operations]]:    In which we join actors to movies in the Movie Database.
+
; [[More JOIN operations/ja|7 More JOIN operations]]:    ここではMovieデータベースのactorsとmoviesを結合する
 
; [[Using Null|8 Using Null]]:    In which we look at teachers in departments. [[Scottish_Parliament |previously Scottish Parliament]]
 
; [[Using Null|8 Using Null]]:    In which we look at teachers in departments. [[Scottish_Parliament |previously Scottish Parliament]]
 
; [[NSS Tutorial|8+ Numeric Examples]]:    In which we look at a survey and deal with some more complex calculations.
 
; [[NSS Tutorial|8+ Numeric Examples]]:    In which we look at a survey and deal with some more complex calculations.
 +
; [[Window functions|9- Window function]]:    In which we examine UK general election results.
 +
; [[Window LAG|9+ COVID 19]]:    In which we measure the impact of COVID-19
 
; [[Self join|9 Self join]]:    In which we join Edinburgh bus routes to Edinburgh bus routes.
 
; [[Self join|9 Self join]]:    In which we join Edinburgh bus routes to Edinburgh bus routes.
 
; [[Tutorial_Quizzes|10 Tutorial Quizzes]]:    Test your knowledge with multiple choice quizzes
 
; [[Tutorial_Quizzes|10 Tutorial Quizzes]]:    Test your knowledge with multiple choice quizzes
Line 44: Line 57:
 
;10 [[Transactions|An introduction to transactions]]
 
;10 [[Transactions|An introduction to transactions]]
 
:  Video tutorials showing how sessions can interfere with each other and how to stop it.
 
:  Video tutorials showing how sessions can interfere with each other and how to stop it.
;11 [[SQL with C#|Using SQL with C# in Visual Studio]]
+
;11 [[SQL with CS|Using SQL with C#]]
Video tutorials showing how to connect to a database in Visual Studio.
+
Code to connect to a database in Visual Studio.
  
 
</div>
 
</div>
Line 93: Line 106:
 
{{Languages}}
 
{{Languages}}
 
-->
 
-->
 +
<div>This server is hosted by Edinburgh Napier University https://napier.ac.uk</div>

Latest revision as of 19:07, 6 June 2021


SQL学習者のための実践練習と問題シリーズ
Language:Project:Language policy English  • 日本語 • 中文

フランスの首都は?

SELECT capital
  FROM world
 WHERE name = 'France'

あなたは首都capitalや大陸continentpopulation人口を問えます。

他の国も選べます。

チュートリアル: SQL学習ステージ

0 SELECT basics
手始めの簡単なクエリー
1 SELECT name
パターンマッチのクエリー
2 SELECT from World
世界各国のプロフィールのテーブルのクエリー
3 SELECT from Nobel
ノーベル賞の授賞者のテーブルを使った基本事項の追加練習
4 SELECT within SELECT
クエリーを他のクエリーの中で使う
5 SUM and COUNT
ここでは集計関数を扱う。/ さらにノーベル賞テーブルを利用したSUMとCOUNT関数の練習も重ねて可能
6 JOIN
ここではgameとgoalsの2つのテーブルを結合する。/ 以前の音楽チュートリアルはこちらに
7 More JOIN operations
ここではMovieデータベースのactorsとmoviesを結合する
8 Using Null
In which we look at teachers in departments. previously Scottish Parliament
8+ Numeric Examples
In which we look at a survey and deal with some more complex calculations.
9- Window function
In which we examine UK general election results.
9+ COVID 19
In which we measure the impact of COVID-19
9 Self join
In which we join Edinburgh bus routes to Edinburgh bus routes.
10 Tutorial Quizzes
Test your knowledge with multiple choice quizzes
11 Tutorial Student Records
Creating a database
12 Tutorial DDL
Instructions on how to import data and analyse it in mysql

リファレンス: ハウツー...

1 SELECT
How to read the data from a database.
2 CREATE and DROP
How to create tables, indexes, views and other things. How to get rid of them.
3 INSERT and DELETE
How to put records into a table, change them and how to take them out again.
4 DATE and TIME
How to work with dates; adding, subtracting and formatting.
5 Functions
How to use string functions, logical functions and mathematical functions.
6 Users
How to create users, GRANT and DENY access, get at other peoples tables. How to find processes and kill them.
7 Meta Data
How to find out what tables and columns exist. How to count and limit the rows return.
8 SQL Hacks
Some SQL Hacks, taken from "SQL Hacks" published by O'Reilly
9 Using SQL with PHP on Amazon EC2 servers
Video tutorials showing how to run MySQL, PHP and Apache on Amazon's EC2 cloud servers.
Simpler instructions for students following module INF08104 at Edinburgh Napier University
10 An introduction to transactions
Video tutorials showing how sessions can interfere with each other and how to stop it.
11 Using SQL with C#
Code to connect to a database in Visual Studio.

宿題: 自信のある利用者向けの関連サンプル

Each assessment includes 15 questions graded easy, medium and hard.

Module Feedback
Responses from students on their learning experience.
Help Desk
Calls to a support desk
Guest House
Managing bookings for a hotel
Adventure Works
An example based on a wholesaler (based on MicroSoft's sample database)
University Timetables
Schedules for lectures and tutorials
Musicians
Bands, Concerts, Performances
Dressmaker
Making and ordering dresses
Congestion Charging
Monitoring and charging cars going in and out of London

チャレンジ問題

SQL リファレンス

SQL User Manuals
MimerMySQL Oracle SQL Server Access DB2 Sybase Postgres SQLite
Online copies of implementation specific user manuals.
Starting SQL
[ MySQL | Oracle | SQL Server | DB2 | Postgres | Ingres ]
How to connect to the server and execute SQL statements.
Programming with SQL
[ SQL in perl on the Web | SQL from Java ]
Error Messages
Some error messages from SQL engines
Temporary Assessment section, before the main menu is finished.
Assessment Temp

To do list

This server is hosted by Edinburgh Napier University https://napier.ac.uk