SQL Tutorial/ja

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 User Manuals: Mimer MySQL 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