{"product_id":"sql-database-reporting-paperback","title":"SQL Database Reporting - Paperback","description":"\u003cdiv\u003e\u003cp style=\"text-align: right;\"\u003e\u003ca href=\"https:\/\/reportcopyrightinfringement.com\/\" target=\"_blank\" rel=\"nofollow\"\u003e\u003cb\u003eReport copyright infringement\u003c\/b\u003e\u003c\/a\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cp\u003eby \u003cb\u003eSimon Smart\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eIf you're a beginner and want to learn practical SQL reporting skills in the shortest time possible, this is the course for you. The course's examples use free software, meaning you don't need to make any additional purchases.\u003c\/p\u003e\u003cp\u003e\u003cb\u003eTo follow the course's examples, you will need a Windows computer.\u003c\/b\u003e\u003c\/p\u003e\u003cp\u003eUnlike many other courses, this book works entirely with practical examples. You won't be slowed down by long explanations of database theory and instead will get started doing useful work immediately and will be able to begin creating reports from SQL databases after just a few lessons.\u003c\/p\u003e\u003cp\u003eAlmost any modern organization can benefit from a staff member who knows how to generate database reports using the SQL language, but SQL is a rare skill among most office staff. Part of the reason that few people have SQL skills is that most related courses try to teach every aspect of database theory, including database design and server administration.\u003c\/p\u003e\u003cp\u003eThis course is different. It focuses entirely on database reporting and won't slow you down by trying to teach skills that you don't need. This course also focuses on skills that will be useful on many different types of database rather than teaching obscure commands that will only work on a certain type of database.\u003c\/p\u003eCourse Outline\u003cul\u003e\n\u003cli\u003eLesson 1: Install SQL Server Express\u003c\/li\u003e\n\u003cli\u003eLesson 2: Connect to SQL Server\u003c\/li\u003e\n\u003cli\u003eLesson 3: Install the sample database\u003c\/li\u003e\n\u003cli\u003eLesson 4: Explore a database\u003c\/li\u003e\n\u003cli\u003eLesson 5: Write your first database query\u003c\/li\u003e\n\u003cli\u003eLesson 6: Understand the SELECT statement and save a query\u003c\/li\u003e\n\u003cli\u003eLesson 7: Sort with ORDER BY and export query results\u003c\/li\u003e\n\u003cli\u003eLesson 8: Use the TOP and DISTINCT keywords\u003c\/li\u003e\n\u003cli\u003eLesson 9: Filter results with WHERE\u003c\/li\u003e\n\u003cli\u003eLesson 10: Use the LIKE keyword for inexact filters\u003c\/li\u003e\n\u003cli\u003eLesson 11: Use simple mathematical operators and custom column names\u003c\/li\u003e\n\u003cli\u003eLesson 12: Concatenate text and numbers\u003c\/li\u003e\n\u003cli\u003eLesson 13: Understand dates and use the CONVERT function\u003c\/li\u003e\n\u003cli\u003eLesson 14: Use logical operators and filter by date\u003c\/li\u003e\n\u003cli\u003eLesson 15: Use aggregate functions and GROUP BY\u003c\/li\u003e\n\u003cli\u003eLesson 16: Work with NULL values and the IN keyword\u003c\/li\u003e\n\u003cli\u003eLesson 17: Use the HAVING statement to filter aggregate results\u003c\/li\u003e\n\u003cli\u003eLesson 18: Use date functions\u003c\/li\u003e\n\u003cli\u003eLesson 19: Work with text functions\u003c\/li\u003e\n\u003cli\u003eLesson 20: Understand relationships\u003c\/li\u003e\n\u003cli\u003eLesson 21: Use inner joins to extract data from multiple tables\u003c\/li\u003e\n\u003cli\u003eLesson 22: Use outer joins\u003c\/li\u003e\n\u003cli\u003eLesson 23: Use full joins\u003c\/li\u003e\n\u003cli\u003eLesson 24: Use cross joins\u003c\/li\u003e\n\u003cli\u003eLesson 25: Use the CASE function\u003c\/li\u003e\n\u003cli\u003eLesson 26: Work with subqueries\u003c\/li\u003e\n\u003cli\u003eLesson 27: Use IN and EXISTS\u003c\/li\u003e\n\u003cli\u003eLesson 28: Use UNION to append the results of multiple queries together\u003c\/li\u003e\n\u003cli\u003eLesson 29: Create a View\u003c\/li\u003e\n\u003cli\u003eLesson 30: Analyze and optimize a query\u003c\/li\u003e\n\u003c\/ul\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 72\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.15 x 11.02 x 8.5 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e November 11, 2019\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":47391907873017,"sku":"9781916058668","price":13.48,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0789\/2782\/3097\/files\/T6Sf_T9GsI9781916058668.webp?v=1770232462","url":"https:\/\/bookscloud.io\/products\/sql-database-reporting-paperback","provider":"BooksCloud Book Dropshipping","version":"1.0","type":"link"}