Nanfor Ibérica Formación

Nanfor Ibérica Formación

5 estrellas (Calificada por 7 clientes)

Madrid, Madrid, ESP | Ver mapa y dirección


Nanfor Ibérica Formación

10774-Querying Microsoft SQL Server 2012

(0 evaluaciones. Evalúe esta aplicación o servicio)
  • Tipo de servicio:

    Aprendizaje
  • Necesidad de negocio:

    Aprendizaje para certificación
  • Trabaja con:

    SQL Server 2012 Business Intelligence Edition
  • Enfoque en el sector:

    Servicios profesionales

Module 1: Introduction to Microsoft SQL Server 2012
This module introduces the SQL Server platform and major tools. It discusses editions, versions, tools used to query, documentation sources, and the logical structure of databases.
Lessons
Introducing Microsoft SQL Server 2012
Getting Started with SQL Server Management Studio
Lab : Working with SQL Server 2012 Tools
Working with SQL Server Management Studio
Creating and Organizing T-SQL scripts
Using Books Online
After completing this module, students will be able to:
Describe the architecture and editions of SQL Server 2012.
Work with SQL Server Management Studio.
Module 2: Getting Started with SQL Azure
This module introduces you to the concepts of SQL Azure. If the virtual machines in your classroom are able to connect to the internet and you have a Windows Azure account you may be able to connect to your Azure server and database. Many of the labs in the rest of this course are enabled for you to perform the lab while connected to your own Azure database in the cloud.
Lessons
Overview of SQL Azure
Working with SQL Azure
After completing this module, students will be able to:
Describe the basic features of SQL Azure.
Provision a SQL Azure server and configure its security.
Module 3: Introduction to T-SQL Querying
This module introduces Transact SQL as the primary querying language of SQL Server. It discusses the basic structure of T-SQL queries, the logical flow of a SELECT statement, and introduces concepts such as predicates and set-based operations.
Lessons
Introducing T-SQL
Understanding Sets
Understanding Predicate Logic
Understanding the Logical Order of Operations in SELECT statements
Lab : Introduction to Transact-SQL Querying
Executing Basic SELECT Statements
Executing queries which filter data using predicates
Executing queries which sort data using ORDER BY
After completing this module, students will be able to:
Describe the elements of T-SQL and their role in writing queries
Describe the use of sets in SQL Server
Describe the use of predicate logic in SQL Server
Describe the logical order of operations in SELECT statements
Module 4: Writing SELECT Queries
This module introduces the fundamentals of the SELECT statement, focusing on queries against a single table.
Lessons
Writing Simple SELECT Statements
Eliminating Duplicates with DISTINCT
Using Column and Table Aliases
Writing Simple CASE Expressions
Lab : Writing Basic SELECT Statements
Write simple SELECT Statements
Eliminate Duplicates

    Ningún cliente ha evaluado a 10774-Querying Microsoft SQL Server 2012.

    Envíe una evaluación

    Las opiniones aquí publicadas y expresadas no son las de Microsoft.