SQL in easy steps

SQL in easy steps

Mike McGrath
Book - 2020

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.

محفوظ في:

Holdings -

Liberty Park

Barcode Status Material Type CallNumber
37413318768944 Checked out Non-fiction 005.7565 MCGRATH
التفاصيل البيبلوغرافية
المؤلف الرئيسي: McGrath, Mike, 1956- (مؤلف)
التنسيق: كتاب
اللغة:English
منشور في: Leamington Spa, Warwickshire : In Easy Steps Limited, [2020]
الطبعة:Fourth edition.
سلاسل:In easy steps.
الموضوعات:

MARC

LEADER 00000cam a2200000 i 4500
001 707189
005 20201125073800.0
008 200527t20202020enka 001 0 eng d
020 |a 9781840789027  |q (paperback) 
020 |a 1840789026  |q (paperback) 
035 |a (OCoLC)1180260813  |z (OCoLC)1190756454 
040 |a UKMGB  |b eng  |e rda  |c UKMGB  |d OCLCO  |d OI6  |d PNX  |d OCLCF  |d VP@  |d CLE  |d OCLCQ  |d JQM 
082 0 4 |a 005.75/65  |2 23 
092 0 |a 005.7565 MCGRATH 
100 1 |a McGrath, Mike,  |d 1956-  |e author. 
245 1 0 |a SQL in easy steps /  |c Mike McGrath. 
246 3 0 |a Structured Query Language in easy steps 
250 |a Fourth edition. 
264 1 |a Leamington Spa, Warwickshire :  |b In Easy Steps Limited,  |c [2020] 
264 4 |c ©2020 
300 |a 192 pages :  |b color illustrations ;  |c 23 cm. 
336 |a text  |b txt  |2 rdacontent 
336 |a still image  |b sti  |2 rdacontent 
337 |a unmediated  |b n  |2 rdamedia 
338 |a volume  |b nc  |2 rdacarrier 
490 1 |a In easy steps 
500 |a Includes index. 
505 0 |a Introducing SQL -- Getting started -- Creating database tables -- Inserting data into tables -- Retrieving data from tables -- Sorting retrieved data -- Simple data filtering -- Complex data filtering -- Generating calculated fields -- Manipulating data -- Grouping table data -- Making complex queries -- Joining database tables -- Handy reference. 
520 |a 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. 
650 0 |a SQL (Computer program language) 
650 0 |a Database management. 
650 0 |a Relational databases. 
830 0 |a In easy steps. 
949 |b 37413318768944  |c newanf  |d prta  |e 005.7565 MCGRATH  |g so  |h 16.00  |q 1626974 
998 |a 2020.10.15 
999 f f |i 05b3442a-afbd-5ac3-84bb-1f2c1bd4ee3a  |s 14041433-69fc-5715-862c-74714cc453b1  |t 0 
952 f f |p Standard Circulation  |a City of Spokane  |b Spokane Public Library  |c Branches  |d Liberty Park  |t 0  |e 005.7565 MCGRATH  |h Dewey Decimal classification  |i Non-fiction  |m 37413318768944