SQL Tutorial/ja

From SQLZOO
Jump to navigation Jump to search
Language:Project:Language policy English  • 日本語 • 中文

チュートリアル: 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
ここでは学科の教員について見ていく。previously Scottish Parliament
8+ Numeric Examples
In which we look at a survey and deal with some more complex calculations.
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