El buscador de formación
¿Te ayudamos? 900 49 47 47

  

Curso MCSA: SQL 2016 Database Development

Curso en Madrid (Madrid)

CAS TRAINING

Consultar precio

Nuestro portal te presenta el curo "MCSA: SQL 2016 Database Development" impartido por el centro Cas Training.

Temario completo de este curso

MOC 20 761 Querying Data with Transact-SQL

  • 1. Introduction to Microsoft SQL Server 2016
  • 1.1. The Basic Architecture of SQL Server
  • 1.2. SQL Server Editions and Versions
  • 1.3. Getting Started with SQL Server Management Studio
  • 2. Introduction to T-SQL Querying
  • 2.1. Introducing T-SQL
  • 2.2. Understanding Sets
  • 2.3. Understanding Predicate Logic
  • 2.4. Understanding the Logical Order of Operations in SELECT statements
  • 3. Writing SELECT Queries
  • 3.1. Writing Simple SELECT Statements
  • 3.2. Eliminating Duplicates with DISTINCT
  • 3.3. Using Column and Table Aliases
  • 3.4. Writing Simple CASE Expressions
  • 4. Querying Multiple Tables
  • 4.1. Understanding Joins
  • 4.2. Querying with Inner Joins
  • 4.3. Querying with Outer Joins
  • 4.4. Querying with Cross Joins and Self Joins
  • 5. Sorting and Filtering Data
  • 5.1. Sorting Data
  • 5.2. Filtering Data with Predicates
  • 5.3. Filtering with the TOP and OFFSET-FETCH Options
  • 5.4. Working with Unknown Values
  • 6. Working with SQL Server 2016 Data Types
  • 6.1. Introducing SQL Server 2016 Data Types
  • 6.2. Working with Character Data
  • 6.3. Working with Date and Time Data
  • 7. Using DML to Modify Data
  • 7.1. Inserting Data
  • 7.2. Modifying and Deleting Data
  • 8. Using Built-In Functions
  • 8.1. Writing Queries with Built-In Functions
  • 8.2. Using Conversion Functions
  • 8.3. Using Logical Functions
  • 8.4. Using Functions to Work with NULL
  • 9. Grouping and Aggregating Data
  • 9.1. Using Aggregate Functions
  • 9.2. Using the GROUP BY Clause
  • 9.3. Filtering Groups with HAVING
  • 10. Using Subqueries
  • 10.1. Writing Self-Contained Subqueries
  • 10.2. Writing Correlated Subqueries
  • 10.3. Using the EXISTS Predicate with Subqueries
  • 11. Using Set Operators
  • 11.1. Writing Queries with the UNION Operator
  • 11.2. Using EXCEPT and INTERSECT
  • 11.3. Using APPLY

MOC 20 762 Developing SQL Databases
  • 1. Introduction to Database Development
  • 1.1. Introduction to the SQL Server Platform
  • 1.2. SQL Server Database Development Tasks
  • 2. Designing and Implementing Tables
  • 2.1. Designing Tables
  • 2.2. Data Types
  • 2.3. Working with Schemas
  • 2.4. Creating and Altering Tables
  • 3. Advanced Table Designs
  • 3.1. Partitioning Data
  • 3.2. Compressing Data
  • 3.3. Temporal Tables
  • 4. Ensuring Data Integrity through Constraints
  • 4.1. Enforcing Data Integrity
  • 4.2. Implementing Data Domain Integrity
  • 4.3. Implementing Entity and Referential Integrity
  • 5. Introduction to Indexes
  • 5.1. Core Indexing Concepts
  • 5.2. Data Types and Indexes
  • 5.3. Heaps, Clustered, and Nonclustered Indexes
  • 5.4. Single Column and Composite Indexes
  • 6. Designing Optimized Index Strategies
  • 6.1. Index Strategies
  • 6.2. Managing Indexes
  • 6.3. Execution Plans
  • 6.4. The Database Engine Tuning Advisor
  • 6.5. Query Store
  • 7. Columnstore Indexes
  • 7.1. Introduction to Columnstore Indexes
  • 7.2. Creating Columnstore Indexes
  • 7.3. Working with Columnstore Indexes
  • 8. Designing and Implementing Views
  • 8.1. Introduction to Views
  • 8.2. Creating and Managing Views
  • 8.3. Performance Considerations for Views
  • 9. Designing and Implementing Stored Procedures
  • 9.1. Introduction to Stored Procedures
  • 9.2. Working with Stored Procedures
  • 9.3. Implementing Parameterized Stored Procedures
  • 9.4. Controlling Execution Context
  • 10. Designing and Implementing User-Defined Functions
  • 10.1. Overview of Functions
  • 10.2. Designing and Implementing Scalar Functions
  • 10.3. Designing and Implementing Table-Valued Functions
  • 10.4. Considerations for Implementing Functions
  • 10.5. Alternatives to Functions
  • 11. Responding to Data Manipulation via Triggers
  • 11.1. Designing DML Triggers
  • 11.2. Implementing DML Triggers
  • 11.3. Advanced Trigger Concepts
  • 12. Using In-Memory Tables
  • 12.1. Memory-Optimized Tables
  • 12.2. Natively Compiled Stored Procedures
  • 13. Implementing Managed Code in SQL Server
  • 13.1. Introduction to CLR Integration in SQL Server
  • 13.2. Implementing and Publishing CLR Assemblies
  • 14. Storing and Querying XML Data in SQL Server
  • 14.1. Introduction to XML and XML Schemas
  • 14.2. Storing XML Data and Schemas in SQL Server
  • 14.3. Implementing the XML Data Type
  • 14.4. Using the Transact-SQL FOR XML Statement
  • 14.5. Getting Started with XQuery
  • 14.6. Shredding XML
  • 15. Storing and Querying Spatial Data in SQL Server
  • 15.1. Introduction to Spatial Data
  • 15.2. Working with SQL Server Spatial Data Types
  • 15.3. Using Spatial Data in Applications
  • 16. Storing and Querying BLOBs and Text Documents in SQL Server
  • 16.1. Considerations for BLOB Data
  • 16.2. Working with FILESTREAM
  • 16.3. Using Full-Text Search
  • 17. SQL Server Concurrency
  • 17.1. Concurrency and Transactions
  • 17.2. Locking Internals
  • 18. Performance and Monitoring
  • 18.1. Extended Events
  • 18.2. Working with extended Events
  • 18.3. Live Query Statistics
  • 18.4. Optimize Database File Configuration
  • 18.5. Metrics

 
ver temario completo
 
  

Más cursos relacionados de Informática y tecnología



  • SEAS, Estudios Superiores Abiertos

    Requisitos: Ser mayor de 21 años y estar en posesión de un título universitario, o bien tener experiencia profesional en el sector.

    Máster
    Online
    Consultar precio


  • OpenClassrooms

    Objetivos: Siguiendo el programa de desarrollo web - frontend aprenderás a:Utilizar herramientas como JQuery para concebir proyectos webs profesionales.Implementar tests unitarios y tests de ...

    Carrera universitaria
    Online
    3.600 €


  • Esneca

    El curso está estructurado en dos grandes partes: el contenido del primer bloque se centra en un estudio profundo del lenguaje, desde la sintaxis hasta cómo está implementada la programación ...

    Máster
    Distancia
    2.300 € 575 € Descuento


  • CAS TRAINING

    El programa contiene el track formativo oficial necesario para presentarse a los exámenes de certificación:- 1Z0-808: Java SE 8 Programmer I (OCA)- 1Z0-809: Java SE 8 Programmer II (OCP) Requisitos: ...

    Curso
    Presencial en Madrid
    Consultar precio


  • FP Jesuïtes - UOC

    El ciclo formativo de grado superior de Desarrollo de Aplicaciones Multiplataforma está pensado para todas aquellas personas a las que les apasiona el mundo de la programación y el desarrollo en ...

    Ciclo formativo
    Online
    Consultar precio


  • VIU Valencian International University

    Objetivos: 1) Comprender los fundamentos en el diseño de experiencias.2) Maximizar el uso de game engines para el rápido desarrollo de videojuegos.3) Aprender las particularidades de los ...

    Máster
    Online
    4.980 €


  • Deusto Formación

    Objetivos: En esta formación anunciada en Lectiva.com se estudiará la evolución y el mercado del sector del videojuego, sus bases, la técnica de la creación de un producto de este tipo, aprenderás a ...

    Curso
    Online
    Consultar precio