Fundación Tripartita

Writing Queries Using Microsoft SQL Server 2008 SQL MOC 2778 TransAC


This course provides the necessary expertise to write database queries Transact-SQL for Microsoft SQL Server 2008.

Who should attend?

This course is designed for administrators database SQL Server, implementers, system engineers and developers who are responsible for drafting the questions.

At the end of this year:

After completing this course, students will be able to: Describe the uses and forms deejecutar the Transact-SQL language. - Use laherramienta consultation. - Write SELECT queries to retrieve data. - Group and summarize data by using Transact-SQL. -Ingrés Devarias data tables. - Write querecuperar query and modify data by using subqueries. - Modify data in tables. -Consulta Detexto fields with full-text search. - Describe how to create programming objects. - Use various techniques to trabajarcon consultascomplejas.

Prerequisite Comments:

  • Skills relational database design
  • Programming skills
  • Knowledge of data integrity concepts.
  • Windows Server Basic skills
    Lesson 1: Introduction to Databases and Transact-SQL in SQL Server 2008
  • Information SQL Server 2008
  • Information Database SQL Server
  • Overview and syntax elements of T-SQL
  • Working with T-SQL Scripts
  • Use T-SQL query tools
    Lesson 2: Find and filter data
  • Use the SELECT
  • Filtering Data
  • Working with NULL
  • Formatting Result Sets
  • Performance Considerations for Writing Queries
    Lesson 3: How to group and summarize data
  • Summarize data with aggregate functions
  • Summarize grouped data
  • Traffic pooled
  • Create cross-reference queries
    Lesson 4: Join data from multiple tables
  • View multiple tables using combinations
  • The application joins for typical reporting needs
  • The combination of limited and result set
    Lesson 5: Working with Subqueries
  • Writing Basic Subqueries
  • Write correlated subquery
  • Comparing Subqueries with unions and temporary tables
  • Use common table expressions
    Lesson 6: Modifying Data in tables
  • insert data into tables
  • Deleting Data Tables
  • Update data in tables
  • Information transactions
    Lesson 7: Question metadata, XML, and full-text indexes
  • Metadata Query
  • Information XML
  • query XML data
  • List of full-text indexes
  • query full-text indexes
    Lesson 8: Using Programming Objects for Data Recovery
  • Summary Visitors
  • Understanding user-defined functions
  • Summary stored procedures
  • List Triggers
  • Writing Distributed Queries
    Lesson 9: Using Advanced Query Techniques
  • Considerations for data available
  • Working with data type
  • cursors and queries based on sets
  • Dynamic SQL
  • Maintaining query files

Utilizamos cookies propias y de terceros para mejorar nuestros servicios, personalizar y analizar sus hábitos de navegación y mostrarle publicidad relacionada con sus preferencias. Si continúa navegando, consideramos que acepta su uso. Puede cambiar la configuración u obtener más información acerca de las cookies en el siguiente enlace:Política de Cookies.

Aceptar Cookies