SQL Built-In Functions And Stored Procedures

How did Bitcoin price increase 1,200 times in only a decade? Why can a virtual image be sold for as high as HK$500 million? How did Dogecoin once become the fourth largest digital asset in terms of market cap, after being created for fun? Understanding the development of blockchain and crypto assets and how to make good use of its decentralized technology can protect individual wealth effectively and be an edge against the inflation caused by central banks, and sometimes also be a shortcut to get rich. Cryptocurrencies, including Bitcoin, Ethereum, and many others, have been mushrooming in recent years. Blockchain technology has also evolved from 1.0 to 3.0. How can you identify and seize these new opportunities? This book gives a brief explanation of the development course of blockchain and crypto assets, an analysis of the industry ecosystem, a framework for institutional investors to manage their portfolios, and an outlook on the development direction of this industry in the coming

本書內容改編自第12屆 iT 邦幫忙鐵人賽，Microsoft Azure 組冠軍系列文章 《白眼狼的30天Azure跳槽計畫》 第一本使用 Azure 雲端服務與 TypeScript 語言開發聊天機器人專書，帶讀者從需求出發，靈活使用 Azure 雲服務，設計自己的雲端系統架構解決方案，快速建置聊天機器人。本書旨在讓者具備自學雲端的能力，將來在面對不同應用場景，能使用你擅長的開發工具，選擇適合的雲端服務，靈活使用 Azure 雲端服務設計自己的應用程式。 書籍特色 新手也能輕鬆學 Azure!四大主題(無伺服器運算、資料庫服務、訊息服務、認知服務)一次滿足，手把手帶你用 TypeScript 實作! 🔹詳細的圖解操作流程，讓你熟悉使用 Azure 雲端平台 🔹整合 Azure 與聊天機器人，帶你建置、管理及部署應用程式 🔹列舉一個雲端架構，引導你善用 Azure 服務設計屬於自己的解決方案 精選主題 訊息交換平台 Microsoft Teams、LINE 🔹使用 Webhook 將 Web Service 連接至 Microsoft Teams 🔹理解 LINE Messaging API 打造聊天機器人 無伺服器運算 Azure Functions 🔹打造 Serverless API 🔹打造事件訂閱 Webhooks 🔹使用指令開發、測試、部署函式 資料庫服務 Azure Cosmos DB 、Azure Cache for Redis 🔹使用 SQL/Core API 搜尋 Cosmos DB 資料 🔹開發 RESTful API 存取 Cosmos DB 資料 🔹使用 Azure 建立 Redis Cache 緩存資料 訊息服務 Azure Service Bus 🔹使用 Queues 佇列傳訊 🔹使用發佈/訂閱 Topics 主題傳訊 🔹部署 Service Bus Trigger 事件觸發器 認知服務 LUIS、Custom Vision 🔹使用 LUIS 建立自然語言理解模型 🔹使用 Custom Vision 建立影像辨識模型 🔹整合認知服務加值聊天機器人 專業推薦 本書涵蓋雲端運算的概念與型態、技術實作、趨勢應用與產品實務，作者以自學累積的知識與實務經驗，結合了現行趨勢應用的聊天機器人，一步步帶你進入雲端世界。

序The publisher invites Japanese readers and Satoyama supporters to spread these stories of harmonious coexistence between humanity and nature in rural communities in Taiwan, and to keep telling the story of the Satoyama Initiative. Let us keep learning from one another through exchange, strengthening the friendship between Taiwan and Japan on the road to landscape restoration, and contributing to global biodiversity. We are all in this together, and we can do it together.內容簡介There are four books in the set, about four rural communities in Taiwan. First, The Spring on the Highland explains how two generations of farmers in Gonglaoping, Fengyuan District, Taichung enjoy the fruits of kinship with the land following the restoration of the spring on the highland. Second, Farming Village Co. Unlimited is about a Satoyama-inspired enterprise based on crop diversification and creative local produce marketing in Gongrong, Sanzhi District, New Taipei City. Third, Letters the Blue Sea Wrote to t

本書一共分為3篇：基礎篇(上)、案例篇和工具篇(下)。基礎篇：從理論基礎和基本原理層面介紹了 MySQL 的安裝與設定、升級和架構，information_schema、sys_schema、performance_schema 和 mysql_schema，MySQL複製、MySQL 交易、SQL 語句最佳化及架構設計基礎知識。案例篇：從硬體和系統、MySQL 架構等方面提出了效能最佳化的十幾個案例，包括：效能測試的基本最佳化概念和最需要關注的效能指標解釋、對 SQL 語句執行慢的基本定位、避免 x86 可用性的一般性方法、節能模式會怎樣影響效能、I/O 儲存作為資料庫最重要的依賴是如何影響資料庫效能的、主備複製不一致可能有哪些原因、字元集不一致會造成哪些效能問題、在實際場景中鎖的爭用是怎樣的。工具篇：介紹了在 MySQL 效能最佳化過程中需要用到的各種工具，包括：dmidecode、top、dstat 等硬體和系統排查工具；FIO、sysbench、HammerDB 等壓力測試工具；mysqldump、XtraBackup 等備份工具；Percona、innotop、Prometheus 等監控工具。--------------------------------------------------------------------------------效能問題：本書解決 MySQL 資料庫效能問題，某種程度來說，MySQL 資料庫效能最佳化問題是一個平行處理的問題，歸根究柢是鎖和資源爭用的問題。其實效能最佳化要做的就是下列事情：•瞭解基本原理。找到事情的因果關係和依賴關係，儘量讓不相關的事情能平行進行。•要事第一。找到目前最重要、最需要最佳化的地方，投入時間和精力，不斷去改進與最佳化。•切中要害。找到耗費時間最長的地方，想盡辦法縮短其時間。機械思維和大數據思維：本書的效能最佳化方法論還是工業革命時代的機械思維，簡而言之，就是尋找因果關係，大膽假設，小心求證。現在已經是資訊時代，理應瞭解什麼是資訊理論，解決問題需要利用大數據思維！讀者對象：（1）MySQL 初學者。（2）專門從事 MySQL 工作1~3年的開發人員和運維人員。（3）資深的 MySQL DBA。

和SQL一樣簡單的NoSQL，從汎汎小工程師昇華到資料庫宗師的一大步！ MongoDB是當今業界使用最廣泛的文件資料庫之一，本書特別結合實踐案例，再以開發管理者的角度對MongoDB技術進行系統地整理，想要從SQL跳槽的讀者，這本書是市面上難得的最佳範例手冊。 本書內容概要 第1 部分：MongoDB 入門（第1 ～ 6 章） 該部分介紹MongoDB 的基本概念及入門知識。透過該部分的學習，讀者可對MongoDB 自身的技術全貌形成一定的認識。 第2 部分：MongoDB 微服務開發（第7 ～ 10 章） 該部分介紹微服務的基本概念及微服務架構中應用MongoDB 的相關技術實現。透過該部分的學習，讀者將能深入了解基於Java 微服務技術堆疊開發MongoDB 應用的實踐方法。 第3 部分：MongoDB 進階（第11 ～ 15 章） 該部分介紹MongoDB 更加進階的一些使用技巧。透過該部分的學習，讀者可掌握MongoDB 在性能最佳化方面的一些最佳實踐及指導方案。 第4 部分：MongoDB 架構管理（第16 ～ 18 章） 該部分介紹MongoDB 在架構管理方面的一些經驗。透過該部分的學習，讀者可獲得MongoDB 在架構可靠性、安全方面的指導及如何在專案中進行資料庫問題防治的一些想法。 適合讀者群 本書適合希望了解、使用MongoDB 資料庫的技術從業者。 對有一定基礎的研發人員，透過閱讀本書可以更深入地了解MongoDB在性能最佳化、叢集技術方面的一些原理。 對初學者，可以根據書中的一些案例快速開發基於 MongoDB 的微服務應用。 對系統架構師，可以透過本書了解 MongoDB 的一些進階特性及原理，並獲得在技術選型、架構管理方面的指導資訊。

A comprehensive and current introduction to the fundamentals of regression analysisIntroduction to Linear Regression Analysis, 6th Edition is the most comprehensive, fulsome, and current examination of the foundations of linear regression analysis. Fully updated in this new sixth edition, the distinguished authors have included new material on generalized regression techniques and new examples to help the reader understand retain the concepts taught in the book.The new edition focuses on four key areas of improvement over the fifth edition: New exercises and data setsNew material on generalized regression techniquesThe inclusion of JMP software in key areasCarefully condensing the text where possibleIntroduction to Linear Regression Analysis skillfully blends theory and application in both the conventional and less common uses of regression analysis in today's cutting-edge scientific research. The text equips readers to understand the basic principles needed to apply regression model-b

本書詳實記錄二戰期間盟軍戰俘被送至台灣的經過，以及十四座戰俘營的樣貌與戰俘的日常生活。內容整理自戰俘本人與家屬的訪談、日記與書信，也參考多份歷史檔案與紀錄。全書收錄超過六百張照片與手繪圖，並介紹各戰俘營現址現況，是了解台灣戰俘歷史的重要資料彙編。‘NEVER FORGOTTEN’ tells the story of the Japanese prisoner of war camps on the island of Taiwan (Formosa) in the Second World War. It is the only book ever written that provides the complete story of all the Taiwan camps and the men who were interned in them.Finished on Remembrance Day - November 11th 2020 - 75 years after the end of the world’s most devastating war, this book traces the story of the allied soldiers, sailors and airmen - primarily British, American, Australian and Dutch - who were taken captive by the Japanese in Hong Kong, Malaya, Singapore, the Dutch East Indies and the Philippines and sent to Taiwan to do forced labour for their war effort.What you will read is the result of numerous interviews with the former Taiwan prisoners of war, the collection of materials supplied by them and their families, and thousands of hours spent poring over their

In today’s Buddhist sphere, numerous claims have been made on what the Buddha has taught. However, were they truly spoken by the Buddha? The Buddha-Dharma: Pure and Simple series is an exploration of

This book explores and investigates students’ skill acquisition and learning progress in Court Interpreting. Focusing on the language combination of Mandarin Chinese and English, this research project

Teaching practices and researching in TESOL一書，係著者任教國內英文系時，在英語教學師資訓練課程中，根據其專長所進行的三篇研究。三篇研究希望能記錄臺灣高等教育下英語教育的課堂實踐和個案紀錄。三篇論文皆呼應現在英語教學課程和研究的一些趨勢：－英語語言課程具互動性、重視社會溝通－鼓勵教師做行動研究－學生進入社會參與和職場體驗、進而進行反思－培養學生學術書寫能力

We all like to win. But what exactly does it mean to win in life and how can we win ... and win with Honour?The purpose of this book is to invite you and your child to think about what "winning in lif

We all like to win. But what exactly does it mean to win in life and how can we win ... and win with Honour?The purpose of this book is to invite you and your child to think about what "winning in lif

This book is one of the few books written in English on Chaozhou culture and history. It compiles information from Chinese and English sources including archive material, academic works and publicatio

Laser Procedures實用美容雷射治療圖譜這套備受推崇的「實用美容治療圖譜」系列，其第四冊提供如何一步步治療日光損傷皮膚的說明，以及其他在使用雷射光電科技時，常遇到的醫美主訴。不論你的經驗值為何，這本圖解參考書詳細地提供了極有用的治療指引：從設備到病人如何選擇，甚至如何將雷射治療與其他美容治療合併使用以促進效果，都加以解說。《實用美容雷射治療圖譜》傳遞了關於如何達到患者滿意度高，以及成功

U.S.-China Relations and the Changing Security Dynamics in East Asia collects 9 papers which were presented at the annual conference of the Graduate Institute of International Affairs and Strategic St

When in the East, Work with What the East Has!Regarding teeth and the periodontium, the anatomical disadvantages of eastern populations from westernpopulations often leads to greater tooth mobility fo

Drawing extensively on the current critical state of affairs at the global level, this book highlights the vital importance of systemic thinking and integrated, transformative knowledge in bringing ab

Winning in Service Markets: Success through People, Technology, and Strategy is the first practitioner book in the market to cover the key aspects of services marketing and management based on sound a

This book provides trainers with essential Consecutive Interpreting (CI) techniques, and training guidelines which they can adapt to suit their own training situations. In addition, students and self-

Makes Learning Chinese Verbs FUN and EASY!1. Easy to LearnExplains how verbs can be used in different tenses and sentences in a clear and effective way.2. It’s PracticalTeaches verbs for everyday use:

What in Brief is Buddhism? Looks at the great religious system of Buddhism diachronically on a historical timeline, and synchronically as a widespread heritage of humankind as it enters the new

This book has invited scholars from UK, Taiwan, South Korea and Hong Kong to address the social quality reality in Taiwan and South Korea. The main themes and discussion in this book include 4 dimensi

DescriptionThe Fox and the Crow Level 2-4A fox sees a crow with some meat. The fox wants to get the meat from the crow. But the crow is in a tree. The fox must think of a good idea to get the meat.Ear

DescriptionThe Wolf and the Seven Children Level 3-3Mother Goat goes out for the day. Her seven children are home. They know not to open the door. But the Wolf has an idea to get in!Early readers will

DescriptionThe Rabbits and the Frogs Level 5-3Rabbits are nice and kind. They live in a scary world. Many things in the world eat rabbits! It is not easy to live in a scary world. One rabbit tells his

The global expansion of judicial powers makes no exception to Asia. Most noticeable is the judicial expansion in tandem with unprecedented political and legal reforms that have occurred in the two Asi

In times of conflicts and crises, an argument insisting on the humane is commonly heard. In wars, voices demanding a humane treatment of prisoners – as decreed by the Geneva Convention – will be raise

In Company Third Edition The English course for working professionals In Company 3.0 provides updated and expanded content and builds on the success of previous editions, making it the English

Each Student Book in the three-level Listening Point series features twelve units accompanied by Workbook and Teacher's Guide. Features‧Language presented through familiar themes and contexts in fun a

從歷史的角度探討二十世紀上半葉台灣社會的轉型。 The late twentieth century witnessed rapid changes not only in Taiwan’s economy, but also in its identity. Both economic as well as ideological restructuring have been basic el

學習不僅是要「知道」，還要能夠「做到」資料庫系統是資料處理與資訊管理系統的核心，因此熟悉其理論與設計是開發大型資訊應用系統不可或缺的能力。本書在內容上著重於理論與實務兼具，針對實務所需的理論加以介紹，並透過實務的操作，提供學習者熟練SQL Server資料庫的使用，目標在於提供學習者能夠花費最短的時間建立資料庫設計與開發足夠的理論基礎與專業技能。 學習不僅是要「單一」，還要能夠「全面」資料庫系統需

Partly due to the European Union's insistent and successful policies on pluriculturalism and plurilinguism, there have recently been voices challenging the prevalent and practical consensus in East As

Shakespeare, as well as the reading, translating, teaching, criticizing, performing, and adapting of Shakespeare, does not exist outside culture. Culture in its many varieties not only informs the Sha

The R&D activity in the Information and Communication Technologies (ICT) industrial sectors is an important factor in boosting the competitiveness of the European economy, and it stands high on th

Mathews (California State U.-Fullerton) and Howell (Westmont College) present a textbook for students in mathematics, physics, and engineering at the junior or senior undergraduate level who have comp

Tristan and Isolde are in love, but Isolde must marry King Mark. So a happy love story seems impossible...The lovers meet every day but then, one night, King Mark finds them together. Now Tristan must

‧Current thoughts and concepts in marketing strategy formulation, based on constructs that have taken place in the field ‧Incorporation of global focus throughout the book ‧Discussion of problems and

Formulate treatment plans with confidence when you consult Sleep Disorders in Neurology, a helpful overview of both common and rare neurological disorders that are frequently accompanied by significan

Oral Medicine and Pathology At A Glance is the latest title in the highly popular at a Glance series. It provides a concise and accessible introduction and revision aid. Following the familiar, easy-t

【Articles】‧Jonathan P. Evans：‘African’ Tone in the Sinosphere‧Lillian M. Huang and Tali’ Hayung：Syntax and Semantics of p- in Squliq Atayal‧Paul Jen-kuei Li：The Great Diversity of Formosan Languages‧C