Descreva:
INSCREVA-SE AGORA!
INSCRIÇÃO ONLINE





CURSOS 30% OFF e FORMAÇÕES 40% OFF


Descontos em Cursos
X

Combo MCSA Microsoft SQL Server 2014

5 (20)votos

Cursos da Formação:

20461 - Querying Microsoft SQL Server 2014
20462 - Administrando Microsoft SQL Server 2014 Databases
20463 - Implementando Data Warehouse com Microsoft SQL Server 2014

Objetivo do Curso:

Este curso tem como objetivo fornece aos alunos o conhecimento e as habilidades para manter um banco de dados no software Microsoft SQL Server . O curso se concentra em ensinar as pessoas como usar SQL Server 2014 recursos de produtos e ferramentas relacionadas com a manutenção de um banco de dados. Nota: Este curso é destinado aos clientes que estão interessados ??em aprender SQL Server 2012 ou SQL Server 2014. Abrange os novos recursos do SQL Server 2014, mas também as capacidades importantes em toda a plataforma de dados SQL Server.
Combo MCSA Microsoft SQL Server 2014
Combo MCSA Microsoft SQL Server 2014
Carga Horaria 120 h Pretendo Fazer
-
PRÓXIMAS TURMAS PREVISTAS
10/04/17 - NOTURNO - SP
08/05/17 - NOTURNO - SP
05/06/17 - NOTURNO - SP
de R$ 5.970,00    (60% de desconto)
por R$ 2.388,00
12x de R$ 199,00 sem juros
Curso presencial e remoto ao vivo Formas de Pagamento
  CONSULTE-NOS >
  INSCREVA-SE >

Conteúdo Programático:

20461 - Querying Microsoft SQL Server 2014

Course Objectives

After completing this course, students will be able to:

  • Write SELECT queries
  • Query multiple tables
  • Sort and filter data - Describe the use of data types in SQL Server
  • Modify data using Transact-SQL
  • Use built-in functions
  • Group and aggregate data
  • Use subqueries
  • Use table expressions
  • Use set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting and grouping sets
  • Execute stored procedures
  • Program with T-SQL
  • Implement error handling
  • Implement transactions


Course Outline
1 - Introduction to Microsoft SQL Server 2014

  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio
  • Lab : Working with SQL Server 2014 Tools

2 - Introduction to T-SQL Querying

  • Introducing T-SQL
  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements
  • Lab : Introduction to Transact-SQL Querying

3 - Writing SELECT Queries

  • Writing Simple SELECT Statements
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Writing Simple CASE Expressions
  • Lab : Writing Basic SELECT Statements

4 - Querying Multiple Tables

  • Understanding Joins
  • Querying with Inner Joins
  • Querying with Outer Joins
  • Querying with Cross Joins and Self Joins
  • Lab : Querying Multiple Tables

5 - Sorting and Filtering Data

  • Sorting Data
  • Filtering Data with a WHERE Clause
  • Filtering with the TOP and OFFSET-FETCH Options
  • Working with Unknown and Missing Values
  • Lab : Sorting and Filtering Data

6 - Working with SQL Server 2014 Data Types

  • Introducing SQL Server 2014 Data Types
  • Working with Character Data
  • Working with Date and Time Data
  • Lab : Working with SQL Server 2014 Data Types
  •  

7 - Using DML to Modify Data

  • Inserting Data
  • Modifying and Deleting Data
  • Lab : Using DML to Modify Data

8 - Using Built-In Functions

  • Writing Queries with Built-In Functions
  • Using Conversion Functions
  • Using Logical Functions
  • Using Functions to Work with NULL
  • Lab : Using Built-In Functions

9 - Grouping and Aggregating Data

  • Using Aggregate Functions
  • Using the GROUP BY Clause
  • Filtering Groups with HAVING
  • Lab : Grouping and Aggregating Data

10 - Using Subqueries

  • Writing Self-Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries
  • Lab : Using Subqueries

11 - Using Table Expressions

  • Using Derived Tables
  • Using Common Table Expressions
  • Using Views
  • Using Inline Table-Valued Functions
  • Lab : Using Table Expressions

12 - Using Set Operators

  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY
  • Lab : Using Set Operators

13 - Using Window Ranking, Offset, and Aggregate Functions

  • Creating Windows with OVER
  • Exploring Window Functions
  • Lab : Using Window Ranking, Offset and Aggregate Functions

14 - Pivoting and Grouping Sets

  • Writing Queries with PIVOT and UNPIVOT
  • Working with Grouping Sets
  • Lab : Pivoting and Grouping Sets

15 - Executing Stored Procedures

  • Querying Data with Stored Procedures
  • Passing Parameters to Stored Procedures
  • Creating Simple Stored Procedures
  • Working with Dynamic SQL
  • Lab : Executing Stored Procedures

16 - Programming with T-SQL

  • T-SQL Programming Elements
  • Controlling Program Flow
  • Lab : Programming with T-SQL

17 - Implementing Error Handling

  • Using TRY / CATCH Blocks
  • Working with Error Information
  • Lab : Implementing Error Handling

18 - Implementing Transactions

  • Transactions and the Database Engine
  • Controlling Transactions
  • Isolation Levels
  • Lab : Implementing Transactions

20462 - Administrando Microsoft SQL Server 2014 Databases

Course Objectives
After completing this course, students will be able to:

  • Describe core database administration tasks and tools
  • Install and configure SQL Server 2014
  • Configure SQL Server databases and storage
  • Plan and implement a backup strategy
  • Restore databases from backups
  • Import and export data
  • Monitor SQL Server
  • Trace SQL Server activity
  • Manage SQL Server security
  • Audit data access and encrypt data
  • Perform ongoing database maintenance
  • Automate SQL Server maintenance with SQL Server Agent Jobs
  • Configure Database Mail, alerts and notifications

 

Course Outline

1 - Introduction to SQL Server 2014 Database Administration

  • Database Administration Overview
  • Introduction to the SQL Server Platform
  • Database Management Tools and Techniques
  • Lab : Using SQL Server Administrative Tools
  • Using SQL Server Management Studio
  • Using the sqlcmd Utility
  • Using Windows PowerShell with SQL Server

2 - Installing and Configuring SQL Server 2014

  • Planning SQL Server Installation
  • Installing SQL Server 2014
  • Post-Installation Configuration
  • Lab : Installing SQL Server 2014
  • Preparing to Install SQL Server
  • Installing SQL Server
  • Performing Post-Installation Configuration

3 - Working with Databases and Storage

  • Introduction to Data Storage with SQL Server
  • Managing Storage for System Databases
  • Managing Storage for User Databases
  • Moving Database Files
  • Configuring the Buffer Pool Extension
  • Lab : Managing Database Storage
  • Configuring tempdb Storage
  • Creating Databases
  • Attaching a Database

4 - Planning and Implementing a Backup Strategy

  • Understanding SQL Server Recovery Models
  • Planning a Backup Strategy
  • Backing up Databases and Transaction Logs
  • Using Backup Options
  • Ensuring Backup Reliability
  • Lab : Backing Up SQL Server Databases
  • Backing Up Database
  • Performing Database, Differential, and Transaction Log Backups
  • Performing a Partial Backup

5 - Restoring SQL Server 2014 Databases

  • Understanding the Restore Process
  • Restoring Databases
  • Advanced Restore Scenarios
  • Working with Point-in-Time Recovery
  • Lab : Restoring SQL Server Databases
  • Restoring a Database Backup
  • Restoring Database, Differential, and Transaction Log Backups
  • Performing a Piecemeal Restore

6 - Importing and Exporting Data

  • Introduction to Transferring Data
  • Importing and Exporting Table Data
  • Copying or Moving a Database
  • Lab : Importing and Exporting Data
  • Using the SQL Server Import and Export Wizard
  • Using the bcp Utility
  • Using the BULK INSERT Statement
  • Using the OPENROWSET Function

7 - Monitoring SQL Server 2014

  • Introduction to Monitoring SQL Server
  • Dynamic Management Views and Functions
  • Performance Monitor
  • Lab : Monitoring SQL Server 2014
  • Collecting Baseline Metrics
  • Monitoring a Workload

8 - Tracing SQL Server Activity

  • Tracing SQL Server Workload Activity
  • Using Traces
  • Lab : Tracing SQL Server Workload Activity
  • Capturing a Trace in SQL Server Profiler
  • Generating Database Tuning Recommendations
  • Using SQL Trace

9 - Managing SQL Server Security

  • Introduction to SQL Server Security
  • Managing Server-Level Security
  • Managing Database-Level Principals
  • Managing Database Permissions
  • Lab : Managing SQL Server Security
  • Managing Server-Level Security
  • Managing Database-Level Security
  • Testing Database Access

10 - Auditing Data Access and Encrypting Data

  • Auditing Data Access in SQL Server
  • Implementing SQL Server Audit
  • Encrypting Databases
  • Lab : Auditing Data Access and Encrypting Data
  • Implementing Auditing
  • Implementing Transparent Database Encryption

11 - Performing Ongoing Database Maintenance

  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
  • Lab : Performing Ongoing Database Maintenance
  • Managing Database Integrity
  • Managing Index Fragmentation
  • Implementing a Maintenance Plan

12 - Automating SQL Server 2014 Management

  • Automating SQL Server Management
  • Implementing SQL Server Agent Jobs
  • Managing SQL Server Agent Jobs
  • Managing Job Step Security Contexts
  • Managing Jobs on Multiple Servers
  • Lab : Automating SQL Server Management
  • Creating a Job
  • Scheduling a Job
  • Configuring Job Step Security Contexts

13 - Monitoring SQL Server 2014 by Using Alerts and Notifications

  • Monitoring SQL Server Errors
  • Configuring Database Mail
  • Configuring Operators, Alerts, and Notifications
  • Lab : Monitoring SQL Server by Using Alerts and Notifications
  • Configuring Database Mail
  • Implementing Operators and Notifications
  • Implementing Alerts

20463 - Implementando Data Warehouse com Microsoft SQL Server 2014

Course Objectives

After completing this course, students will be able to:

  • Describe data warehouse concepts and architecture considerations
  • Select an appropriate hardware platform for a data warehouse
  • Design and implement a data warehouse
  • Implement Data Flow in an SSIS Package
  • Implement Control Flow in an SSIS Package
  • Debug and Troubleshoot SSIS packages
  • Implement an ETL solution that supports incremental data extraction
  • Implement an ETL solution that supports incremental data loading
  • Implement data cleansing by using Microsoft Data Quality Services
  • Implement Master Data Services to enforce data integrity
  • Extend SSIS with custom scripts and components
  • Deploy and Configure SSIS packages
  • Describe how BI solutions can consume data from the data warehouse

Course Outline

1 - Introduction to Data Warehousing

  • Overview of Data Warehousing
  • Considerations for a Data Warehouse Solution
  • Lab : Exploring a Data Warehousing Solution
  • Exploring Data Sources
  • Exploring and ETL Process
  • Exploring a Data Warehouse

2 - Planning Data Warehouse Infrastructure

  • Considerations for Data Warehouse Infrastructure
  • Planning Data Warehouse Hardware
  • Lab : Planning Data Warehouse Infrastructure
  • Planning Data Warehouse Hardware

3 - Designing and Implementing a Data Warehouse

  • Data Warehouse Design Overview
  • Designing Dimension Tables
  • Designing Fact Tables
  • Physical Design for a Data Warehouse
  • Lab : Implementing a Data Warehouse
  • Implement a Star Schema
  • Implement a Snowflake Schema
  • Implement a Time Dimension

4 - Creating an ETL Solution with SSIS

  • Introduction to ETL with SSIS
  • Exploring Data Sources
  • Implementing Data Flow
  • Lab : Implementing Data Flow in an SSIS Package
  • Exploring Data Sources
  • Transferring Data by Using a Data Flow Task
  • Using Transformations in a Data Flow

5 - Implementing Control Flow in an SSIS Package

  • Introduction to Control Flow
  • Creating Dynamic Packages
  • Using Containers
  • Managing Consistency
  • Lab : Implementing Control Flow in an SSIS Package
  • Using Tasks and Precedence in a Control Flow
  • Using Variables and Parameters
  • Using Containers
  • Lab : Using Transactions and Checkpoints
  • Using Transactions
  • Using Checkpoints

6 - Debugging and Troubleshooting SSIS Packages

  • Debugging an SSIS Package
  • Logging SSIS Package Events
  • Handling Errors in an SSIS Package
  • Lab : Debugging and Troubleshooting an SSIS Package
  • Debugging an SSIS Package
  • Logging SSIS Package Execution
  • Implementing an Event Handler
  • Handling Errors in a Data Flow

7 - Implementing a Data Extraction Solution

  • Planning Data Extraction
  • Extracting Modified Data
  • Lab : Extracting Modified Data
  • Using a Datetime Column
  • Using Change Data Capture
  • Using the CDC Control Task
  • Using Change Tracking

8 - Loading Data into a Data Warehouse

  • Planning Data Loads
  • Using SSIS for Incremental Loads
  • Using Transact-SQL Loading Techniques
  • Lab : Loading a Data Warehouse
  • Loading Data from CDC Output Tables
  • Using a Lookup Transformation to Insert or Update Dimension Data
  • Implementing a Slowly Changing Dimension
  • Using the MERGE Statement

9 - Enforcing Data Quality

  • Introduction to Data Quality
  • Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Cleanse Data
  • Lab : Cleansing Data
  • Creating a DQS Knowledge Base
  • Using a DQS Project to Cleanse Data
  • Using DQS in an SSIS Package

10 - Master Data Services

  • Introduction to Master Data Services
  • Implementing a Master Data Services Model
  • Managing Master Data
  • Creating a Master Data Hub
  • Lab : Implementing Master Data Services
  • Creating a Master Data Services Model
  • Using the Master Data Services Add-in for Excel
  • Enforcing Business Rules
  • Loading Data Into a Model
  • Consuming Master Data Services Data

11 - Extending SQL Server Integration Services

  • Using Scripts in SSIS
  • Using Custom Components in SSIS
  • Lab : Using Custom Scripts
  • Using a Script Task

12 - Deploying and Configuring SSIS Packages

  • Overview of SSIS Deployment
  • Deploying SSIS Projects
  • Planning SSIS Package Execution
  • Lab : Deploying and Configuring SSIS Packages
  • Creating an SSIS Catalog
  • Deploying an SSIS Project
  • Running an SSIS Package in SQL Server Management Studio
  • Scheduling SSIS Packages with SQL Server Agent

13 - Consuming Data in a Data Warehouse

  • Introduction to Business Intelligence
  • Enterprise Business Intelligence
  • Self-Service BI and Big Data
  • Lab : Using a Data Warehouse
  • Exploring an Enterprise BI Solution
  • Exploring a Self-Service BI Solution

 

 


RECEBA MAIS INFORMAÇÕES SOBRE O CURSO
Combo MCSA Microsoft SQL Server 2014




 

 

CALENDÁRIO

Cursos em Destaque

QUER OFERTAS EXCLUSIVAS?
Cadastre-se aqui e receba as novidades e descontos especiais.
Política de Privacidade