Название: Become a SQL Programming for Absolute Beginners: The Ultimate Guide To Learning SQL Programming Quickly with Hands-on Project
Автор: Hendrix Alvarez
Издательство: Independently published
Год: 2022
Страниц: 702
Язык: английский
Формат: epub
Размер: 41.3 MB

Do you want to learn good coding techniques quickly and easily? Are you looking for a well explained introduction to SQL for absolute beginners? This book provides all the essentials in one handy place! Structured Query Language is abbreviated as SQL. SQL is used to communicate with databases. It is considered the standard language for relational database management systems by the American National Standards Institute (ANSI). SQL statements are employed to conduct operations such as updating or retrieving a database's data. Common SQL-based relational database management systems include Sybase, Oracle, Microsoft SQL Server, Access, and Ingres. This book is ideal for people who want to improve their job prospects and advance their careers, for development companies who want to expand their providing individuals, or for anyone who wants to capitalize on our inexorably data-driven future-even if they have no prior experience with coding!

Название: Communication Principles for Data Science
Автор: Changho Suh
Издательство: Springer
Год: 2023
Страниц: 294
Язык: английский
Формат: pdf (true), epub
Размер: 50.0 MB

This book introduces the basic principles underlying the design and analysis of the digital communication systems that have heralded the information revolution. One major goal of the book is to demonstrate the role of the digital communication principles in a wide variety of data science applications, including community detection, computational biology, speech recognition and Machine Learning. One defining feature of this book is to make an explicit connection between the communication principles and data science problems, as well as to succinctly deliver the “story” of how the communication principles play a role for trending data science applications. All the key “plots” involved in the story are coherently developed with the help of tightly coupled exercise problem sets, and the associated fundamentals are explored mostly from first principles. Another key feature is that it includes programming implementation of a variety of algorithms inspired by fundamentals, together with a brief tutorial of the used programming tools. The implementation is based on Python and TensorFlow.

Название: Embedding Knowledge Graphs with RDF2vec
Автор: Heiko Paulheim, Petar Ristoski, Jan Portisch
Издательство: Springer
Год: 2023
Страниц: 165
Язык: английский
Формат: pdf (true), epub
Размер: 19.6 MB

This book explains the ideas behind one of the most well-known methods for knowledge graph embedding of transformations to compute vector representations from a graph, known as RDF2vec. The authors describe its usage in practice, from reusing pre-trained knowledge graph embeddings to training tailored vectors for a knowledge graph at hand. They also demonstrate different extensions of RDF2vec and how they affect not only the downstream performance, but also the expressivity of the resulting vector representation, and analyze the resulting vector spaces and the semantic properties they encode. Knowledge graph embedding is a technique which projects entities and relations in a knowledge graph into a continuous vector space. Many other components of AI systems, especially machine learning components, can work with those continuous representations better than operating on the graph itself, and often yield superior result quality compared to those trying to extract non-continuous features from a graph.

Название: Linux. Командная строка. Лучшие практики
Автор: Дэниел Джей Барретт
Издательство: Питер
Год: 2023
Формат: pdf
Страниц: 257
Размер: 14,2 Мб
Язык: русский

Перейдите на новый уровень работы в Linux! Если вы системный администратор, разработчик программного обеспечения, SRE-инженер или пользователь Linux, книга поможет вам работать быстрее, элегантнее и эффективнее. Вы научитесь создавать и запускать сложные команды, которые решают реальные бизнес-задачи, обрабатывать и извлекать информацию, а также автоматизировать ручную работу. Узнайте, что происходит внутри командной оболочки Linux. Вне зависимости от используемых команд, вы повысите эффективность работы в Linux и станете более конкурентоспособным специалистом.

Название: Оконные функции в T-SQL: По ту сторону анализа данных
Автор: Ицик Бен-Ган
Издательство: ДМК Пресс
Год: 2022
Страниц: 343
Язык: русский
Формат: pdf
Размер: 66.3 MB

В этой книге на конкретных примерах рассматриваются все типы оконных функций: агрегатные, ранжирующие, статистические, а также функции смещения и функции упорядоченного набора. Вы узнаете, как использовать оконные функции для повышения эффективности запросов, которые раньше писали с применением предикатов; освоить концепцию работы с окнами в SQL и строить запросы наиболее эффективным образом; умело использовать опции секционирования, упорядочивания и определения границ окна; оптимизировать оконные функции с использованием индексов и пакетного режима; применять оконные функции для решения распространенных бизнес-задач.

Название: Формулы в Microsoft Excel 2016
Автор: Александер М., Куслейка Р.
Издательство: Санкт-Петербург: Диалектика
Год: 2020
Формат: pdf
Страниц: 784
Размер: 47 mb
Язык: Русский

Данная книга — идеальное руководство по работе с формулами в Excel, позволяющее изучить все аспекты применения программы. Книга содержит множество полезнейших советов и готовых рецептов, которые помогут вам ускорить, упростить и лучше организовать свой рабочий процесс. Вы освоите профессиональные методики, описания которых вы нигде больше не найдете.

Название: Predicting the Unknown: The History and Future of Data Science and Artificial Intelligence
Автор: Stylianos Kampakis
Издательство: Apress
Год: 2023
Страниц: 270
Язык: английский
Формат: pdf
Размер: 38.8 MB

As a society, we’re in a constant struggle to control uncertainty and predict the unknown. Quite often, we think of scientific fields and theories as being separate from each other. But a more careful investigation can uncover the common thread that ties many of those together. From ChatGPT, to Amazon’s Alexa, to Apple’s Siri, Data Science, and Computer Science have become part of our lives. In the meantime, the demand for data scientists has grown, as the field has been increasingly called the “sexiest profession.” This book attempts to specifically cover this gap in literature between Data Science, Machine Learning and Artificial Intelligence (AI). How was uncertainty approached historically, and how has it evolved since? What schools of thought exist in philosophy, mathematics, and engineering, and what role did they play in the development of Data Science? It uses the history of Data Science as a stepping stone to explain what the future might hold.

Название: Learn SQL in a Month of Lunches (MEAP v8)
Автор: Jeff Iannucci
Издательство: Manning Publications
Год: 2023
Страниц: 192
Язык: английский
Формат: pdf, epub, mobi
Размер: 10.1 MB

Use SQL to get the data you need in no time at all! Learn to read and write basic queries, troubleshoot common problems, and control your own business data in just 24 short lessons–no programming experience required! Structured Query Language (SQL) is the standard way to get specific datasets out of large relational databases. If you use Excel, Tableau, or PowerBI to crunch business data, you’ve probably seen a lot of SQL already. And guess what? It’s easy to master the most useful parts of SQL! In just a few quick lessons, you can learn to write your own queries, modify existing SQL statements, and add a new superpower to your bag of tricks. Learn SQL in a Month of Lunches introduces you to the most useful parts of SQL for business data analysis. This practical book gives you instantly-useful techniques starting from the first short chapter. 25-year SQL veteran Jeff Iannucci makes SQL a snap through hands-on lab exercises, relevant code examples, and easy-to-understand language.

Название: Everyday Data Visualization (MEAP v4)
Автор: Desiree Abbott
Издательство: Manning Publications
Год: 2023
Страниц: 238
Язык: английский
Формат: pdf, epub
Размер: 25.8 MB

Radically improve the quality of the data visualizations you do every day by mastering core principles of color, typography, chart types, data storytelling, and more! In Everyday Data Visualization you’ll learn important design principles for the most common data visualizations. Everyday Data Visualization is a field guide for design techniques that will improve the charts, reports, and data dashboards you build every day. The foundation of data visualization is storytelling, and this book gives you the tools you need to start telling those stories with clarity, precision, and flair! You’ll learn how human brains perceive and process information, master modern accessibility standards, get the basics of color theory and typography, and more!

Название: Exam Ref DP-500 Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI
Автор: Daniil Maslyuk, Justin Frebault
Издательство: Microsoft Press/Pearson Education
Год: 2024
Страниц: 734
Язык: английский
Формат: epub
Размер: 22.8 MB

Prepare for Microsoft Exam DP-500 and demonstrate your real-world ability to design, create, and deploy enterprise-scale data analytics solutions. Designed for business intelligence developers, architects, data analysts, and other professionals, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified: Azure Enterprise Data Analyst Associate level. Exam DP-500 focuses on knowledge needed to govern and administer data analytics environments; integrate analytics platforms into existing IT infrastructure; manage the analytics development lifecycle; query data with Azure Synapse Analytics; ingest and transform data with Power BI; design and build tabular models; optimize enterprise-scale data models; explore data with Azure Synapse Analytics; and visualize data with Power BI.