Course: SQL Server 2012 Administration and T-SQL

$389.00
$470.69 incl. vat

duration: 26 hours |

Language: English (US) |

access duration: 180 days |

Details

SQL Server 2012 Administration and T-SQL

(English version)

Target audience

Software Developer

Content

SQL Server 2012 Administration and T-SQL

26 hours

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.

Course options

We offer several optional training products to enhance your learning experience. If you are planning to use our training course in preperation for an official exam then whe highly recommend using these optional training products to ensure an optimal learning experience. Sometimes there is only a practice exam or/and practice lab available.

Optional practice exam (trial exam)

To supplement this training course you may add a special practice exam. This practice exam comprises a number of trial exams which are very similar to the real exam, both in terms of form and content. This is the ultimate way to test whether you are ready for the exam. 

Optional practice lab

To supplement this training course you may add a special practice lab. You perform the tasks on real hardware and/or software applicable to your Lab. The labs are fully hosted in our cloud. The only thing you need to use our practice labs is a web browser. In the LiveLab environment you will find exercises which you can start immediatelyThe lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience. 

WHY_ICTTRAININGEN

Via ons opleidingsconcept bespaar je tot 80% op trainingen

Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo

Spar met medecursisten en profileer je als autoriteit in je vakgebied.

Ontvang na succesvolle afronding van je cursus het officiële certificaat van deelname van Icttrainingen.nl

Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers

Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten

Orderproces

Once we have processed your order and payment, we will give you access to your courses. If you still have any questions about our ordering process, please refer to the button below.

read more about the order process

What is included?

Certificate of participation Yes
Monitor Progress Yes
Mobile ready Yes
Sharing knowledge Unlimited access to our IT professionals community
Study advice Our consultants are here for you to advice about your study career and options
Study materials Certified teachers with in depth knowledge about the subject.
Service World's best service

Platform

Na bestelling van je training krijg je toegang tot ons innovatieve leerplatform. Hier vind je al je gekochte (of gevolgde) trainingen, kan je eventueel cursisten aanmaken en krijg je toegang tot uitgebreide voortgangsinformatie.

Life Long Learning

Follow multiple courses? Read more about our Life Long Learning concept

read more

Contact us

Need training advise? Contact us!


contact