Adobe PDF (7.32 MB)
EPUB (17.59 MB)
Download
Table of Contents - Adobe PDF (297.55 kB)
Brochure
Download
User comments
Similar Books
Title Details:
Introduction to SQL
Other Titles: Laboratory exercises in MySQL 5.7
Authors: Loukopoulos, Thanasis
Theodoridis, Evangelos
Reviewer: Vasilakopoulos, Michail
Subject: MATHEMATICS AND COMPUTER SCIENCE > COMPUTER SCIENCE > INFORMATION MANAGEMENT > DATABASE SYSTEMS
Keywords:
Databases
MySQL
SQL
RDBMS
Description:
Abstract:
The subject of the e-book is the programming and management of relational databases using the SQL programming language. The aim of the e-book is to cover the basics of SQL and to support, both with the presentation of the corresponding theory and with the presentation of solved tasks, a first laboratory course on databases at university level. The examples, exercises as well as the assignments are done on the MySQL 5.6 relational database management system, a modern system with a wide response in the open source community. There are 14 chapters in the text and they are structured so that they can be stand-alone laboratory exercises. Each chapter has the following structure: 1) theory elements and presentation of corresponding SQL language functions/commands, 2) presentation of a solved laboratory exercise, 3) a short video lecture (~15 minutes), where the basic elements of the laboratory exercise on the MySQL 5.6 system are presented, 4) unsolved exercises which can be used for a laboratory examination. In summary, the chapters of the textbook cover the following. 5.6.6.6 Relational Database Design Theory Elements 3. Theory of Table Creation - Data Definition Language (DDL) 4. Inserting Records and Modifying Tables 5. Basic SQL Query Structure 6. Basic Set Theory Operations 7. The Operation of Concatenation 8. Enriched Queries 9. Aggregations 10. Other Set Theory Operations 11. Updating Data and Overview of Questions 12. Implementation of Stored Procedures / Use of Indexes 13. Dossiers 14. Interface with JAVA Applications.
Technical Editors: Tsoumani, Alexia
Type: Laboratory Guide
Creation Date: 14-05-2016
Item Details:
ISBN 978-960-603-473-2
License: http://creativecommons.org/licenses/by-nc-sa/3.0/gr
DOI http://dx.doi.org/10.57713/kallipos-709
Handle http://hdl.handle.net/11419/6247
Bibliographic Reference: Loukopoulos, T., & Theodoridis, E. (2016). Introduction to SQL [Laboratory Guide]. Kallipos, Open Academic Editions. https://dx.doi.org/10.57713/kallipos-709
Language: Greek
Consists of:
1. Εισαγωγή στα Συστήματα Διαχείρισης Σχεσιακών ΒΔ / MySQL 5.6
2. Στοιχεία Θεωρίας Σχεδιασμού Σχεσιακών Βάσεων Δεδομένων
3. Δημιουργία Πινάκων – Data Definition Language (DDL)
4. Εισαγωγή Εγγραφών και Τροποποίηση Πινάκων
5. Βασική Δομή SQL Ερωτήματος
6. Βασικές Πράξεις Θεωρίας Συνόλων
7. Η Πράξη της Συνένωσης
8. Εμφωλευμένα Ερωτήματα
9. Συναθροίσεις
10. Άλλες Πράξεις Θεωρίας Συνόλων
11. Ενημέρωση Δεδομένων και Συνολική Επισκόπηση Ερωτημάτων
12. Υλοποίηση Stored Procedures / Χρήση Ευρετηρίων
13. Δοσοληψίες
14. Διασύνδεση με JAVA Εφαρμογές
Number of pages 220
You can also view
User comments
There are no published comments available!