TY - GEN AU - Nield,Thomas TI - Getting Started with SQL: a hands-on approach for beginners SN - 9783030109189 U1 - 005.7565 23 PY - 2016/// CY - Mumbai PB - O'Reilly Media KW - Relational Databases KW - SQL KW - Computer program language KW - Database Management N1 - Includes index; Preface -- 1. Why Learn SQL? -- 2. Databases -- 3. SQLite -- 4. SELECT -- 5. WHERE -- 6. Group by and order by -- 7. CASE Statements-- 8. JOIN -- 9. Database design -- 10. Managing Data -- 11. Going Forward -- A. Operators and functions -- B. Supplementary Topics -- N2 - Quickly master the fundamentals of SQL right in your own home, without having to use a database server environment. Ideal for business professionals as well as absolute beginners who want to acquire data proficiency, this practical guide teaches you how to pull and transform data in meaningful ways. You’ll also learn how to design your own databases, using best practices in table design. Practice at home with hands-on exercises to learn SQL Leverage SQLite and SQLiteStudio to create databases within minutes Query, transform, and aggregate data to make it meaningful Join tables to get a more complete view of your business data Create resilient databases with normalized design principles ER -