MariaDB Crash Course

個数:

MariaDB Crash Course

  • 在庫がございません。海外の書籍取次会社を通じて出版社等からお取り寄せいたします。
    通常6~9週間ほどで発送の見込みですが、商品によってはさらに時間がかかることもございます。
    重要ご説明事項
    1. 納期遅延や、ご入手不能となる場合がございます。
    2. 複数冊ご注文の場合は、ご注文数量が揃ってからまとめて発送いたします。
    3. 美品のご指定は承りかねます。

    ●3Dセキュア導入とクレジットカードによるお支払いについて
  • 【入荷遅延について】
    世界情勢の影響により、海外からお取り寄せとなる洋書・洋古書の入荷が、表示している標準的な納期よりも遅延する場合がございます。
    おそれいりますが、あらかじめご了承くださいますようお願い申し上げます。
  • ◆画像の表紙や帯等は実物とは異なる場合があります。
  • ◆ウェブストアでの洋書販売価格は、弊社店舗等での販売価格とは異なります。
    また、洋書販売価格は、ご注文確定時点での日本円価格となります。
    ご注文確定後に、同じ洋書の販売価格が変動しても、それは反映されません。
  • 製本 Paperback:紙装版/ペーパーバック版/ページ数 287 p.
  • 言語 ENG
  • 商品コード 9780321799944
  • DDC分類 004.36

Full Description


MariaDB is a database server that offers drop-in replacement functionality for MySQL. Built by some of the original authors of MySQL, with assistance from the broader community of free and open source software developers, MariaDB offers a rich set of feature enhancements to MySQL, including alternate storage engines, server optimizations, and patches. MariaDB Crash Course teaches you all you need to know to be immediately productive with MariaDB. Master trainer Ben Forta introduces all the essentials through a series of quick, easy-to-follow, hands-on lessons. Instead of belaboring database theory and relational design, Forta focuses on teaching solutions for the majority of users who simply want to interact with data.Learn how to:Retrieve and sort dataFilter data using comparisons, regular expressions, and full text searchJoin relational dataCreate and alter tablesInsert, update, and delete dataLeverage the power of stored procedures and triggersUse views and cursorsManage transactional processingCreate user accounts and manage security via access control

Contents

Introduction 1What Is MariaDB Crash Course? 1 Who Is This Book For? 2Companion Web Site 3Conventions Used in This Book 31: Understanding SQL 5Database Basics 5What Is a Database? 6Tables 6Columns and Datatypes 7Rows 8NULL 8Primary Keys 9What Is SQL? 10Try It Yourself 11Summary 112: Introducing MariaDB 13What Is MariaDB? 13Client-Server Software 14MySQL Compatibility 15MariaDB Tools 16mysql Command Line 16MySQL Workbench 17Summary 193: Working with MariaDB 21Making the Connection 21Selecting a Database 22Learning About Databases and Tables 23Summary 264: Retrieving Data 27The SELECT Statement 27Retrieving Individual Columns 27Retrieving Multiple Columns 29Retrieving All Columns 30Retrieving Distinct Rows 31Limiting Results 32Using Fully Qualified Table Names 34Using Comments 35Summary 365: Sorting Retrieved Data 37Sorting Data 37Sorting by Multiple Columns 39Specifying Sort Direction 40Summary 436: Filtering Data 45Using the WHERE Clause 45The WHERE Clause Operators 46Checking Against a Single Value 47Checking for Nonmatches 48Checking for a Range of Values 49Checking for No Value 50Summary 517: Advanced Data Filtering 53Combining WHERE Clauses 53Using the AND Operator 53Using the OR Operator 54Understanding Order of Evaluation 55Using the IN Operator 57Using the NOT Operator 58Summary 598: Using Wildcard Filtering 61Using the LIKE Operator 61The Percent Sign (%) Wildcard 62The Underscore (_) Wildcard 64Tips for Using Wildcards 65Summary 659: Searching Using Regular Expressions 67Understanding Regular Expressions 67Using Regular Expressions 68Basic Character Matching 68Performing OR Matches 70Matching One of Several Characters 71Matching Ranges 72Matching Special Characters 73Matching Character Classes 75Matching Multiple Instances 75Anchors 77Summary 7910: Creating Calculated Fields 81Understanding Calculated Fields 81Concatenating Fields 82Using Aliases 84Performing Mathematical Calculations 85Summary 8711: Using Data Manipulation Functions 89Understanding Functions 89Using Functions 90Text Manipulation Functions 90Date and Time Manipulation Functions 92Numeric Manipulation Functions 96Summary 9612: Summarizing Data 97Using Aggregate Functions 97The AVG() Function 98The COUNT() Function 99The MAX() Function 100The MIN() Function 101The SUM() Function 102Aggregates on Distinct Values 103Combining Aggregate Functions 104Summary 10513: Grouping Data 107Understanding Data Grouping 107Creating Groups 108Filtering Groups 109Grouping and Sorting 112SELECT Clause Ordering 113Summary 11414: Working with Subqueries 115Understanding Subqueries 115Filtering by Subquery 115Using Subqueries as Calculated Fields 119Summary 12215: Joining Tables 123Understanding Joins 123Understanding Relational Tables 123 Why Use Joins? 125Creating a Join 125The Importance of the WHERE Clause 127Inner Joins 129Joining Multiple Tables 130Summary 13216: Creating Advanced Joins 133Using Table Aliases 133Using Different Join Types 134Self Joins 134Natural Joins 136Outer Joins 137Using Joins with Aggregate Functions 139Using Joins and Join Conditions 140Summary 14017: Combining Queries 141Understanding Combined Queries 141Creating Combined Queries 141Using UNION 142UNION Rules 144Including or Eliminating Duplicate Rows 144Sorting Combined Query Results 145Summary 14618: Full-Text Searching 147Understanding Full-Text Searching 147Using Full-Text Searching 148Enabling Full-Text Searching Support 148Performing Full-Text Searches 149Using Query Expansion 152Boolean Text Searches 154Full-Text Search Usage Notes 158Summary 15919: Inserting Data 161Understanding Data Insertion 161Inserting Complete Rows 161Inserting Multiple Rows 165Inserting Retrieved Data 166Summary 16820: Updating and Deleting Data 169Updating Data 169Deleting Data 171Guidelines for Updating and Deleting Data 172Summary 17321: Creating and Manipulating Tables 175Creating Tables 175Basic Table Creation 176Working with NULL Values 177Primary Keys Revisited 179Using AUTO_INCREMENT 180Specifying Default Values 181Engine Types 182Updating Tables 183Deleting Tables 185Renaming Tables 185Summary 18622: Using Views 187Understanding Views 187Why Use Views 188View Rules and Restrictions 188Using Views 189Using Views to Simplify Complex Joins 189Using Views to Reformat Retrieved Data 191Using Views to Filter Unwanted Data 192Using Views with Calculated Fields 193Updating Views 194Summary 19523: Working with Stored Procedures 197Understanding Stored Procedures 197Why Use Stored Procedures 198Using Stored Procedures 199Executing Stored Procedures 199Creating Stored Procedures 200Dropping Stored Procedures 201Working with Parameters 202Building Intelligent Stored Procedures 205Inspecting Stored Procedures 208Summary 20824: Using Cursors 209Understanding Cursors 209Working with Cursors 209Creating Cursors 210Opening and Closing Cursors 210Using Cursor Data 212Summary 21625: Using Triggers 217Understanding Triggers 217Creating Triggers 218Dropping Triggers 219Using Triggers 219INSERT Triggers 219DELETE Triggers 221UPDATE Triggers 223More on Triggers 223Summary 22426: Managing Transaction Processing 225Understanding Transaction Processing 225Controlling Transactions 227Using ROLLBACK 227Using COMMIT 228Using Savepoints 229Changing the Default Commit Behavior 230Summary 23027: Globalization and Localization 231Understanding Character Sets and Collation Sequences 231Working with Character Set and Collation Sequences 232Summary 23428: Managing Security 235Understanding Access Control 235Managing Users 236Creating User Accounts 237Deleting User Accounts 238Setting Access Rights 238Changing Passwords 241Summary 24229: Database Maintenance 243Backing Up Data 243Performing Database Maintenance 243Diagnosing Startup Problems 245Review Log Files 245Summary 24630: Improving Performance 247Improving Performance 247Summary 249A: Getting Started with MariaDB 251What You Need 251Obtaining the Software 252Installing the Software 252Preparing to Try It Yourself 253B: The Example Tables 255Understanding the Sample Tables 255Table Descriptions 256Creating the Sample Tables 259Using mysql 260Using MySQL Workbench 261C: MariaDB Datatypes 263String Datatypes 263Numeric Datatypes 265Date and Time Datatypes 266Binary Datatypes 266D: MariaDB Reserved Words 269Index 275

最近チェックした商品