¿Buscas alumnos?
Entra y promociona tus cursos
¿Buscas formación?
Entra o regístrate
Curso Presencial
Lugar:
Maracena
Duración:
21 Horas
Requisitos:
Residentes en España
Fomento Ocupacional nace en octubre del 1993. Desde el principio su misión ha sido clara y se ha mantenido vigente en el tiempo. Aportar una mejora en la calidad de la formación de estudiantes y profe...
contactar con el responsable| Requisitos |
Residentes en España
|
| Precio |
Consultar con el centro de formación |
Module 1: SQL Server Overview.
- What is SQL Server?.
- SQL Server Integration.
- SQL Server Databases.
- SQL Server Security.
- Working with SQL Server.
Module 2: Overview of Programming SQL Server.
- Designing Enterprise Application Architecture.
- SQL Server Programming Tools.
- The Transact-SQL Programming Language.
- Elements of Transact-SQL.
- Additional Language Elements.
- Ways to Execute Transact-SQL Statement.
Module 3: Creating and Managing Databases.
- Creating Databases.
- Creating Filegroups.
- Managing Databases.
- Introduction to Data Structures.
Module 4: Creating Data Types and Tables.
- Creating Data Types.
- Creating Tables.
- Generating Column Values.
- Generating Scripts.
Module 5: Implementing Data Integrity.
- Types of Data Integrity.
- Enforcing Data Integrity.
- Defining Constraints.
- Types of Constraints.
- Using Defaults and Rules.
- Deciding Which Enforcement Method to use.
Module 6: Planning Indexes.
- Introduction to Indexes.
- Index Architecture.
- How SQL Server Retrieves Stored Data.
- How SQL Server Maintains Index and Heap Structures.
- Deciding Which Columns to index.
Module 7: Creating and Maintaining Indexes.
- Creating indexes.
- Creating Index Options.
- Maintaining Indexes.
- Introduction to Statistics.
- Querying the sysindexes Table.
- Setting Up Indexes Using the Index Tuning Wizard.
- Performance Considerations.
Module 8: Implementing Views.
- Introduction to Views.
- Advantages of Views.
- Defining Views.
- Modifying Data Through Views.
- Optimizing Performance by Using Views.
- Performance Considerations.
Module 9: Implementing Stored Procedures.
- Introduction to Stored Procedures.
- Creating, Executing, Modifying, and Dropping Stored Procedures.
- Using Parameters in Stored Procedures.
- Executing Extended Stored Procedures.
- Handling Error Messages.
- Performance Considerations.
Module 10: Implementing Userdefined Functions.
- What Is a User-defined Function?.
- Defining User-defined Functions.
- Examples of User-defined Functions.
Module 11: Implementing Triggers.
- Introduction to Triggers.
- Defining Triggers.
- How Triggers Work.
- Examples of Triggers.
- Performance Considerations.
Module 12: Programming Across Multiple Servers.
- Introduction to Distributed Queries.
- Executing an Ad Hoc Query on a Remote Data Source.
- Setting Up a Linked Server Environment.
- Executing a Query on a Linked Server.
- Managing Distributed Transactions.
- Modifying Data on a Linked Server.
- Using Partitioned Views.
Module 13: Optimizing Query Performance.
- Introduction to the Query Optimizer.
- Obtaining Execution Plan Information.
- Using an Index to Cover a Query.
- Indexing Strategies.
- Overriding the Query Optimizer
Module 14: Analyzing Queries.
- Queries That Use the AND Operator.
- Queries That Use the OR Operator.
- Queries That Use Join Operations.
Module 15: Managing Transactions and Locks.
- Introduction to Transactions and Locks.
- managing Transactions.
- SQL Server Locking.
- Managing Locks
Requisitos:
Antes de asistir a este curso, el estudiante debería tener: Experiencia usando sistemas operativos Windows 2000; MOC-2151 Redes y fundamentos del sistema operativo Microsoft Windows 2000; MOC-2152 Implementar Microsoft Windows 2000 Professional y Server; Comprensión del concepto de base de datos relacional; Conocimiento básico de la sintaxis de sentencias SQL; Familiarizarse con los roles del Administrador de bases de datos.
| Dónde | Maracena, C/ Joaquin Blume, 2. ver mapa |
| Cuándo | Inicio: consultar al centro de formación |
