000			02386nam a2200289Ia 4500
001			3500
008			230305s2020 xx 000 0 und d
020			_a9781492057611
040			_cTBS
041			_aeng
043			_aen_UK
245		0	_aLearning SQL : generate, manipulate, and retrieve data
260			_bO'Reilly, _c2020
300			_axvi, 360 pages : illustrations ; 24 cm
505			_aA Little Background - Creating and Populating a Database - Query Primer - Filtering - Querying Multiple Tables - Working with Sets - Data Generation, Manipulation, and Conversion - Grouping and Aggregates - Subqueries - Joins Revisited - Conditional Logic - Transactions - Indexes and Constraints - Views - Metadata - Analytic Functions - Working with Large Databases - SQL and Big Data.
520			_aAs data floods into your company, you need to put it to work right away and SQL is the best tool for the job. With the latest edition of this introductory guide, author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications, performing administrative tasks, and generating reports. You'll find new chapters on SQL and big data, analytic functions, and working with very large databases. ; ; Each chapter presents a self-contained lesson on a key SQL concept or technique using numerous illustrations and annotated examples. Exercises let you practice the skills you learn. Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly discover how to put the power and flexibility of this language to work. ; ; Move quickly through SQL basics and several advanced features ; Use SQL data statements to generate, manipulate, and retrieve data ; Create database objects, such as tables, indexes, and constraints with SQL schema statements ; Learn how datasets interact with queries; understand the importance of subqueries ; Convert and manipulate data with SQL's built-in functions and use conditional logic in data statements
630			_aCLASS Q - SCIENCE _93445
650			_aLearning Structured Query Language _914312
650			_aLC Subjects _914313
650			_aSQL (Computer program language) _914314
650			_aRelational databases _914315
700			_aBeaulieu, Alan _eAutor _914316
902			_a1684
905			_am
942			_a1 _2ddc
999			_c3329 _d3329