Curso de Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Galería de imágenes

InterSoftware

Comentarios sobre Curso de Writing Queries Using Microsoft SQL Server 2008 Transact-SQL - Presencial - Benito Juárez - Ciudad de México - CDMX - Ciudad de México

• Objetivos del curso
  This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
• Curso dirigido a
  This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.
• Contenido
  Prerrequisitos
  
  Before attending this course, students must have:
  •Knowledge of data integrity concepts.
  •Core Windows Server skills.
  •Relational database design skills.
  •Programming skills.
   
  After completing this course, students will be able to:
  •Describe the uses of and ways to execute the Transact-SQL language.
  •Use querying tool.
  •Write SELECT queries to retrieve data.
  •Group and summarize data by using Transact-SQL.
  •Join data from multiple tables.
  •Write queries that retrieve and modify data by using subqueries.
  •Modify data in tables.
  •Query text fields with full-text search.
  •Describe how to create programming objects.
  •Use various techniques when working with complex queries.
  
  Module 1: Getting Started with Databases and Transact-SQL in SQL Server 2008
  Module 2: Querying and Filtering Data
  Module 3: Grouping and Summarizing Data
  Module 4: Joining Data from Multiple Tables
  Module 5: Working with Subqueries
  Module 6: Modifying Data in Tables
  Module 7: Querying Metadata, XML, and Full-Text Indexes
  Module 8: Using Programming Objects for Data Retrieval
  Module 9: Using Advanced Querying Techniques
  

Otra formación relacionada con programación sql