Table of Contents - Adobe PDF (276.59 kB)
Adobe PDF (16.75 MB)
ZIP (29.36 MB)
Download
Brochure
Download
User comments
Similar Books
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!