Description |
1 online resource |
Contents |
Table of Contents; Introduction to Relational Database Management Systems; Installing and Using MySQL Workbench; Understanding Data Types; Designing and Creating a Database; Importing and Exporting Data; Querying a Single Table; Querying Multiple Tables; Modifying Data and Table Structures; Working with Expressions; Grouping and Summarizing Data; Advanced Querying Techniques; Programmable Objects; Exploring and Processing Your Data; Tell a Story with Your Data; Best Practices for Design and Querying;SQL; Appendix. |
|
Cover -- Title Page -- Copyright and Credits -- About Packt -- Contributors -- Table of Contents -- Preface -- Section 1: Database Fundamentals -- Chapter 1: Introduction to Relational Database Management Systems -- Understanding SQL -- Elements of SQL -- Understanding databases -- Tables -- Fields -- Records or rows -- Columns -- Understanding data integrity -- Types of integrity -- Entity integrity -- Unique constraints -- Not null constraints -- The primary key -- Referential integrity -- Domain integrity -- Database normalization -- The first normal form -- The second normal form |
|
The third normal form -- Types of RDMS -- Oracle -- MySQL -- SQL Server -- PostgreSQL -- RDMS SQL differences -- Summary -- Questions -- Chapter 2: Installing and Using MySQL Workbench -- Technical requirements -- Installing MySQL Workbench -- Installing on Windows -- Installing MySQL on Windows -- Configuring MySQL on Windows -- Installing on Mac -- Installing MySQL Server on Mac -- Checking the status of MySQL Server on Mac -- Installing MySQL Workbench on Mac -- Using MySQL Workbench -- Connecting to your local instance -- Connecting to another instance or setting up your local instance |
|
Restoring a database -- Summary -- Questions -- Chapter 3: Understanding Data Types -- Understanding string data types -- String data types in MySQL -- MySQL string data type table summary -- String data types in other RDMS -- Oracle -- PostgreSQL -- SQL Server -- String data types RDMS table comparison -- Understanding numeric data types -- Numeric data types in MySQL -- MySQL numeric data type table summary -- Numeric data types in other RDMSes -- SQL Server -- Oracle -- PostgreSQL -- Numeric data types table comparison -- Understanding date and time data types |
|
Date and time data types in MySQL -- MySQL date and time data type table summary -- Date and time data types in other RDMSes -- Oracle -- PostgreSQL -- SQL Server -- Date and time data types table comparison -- Understanding other data types -- Other data types in MySQL -- Other data types in other RDMSes -- Oracle -- PostgreSQL -- SQL Server -- Choosing the right data type -- Examples of choosing a data type -- Summary -- Questions -- Chapter 4: Designing and Creating a Database -- Technical requirements -- Creating a database -- Guidelines for naming conventions -- Avoiding keywords |
|
Avoiding spaces -- Descriptive and accurate naming -- Case and separating words -- Allowed characters when naming database objects -- Learning how to create a database -- Creating a database via the MySQL Workbench interface -- Creating a database via MySQL Workbench with a SQL script -- Understanding SQL code errors -- Understanding table relationships -- Understanding entity-relationship diagrams -- Understanding one-to-one table relationships -- Understanding one-to-many table relationships -- Understanding many-to-many table relationships -- Creating a table in the database |
Summary |
SQL is a powerful querying language used to store, manipulate, and retrieve data. This is a comprehensive guide for who are new to SQL, which will have you up-to-speed and using SQL to streamline your work in no time. It gives users enough confidence to use SQL queries for retrieving and manipulating data relevant to their work-related tasks. |
Bibliography |
Includes bibliographical references and index. |
Subject |
SQL (Computer program language)
|
|
Database management.
|
|
SQL (Langage de programmation) |
|
Bases de données -- Gestion. |
|
Database management |
|
SQL (Computer program language) |
Other Form: |
Print version: 9781838984762 |
ISBN |
1838981705 |
|
9781838981709 (electronic bk.) |
|
(pbk.) |
|