A Step-by-Step Approach
De som köpt den här boken har ofta också köpt Tomorrow, And Tomorrow, And Tomorrow av Gabrielle Zevin (häftad).Köp båda 2 för 810 kr
Kathi Kellenberger is an editor and DevOps advocate at Redgate Software and a Microsoft Data Platform MVP. She has been working with SQL Server for over 20 years, starting with version 6.5. She has worked as a developer, database administrator, and consultant. Kathi has been involved with almost 20 book projects as an author, co-author, or technical editor, and enjoys presenting at events, webinars, and user groups. When not working, she teaches T-SQL to beginners at a non-profit in St. Louis, Missouri that helps people transition to tech careers. Lee Everest is a SQL Server developer who has worked with the product since version 6.5. He has taught part-time at Dallas College North Lake Campus for 18 years, and has had several students move on to companies such as Microsoft, filling roles from support engineer to data scientist to vice president. When Lee isn't working, he enjoys computers, golf, and fishing.
1. Getting Started 2. Exploring Database Concepts 3. Writing Simple SELECT Queries4. Using Built-In Functions and Expressions5. Joining Tables6. Building on Subqueries, Common Table Expressions, and Unions7. Grouping and Summarizing Data8. Discovering Windowing Functions9. Advanced WHERE Clauses10. Manipulating Data11. Managing Transactions12. Understanding T-SQL Programming Logic13. Implementing Logic in the Database 14. Expanding on Data Type Concepts15. Working with XML and JSON16. Writing Advanced Queries17. Where to Go Next?Appendix A: SQL Server for Linux and macOS Appendix B: Using SSMSAppendix C: SQL Notebooks