Difference between revisions of "Main Page/fr"

From SQLZOO
Jump to: navigation, search
Line 1: Line 1:
−
[[Category:Deutsch]]
+
<p class=slogan><span>Learn about:</span> SQL Server, Oracle, MySQL, DB2, <span>and</span> PostgreSQL.</p>
−
<p class=slogan><span>Apprendre SQL avec</span> SQL Server, Oracle, MySQL, DB2 <span>et</span> PostgreSQL.</p>
+
−
__NOTOC__
+
−
=== <span style="color:#ee8301;">Attention: Cette page est en cours de traduction.</span> ===
+
  
 
<div class=tutblock>
 
<div class=tutblock>
−
==Tutoriels==
+
==Tutorial Section==
 
; [[SELECT bases                | 1 SELECT-bases]]: Pour commencer, quelques accès simples à la base de données.
 
; [[SELECT bases                | 1 SELECT-bases]]: Pour commencer, quelques accès simples à la base de données.
−
; [[SELECT from BBC Tutorial     | 2 SELECT from BBC]]: Übungen zum Anwenden der SELECT-Anweisung am Beispiel einer Tabelle mit Länderprofilen.
+
; [[SELECT from WORLD Tutorial|2 SELECT from World]]:In which we query the World country profile table.
−
; [[SELECT from Nobel Tutorial   | 3 SELECT from Nobel]]: Weitere SELECT-Übungen am Beispiel einer Tabelle mit Nobelpreisgewinnern.
+
; [[SELECT from Nobel Tutorial|3 SELECT from Nobel]]:Additional practice of the basic features using a table of Nobel Prize winners.
−
; [[SELECT within SELECT Tutorial | 4 Unterabfragen]]: SELECT-Abfragen können andere SELECT-Abfragen enthalten.
+
; [[SELECT within SELECT Tutorial|4 SELECT within SELECT]]:   In which we form queries using other queries.
−
; [[SUM and COUNT                 | 5 SUM und COUNT]]: Wir üben das Anwenden von Aggregatfunktionen. ([[The_nobel_table_can_be_used_to_practice_more_SUM_and_COUNT_functions.|weitere Übungen]])
+
; [[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]]
−
; [[The JOIN operation           | 6 Tabellenverbund (Join)]]: In diesem Tutorium werden Tabellen am Beispiel einer Fussball-Datenbank verknüpft. ([[Music_Tutorial |ehem. Musik-Tutorium]])
+
; [[The JOIN operation|6 JOIN]]:   In which we join two tables; game and goals. [[Music_Tutorial |previously music tutorial]]
−
; [[More JOIN operations         | 7 Weitere Join-Operationen]]: In diesem Beispiel werden Tabellen einer Film-Datenbank miteinander verknüpft.
+
; [[More JOIN operations|7 More JOIN operations]]:   In which we join actors to movies in the Movie Database.
−
; [[Using Null                   | 8 NULL-Werte]]: Wir zeigen die Arbeit mit sog. Null-Werten am Beispiel einer Lehrer-Datenbank. ([[Scottish_Parliament |ehem. Beispiel Schottisches Parlament]])
+
; [[Using Null|8 Using Null]]:   In which we look at teachers in departments. [[Scottish_Parliament |previously Scottish Parliament]]
−
; [[Self join                     | 9 Self-Join]]: Am Beispiel der Busstrecken in Edinburgh schauen wir uns an, wie Tabellen mit sich selbst verknüpft werden.
+
; [[NSS Tutorial|8+ Numeric Examples]]:    In which we look at a survey and deal with some more complex calculations.
−
; [[Tutorial_Quizzes             |10 Quiz]]: Teste dein Wissen (Multiple-Choice-Fragen)
+
; [[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
 
</div>
 
</div>
 
<div class='refblock'>
 
<div class='refblock'>
  
−
==Referenzen / Kurzanleitungen==
+
==Reference Section: how to...==
 
;1 [[SELECT Reference|SELECT]]
 
;1 [[SELECT Reference|SELECT]]
−
:    Zeigt, wie man Daten aus einer Datenbank abfragt.  
+
:    How to read the data from a database.  
−
;2 [[CREATE and DROP Reference|CREATE und DROP]]
+
;2 [[CREATE and DROP Reference|CREATE and DROP]]
−
:    Zeigt, wie man Tabellen, Indizes, externe Sichten (Views) und andere Datenbankobjekte erstellt, ändert und wie man sie wieder los wird.
+
:    How to create tables, indexes, views and other things. How to get rid of them.
−
;3 [[INSERT and DELETE Reference|INSERT und DELETE]]
+
;3 [[INSERT and DELETE Reference|INSERT and DELETE]]
−
:    Zeigt, wie man Zeilen in eine Tabelle einfügt, sie ändert und wie man sie wieder entfernt.
+
:    How to put records into a table, change them and how to take them out again.
−
;4 [[DATE and TIME Reference|DATE und TIME]]
+
;4 [[DATE and TIME Reference|DATE and TIME]]
−
:    Zeigt, wie man mit Datums- und Zeitwerten arbeitet, wie man mit ihnen Berechnungen durchführt und wie sie formatiert werden.
+
:    How to work with dates; adding, subtracting and formatting.
−
;5 [[Functions Reference|Funktionen]]
+
;5 [[Functions Reference|Functions]]
−
:    Zeigt, wie man Zeichenkettenfunktionen, logische Funktionen und mathematische Funktionen verwendet.
+
:    How to use string functions, logical functions and mathematical functions.
−
;6 [[Users Reference|Benutzer und Prozesse]]
+
;6 [[Users Reference|Users]]
−
:    Zeigt, wie man Datenbankbenutzer definiert, ihnen Zugriffsberechtigungen zuweist bzw. entzieht und wie man auf Tabellen anderer Benutzer zugreift. Zeigt, wie man Systemprozesse findet und sie beendet.
+
:    How to create users, GRANT and DENY access, get at other peoples tables. How to find processes and kill them.
−
;7 [[Meta Data Reference|Metadaten]]
+
;7 [[Meta Data Reference|Meta Data]]
−
:    Zeigt, wie man herausfindet, welche Tabellen und Spalten in der Datenbank existieren. Zeigt, wie man Zeilen zählt und deren Anzahl begrenzt.
+
:    How to find out what tables and columns exist. How to count and limit the rows return.
−
;8 [[Hacks Reference|Tipps und Tricks]]
+
;8 [[Hacks Reference|SQL Hacks]]
−
:  
+
:  
 
</div>
 
</div>
 
<div class='resblock'>
 
<div class='resblock'>
−
==SQL-Ressourcen==
+
==SQL Resources==
−
;SQL-Handbücher: [ [http://developer.mimer.com/documentation/html_100/Mimer_SQL_Engine_DocSet/index.htm Mimer] | [https://dev.mysql.com/doc/refman/5.5/en/select.html MySQL] | [http://docs.oracle.com/cd/E11882_01/server.112/e26088/toc.htm Oracle] | [http://msdn.microsoft.com/de-de/library/bb510741%28v=sql.105%29 SQL Server] | [http://technet.microsoft.com/de-de/office/gg406142.aspx Access] | [http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.sql.ref.doc/doc/c0004100.html  DB2] | [http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32300.1570/html/sqlug/X27694.htm  Sybase] | [http://www.postgresql.org/docs/current/static/index.html PostgreSQL] | [http://www.sqlite.org/lang.html SQLite] ]
+
;SQL User Manuals: [http://developer.mimer.com/documentation/html_92/Mimer_SQL_Engine_DocSet/Mimer_SQL_Engine.htm Mimer][http://dev.mysql.com/doc/refman/5.1/en/select.html MySQL] [http://docs.oracle.com/cd/B28359_01/server.111/b28286/toc.htm Oracle] [http://msdn.microsoft.com/en-us/library/ms189826%28v=sql.90%29.aspx SQL Server] [http://office.microsoft.com/en-us/assistance/CH062526881033.aspx Access] [http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp DB2] [http://sybooks.sybase.com/sybooks/sybooks.xhtml Sybase] [http://www.postgresql.org/docs/current/static/index.html Postgres] [http://www.sqlite.org/lang.html SQLite]
−
:Online-Versionen der entspr. SQL-Handbücher, sofern verfügbar in Deutsch.
+
:Online copies of implementation specific user manuals.
−
;Mit einem DBMS arbeiten:    [ [[Starting MySQL|MySQL]] | [[Starting Oracle|Oracle]] | [[Starting SQL Server|SQL Server]] | [[Starting DB2|DB2]] | [[Starting Postgres|PostgreSQL]] | [[Starting Ingres|Ingres]] ]
+
;Starting SQL:    [ [[Starting MySQL|MySQL]] | [[Starting Oracle|Oracle]] | [[Starting SQL Server|SQL Server]] | [[Starting DB2|DB2]] | [[Starting Postgres|Postgres]] | [[Starting Ingres|Ingres]] ]
−
:Erklärt, wie man eine Verbindung zum Datenbankserver aufbaut und SQL-Anweisungen ausführt.
+
:   How to connect to the server and execute SQL statements.
−
;Programmieren mit SQL: [ [[SQL in perl on the Web | SQL und Perl]] | [[SQL from Java | SQL und Java]] ]
+
;Programming with SQL:   [ [[SQL in perl on the Web]] | [[SQL from Java]] ]
−
;SQL-Syntax: [ [[SQL92 BNF]] ]
+
;Error Messages
−
;Fehlermeldungen
+
:   [[SQL Error Messages|Some error messages from SQL engines]]
−
:[[SQL Error Messages | Ausgewählte Fehlermeldungen verschiedener Datenbanksysteme]]
+
;Temporary Assessment section, before the main menu is finished.
−
;Temporärer Bereich für Prüfungsfragen. Wird geändert, wenn Hauptmenü funktioniert.
+
:[[Assessment Temp]]
−
:[[Assessment Temp |Prüfungsfragen (temp.)]]
+
 
</div>
 
</div>
 
<div style= "    background:#FFC694;
 
<div style= "    background:#FFC694;
Line 56: Line 53:
 
     border-radius:2em;
 
     border-radius:2em;
 
     padding: 0.5em 2em;
 
     padding: 0.5em 2em;
−
     clear:both;">
+
    display: block;
−
<p>'''Was hälst Du vom neuen Layout der SQLZoo-Seiten?'''
+
    margin: 2em 1em 1em -.5em;
−
Bitte teile uns Deine Meinung mit: [mailto:sqlzoo.qa@gmail.com sqlzoo.qa@gmail.com]<br />
+
     clear:both;
−
Die Originalseiten sind nach wie vor erreichbar unter http://old.sqlzoo.net (Englisch) bzw. http://sqlzoo.net/de/ (Deutsch).</p>
+
    width:52em;">
 +
<p>'''What do you think of the new layout of SQLZoo?'''
 +
Please share your opinion with us: [mailto:sqlzoo.qa@gmail.com sqlzoo.qa@gmail.com]<br />
 +
The  original site is still available at http://old.sqlzoo.net</p>
 
</div>
 
</div>
−
 
+
<div style="margin-left:1em">
 +
[[To do list]]
 +
</div>
 +
<!--
 
{{Languages}}
 
{{Languages}}
 +
-->

Revision as of 13:32, 20 December 2012

Learn about: SQL Server, Oracle, MySQL, DB2, and PostgreSQL.

Tutorial Section

1 SELECT-bases
Pour commencer, quelques accès simples à la base de données.
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 JOIN
In which we join two tables; game and goals. previously music tutorial
7 More JOIN operations
In which we join 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 join
In which we join Edinburgh bus routes to Edinburgh bus routes.
10 Tutorial Quizzes
Test your knowledge with multiple choice quizzes

Reference Section: 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 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

SQL Resources

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

What do you think of the new layout of SQLZoo? Please share your opinion with us: sqlzoo.qa@gmail.com
The original site is still available at http://old.sqlzoo.net

To do list

Retrieved from "http://sqlzoo.net/w/index.php?title=Main_Page/fr&oldid=5751"
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense