->
Lynda - Querying Microsoft SQL Server 2012 - 156769
Lynda - Querying Microsoft SQL Server 2012
Learn how to query data from SQL Server tables. Microsoft Certified Trainer Gerry O'Brien reviews the history of SQL and relational theory, so you'll understand exactly where this data manipulation language, and Microsoft's seminal database program, got their starts. Then he shows how to query one or many different tables using SELECT statements, and filter, group, and sort the results. Next, learn how to work with special data types like dates, times, and characters. Gerry also covers advanced topics like subqueries, programming with T-SQL (Microsoft's proprietary extension for SQL), and improving query performance.


Table of Contents

  • Introduction
  • 1. SQL Query Fundamentals
  • 2. Query the Database
  • 3. Filtering Results
  • 4. Query Multiple Tables
  • 5. Grouping and Sorting
  • 6. Querying with Data-Type Considerations
  • 7. Subqueries and Table Expressions
  • 8. Programming with T-SQL
  • 9. Query Performance
  • Conclusion
  • Lynda - Querying Microsoft SQL Server 2012


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss