Atnaujinkite slapukų nuostatas

El. knyga: SQL in easy steps, 4th edition

3.96/5 (60 ratings by Goodreads)
  • Formatas: 192 pages
  • Serija: In Easy Steps
  • Išleidimo metai: 23-Jun-2020
  • Leidėjas: In Easy Steps Limited
  • ISBN-13: 9781840789201
Kitos knygos pagal šią temą:
SQL in easy steps, 4th editionDidesnis paveikslėlis
  • Formatas: 192 pages
  • Serija: In Easy Steps
  • Išleidimo metai: 23-Jun-2020
  • Leidėjas: In Easy Steps Limited
  • ISBN-13: 9781840789201
Kitos knygos pagal šią temą:

DRM apribojimai

  • Kopijuoti:

    neleidžiama

  • Spausdinti:

    neleidžiama

  • El. knygos naudojimas:

    Skaitmeninių teisių valdymas (DRM)
    Leidykla pateikė šią knygą šifruota forma, o tai reiškia, kad norint ją atrakinti ir perskaityti reikia įdiegti nemokamą programinę įrangą. Norint skaityti šią el. knygą, turite susikurti Adobe ID . Daugiau informacijos  čia. El. knygą galima atsisiųsti į 6 įrenginius (vienas vartotojas su tuo pačiu Adobe ID).

    Reikalinga programinė įranga
    Norint skaityti šią el. knygą mobiliajame įrenginyje (telefone ar planšetiniame kompiuteryje), turite įdiegti šią nemokamą programėlę: PocketBook Reader (iOS / Android)

    Norint skaityti šią el. knygą asmeniniame arba „Mac“ kompiuteryje, Jums reikalinga  Adobe Digital Editions “ (tai nemokama programa, specialiai sukurta el. knygoms. Tai nėra tas pats, kas „Adobe Reader“, kurią tikriausiai jau turite savo kompiuteryje.)

    Negalite skaityti šios el. knygos naudodami „Amazon Kindle“.

SQL (Structured Query Language) is THE standard language used world-wide for database communication on all popular database software. It allows the storage and manipulation of data both on Windows platforms and on Unix-based platforms, such as Linux.

SQL in easy steps, 4th edition begins by explaining how to download and install the free MySQL database server on both Windows and Linux platforms. This allows you to establish an environment in which to develop and administer your own databases. This book makes no assumption that you will have previous knowledge of any programming or scripting language so it's ideal for the newcomer to SQL. Each chapter builds your knowledge of executing database queries. The book contains exciting chapters on how to selectively extract data from within one, or more, databases and there are complete examples that illustrate each aspect of SQL. By the end of this book you will have gained a sound understanding of the Structured Query Language and be able to write your own SQL scripts to insert, extract, and manipulate data.

SQL in easy steps, 4th edition has an easy-to-follow style that will appeal to anyone who wants to begin using databases. It is suitable for those with little or no experience of SQL. This book will appeal to all who need a fundamental understanding of database administration with SQL:

  • Web developers wanting to add database interaction to their web sites
  • Programmers wanting to add SQL to their skills set
  • Hobbyists who want to begin creating SQL scripts for upload to their own ISP
  • Students or those seeking a career in computing.

    • Free, downloadable source code is available from our website so you can check the code against your own work, and get started straight away!



    SQL in easy steps, 4th edition gives the reader a sound understanding of the Structured Query Language so they can write their own SQL scripts to insert, extract and manipulate data.
    1 Introducing Sql
    		7(14)
    What is SQL?
    		8(2)
    Making SQL queries
    		10(2)
    Installing MySQL on Windows
    		12(2)
    Installing MySQL on Linux
    		14(2)
    Adding an ODBC connector
    		16(2)
    Using Microsoft Query tool
    		18(2)
    Summary
    		20(1)
    2 Getting Started
    		21(10)
    Introducing databases
    		22(1)
    Exploring databases
    		23(1)
    Creating a database
    		24(2)
    Deleting a database
    		26(2)
    Running SQL scripts
    		28(2)
    Summary
    		30(1)
    3 Creating Database Tables
    		31(16)
    Exploring database tables
    		32(2)
    Creating a table
    		34(2)
    Deleting a table
    		36(2)
    Table data types
    		38(2)
    Table field modifiers
    		40(2)
    Setting the primary key
    		42(2)
    Altering a table
    		44(2)
    Summary
    		46(1)
    4 Inserting Data Into Tables
    		47(14)
    Inserting complete rows
    		48(2)
    Including a columns list
    		50(2)
    Inserting selected data
    		52(2)
    Updating data
    		54(2)
    Changing specific data
    		56(2)
    Deleting data
    		58(2)
    Summary
    		60(1)
    5 Retrieving Data From Tables
    		61(12)
    Retrieving a column
    		62(2)
    Retrieving multiple columns
    		64(2)
    Retrieving a row
    		66(2)
    Copying retrieved data
    		68(2)
    Inserting selected fields
    		70(2)
    Summary
    		72(1)
    6 Sorting Retrieved Data
    		73(10)
    Sorting a column
    		74(2)
    Sorting multiple columns
    		76(2)
    Sorting by column position
    		78(2)
    Setting the sort direction
    		80(2)
    Summary
    		82(1)
    7 Simple Data Filtering
    		83(12)
    Making comparisons
    		84(2)
    Comparing a single value
    		86(2)
    Comparing a range of values
    		88(2)
    Seeking non-matches
    		90(2)
    Finding null values
    		92(2)
    Summary
    		94(1)
    8 Complex Data Filtering
    		95(16)
    Comparing multiple values
    		96(2)
    Comparing alternative values
    		98(2)
    Comparing alternative lists
    		100(2)
    Specifying evaluation order
    		102(2)
    Matching strings
    		104(2)
    Matching characters
    		106(2)
    Matching regular expressions
    		108(2)
    Summary
    		110(1)
    9 Generating Calculated Fields
    		111(10)
    Concatenating fields
    		112(2)
    Trimming padded spaces
    		114(2)
    Adopting aliases
    		116(2)
    Doing arithmetic
    		118(2)
    Summary
    		120(1)
    10 Manipulating Data
    		121(12)
    Introducing functions
    		122(2)
    Text functions
    		124(2)
    Numeric functions
    		126(2)
    Date and time functions
    		128(2)
    System functions
    		130(2)
    Summary
    		132(1)
    11 Grouping Table Data
    		133(16)
    Finding summary values
    		134(2)
    Counting rows
    		136(2)
    Discovering total values
    		138(2)
    Working with distinct values
    		140(2)
    Creating data groups
    		142(2)
    Filtering grouped data
    		144(2)
    Sorting filtered group data
    		146(2)
    Summary
    		148(1)
    12 Making Complex Queries
    		149(12)
    Using sub-queries
    		150(2)
    Sub-query calculated fields
    		152(2)
    Combining queries
    		154(2)
    Handling duplicate rows
    		156(2)
    Sorting combined results
    		158(2)
    Summary
    		160(1)
    13 Joining Database Tables
    		161(14)
    What are joins?
    		162(2)
    Creating a join
    		164(2)
    Joining multiple tables
    		166(2)
    Creating self joins
    		168(2)
    Creating natural joins
    		170(2)
    Specifying join direction
    		172(2)
    Summary
    		174(1)
    Handy reference 175(12)
    Index 187
    Mike McGrath gained his extensive knowledge of computer languages while working as a developer contracting to companies around the world, and is an established In Easy Steps author.
    Daugiau apie elektronines knygas Daugiau apie elektronines knygas
    Pastovi nuoroda: https://www.kriso.lt/db/97818407892016e.html
    Raktažodžiai: