Sqlzoo 5l5rz

9/3/2017

SQLZOO

SQL Tutorial From SQLZOO Learn SQL using: SQL Server, Oracle, MySQL, DB2, and PostgreSQL.

Language:

English • 中文

Tutorials: Learn SQL in stages 0 SELECT basics Some simple queries to get you started 1 SELECT name Some pattern matching queries 2 SELECT from World In which we query the World country profile table. 3 SELECT from Nobel Additional practice of the basic features using a table of Nobel Prize winners. 4 SELECT within SELECT In which we form queries using other queries. 5 SUM and COUNT In which we apply aggregate functions. more the same 6 In which we two tables; game and goals. previously music tutorial 7 More operations In which we actors to movies in the Movie Database. 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 Self In which we 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

Reference: how to... 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 s How to create s, 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. 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# in Visual Studio Video tutorials showing how to connect to a database in Visual Studio.

Assessments: More involved examples for confident s Each assessment includes 15 questions graded easy, medium and hard. Module Responses from students on their learning experience. Help Desk Calls to a 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 http://sqlzoo.net//

1/2

9/3/2017

SQLZOO

Bands, Concerts, Performances Dressmaker Making and ordering dresses Congestion Charging Monitoring and charging cars going in and out of London

Challenges White Christmas

SQL Resources Select Basics - Answers (http://sqlzoo.net/wiki/SELECT_basics?answer=1) Select from World - Answers (http://sqlzoo.net/wiki/SELECT_from_WORLD_Tutorial?answer=1) See if you can spot the pattern SQL Manuals Mimer (http://developer.mimer.com/documentation/html_92/Mimer_SQL_Engine_DocSet/Mimer_SQL_Engine.htm)MySQL (http://dev.mysql.com/doc/refman/5.1/e n/select.html) Oracle (http://docs.oracle.com/cd/B28359_01/server.111/b28286/toc.htm) SQL Server (http://msdn.microsoft.com/en-us/library/ms189826%28v=sql.9 0%29.aspx) Access (http://office.microsoft.com/en-us/assistance/CH062526881033.aspx) DB2 (http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp) Sybase (htt p://sybooks.sybase.com/sybooks/sybooks.xhtml) Postgres (http://www.postgresql.org/docs/current/static/index.html) SQLite (http://www.sqlite.org/lang.html) Online copies of implementation specific 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 Retrieved from "http://sqlzoo.net/w/index.php?title=SQL_Tutorial&oldid=38970"

SQL Server Protection at an enterprise and granular level Watch the free webinar now! veeam.com This page was last modified on 9 June 2017, at 11:55.

http://sqlzoo.net//

2/2