{"product_id":"sql-basics-fabian-gaussling-9781521749784","title":"SQL Basics: Learn SQL the easy way","description":"Learn SQL the easy wayStart directly now and dive into the world of databases and SQL. With this book you'll learn all the necessary basics: \u003cul\u003e\n\u003cli\u003eDatabase theory\u003c\/li\u003e\n\u003cli\u003eCreate and alter database structures\u003c\/li\u003e\n\u003cli\u003eInsert, edit and delete data\u003c\/li\u003e\n\u003cli\u003eCreate easy queries (calculations, filter, sorting, functions)\u003c\/li\u003e\n\u003cli\u003eQuery multiple tables (Cross product, Inner joins, Outer joins)\u003c\/li\u003e\n\u003cli\u003eGrouping and aggregation\u003c\/li\u003e\n\u003cli\u003eSub-queries \u0026amp; Set operations\u003c\/li\u003e\n\u003cli\u003eetc.\u003c\/li\u003e\n\u003c\/ul\u003eThis book is based on an Oracle database. But it's possible to use it easily with other relational databases like Microsoft SQL Server, DB2 or MySQL. Where it is necessary the differences between the databases are pointed out. In the appendix you find \"translation tables\" for DB2, MySQL and MS SQL.Lot's of practical exercissEach chapter contains a lot of execises in order to deepen the new knowledge and to apply it. At the end of each chapter there are more execises. The solutions for the execises can be downloaded on the authors webpage.About the authorFabian Gau ling studied information management in Kiel, Germany. After that he worked several years for different companies in the area of database developement and data warehousing. Since 2013 he has worked as an freelancer in the field of databases. Besides he's offering trainings on different database topics (SQL, Cognos, MDX, etc.).\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Fabian Gaussling\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 1521749787\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781521749784\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Independently Published\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 07\/03\/2017\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 72\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.24lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.00h x 6.00w x 0.15d","brand":"Fabian Gaussling","offers":[{"title":"Paperback","offer_id":48088512758015,"sku":"9781521749784","price":11.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_ec6fd316-1fc1-493b-826e-834e26600a6e.jpg?v=1769105182","url":"https:\/\/www.whiterainbookhouse.com\/products\/sql-basics-fabian-gaussling-9781521749784","provider":"WR Book House","version":"1.0","type":"link"}