MCSA: SQL 2016 Database Development

Cas Training
Precio

Precio a consultar

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

Impartición

Máster en Madrid

Sedes

Madrid

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 más

Más cursos relacionados de Bases de datos

New Horizons Madrid

MCSA SQL Server 2016 Database Administration

New Horizons Madrid - Máster en Madrid
20764 ADMINISTERING A SQL DATABASE INFRASTRUCTURE 1 - AUTHENTICATING AND AUTHORIZING USERS Authenticating connections to SQL Server Authorizing
Descuento por matrícula anticipada

2.050 € 1.550 
PUE

MCSA SQL 2016 Database Administration

PUE - Curso en Madrid y 1 sede más
Protecting Data with Encryption and Auditing Recovery Models and Backup Strategies Backing Up SQL Server Databases Restoring SQL Server 2016 Databases

1.250 
Intergrupo

Máster MCSA: SQL SERVER 2012

Intergrupo - Máster online
de datos en SQL Server 2012 Simuladores de Examen 70-462 "Administering Microsoft SQL Server 2012 Databases" Módulo 3: Implementación de un Datawarehouse

Precio a consultar
Formatres

SQL

Formatres - Curso en GETAFE (Madrid)
· Claves primarias -primary key-. · Claves foráneas -foreign key-. · Restricciones -constraints-. · Tipos de datos · Caracteres · Numéricos · Fechas y

360 
Vision y Valor Consulting S.L

Administración Avanzada de Oracle Database 11G

Vision y Valor Consulting S.L - Curso online
1. INTRODUCCIÓN A ORACLE 11G: SQL Introducción Recuperación De Datos Mediante La Sentencia SQL Select Restricción Y Ordenación De Datos Uso

450 
IVA exento
Ver más