Olá,
Seja bem vindo ao treinamento SQL Server 2017 - Fundamento profissionais em T-SQL.
Antes de mais nada quero parabeniliza-lo para iniciativa de realizar o treinamento. Terei o prazer de conduzir você durante todo aprendizado. E também lhe agradecer pela oportunidade de mostra o meu trabalho é o conhecimento que adquirir durantes os mais de 15 anos que atuo na área de banco de dados com o Microsoft SQL Server realizando as atividades de DBA, desenvolvedor, consultor e instrutor.
Beginner SQL programmers find in cursors a comfortable and familiar way of coding. Well, unfortunately this lead to bad performance. The whole purpose of SQL is specifying what you want, not how it should be done. I've once rewritten a cursor-based stored procedure and substituted some code for a pair of traditional SQL queries. Curso SQL Server 2017 Developer Expert SQL e T-SQL 4.4 (285 ratings) Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
Durante os próximos dias vamos conversar muito sobre a linguagem T-SQL e todos os recursos que ela tem e como aplica-los de forma profissional.
Por exemplos, você sabe qual é o conceito de all-at-once em SQL? Os erros mais comuns na escrita de código? Quais as fases do processamento lógico de uma consulta?
Por isso o nosso treinamento será dividido em módulos e dentro dele teremos seções com assunto específicos que serão realizadas com uma teoria, exposição de exemplos, quiz para avaliar os conhecimentos e uma tarefa.
O processo será gradativo desde o conhecimento teórico necessário da linguagem SQL, passando a conhecer a linguagem T-SQL e desenvolver consultas complexas.
Em paralelo ao treinamento, em qualquer momento você pode ( e deve !!! ) usar o link Pergunta e Respostas exclusivo associado ao treinamento. Teremos o prazer de responder a todas as dúvidas que voce tenha.
Também tenho em cada aula, links com conteúdo adicional, caso você deseja aprofundar no assunto. Os links podem levar ao site da Microsoft com detalhes completos do assunto ao a algum posts de um especialista no tema.
Todos os exemplos aplicados em cada aula ficará disponível para download. Teremos uma aula exclusiva para realizar a configuração do ambiente, download dos arquivos e operação das ferramentas.
Por falar em exemplos, teremos um conjunto grande de quiz com mais de 20 perguntas em cada um deles.
E tudo isso, disponível para você 24 horas e de forma vitalícia.
Espero que goste de treinamento e aproveito ao máximo essa oportunidade que voce está se permitindo.
Obrigado e um ótimo treinamento.
If you’re ready to learn how to harness Microsoft SQL Server to deliver mission-critical performance, gain faster insights on data, or drive your hybrid cloud strategy, you’re in the right place. These learning opportunities can help you get started quickly—from product exploration to deep training and certification.
Training for Microsoft SQL Server certifications
Get certified, and show the world that you’re ready to take advantage of the breakthrough performance of Microsoft SQL Server to deliver faster data insights that drive business transformation.
Entry level: Database
Take this course, and prepare to earn a Microsoft Technology Associate (MTA) certification.
Database Fundamentals
Prepares you for exam 98-364 | Instructor-led classroom training
Associate level: MCSA: SQL 2016 Database Development
Take these courses, and prepare to earn a Microsoft Certified Solutions Associate (MCSA): SQL 2016 certification.
Querying Data with Transact-SQL
Prepares you for exam 70-761 | Instructor-led classroom training or on-demand training
Developing SQL Databases
Prepares you for exam 70-762 | Instructor-led classroom training or on-demand training
Associate level: MCSA: SQL 2016 Database Administration
Take these courses, and prepare to earn an MCSA: SQL 2016 certification.
Administering a SQL Database Infrastructure
Prepares you for exam 70-764 | Instructor-led classroom training
Provisioning SQL Databases
Prepares you for exam 70-765 | Instructor-led classroom training
![Gratis Gratis](/uploads/1/2/5/0/125074347/835507069.jpg)
Associate level: MCSA: SQL 2016 Business Intelligence Development
![Sql Sql](/uploads/1/2/5/0/125074347/650531432.png)
Take these courses, and prepare to earn an MCSA: SQL 2016 certification.
Implementing a SQL Data Warehouse
Prepares you for exam 70-767 | Instructor-led classroom training
Developing SQL Data Models
Prepares you for exam 70-768 | Instructor-led classroom training
Associate level: MCSA: SQL Server 2012/2014
Take these courses, and prepare to earn an MCSA: SQL Server 2012/2014 certification.
Querying Microsoft SQL Server
Prepares you for exam 70-461 | Instructor-led classroom training or on-demand training
Administering Microsoft SQL Server Databases
Prepares you for exam 70-462 | Instructor-led classroom training or on-demand training
Implementing a Data Warehouse with Microsoft SQL Server
Prepares you for exam 70-463 | Instructor-led classroom training or on-demand training
SQL Server resources
Performance Tuning and Optimizing SQL Databases
Instructor-led classroom training
Managing SQL Business Intelligence Operations
Instructor-led classroom training
Analyzing Data with Power BI
Instructor-led classroom training
Analyzing Data with SQL Server Reporting Services
Instructor-led classroom training
Querying Microsoft SQL Server
Instructor-led classroom or on-demand training
Administering Microsoft SQL Server Databases
Instructor-led classroom or on-demand training
Implementing a Data Warehouse with Microsoft SQL Server
Instructor-led classroom or on-demand training
Developing Microsoft SQL Server Databases
Instructor-led classroom training
Designing Solutions for Microsoft SQL Server
Instructor-led classroom training
Implementing Data Models and Reports with Microsoft SQL Server
Instructor-led classroom training
Designing Business Intelligence Solutions with Microsoft SQL Server
Instructor-led classroom training
Maintaining a Microsoft SQL Server 2008 R2 Database
Instructor-led classroom training
Basics of Transact SQL with SQL Server 2008 R2
Instructor-led classroom training
Dashboards for Monitoring, Analyzing and Managing
Instructor-led classroom training
Updating Your SQL Server 2005 Skills to SQL Server 2008
Instructor-led classroom training
Implementing a Microsoft SQL Server 2008 R2 Database
Instructor-led classroom training
Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
Instructor-led classroom training
Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
Instructor-led classroom training
Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
Instructor-led classroom training
Upgrading Your SQL Server 2000 Database Administration (DBA) Skills to SQL Server 2008
Instructor-led classroom training