PUBLIC MARKS from cascamorto with tags sql & bases.de.donnees

Supports de Cours * Cours 1 : Introduction, HTML * Cours 2 : HTML * Cours 3 : Formulaire HTML, Javascript * Cours 4 : PHP * Cours 5 : PHP formulaires, fichiers, sessions * Cours 6 : Bases de données, Mysql * Cours 7 : PHP Mysql Sujets de TDs * TD 1 * TD 2-3 * TD 4 * TD 5 * TD 6 Sujets de TPs * Séance 1 (15/02/08) : TP 1 * Séances 2 et 3 (07/03/08, 21/03/08) : TP 2 * Séance 4 et 5 (28/03/08, 04/04/08) : TP 3 * Séance 6 (11/04/08) : exercice 2 du TD5 * Séance 7 (18/04/08) : manipulation de bases de données * Séance 8, 9 et 10 : Projet

* Présentation des Bases de Données * Schémas Entités/Associations (entités faibles) * Des schémas Entités/Relations aux schémas relationnels * Algèbre relationnelle (différence ensembles/multi-ensembles; optimisation des expressions; expressions des contraintes en algèbre;...) * DATALOG (= Prolog sans termes pour les BD) clauses, clauses sures, évalutation, récursion, * SQL (algèbre->SQL , SQL->algèbre; ensemble/multiensembles; ordre d'évaluation; ...) * Dépendances fonctionnelles, formes normales * Reprise sur panne * Gestion des transactions * Index et stockage des données

Windows CE port to the SQLite library (see http://www.sqlite.org).

Glaos is an interactive SQL tool for PocketPC. it is innovative product designed to access SQL databases from your PocketPC. Now it supports MS SQL, InterBase/Firebird and MySQL databases. Glaos MySQL Glaos is a great PocketPC isql utility which can access MS SQL, InterBase/Firebird and MySQL databases from PocketPC and run SQL queries. Go mobile with you database! Glaos is a great PocketPC isql utility which can access MS SQL, InterBase/Firebird and MySQL databases from PocketPC and run SQL queries. Go mobile with you database!

SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. Features include:

TkSQLite is a GUI database manager for SQLite implemented by Tcl/Tk. It can manage SQLite version2.8 and SQLite version3.x database. And it can handle many encodings like Shift-JIS, EUC-JP and Windows native milti-byte encodings not only UTF-8. And it can run on Windows and Linux (and maybe MacOSX ?) as native Look & Feel. And it's Freeware.

Bienvenue sur ce site consacré à un cours de bases de données relationnelles. Il propose * des documents pédagogiques (polycopié, transparents, exercices); * des exemples de code et échantillons de bases de données, * un environnement de travaux pratiques accessible via le Web, comprenant une interface de pratique du langage SQL, et une interface de gestion d'une base de données.

eSQL is a small, fast, portable and powerful embedded relational SQL database for Windows and Windows Mobile devices. Based on excellent database engine sqlite, eSQL provides rich features including: * A complete database is stored in a single cross-platform file. * No setup or administration needed. * Implements most of SQL92 standard, such as multiple tables, multiple indexes, transactions with atomic commit/ rollback, subqueries, compound queries, views, triggers. * Support for in-memory database. * Support database size up to 2 terabytes. * Very small memory footprint and faster than most popular database. * Compression for compacting database. * AES 256-bit encryption for securing data. * Native C/C or standard ODBC API is simple and easy to use. * eSQL.Net data provider for Microsoft .Net integration and rapid application development. * A cross-platform graphical database manager can be used to administer an eSQL database. * An interactive SQL command line tool is provided as an example of how to use eSQL in your application. eSQL database engine has been used by wide variety of applications. It has been included by General Dynamics for the US Navy for use onboard the DDG class of destroyers. It is also being used at Duke Energy and in other branches of the US military. If you want the convenience of SQL without the size and setup hassles of database servers for your Windows Mobile device, or if you just simply want a best MS Access replacement, eSQL is right for you!