Adobe PDF (8.66 MB)
Table of Contents - Adobe PDF (297.65 kB)
EPUB (17.59 MB)
Download
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 > > >
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 an academic 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 in such a way so that they can be stand-alone as 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: Attribution - NonCommercial - ShareAlike 4.0 International (CC BY-NC-SA 4.0)
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. Introduction to Relational Database Management Systems / MySQL 5.6
2. Elements of Relational Database Design Theory
3. Creation of Tables - Data Definition Language (DDL)
4. Inserting Records and Modifying Tables
5. Basic SQL Query Structure
6. Baisc Operations of Set Theory
7. The Act of Union
8. Nested Queries
9. Gatherings
10. Other Set Theory Works
11. Data Update and Overall Query Overview
12. Implementing Stored Procedures / Using Indexes
13. Transactions
14. Interfacing with JAVA Applications
Number of pages 269
Publication Origin: Kallipos, Open Academic Editions
You can also view
User comments
There are no published comments available!