Title Details: | |
Databases, Data Warehouses and Data Mining |
|
Other Titles: |
Laboratory guide |
Authors: |
Symeonidis, Panagiotis Gounaris, Anastasios |
Reviewer: |
Theodoridis, Ioannis |
Subject: | MATHEMATICS AND COMPUTER SCIENCE > > > MATHEMATICS AND COMPUTER SCIENCE > > > |
Keywords: |
Data Bases
Data Warehouses Data Mining SQL Server |
Description: | |
Abstract: |
The book is a complete lab guide for SQL Server. It consists of two parts, of which the first part deals with the database subject, while the second part deals with the subject of Warehousing and Data Mining. The first part of the book describes the basic functions and capabilities offered by a database management system. Specifically, it describes the features of SQL Server 2014 Management Studio in five chapters. SQL Server is a powerful tool that contains a multitude of capabilities, including Data Definition Language commands, Data Manipulation Language commands, and the Transact-SQL programming language for creating stored procedures, triggers, and transactions. Each of the five chapters in the first part of the book describes one of these SQL Server features in detail. The second part of the book describes basic data mining techniques and the process of creating cubes in data warehouses. The second part of the book describes these techniques through the use of SQL Server 2014 Business Intelligence. Specifically, the five chapters in the second part describe mining techniques such as decision trees, clustering, association rules, and time series. Finally, data warehouses are discussed in the last chapter of the book.
|
Type: |
Laboratory Guide |
Creation Date: | 10-11-2015 |
Item Details: | |
ISBN |
978-960-603-021-5 |
License: |
Attribution – NonCommercial – NoDerivatives 4.0 International (CC BY-NC-ND 4.0) |
DOI | http://dx.doi.org/10.57713/kallipos-888 |
Handle | http://hdl.handle.net/11419/276 |
Bibliographic Reference: | Symeonidis, P., & Gounaris, A. (2015). Databases, Data Warehouses and Data Mining [Laboratory Guide]. Kallipos, Open Academic Editions. https://dx.doi.org/10.57713/kallipos-888 |
Language: |
Greek |
Consists of: |
1. SQL Server Installation and Environment 2. Creation of Database and Tables 3. SQL Queries 4. Advances features in SQL Server 5. Creating forms for the DVDclub database 6. Data Preperation for the Mining Process 7. Data Classification with Decison Trees 8. Data grouping 9. Export Association Rules 10. Time Series 11. Data warehouses and cubes |
Number of pages |
348 |
Publication Origin: |
Kallipos, Open Academic Editions |
You can also view | |
User comments | |
There are no published comments available! | |