MySQL Crash Course

Paperback Engels 2023 2e druk 9780138223021
€ 44,07
Levertijd ± 11 werkdagen
Gratis verzonden

Samenvatting

MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between.

This book will teach you all you need to know to be immediately productive with the latest version of MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible.

Learn How To
- Retrieve and Sort Data
- Filter Data Using Comparisons, Regular Expressions, Full Text Search, and Much More
- Join Relational Data
- Create and Alter Tables
- Insert, Update, and Delete Data
- Leverage the Power of Stored Procedures and Triggers
- Use Views and Cursors
- Manage Transactional Processing
- Create User Accounts and Manage Security via Access Control

Specificaties

ISBN13:9780138223021
Taal:Engels
Bindwijze:paperback
Aantal pagina's:304
Druk:2
Verschijningsdatum:24-11-2023
Hoofdrubriek:IT-management / ICT

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Inhoudsopgave

Chapter 1 Understanding SQL 1
Database Basics 1
What Is a Database? 2
Tables 2
Columns and Datatypes 3
Rows 4
Primary Keys 4
What Is SQL? 6
Try It Yourself 6
Summary 7

Chapter 2 Introducing MySQL 9
What Is MySQL? 9
Client/Server Software 9
MySQL Versions 10
MySQL Tools 11
mysql Command-Line Utility 11
MySQL Workbench 12
Other Tools 13
Summary 13

Chapter 3 Working with MySQL 15
Using the Command-Line Tool 15
Selecting a Database 16
Learning About Databases and Tables 17
Using MySQL Workbench 20
Getting Started 20
Using MySQL Workbench 21
Selecting a Database 22
Learning About Databases and Tables 22
Executing SQL Statements 23
Next Steps 23
Summary 24

Chapter 4 Retrieving Data 25
The SELECT Statement 25
Retrieving Individual Columns 25
Retrieving Multiple Columns 27
Retrieving All Columns 29
Retrieving Distinct Rows 29
Limiting Results 31
Using Fully Qualified Table Names 32
Using Comments 33
Summary 34
Challenges 34

Chapter 5 Sorting Retrieved Data 35
Sorting Data 35
Sorting by Multiple Columns 37
Sorting by Column Position 38
Specifying Sort Direction 39
Summary 41
Challenges 42

Chapter 6 Filtering Data 43
Using the WHERE Clause 43
WHERE Clause Operators 44
Checking Against a Single Value 45
Checking for Nonmatches 46
Checking for a Range of Values 47
Checking for No Value 48
Summary 49
Challenges 49
Afgekapt op 63 regels

Managementboek Top 100

€ 44,07
Levertijd ongeveer 11 werkdagen
Gratis verzonden

Rubrieken

Producten

    Auteurs

      Trefwoorden

        Artikelen

          MySQL Crash Course