MARC 닫기

• LDR

  05567cam a22005531i 4500

• 001

  000000532627

• 005

  20210114163540

• 006

  m d

• 007

  cr |||||||||||

• 008

  200519s2020 enk o 000 0 eng d

• 015

  ▼a  GBC065854
  ▼2  bnb

• 016

  ▼a  019807053
  ▼2  Uk

• 019

  ▼a  1157096269

• 020

  ▼a  1838981705

• 020

  ▼a  9781838981709
  ▼q  (electronic bk.)

• 020

  ▼z  9781838984762 (pbk.)

• 035

  ▼a  2490091
  ▼b  (N$T)

• 035

  ▼a  (OCoLC)1174731395
  ▼z  (OCoLC)1157096269

• 037

  ▼a  9781838981709
  ▼b  Packt Publishing

• 040

  ▼a  UKMGB
  ▼b  eng
  ▼e  rda
  ▼e  pn
  ▼c  UKMGB
  ▼d  OCLCO
  ▼d  EBLCP
  ▼d  UKAHL
  ▼d  UAB
  ▼d  N$T
  ▼d  248023

• 050

  ▼a  QA76.73.S67

• 082

  ▼a  005.756
  ▼2  23

• 100

  ▼a  Bush, Josephine,
  ▼e  author.

• 245

  ▼a  Learn SQL database programming:
  ▼b  query and manipulate databases from popular relational database servers using SQL /:
  ▼c  Josephine Bush.

• 260

  ▼a  Birmingham:
  ▼b  Packt Publishing,
  ▼c  2020.

• 300

  ▼a  1 online resource.

• 336

  ▼a  text
  ▼2  rdacontent

• 337

  ▼a  computer
  ▼2  rdamedia

• 338

  ▼a  online resource
  ▼2  rdacarrier

• 500

  ▼a  Table of ContentsIntroduction to Relational Database Management SystemsInstalling and Using MySQL WorkbenchUnderstanding Data TypesDesigning and Creating a DatabaseImporting and Exporting DataQuerying a Single TableQuerying Multiple TablesModifying Data and Table StructuresWorking with ExpressionsGrouping and Summarizing DataAdvanced Querying TechniquesProgrammable ObjectsExploring and Processing Your DataTell a Story with Your DataBest Practices for Design and QueryingSQL Appendix.

• 505

  ▼a  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

• 505

  ▼a  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

• 505

  ▼a  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

• 505

  ▼a  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

• 505

  ▼a  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

• 520

  ▼a  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.

• 588

  ▼a  Description based on CIP data; resource not viewed.

• 590

  ▼a  Master record variable field(s) change: 050

• 650

  ▼a  SQL (Computer program language)

• 650

  ▼a  Database management.

• 655

  ▼a  Electronic books.

• 776

  ▼i  Print version:,
  ▼z  9781838984762

• 856

  ▼3  EBSCOhost
  ▼u  http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=2490091

• 938

  ▼a  Askews and Holts Library Services
  ▼b  ASKH
  ▼n  AH37377508

• 938

  ▼a  ProQuest Ebook Central
  ▼b  EBLB
  ▼n  EBL6215709

• 938

  ▼a  EBSCOhost
  ▼b  EBSC
  ▼n  2490091

• 990

  ▼a  강리원

• 991

  ▼a  eBook

• 994

  ▼a  92
  ▼b  N$T