|
Size: 1781
Comment:
|
Size: 1701
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 5: | Line 5: |
| * If you want to perform practical exercises on database design and programming you can obtain an account on our MariaDB (a MySQL open source fork) database server. Get in touch with ISG.EE (e-mail to support@ee.ethz.ch) and let us know what your plans are. The URI of our database server is {{{remi.ee.ethz.ch}}}. MariaDB runs on the default TCP port 3306. Besides the basic MariaDB SQL service, we provide a [[https://mysql.ee.ethz.ch/|phpMyAdmin]] WebUI for queries and database management. [[https://mariadb.org/|MariaDB]] is a multi-user, multi-threaded and (mostly) MySQL-compatible database server. It consists of the server daemon {{{mysqld}}} and of a bunch of different client programs and libraries. ANSI-SQL, a declarative language, is the standard for most relational databases and it is the most popular database language in the world. It consists of DML (data manipulation language, e.g. data queries, -updates, -inserts, -deletes), DDL (data definition language, e.g. table creation, -alteration, -removal) and DCL elements (data control language, e.g. granting and revoking permissions). MariaDB also supports transactions, indexes, (foreign) key constraints, stored procedures and so on. | * If you want to perform practical exercises on database design and programming you can obtain an account on our MariaDB (a MySQL open source fork) database server. Get in touch with ISG.EE (e-mail to support@ee.ethz.ch) and let us know what your plans are. ANSI-SQL, a declarative language, is the standard for most relational databases and it is the most popular database language in the world. It consists of DML (data manipulation language, e.g. data queries, -updates, -inserts, -deletes), DDL (data definition language, e.g. table creation, -alteration, -removal) and DCL elements (data control language, e.g. granting and revoking permissions). MariaDB also supports transactions, indexes, (foreign) key constraints, stored procedures and so on. * Besides the basic MariaDB SQL service, we provide a [[https://mysql.ee.ethz.ch/|phpMyAdmin]] WebUI for queries and database management. [[https://mariadb.org/|MariaDB]] is a multi-user, multi-threaded and (mostly) MySQL-compatible database server. It consists of the server daemon {{{mysqld}}} and of a bunch of different client programs and libraries. |
| Line 9: | Line 11: |
| * Note: All database services are accessible from the internal ETHZ networks only. The only exception is the [[https://mysql.ee.ethz.ch/|phpMyAdmin]] web interface, which can be used globally after user authentication. | * Accessibility note: All database services are accessible from the internal ETHZ networks only. The only exception is the [[https://mysql.ee.ethz.ch/|phpMyAdmin]] web interface, which can be used globally after user authentication. |
Database programming
If you want to perform practical exercises on database design and programming you can obtain an account on our MariaDB (a MySQL open source fork) database server. Get in touch with ISG.EE (e-mail to support@ee.ethz.ch) and let us know what your plans are. ANSI-SQL, a declarative language, is the standard for most relational databases and it is the most popular database language in the world. It consists of DML (data manipulation language, e.g. data queries, -updates, -inserts, -deletes), DDL (data definition language, e.g. table creation, -alteration, -removal) and DCL elements (data control language, e.g. granting and revoking permissions). MariaDB also supports transactions, indexes, (foreign) key constraints, stored procedures and so on.
Besides the basic MariaDB SQL service, we provide a phpMyAdmin WebUI for queries and database management. MariaDB is a multi-user, multi-threaded and (mostly) MySQL-compatible database server. It consists of the server daemon mysqld and of a bunch of different client programs and libraries.
As an alternative to relational databases, ISG.EE offers MongoDB, a NoSQL (nonrelational) JSON-/ object-based database especially suitable with software written in JavaScript. The service is reachable on mongodb01.ee.ethz.ch, on tcp/27017.
Accessibility note: All database services are accessible from the internal ETHZ networks only. The only exception is the phpMyAdmin web interface, which can be used globally after user authentication.