by Gregory A. Gavarian (Author)
A fast, easy, no-nonsense guide to SQL Server. This book will take you from the very basics of querying with SQL Server to more advanced topics. It covers all major topics including selecting from tables, filtering, grouping/aggregations, joining tables, window functions, and more. For a full breakdown of topics covered, see the table of contents below.While this book is aimed at beginners, more experienced users can definitely find something to learn from this, and/or use it as a reference book. SQL Server is the main database management system (DBMS) covered by the book, but users of other DBMSs should be able to find useful information, since many SQL commands are transferrable to other platforms. Topics covered in this book1. Introduction 2. Creating and modifying databases and tables 3. Choosing and filtering columns 4. Choosing and filtering rows 5. Aggregating data 6. Subqueries 7. Common table expressions 8. Reading from multiple tables 9. Updating and deleting data 10. Advanced functionality 11. Indexes 12. Selected functions