Cursos de MSSQL

MSSQL Training

MSSQL courses

Testi...Client Testimonials

Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012

I appreciated Fulvio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).

Raphael Keymer - Markit Valuations Limited

Programas de los Cursos de MSSQL

Código Nombre Duración Información General
3119 Business Intelligence in MS SQL Server 2008 14 horas Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008. Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008. Gain knowledge of how to build a simple ETL process based on the SSIS and then design and implement a data cube using SSAS. The participant will be able to manage OLAP database: create and delete database OLAP Processing a partition changes on-line. The participant will acquire knowledge of scripting XML / A and MDX. basis, objectives and application of data warehouse, data warehouse server types base building ETL processes in SSIS basic design data cubes in an Analysis Services: measure group measure dimensions, hierarchies, attributes, development of the project data cubes: measures calculated, partitions, perspectives, translations, actions, KPIs, Build and deploy, processing a partition the base XML / A: Partitioning, processes and overall Incremental, delete partitions, processes of aggregation, base MDX language
ddavsvbsqls Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012 21 horas This course is divided into 3 main sections and is made up of a mixture of presentations and practical exercises. VB.NET Language in Visual Studio 2012 VB.NET Object Orientation VB.NET and Sql Server 2012 Part I. VB.NET Language in Visual Studio 2012 Module 1. Introduction to Visual Basic 2012 The Object-Oriented Programming The Visual Studio 2012 IDE Creating a new Application Using the Help System Module 2. The Microsoft .NET Framework The .NET Framework Classes Executing the Code Common Language Runtime Code Loading and Execution Application Isolation Security Interoperability Exception Handling Module 3. The Visual Basic 2012 Language Data Types Storing Variables Using Methods Making Decisions Working with Data Structures Using Arrays, Enumerations and Collections Module 4. Building Windows Applications Responding to Events Creating the Toolbar Creating the Status Bar Using Multiple Forms OpenFileDialog and SaveDialog controls PrintDialog and FolderBrowserDialog controls Understanding Menu Features Creating Menus Context Menus Part II. VB.NET Object Orientation Module 5. Building Objects Understanding Objects Encapsulation Methods and Properties Managing Events Building Classes Using Constructors Managing Inheritance Module 6. Advanced Language Constructs Using Lambda Expressions Using Async and Wait Using Iterators Module 7. Exception Handling and Debugging Handling Exceptions Try, Catch, Finally The Throw Keyword The Exit Try Statement Using Exit Try Statement Using Exception Properties Logging Errors Module 8. Parallel Programming Using Tasks and Threads Launching Parallel Tasks Transforming Sequential Code to Parallel Code Parallelizing Loops Specifying the Desired Degree of Parallelism Creating and Managing Tasks Part III. VB.NET and Sql Server 2012 Module 9. Database Programming with Sql Server 20012 and ADO.NET The ADO.NET architecture The Connection class The Command and DataReader Classes The ExecuteReader(), ExecuteScalar(), ExecuteNonQuery() methods Using Parameterized Commands Calling Stored Procedure Managing Transactions Module 10. Data Components and the DataSet Building a Data Access Component Managing Disconnected Data The DataSet Class The DataAdapter Class: Filling a DataSet, working with Multiple Tables and Relationships The DataView Class Module 11. Using Data Binding Basic Data Binding Data Source Controls The SqlDataSource Inserting, Updating, Deleting and Selecting records
3033 Administering in Microsoft SQL Server 21 horas The course is designed for administrators, developers and database developers. The objectives of the training: acquire and strengthen the skills to create and manage databases knowledge of the syntax and use SQL to retrieve and modify data apply safety rules in the database the use of advanced elements (replication, automation, BI) the use of Microsoft SQL Server capabilities to create complex reports and solutions for developers Basic information about databases Database files, Database Client / Server Relational database management systems (RDBMS) SQL Server versions and the differences between them Express, Standard, Enterprise Workgroup, Mobile , Developer SQL Server Tools SQL Server Management Studio SQL Server Agent Services in SQL Server Database Services Analysis Services Reporting Services Integration Services Base system Master Model Msdb Tempdb Distribution Resource       Create a database The database files and their location File size and its growth Partitioning tables Data Modification Language (DML) INSERT UPDATE DELETE Data Definition Language (DDL) Designing Tables Columns and Attributes Determine the type of data Indexes and Keys Indexes Clustered Indexes Non-Clustered Indexes REBUILD vs. REORGANIZE  Creating a database application Server-side programming Procedures Views Functions Triggers Models play Simple Full Bulk logged Backup Full Differential Transaction Log Backup Strategies Strategy full copy of the database Strategy of full backups and transaction log The strategy of incremental database backup Strategy copy of the database files Basic security and administration of SQL Server Automation Maintenance Plan Jobs Basic security and administration of SQL Server Server Roles Database Roles SA Account Creating Accounts Schemes High Availability Log Shipping Database Mirroring Server Clustering Replication Snapshot Replication Transactional Replication Merge Replication Activity Monitor SQL Server SQL Server Profiler Upgrade In-Place vs. Side-By-Side Service-Pack Cluster Best Practices
67592 SQL Server 2008 Administration 28 horas This SQL Server Administration training course teaches students how to administer a SQL Server 2008. Objectives Install and configure Microsoft SQL Server Create databases and tables Implement indexes and partitions Take database snapshots Implement service broker for asynchronous processing of database requests Create and use full-text indexes Secure SQL Server and implement policy-based management Recover data Automate administrative tasks with the SQL Server Agent Use Dynamic Management Views to monitor the database and troubleshoot problems Configure a SQL Server for high availability using failover clustering, database mirroring, log shipping, and replication Overview of Microsoft SQL Server 2008 Database Engine Business Intelligence Installing and Configuring SQL Server 2008 Editions of SQL Server Infrastructure Requirements Service Accounts Collation Sequences Authentication Modes SQL Server Instances Upgrading to SQL Server Installing SQL Server Using the Tools in SQL Server 2008 SQL Server Documentation Management Tools in SQL Server Performance Management Tools Business Intelligence Tools Creating Databases SQL Server System Databases SQL Server Database Structure Creating a Database Moving Databases Designing Tables Naming Objects Schemas Data Types Column Properties Creating Tables Computed Columns Sparse Columns Constraints Database Diagrams Indexes Index Structure Clustered Indexes Nonclustered Indexes Included Columns Filtered Indexes Online Index Creation Index Management and Maintenance XML Indexes Spatial Indexes Partitioning Partition Functions Partition Schemes Partitioning Tables and Indexes Managing Partitions Database Snapshots Creating a Database Snapshot Reverting Data Using a Database Snapshot Service Broker Service Broker Architecture Message Types and Contracts Queues and Services Conversations Sending and Receiving Messages Queue Activation Prioritization Full-Text Indexing Full-Text Catalogs Full-Text Indexes Querying Full-Text Data Security Configuring the Attack Surface Endpoints Principals, Securables, and Permissions CLR Security Data Encryption Policy-Based Management Overview of Policy-Based Management Facets Conditions Policy Targets Policies Policy Categories Policy Compliance Data Recovery Database Backups Recovery Models Database Restores SQL Server Agent Creating Jobs Creating Maintenance Plans Creating Alerts Dynamic Management Views Overview of DMVs Retrieving Object Metadata Database Diagnostics High Availability Failover Clustering Database Mirroring Log Shipping Replication
66437 Microsoft SQL Server 2008/2012 (MSSQL) 14 horas This course has been created for delegates already acquainted with SQL in Microsoft SQL Server Environment 2008/2012. The course focuses on set-based querying and query tuning, working with indexes and analyzing execution plans. The training also covers table expressions, ranking functions and how to deal with partitioned tables. Module 1. Query Tuning Tools for Query Tuning Cached Query Execution Plans Clearing the Cache Analyzing Execution Plans Hints Using the Database Engine Tuning Advisor Index Tuning Table and Index Structures Index Access Methods Indexing Strategies Module 2. Subqueries, Table Expression, and Ranking Functions Writing Subqueries Using Table Expressions Using Ranking Functions Module 3. Optimizing Joins and Set Operations Fundamental Join Types Join Algorithm Set Operations Using INTO with Set Operation Module 4. Aggregating and Pivoting Data Using the OVER Clause Different types of aggregations (Cumulative, Sliding and Year-To-Date) Pivoting and Unpivoting Setup Custom Aggregations Using GROUPING SETS Subclause CUBE and RULLUP Subclauses How to materialize Grouping Sets Module 5. Using TOP and APPLY SELECT TOP Using the APPLY table operator TOP n at the Group Level Implementing Paging Module 6. Optimizing Data Transformation Inserting data with Enhanced VALUES Clause Using the BULK Rowset Provider Using INSERT EXEC The Sequence Mechanisms DELETE with joins UPDATE with joins MERGE statement The OUTPUT Clause with INSERT The OUTPUT Clause with DELETE The OUTPUT Clause with UPDATE The OUTPUT Clause with MERGE Module 7. Querying Partitioned Tables Partitioning in SQL Server How to write queries on partitioned tables How to write queries on partitioned views
3092 SQL language in MSSQL 14 horas The course answers questions How to build a query? What opportunities have SQL? What is a relational database? What is the structure and SQL commands? Relational database models The structure of a relational database Relational operators Download the data Rules for writing SQL queries The syntax for the SELECT Selecting all columns Inquiries from arithmetic operations Aliases columns Literals Concatenation Restrict results The WHERE clause The comparison operators. LIKE Condition Prerequisite BETWEEN ... AND IS NULL condition IN condition. Logical operators Many of the conditions in the WHERE clause The order of operators DISTINCT clause Sorting Data The ORDER BY clause Sorting by multiple columns or expressions SQL Functions The differences between the functions of single and multi-rows Functions text, numeric, date, Conversion functions Nesting functions Handling of NULL values Aggregating data using the grouping function Grouping functions How grouping functions treat NULL values Create groups of data - the GROUP BY clause Grouping multiple columns Reducing the function result grouping - the HAVING clause Retrieving data from multiple tables Types of joins Aliases tables Joins in the WHERE clause INNER JOIN Inner join External Merge LEFT, RIGHT Cartesian product Subqueries Place subqueries in the SELECT command Subqueries single and multi-lineage Operators Subqueries single-line Operators Subqueries multi-IN, ALL, ANY Collective operators UNION operator INTERSECT operator EXCEPT operator Insert, update, and delete data INSERT command UPDATE command DELETE command Transactions
SQL100 Fundamentos de T-SQL con el Servidor SQL 16 horas Este curso de formación de SQL es para personas que quieren adquirir habilidades básicas para tratar con bases de datos de SQL Server. El curso ayudará a los miembros a aprender: Cómo trabajar con SQL Server y SQL Server Management Studio. Significado de bases de datos, SQL y RDBMS etc. Cómo crear tablas, use DDL, DML y DAL. Cuáles son los diversos paquetes de RDBMS en el mercado y cómo se comparan entre sí. Una introducción a NoSQL y cómo son las organizaciones están cambiando en bases de datos híbridas. Cuál es el significado de las bases de datos. Comparación de RDBMS y DBMS Diferentes RDBMS disponibles en el mercado. ¿Qué es SQL Server? Trabajar con SQL Server Management Studio Trabajo con sublanguages como DDL, DML, DAL. Creación de tablas, tipos de datos, restricciones y su definición. Uso de instrucciones Insert, Delete y Update. Utilizando Select Query y sus diversos operadores. Uso de Nulo, No Nulo, Y, O, Entre, Exista, Ordenar por, Agrupar por, Tener cláusula ¿Cuáles son las funciones incorporadas? Matemáticas, Cadena y Fecha. Trabajo con vistas. Cómo se utilizan para el acceso a los datos. Trabajo con uniones. Se une a tipos y obtiene datos de varias tablas. Trabajo con sub consultas. Qué es una subconsulta correlacionada. Diferencia entre Sub Query y Joins. Cuáles son expresiones comunes de la tabla. Uso de expresiones de tabla común recursiva.
mssql2016 MS SQL Server 2016 14 horas Actuación y Gestión Caching mejorado de la base de datos Almacén de datos de consulta OLTP en memoria en SQL Server 2016 Desarrollo Base de datos temporal Tabla Temporal y Tabla Variable en memoria Native JSON Alta disponibilidad y seguridad Siempre mejorado Siempre encriptado Seguridad en fila Mascarilla dinámica de datos Insight de Datos y Inteligencia de Negocio Analítica Operacional Nueva funcionalidad Columnstore Index Consulta directa en tablas SSAS R Integration (lenguaje R en SQL Server) SSIS mejorado MDS mejorado Servicios de Informes Nuevo servidor de informes Informes Mobil Editor de informes de SQL Server Mobile Nube e híbrido Estiramiento de la base de datos Copia de seguridad mejorada a Azure Migración de SQL Server a Azure SSIS y Fábrica de Datos

Próximos Cursos

Other regions

Cursos de Fin de Semana de MSSQL, Capacitación por la Tarde de MSSQL, MSSQL boot camp, Clases de MSSQL , Clases de MSSQL , MSSQL coaching, Cursos de Formación de MSSQL, MSSQL en sitio, Cursos Privados de MSSQL, Clases Particulares de MSSQL, Capacitación empresarial de MSSQL, Instructor de MSSQL, MSSQL con instructor, Talleres para empresas de MSSQL, Cursos por la Tarde de MSSQL, Programas de capacitación de MSSQL,Capacitación de Fin de Semana de MSSQL, Cursos en linea de MSSQL


Descuentos en los Cursos

Respetamos la privacidad de su dirección de correo electrónico. No vamos a pasar o vender su dirección a otros.
Siempre puede cambiar sus preferencias o anular la suscripción por completo.

Algunos de nuestros clientes