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! | |