Gebruik de code voor 20% korting op alle trainingen -->

Black Friday

BLACK20%FRIDAY
Training: SQL Server 2012 Administration and T-SQL
SQL Server 2012
26 uur
Engels (US)

Training: SQL Server 2012 Administration and T-SQL

Snel navigeren naar:

  • Informatie
  • Inhoud
  • Kenmerken
  • Meer informatie
  • Reviews
  • FAQ

Productinformatie

In deze SQL Server 2012 training / cursus leert u Transact-SQL en de administrator functionaliteiten van SQL Server 2012 kennen.

Inhoud van de training

SQL Server 2012 Administration and T-SQL

26 uur

SQL Server 2012: Introduction to T-SQL

This course will start with a quick overview of the history of SQL, then dive right into using T-SQL. You’ll learn about batches and scripts, how to declare and use variables—including the inevitable data type conversions—as well as the rich supply of operators available. Next you’ll learn about some of the many built-in T-SQL functions, for doing things like working with numbers, string manipulation, as well as global functions for getting state information. You’ll also learn about how to rank results using special functions and the OVER clause.

SQL Server 2012: T-SQL Select, Where, and Clauses

In this course you’ll learn about the SELECT statement and its incredible flexibility when retrieving data from one or more database tables. You can shape the data you retrieve, and filter it using the WHERE clause. SQL Server rarely returns data in the order you want, so you can use the ORDER BY clause to sort it. Next you’ll learn some advanced ways to select data. With the GROUP BY clause, you can summarize the information in one or more tables, aggregating it various ways, if you wish. You’ll also learn how you can join the data together from multiple tables, efficiently including related data in the result sets.

SQL Server 2012: T-SQL Working with Data

When you retrieve data with a SELECT statement, SQL returns a result set. However, any actions you take on that data (besides just looking at it) involve data manipulation queries that use one of the following three T-SQL statements: INSERT, UPDATE, or DELETE. SQL queries that use these statements are sometimes known as action queries. You’ll learn about the basic uses of these statements. When you modify data in SQL Server, it is important to understand how isolation levels and locking can affect performance and concurrency. You’ll learn about these concepts and how they can affect T-SQL code you write, as well as mitigating measures you can take to avoid problems.

SQL Server 2012: A Tour of SQL Server

  • The new version of SQL Server 2012 has many new features. This

  • course will talk about these new features and give a tour of SQL
  • Server 2012.You will see the differences between the available
  • editions of SQL Server 2012. Get an overview of the components and
  • tools that SQL Server 2012 includes. Learn about Management Studio
  • and see the sample databases used in this course. You will see how
  • to work with queries, tables, and views in SQL Server. Then the
  • course will finish up with an overview of SQL Server Business
  • Intelligence Services.

SQL Server 2012: Installing

So your company has decided to purchase or upgrade to SQL Server 2012, so now what? This course will cover how to prepare for a SQL Server 2012 installation. It will help you to understand what is involved in upgrading an earlier version of SQL Server to SQL Server 2012. See how to install a default instance of SQL Server 2012 and find out how to configure the server after the installation.

SQL Server 2012: Security Basics

The SQL Server 2012: Security Basics course will show you the basics of SQL Server security by giving you an understanding of potential data threats and how SQL Servers design protects against them. You will then learn about SQL Server and Windows integrated authentication. Then see how SQL Server provides an authorization system to control access to data and objects.

SQL Server 2012: Permissions and Data Protection

In the SQL Server 2012: Permissions and Data Protection course you will understand permissions in SQL Server and how they provide granular control over data and objects. Then you will learn how to provide a final layer of defense by encrypting data.

SQL Server 2012: Working with Management Studio

SQL Server 2012 Management Studio is an excellent tool that is used to code and administer SQL Server 2012. The course will show you Management Studio and how to write code and administer a server. Then the course will explore Management Studios Object Explorer tool. Then see how you can use the Query Editor to write and debug SQL Server code.

SQL Server 2012: Designing and Creating a Database

Creating a database is not just inputting data into a computer and expecting a database to appear. This course will teach you the basics of relational database design principles. You will then see how to create a SQL Server database based on sound design principles. Then see how to build tables using the SQL Server Management Studio designers. You will learn about SQL Server data types, how to create constraints, triggers, and indexes. Then to finish up create a database diagram and define relationships to enforce referential integrity.

Kenmerken

Docent inbegrepen
Bereidt voor op officieel examen
Engels (US)
26 uur
SQL Server 2012
180 dagen online toegang
HBO

Meer informatie

Doelgroep Softwareontwikkelaar
Voorkennis

heeft u basiskennis van databases en SQL Server.

Resultaat

Na het volgen van deze training bent u bekend met Transact-SQL en de administrator functionaliteiten van SQL Server 2012.

Positieve reacties van cursisten

Training: Leidinggeven aan de AI transformatie

Nuttige training. Het bestelproces verliep vlot, ik kon direct beginnen.

- Mike van Manen

Onbeperkt Leren Abonnement

Onbeperkt Leren aangeschaft omdat je veel waar voor je geld krijgt. Ik gebruik het nog maar kort, maar eerste indruk is goed.

- Floor van Dijk

Training: Leidinggeven aan de AI transformatie

Al jaren is icttrainingen.nl onze trouwe partner op het gebied van kennisontwikkeling voor onze IT-ers. Wij zijn blij dat wij door het platform van icttrainingen.nl maatwerk en een groot aanbod aan opleidingen kunnen bieden aan ons personeel.

- Loranne, Teamlead bij Inwork

Hoe gaat het te werk?

1

Training bestellen

Nadat je de training hebt besteld krijg je bevestiging per e-mail.

2

Toegang leerplatform

In de e-mail staat een link waarmee je toegang krijgt tot ons leerplatform.

3

Direct beginnen

Je kunt direct van start. Studeer vanaf nu waar en wanneer jij wilt.

4

Training afronden

Rond de training succesvol af en ontvang van ons een certificaat!

Veelgestelde vragen

Veelgestelde vragen

Op welke manieren kan ik betalen?

Je kunt bij ons betalen met iDEAL, PayPal, Creditcard, Bancontact en op factuur. Betaal je op factuur, dan kun je met de training starten zodra de betaling binnen is.

Hoe lang heb ik toegang tot de training?

Dit verschilt per training, maar meestal 180 dagen. Je kunt dit vinden onder het kopje ‘Kenmerken’.

Waar kan ik terecht als ik vragen heb?

Je kunt onze Learning & Development collega’s tijdens kantoortijden altijd bereiken via support@icttrainingen.nl of telefonisch via 026-8402941.

Background Frame
Background Frame

Onbeperkt leren

Met ons Unlimited concept kun je onbeperkt gebruikmaken van de trainingen op de website voor een vast bedrag per maand.

Bekijk de voordelen

Heb je nog twijfels?

Of gewoon een vraag over de training? Blijf er vooral niet mee zitten. We helpen je graag verder. Daar zijn we voor!

Contactopties