Databaseprogrammering

Learn to create, index and query spatial databases using SQL that applies to PostgreSQL/PostGIS and more.

- A comprehensive overview of the various fields of application of data science and artificial intelligence.- Case studies from practice to make the described concepts tangible.- Practical examples to help you carry out simple data analysis projects.- BONUS in print edition: E-Book insideData Science, Big Data, Artificial Intelligence and Generative AI are currently some of the most talked-about concepts in industry, government, and society, and yet also the most misunderstood. This book will clarify these concepts and provide you with practical knowledge to apply them.Using exercises and real-world examples, it will show you how to apply data science methods, build data platforms, and deploy data- and ML-driven projects to production. It will help you understand - and explain to various stakeholders - how to generate value from such endeavors. Along the way, it will bring essential data science concepts to life, including statistics, mathematics, and machine learning fundamentals, and explore crucial topics like critical thinking, legal and ethical considerations, and building high-performing data teams.Readers of all levels of data familiarity - from aspiring data scientists to expert engineers to data leaders - will ultimately learn: how can an organization become more data-driven, what challenges might it face, and how can they as individuals help make that journey a success.The team of authors consists of data professionals from business and academia, including data scientists, engineers, business leaders and legal experts. All are members of the Vienna Data Science Group (VDSG), an NGO that aims to establish a platform for exchanging knowledge on the application of data science, AI and machine learning, and raising awareness of the opportunities and potential risks of these technologies.WHAT'S INSIDE //- Critical Thinking and Data Culture: How evidence driven decision making is the base for effective AI.- Machine Learning Fundamentals: Foundations of mathematics, statistics, and ML algorithms and architectures- Natural Language Processing and Computer Vision: How to extract valuable insights from text, images and video data, for real world applications.- Foundation Models and Generative AI: Understand the strengths and challenges of generative models for text, images, video, and more.- ML and AI in Production: Turning experimentation into a working data science product.- Presenting your Results: Essential presentation techniques for data scientists.

Welcome to "SQL Performance Tuning: Proven Strategies for Optimizing Queries." In today's data-driven world, SQL query speed and efficiency are paramount. Whether you're a seasoned database pro or just starting your SQL journey, optimizing queries is essential. This book is your comprehensive guide to mastering SQL performance tuning. It equips you with the knowledge and techniques to boost your SQL queries' speed and efficiency. We begin by exploring why SQL performance matters and introducing core optimization concepts. You'll learn to identify bottlenecks and apply essential strategies. With hands-on examples and case studies, you'll tackle real-world SQL performance challenges, covering index tuning, storage optimization, and more. "SQL Performance Tuning: Proven Strategies for Optimizing Queries." empowers you to unlock your queries' full potential, delivering faster, more efficient solutions. Get ready to elevate your SQL performance. Let's optimize your queries and excel in the world of data.

Welcome to the book "Learning SQL: Master SQL Fundamentals"! SQL (Structured Query Language) is the most powerful and widely used database management language in the world. It is an indispensable tool for anyone working with data, from beginners to experts in the fields of information technology and database administration. This book is specially designed to help you gain a deeper understanding of SQL and master its fundamental concepts. We will guide you step by step through the essential aspects of SQL, from querying data to creating and managing tables, joining tables, aggregating data, and many other aspects of this language. Whether you are a beginner looking to learn SQL or an expert looking to refresh your knowledge, "Learning SQL: Master SQL Fundamentals" is a valuable resource for you. Let's embark on the journey of exploring SQL and becoming an expert in data management and querying. We hope this book helps you build a strong foundation in this field and achieve success in your career. Enjoy your reading and find it useful!

With the shift from data warehouses to data lakes, data now lands in repositories before it's been transformed, enabling engineers to model raw data into clean, well-defined datasets. dbt (data build tool) helps you take data further. This practical book shows data analysts, data engineers, BI developers, and data scientists how to create a true self-service transformation platform through the use of dynamic SQL. Authors Rui Machado from Monstarlab and Hélder Russa from Jumia show you how to quickly deliver new data products by focusing more on value delivery and less on architectural and engineering aspects. If you know your business well and have the technical skills to model raw data into clean, well-defined datasets, you'll learn how to design and deliver data models without any technical influence. With this book, you'll learn: What dbt is and how a dbt project is structured How dbt fits into the data engineering and analytics worlds How to collaborate on building data models The main tools and architectures for building useful, functional data models How to fit dbt into data warehousing and laking architecture How to build tests for data transformations

SQL 101 Crash Course is a comprehensive beginner's guide that takes you through the world of SQL, right from understanding databases to mastering complex queries. This book is designed to provide you with a solid foundation in SQL, along with practical examples and real-world scenarios to reinforce your learning. In this book, you'll explore the key concepts of databases and their structure while getting started with SQLite Studio, a versatile SQL tool. You'll dive deep into the fundamentals of SQL queries, turning raw data into meaningful information, and working with tables, multiple tables, and their relationships.You'll also learn how to harness the power of SQL functions and subqueries to optimize your queries and retrieve data more efficiently. As you progress, you'll delve into the world of views, joins, and advanced SQL topics such as transactions, stored procedures, and performance tuning. The book concludes with two sample databases, where you'll put your newfound knowledge to the test and gain hands-on experience.This book promises a smooth learning journey for aspiring SQL developers, enabling them to build robust and efficient databases. The book's step-by-step approach ensures that even complete beginners can grasp complex concepts with ease. By the end of this book, you'll emerge as a smart SQL developer, equipped with the skills and knowledge to tackle real-world database challenges.Key LearningsMaster SQL fundamentals and best practices.Learn to create, modify, and optimize tables.Understand and implement table relationships.Execute complex queries with ease and confidence.Leverage SQL functions for powerful data manipulation.Utilize subqueries and derived tables effectively.Create and manage views for enhanced data access.Apply advanced SQL techniques for optimized performance.Hands-on experience with real-world sample databases.Begin your journey as a skilled SQL developer.Table of ContentIntroduction to Databases and SQLSetting Up Your SQL EnvironmentSQL Queries BasicsTurning Data into InformationWorking with TablesMultiple Tables and JoinsSQL FunctionsSubqueries and Derived TablesViews and Materialized ViewsAdvanced SQL TopicsSample Programs & Executing SQLAudienceThis book requires no prior knowledge to get started, making it an ideal read for those looking to pursue careers in database administration, business analytics, or business intelligence. Its accessibility ensures that an unwavering passion for learning SQL is all you need to effortlessly progress through the book's content.

The latest edition of Murach's classic SQL Server book does a better job than ever of teaching the SQL statements that every database developer should know. Each chapter features clear examples, easy-to-understand explanations, best practices, and helpful tips. To start, this book presents the SQL statements for retrieving and updating the data in a database. These are the SQL statements that you'll use every day. Then, it shows how to design a database, how to implement that design, and how to work with database features like views, scripts, stored procedures, functions, triggers, transactions, and security. Finally, it shows how to work with an Azure SQL database that runs in the cloud as a service that's available from the Azure cloud computing platform. The result? You'll be able to write SQL that's thoroughly professional, and you'll be able to work far more effectively than most of your colleagues. Every Murach book guarantees high quality. The realistic examples show how each feature works in context. The exercises at the end of each chapter let you gain valuable hands-on experience. And the distinctive "paired-pages" format is ideal for learning and reference.

In PL/SQL From Beginner to Pro world-recognized Rick Phillips, Ph.D. leverages his experience with 8 courses and over 65 thousand online students to take the learner through the wonderland which is PL/SQL programming. Whether you are young or old, new to programming or a seasoned veteran, this is the PL/SQL book for you. Google Rick Phillips, Ph.D. to learn more about his experience and lifestyle.

Schematron is a validation language that checks XML documents against business rules. It extends the validation provided by languages such as Document Type Definitions (DTD), W3C XML Schema, and RELAX NG, giving you the ability to check your XML documents for compliance with rules that can be difficult, if not impossible, to check with the other validation languages.Schematron: A language for validating XML is aimed at programmers and others who process XML. It explains the language in detail along with many examples. Anyone who uses Schematron or who would like to begin using it will find a wealth of information in this book.

"Covers all things MySQL from the basics of creating a table to the complexities of managing an entire database. Teaches how to build efficient databases through examples, exercises, and three hands-on projects. Topics include creating simple databases and tables, updating and deleting data, working with multiple tables, and avoiding common mishaps"--

Projektarbeit aus dem Jahr 2017 im Fachbereich Informatik - Programmierung, Note: 1,7, FOM Hochschule für Oekonomie & Management gemeinnützige GmbH, Stuttgart, Sprache: Deutsch, Abstract: Das Ziel der vorliegenden Projektarbeit ist es, dem Leser einen Überblick über die SAP HANA-Datenbank sowie die In-Memory-Plattform als Ganzes und deren wesentliche Merkmale, Bestandteile und Funktionen zu verschaffen. Dabei soll auch einem Leser, der keinen Bezug zu Datenbanktechnologien hat, anschaulich gemacht werden, wie eine SAP HANA-Datenbank funktioniert, welchem Datenbankmodell es zugrunde liegt und welche Voraussetzungen das System erfüllen muss, damit die SAP HANA-Datenbank in Betrieb genommen werden kann.Mit der Einführung von Personal Computer ist das digitale Datenaufkommen rasant gestiegen, seien es nun Unternehmensdaten oder Daten, die ihren Ursprung im Internet haben. Daher stehen die Unternehmen vor der großen Herausforderung, die eintreffenden großen Datenmengen effizient zu verarbeiten. Für die die Bewältigung dieser Herausforderung steht der Begriff Big Data. Die klassischen rationalen Datenbanken sind nicht mehr in der Lage, eine so große Datenmenge in Echtzeit zu verarbeiten. Daher müssen andere Ansätze für eine Datenverarbeitung erforscht werden. Durch den Preisverfall für Arbeitsspeicher wurde es für die Unternehmen finanziell möglich, die Server mit einer großen Arbeitsspeichergröße auszustatten, sodass der Datenzugriff auf die Daten nicht mehr über Festplatten stattfinden muss, sondern direkt aus dem Arbeitsspeicher gelesen werden kann. Diese Art der Datenhaltung wird auch In-Memory genannt. Diesen Trend hat auch der weltweit führende Anbieter für Standardsoftware, die SAP, erkannt und eine In-Memory-Datenbank namens SAP HANA entwickelt. Da es eine relativ neue Technologie ist, ist es nicht jedem bekannt, wie sie funktioniert und welche technischen Grundlagen hinter dieser Technologie verborgen sind.Um den Überblick über SAP HANA In-Memory-Plattform besser darzustellen, ist der Aufbau dieser Projektarbeit in zwei große Teilbereiche aufgeteilt. Zum Verständnis darüber, auf welchen allgemeinen Datenbankmodellen die In-Memory-Technologie und die SAP HANA-Datenbank aufbauen, wird in den ersten Kapiteln der Fokus auf allgemeine Datenbanktechnologien gelegt. Hier werden zum einen die technologischen Grundsätze, aber auch die Geschichte der SAP, das Wie und Warum dargelegt. Der zweite Teil der Arbeit beschreibt die In-Memory-Technologie, die technologischen Wegbereiter für diese sowie den Aufbau einer In-Memory-Datenbank.

Recent spectacular achievements in wireless, mobile, and sensor networks have dramatically changed our lives in many ways. However, the rapid evolution of wireless systems not only promises increased functionality, reliability, availability, and security, as well as putting a wide variety of new services at the users' disposal ? it also creates a number of design challenges that our research community is now facing. Scientists and engineers need to come up with, and promptly implement, novel wireless network architectures, while system operators and planners rethink their business models and attend to the growing expectations of their customer base. To provide a suitable forum for discussion between researchers, practitioners, and industry representatives interested in new developments in the respective research area, IFIP WG 6. 8 launched three separate series of conferences: MWCN (Mobile and Wireless Communications Networks), PWC (Personal Wireless Communications), and WSAN (Wireless Sensor and Actors Networks). In 2008, MWCN and PWC were merged into the IFIP Wireless and Mobile Networking Conference (WMNC 2008), held in Toulouse, France, from September 30 to October 2, 2008. MWNC 2008 and PWC 2008 topics were subsequently revised with a view to covering the whole spectrum of hot issues in wireless and mobile networking. As a result, IFIP WG 6. 8 decided to add WSAN as another WMNC track.

This book constitutes the refereed proceedings of the 10th Information Retrieval Societies Conference, AIRS 2014, held in Kuching, Malaysia, in December 2014. The 42 full papers were carefully reviewed and selected from 110 submissions. Seven tracks were the focus of the AIR 2014 and they were IR models and theories; IR evaluation, user study and interactive IR; web IR, scalability and IR in social media; multimedia IR; natural language processing for IR; machine learning and data mining for IR and IR applications.

This book constitutes the refereed proceedings of the 8th International Conference on Flexible Query Answering Systems, FQAS 2011, held in Roskilde, Denmark, in October 2011. The 43 papers included in this volume were carefully reviewed and selected from numerous submissions. The papers are organized in topical sections on logical approaches to flexible querying, fuzzy logic in spatial and temporal data modeling and querying, knowledge-based approaches, multimedia, data fuzziness, reliability and trust, information retrieval, preference queries, flexible querying of graph data, ranking, ordering and statistics, query recommendation and interpretation, as well as on fuzzy databases and applications (8 papers presented in a special session).

This book constitutes the refereed proceedings of the 14th International Conference on Discovery Science, DS 2011, held in Espoo, Finland, in October 2011 - co-located with ALT 2011, the 22nd International Conference on Algorithmic Learning Theory. The 24 revised full papers presented together with 5 invited lectures were carefully revised and selected from 56 submissions. The papers cover a wide range including the development and analysis of methods for automatic scientific knowledge discovery, machine learning, intelligent data analysis, theory of learning, as well as their application to knowledge discovery.

This book constitutes the thoroughly refereed post proceedings of two international workshops on special aspects of digital libraries, namely the First International Workshop on Natural Language Processing for Digital Libraries, NLP4DL 2009, held in Viareggio, Italy in June 2009 and the CACAO Project Workshop Advanced Technologies for Digital Libraries, AT4DL 2009, held in Trento, Italy in September 2009. A new open call was sent after the workshops. The revised full papers presented at the workshops and the newly submitted ones went through two rounds of reviewing and revision. The 10 papers selected address various aspects of NLP in digital libraries, search, classification, and digital document processing.

The two-volume set LNAI 7301 and 7302 constitutes the refereed proceedings of the 16th Pacific-Asia Conference on Knowledge Discovery and Data Mining, PAKDD 2012, held in Kuala Lumpur, Malaysia, in May 2012. The total of 20 revised full papers and 66 revised short papers were carefully reviewed and selected from 241 submissions. The papers present new ideas, original research results, and practical development experiences from all KDD-related areas. The papers are organized in topical sections on supervised learning: active, ensemble, rare-class and online; unsupervised learning: clustering, probabilistic modeling in the first volume and on pattern mining: networks, graphs, time-series and outlier detection, and data manipulation: pre-processing and dimension reduction in the second volume.

The two-volume set LNAI 7301 and 7302 constitutes the refereed proceedings of the 16th Pacific-Asia Conference on Knowledge Discovery and Data Mining, PAKDD 2012, held in Kuala Lumpur, Malaysia, in May 2012. The total of 20 revised full papers and 66 revised short papers were carefully reviewed and selected from 241 submissions. The papers present new ideas, original research results, and practical development experiences from all KDD-related areas. The papers are organized in topical sections on supervised learning: active, ensemble, rare-class and online; unsupervised learning: clustering, probabilistic modeling in the first volume and on pattern mining: networks, graphs, time-series and outlier detection, and data manipulation: pre-processing and dimension reduction in the second volume.

This book constitutes the refereed proceedings of the 14th Asia-Pacific Conference APWeb 2012 held in Kunming, China, in April 2012. The 39 full papers presented together with 34 short papers, 2 keynote talks, and 5 demo papers were carefully reviewed and selected from 167 initial submissions. The papers cover contemporary topics in the fields of Web management and World Wide Web related research and applications, such as advanced application of databases, cloud computing, content management, data mining and knowledge discovery, distributed and parallel processing, grid computing, internet of things, semantic Web and Web ontology, security, privacy and trust, sensor networks, service-oriented computing, Web community analysis, Web mining and social networks.

The LNCS journal Transactions on Large-Scale Data- and Knowledge-Centered Systems focuses on data management, knowledge discovery, and knowledge processing, which are core and hot topics in computer science. Since the 1990s, the Internet has become the main driving force behind application development in all domains. An increase in the demand for resource sharing across different sites connected through networks has led to an evolution of data- and knowledge-management systems from centralized systems to decentralized systems enabling large-scale distributed applications providing high scalability. Current decentralized systems still focus on data and knowledge as their main resource. Feasibility of these systems relies basically on P2P (peer-to-peer) techniques and the support of agent systems with scaling and decentralized control. Synergy between Grids, P2P systems, and agent technologies is the key to data- and knowledge-centered systems in large-scale environments.This, the third issue of Transactions on Large-Scale Data- and Knowledge-Centered Systems, contains two kinds of papers: Firstly, a selection of the best papers from the third International Conference on Data Management in Grid and Peer-to-Peer Systems, Globe 2010, and secondly, a selection of 6 papers from the 18 papers submitted in response to the call for papers for this issue. The topics covered by this special issue include replication, the semantic web, information retrieval, data storage, source selection, and large-scale distributed applications.