Difference between revisions of "Main Page/fr"

From SQLZOO
Jump to: navigation, search
 
(12 intermediate revisions by 3 users not shown)
Line 1: Line 1:
__NOTOC__
+
<p class=slogan><span>Apprenez </span> SQL Server, Oracle, MySQL, DB2, <span>et</span> PostgreSQL.</p>
=== <span style="color:red;">This page is just a placeholder to test the language selection box at the bottom of this page. If you want to do a French translation of the Wiki pages, please feel free to do it.</span> ===
+
 
+
 
+
<p class=slogan><span>SQL apprendre par:</span> SQL Server, Oracle, MySQL, DB2, <span>et</span> PostgreSQL.</p>
+
  
 
<div class=tutblock>
 
<div class=tutblock>
==Section tutoriel==
+
==Tutorial Section==
...
+
; [[SELECT bases                | 1 SELECT-bases]]: Pour commencer, quelques accès simples à la base de données.
 +
; [[SELECT from MONDE|2 SELECT from Monde]]:Dans cette partie, on interroge la table contenant des données sur les pays.
 +
; [[SELECT from Nobel|3 SELECT from Nobel]]:Un peu de pratique supplémentaire d'utilisation des commandes de base de SQL sur la table des lauréats des Prix Nobel.
 +
; [[SELECT within SELECT Tutorial|4 SELECT within SELECT]]:    In which we form queries using other queries.
 +
; [[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 JOIN]]:    In which we join two tables; game and goals. [[Music_Tutorial |previously music tutorial]]
 +
; [[More JOIN operations|7 More JOIN operations]]:    In which we join actors to movies in the Movie Database.
 +
; [[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.
 +
; [[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'>
  
==Section de référence==
+
==Reference Section: how to...==
...
+
;1 [[SELECT Reference|SELECT]]
 +
:    How to read the data from a database.  
 +
;2 [[CREATE and DROP Reference|CREATE and DROP]]
 +
:    How to create tables, indexes, views and other things. How to get rid of them.
 +
;3 [[INSERT and DELETE Reference|INSERT and DELETE]]
 +
:    How to put records into a table, change them and how to take them out again.
 +
;4 [[DATE and TIME Reference|DATE and TIME]]
 +
:    How to work with dates; adding, subtracting and formatting.
 +
;5 [[Functions Reference|Functions]]
 +
:    How to use string functions, logical functions and mathematical functions.
 +
;6 [[Users Reference|Users]]
 +
:    How to create users, GRANT and DENY access, get at other peoples tables. How to find processes and kill them.
 +
;7 [[Meta Data Reference|Meta Data]]
 +
:    How to find out what tables and columns exist. How to count and limit the rows return.
 +
;8 [[Hacks Reference|SQL Hacks]]
 +
 
</div>
 
</div>
 
<div class='resblock'>
 
<div class='resblock'>
==Resources SQL==
+
==SQL Resources==
...
+
;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 copies of implementation specific user manuals.
 +
;Starting SQL:    [ [[Starting MySQL|MySQL]] | [[Starting Oracle|Oracle]] | [[Starting SQL Server|SQL Server]] | [[Starting DB2|DB2]] | [[Starting Postgres|Postgres]] | [[Starting Ingres|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
 +
:    [[SQL Error Messages|Some error messages from SQL engines]]
 +
;Temporary Assessment section, before the main menu is finished.
 +
:[[Assessment Temp]]
 
</div>
 
</div>
 
<div style= "    background:#FFC694;
 
<div style= "    background:#FFC694;
Line 24: Line 53:
 
     border-radius:2em;
 
     border-radius:2em;
 
     padding: 0.5em 2em;
 
     padding: 0.5em 2em;
     clear:both;">
+
    display: block;
<p>'''Que pensez-vous de ...'''</p>
+
    margin: 2em 1em 1em -.5em;
 +
     clear:both;
 +
    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}}
 +
-->

Latest revision as of 14:26, 20 December 2012

Apprenez SQL Server, Oracle, MySQL, DB2, et PostgreSQL.

[edit] Tutorial Section

1 SELECT-bases
Pour commencer, quelques accès simples à la base de données.
2 SELECT from Monde
Dans cette partie, on interroge la table contenant des données sur les pays.
3 SELECT from Nobel
Un peu de pratique supplémentaire d'utilisation des commandes de base de SQL sur la table des lauréats des Prix Nobel.
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

[edit] 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

[edit] 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

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense