1 / 20

Querying Microsoft SQL Server 2012

Querying Microsoft SQL Server 2012. Version 1.0. Author. MCAD MCSD MCPD Enterprise SQL MCTS MCT Software/Web Development Consultant Cryptography/Digital Signature Consultant SQL Server 2005/2008R2/2012 Consultant SharePoint 2007/2010/2013 Consultant AJAX Consultant

xena
Télécharger la présentation

Querying Microsoft SQL Server 2012

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Querying Microsoft SQL Server 2012 Version 1.0

  2. Author • MCAD • MCSD • MCPD Enterprise • SQL MCTS • MCT • Software/Web Development Consultant • Cryptography/Digital Signature Consultant • SQL Server 2005/2008R2/2012 Consultant • SharePoint 2007/2010/2013 Consultant • AJAX Consultant • Software Development Lead • Professional Scrum Master • Ahmad Adel Gad • mct@jemmail.com

  3. Course Outline • Overview • Select Statement - Retrieve Data • Select Statement - Filtering Data • Working with NULL Values • Formatting Result Sets • System Functions • Combining and Limiting Result Sets • Grouping Data • Using Table Expressions Querying Microsoft SQL Server 2012 - Ahmad Adel

  4. Course Outline • Windowing and Paging Data (Over Clause) • Querying SQL Server Metadata • Data Manipulation Language (DML) • Querying Full-Text Index Search • Distributed Queries • Implementing Error Handling (Handling Exceptions) • Implementing Transactions (TCL) Querying Microsoft SQL Server 2012 - Ahmad Adel

  5. Overview • About SQL Language (T-SQL) • Introduction to Microsoft SQL Server 2012 Querying Microsoft SQL Server 2012 - Ahmad Adel

  6. Select Statement - Retrieve Data • Fixed Values • Variables • Calculated Values • All Fields From Specific Table • Specific Fields From Specific Table • Concatenated Fields - Alias Name • Calculated Value On Specific Fields • Specific Columns From Table Alias Name • Value Returned From Function Querying Microsoft SQL Server 2012 - Ahmad Adel

  7. Select Statement - Filtering Data • Comparison operators • Logical operators Querying Microsoft SQL Server 2012 - Ahmad Adel

  8. Working with NULL Values • IS Null - Comparison • ANSI_NULLS Settings • ISNULL() Function • NullIF() Function • Coalesce()Function Querying Microsoft SQL Server 2012 - Ahmad Adel

  9. Formatting Result Sets • Sorting Data • Eliminating Duplicate Rows Querying Microsoft SQL Server 2012 - Ahmad Adel

  10. System Functions • Aggregate Functions • Scalar Functions • Converting Functions Querying Microsoft SQL Server 2012 - Ahmad Adel

  11. Combining and Limiting Result Sets • Join • Inner/Where Clause • Outer(Full/Left/Right) • Cross • Self Join • Data Samples (TableSampleOperator) • Cube • Union/Except/Intersect • Apply (Cross/Outer) Querying Microsoft SQL Server 2012 - Ahmad Adel

  12. Grouping Data • Group By • RollUP • Cube • Pivot - UnPivot Querying Microsoft SQL Server 2012 - Ahmad Adel

  13. Using Table Expressions • Sub Queries • Derived Tables • Common Table Expressions (CTE) • Views • Table-Valued Functions Querying Microsoft SQL Server 2012 - Ahmad Adel

  14. Windowing and Paging Data (Over Clause) • Paging Functions • Offset– Fetch • Row_Number • Over Clause • Ranking Functions • Analytic Functions • Aggregate Functions • NEXTVALUEFOR Querying Microsoft SQL Server 2012 - Ahmad Adel

  15. Querying SQL Server Metadata • System Variable • System Stored Procedures • System Catalog Views • System Catalog Functions • Dynamic Management Views (DMV) • Dynamic Management Functions (DMF) Querying Microsoft SQL Server 2012 - Ahmad Adel

  16. Data Manipulation Language (DML) • Insert • Update • Delete • Output Clause Querying Microsoft SQL Server 2012 - Ahmad Adel

  17. Querying Full-Text Index Search • Contains • FreeText Querying Microsoft SQL Server 2012 - Ahmad Adel

  18. Distributed Queries • OpenDataSource Function • OpenRowSet Function • Configure 'Ad Hoc Distributed Queries' Settings Querying Microsoft SQL Server 2012 - Ahmad Adel

  19. Implementing Error Handling (Handling Exceptions) • @@Error Variable • Try … Catch • Throw Exceptions • RaiseError • Throw • System Error Information Functions • Error Severities Querying Microsoft SQL Server 2012 - Ahmad Adel

  20. Implementing Transactions (TCL) • AutocommitTransactions • Implicit Transactions • Explicit Transactions • XACT_ABORT Setting • Implementing Transactions with Exception Handling • XACT_STATE() Function • Isolation Levels Querying Microsoft SQL Server 2012 - Ahmad Adel

More Related