Mastering Oracle SQL and SQL*Plus

Write SQL statements that are more powerful, simpler, and faster using Oracle SQL and its full range of features. This book provides a clearer way of thinking about SQL by building sets, and provides

《名師講壇——Oracle SQL入門與實戰經典》是一本小說式的Oracle SQL入門教材。書中使用簡單、生動的生活例子來解釋複雜的電腦和資料庫概念。《名師講壇——Oracle SQL入門與實戰經典》又是一本Oracle SQL的實用教材，內容覆蓋了OCP（Oracle認證專家）考試的幾乎全部內容，但重點放在實際工作能力的訓練，每章中都有大量的例題，而且每道題都給出了答案。為了幫助讀者理解，許多

Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the

Master SQL Server’s Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and addr

SQL is a widely used to access most databases, therefore database developers and system administrators should be familiar with it. This hands-on SQL book will help beginner and intermediate users

Readers will learn by example how to use Microsoft SQL Server 2016 Integration Services (SSIS) as they design and implement extract, transform, and load (ETL) solutions to support a business applicati

Write queries using little-known, but powerful, SQL features implemented in Oracle's database engine. You will be able to take advantage of Oracle’s power in implementing business logic, thereby maxim

Carry out data analysis with PySpark SQL, graphframes, and graph data processing using a problem-solution approach. This book provides solutions to problems related to dataframes, data manipulation su

Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or

Deliver advanced functionality faster and cheaper by exploiting SQL Server's ever-growing amount of built-in support for modern data formats. Learn about the growing support within SQL Server for

Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up t

Get SQL Server up and running on the Linux operating system and containers. No database professional managing or developing SQL Server on Linux will want to be without this deep and authoritative guid

Be guided through the techniques to back up and restore databases and files in SQL Server. Multiple techniques are presented for ensuring the integrity and consistency of database backups, as well as

Move data back and forth between database and application. The must-have knowledge in this book helps programmers learn how to use the official driver, MySQL Connector/Python, by which Python programs

This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari hel

Start developing with Oracle SQL. This book is a one-stop introduction to everything you need to know about getting started developing an Oracle Database. You'll learn about foundational concepts, set

本書主要對SQL Server與Oracle兩種數據庫功能間的相互遷移進行對比講解，向開發人員提供有針對性的參考建議。全書由9章組成，包括安裝準備、數據庫體系結構、用戶及授權、對象遷移、數據遷移、SQL語句遷移(1)和(2)、事務差異及其他功能。每章均採用大量討論與實例對兩種數據庫進行翔實比較，有利於開發人員更好地理解遷移過程。

《OCA Oracle Database SQL認證考試指南(1Z0-071)》完整覆蓋1Z0-071的全部目標，包含的主題如下：●　DDL和SQL SELECT語句 ●　相關數據分組●　對數據進行操縱、限制和排序 ●　創建報表●　單行函數和分組函數 ●　數據字典視圖●　子查詢 ●　大數據集●　模式對象 ●　分層檢索●　集合操作符 ●　正則表達式支持●　從多表顯示數據 ●　用戶訪問控制

紮穩 SQL 基礎, 循序養成大數據分析新技能MySQL / MariaDB、MS SQL Server、Oracle、PostgreSQL、DB2 全適用！在資訊系統的開發中, 資料庫都扮演了重要的角色, 近來資料庫更擴展到大規模的資料處理及數據分析工作, 造就了大數據 (Big Data)、資料科學 (Data Science) 等急速竄升的 IT 發展趨勢。然而無論資料庫的發展如何改變, 學習資料庫形式的主流 – 【關聯式資料庫】, 及其操作用的 【SQL 語言】, 絕對是踏入資料庫領域的重要基礎！本書從認識資料庫、資料表的結構開始, 您可以學習到資料查詢和更新的語法、經常使用的函數、以及多個資料表的結合等透過 SQL 做到的資料庫操作方法。書中繪製了豐富的圖解, 以清楚易懂的方式進行解說 WHERE子句、GROUP BY子句、HAVING 子句或子查詢等初學者較不易理解的部分。最後, 針對讓 SQL 功能大躍進、可提升大規模資料處理效率的【視窗函數 (Window Function)】 和 【GROUPING運算子】, 也會教您如何快速上手, 學習如何挖掘出有價值的數據。本書特色 :本書附件內容，請由書中內頁下載點取得‧查詢語法、擷取結果即時呈現, 隨時都能掌握語法用途、各種修改差異‧隨時盤點須牢記的 SQL 語法原則及關鍵字, 讓你腦袋不卡卡‧熟悉不同資料庫系統的語法差異, 增加職場競爭力‧適用 MySQL / MariaDB、MS SQL Server、Oracle、PostgreSQL、DB2

Learn the intricate workings of DAX and the mechanics that are necessary to solve advanced Power BI challenges. This book is all about DAX (Data Analysis Expressions), the formula language used in Power BI―Microsoft’s leading self-service business intelligence application―and covers other products such as PowerPivot and SQL Server Analysis Services Tabular. You will learn how to leverage the advanced applications of DAX to solve complex tasks.Often a task seems complex due to a lack of understanding, or a misunderstanding of core principles, and how certain components interact with each other. The authors of this book use solutions and examples to teach you how to solve complex problems. They explain the intricate workings of important concepts such as Filter Context and Context Transition. You will learn how Power BI, through combining DAX building blocks (such as measures, table filtering, and data lineage), can yield extraordinary analytical power. Throughout Pro Dax with Power BI t

本書以Oracle 12c數據庫管理系統為開發環境, 以學生-課程數據庫和員工-部門數據庫為例, 全面系統地介紹了Oracle 12c的管理操作和應用開發方法。全書共分13章, 分別介紹Oracle 12c的安裝和卸載, Oracle數據庫體系結構, SQL基礎, PL/SQL概述, 異常處理, ￿標, 存儲子程序, 包, 觸發器, 用戶、權限與角色管理, 數據庫備份與恢復。在本書的最後提供了兩個

本書以Oracle 18c為藍本，系統地講述了Oracle 18c的功能和應用。本書共分9章，詳細介紹了Oracle 18c數據庫的安裝和卸載、管理工具、對象管理、SQL語言、PL/SQL、存儲過程與觸發器、用戶權限與安全、數據導入導出等，最後通過一個綜合實訓將知識點進行融會貫通。本初每章均提供了實訓內容和課後習題，供讀者進一步鞏固和實踐所學到的知識。

Python is today's fastest growing programming language. This engaging and refreshingly different guide breaks down the skills into clear step-by-step chunks and explains the theory using brief easy-to-understand language. Rather than bamboozling readers with pages of mind-numbing technical jargon, this book includes 150 practical challenges, putting the power in the reader's hands. Through creating programs to solve these challenges the reader will quickly progress from mastering the basics to confidently using subroutines, a graphical user interface, and linking to external text, csv and SQL files. This book is perfect for anyone who wants to learn how to program with Python. In particular, students starting out in computer science and teachers who want to improve their confidence in Python will find here a set of ready-made challenges for classroom use.

全書共分24章，內容涵蓋了SQL語言各方面的知識，包括數據庫的基礎知識，搭建運行SQL語言實例的環境，SQL語言的歷史、特點，創建和使用數據庫、數據表、索引、視圖的方法，高級數據查詢的各種使用方法，MySQL、SQL Server和Oracle常用函數的用法，聚合函數的各種用法，數據更新語句的使用方法，創建和使用存儲過程、自定義函數和觸發器的方法，數據庫系統的安全性和完整性方面的知識，T-SQL和

本書是為Oracle初學者編寫的。本著“低門檻、重實踐、精理論”的理念，在講述概念、理論和架構時，采用實際運行案例的方式現身說法，從而使得復雜的概念、難懂的理論、模糊的框架變得簡單、易懂和清晰。全書共14章，內容涉及Oracle體系結構、網絡配置、安全管理、對象管理、并發控制、備份與恢復、PL/SQL程序設計和Oracle數據挖掘技術等。本書在第13章給出了貫串全書的信息系統開發案例，這個案例串聯

The latest on SQL databases SQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administra

在Oracle認證大師Richard Niemiec的幫助下，系統地識別和排除數據庫的性能問題：《Oracle Database 12cR2性能調整與優化(第5版)》詳細介紹最新的監控、故障排除和優化方法，取自現實世界的案例研究和最佳實踐貫穿全書，從中可以探悉如何鑒定和解決本地部署和雲環境的瓶頸問題、如何配置存儲設備、如何有效運行查詢以及如何開發無錯誤的SQL和PL/SQL代碼。此外還介紹了有關測

本書主要介紹使用Oracle?12c數據庫對數據進行管理和應用的知識。本書共分為18章，介紹了Oracle數據庫概述，Oracle的體系結構，實現數據庫，SQL基礎，SQL函數，PL/SQL編程，SQL*Plus數據庫環境，設置表和表空間，管理表和表空間，存儲過程、函數和程序包，索引，其他模式對象，管理控制與日誌文件，視圖、同義詞和序列，數據安全管理，導入與導出，備份與恢復，數據庫的高級應用等內容

本書以一個人力資源管理系統案例開發與管理為主線，深入淺出地介紹Oracle 12c數據庫系統開發與管理的基礎知識。全書包括4部分。第一部分介紹Oracle數據庫系統的構建，包括數據庫的安裝與配置、數據庫管理與開發工具、數據庫系統結構等；第二部分介紹人力資源管理系統數據庫開發，包括數據庫的創建、數據庫存儲設置、數據庫對象的創建與管理、利用SQL語句與數據庫交互、利用PL/SQL程序進行數據庫功能模塊

Oracle數據庫是數據庫領域使用最廣泛、佔有市場份額最大的數據庫管理系統。本書以Oracle Database 12c 發行版1 (版本號為12.1.0.2.0) 為基礎, 全面細緻地介紹了Oracle Database 12c的安裝及配置, 使用數據庫管理系統進行數據管理的各種SQL操作, 使用PL/SQL進行數據庫程序開發所需要的基本知識和技術。本書內容豐富、結構合理、思路清晰、語言精練,