Cauta cursuri
Vezi toate categoriile

Course 10774A Querying Microsoft SQL Server 2012

599 EURO
539 EURO
+ TVA
Reducere prin Studentie.ro 10%
  Curs cu prezenta
  40 ore
Predare in limba: Romana
Date incepere curs: 22 Apr 2013
Diploma de participare: DA
Examen certificare inclus: NU
Reducere :
• 20% pentru grup de 5 si mai multe persoane

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.


All the labs for this course can be performed using the provided virtual machines. However, if you have a Microsoft Windows Azure account and the classroom virtual machines connect to the internet you may be able to connect to your Windows Azure server and database from the classroom. Many of the labs in this course are enabled for you to perform the lab while connected to your own Windows Azure database in the cloud. Your instructor should be able to provide a current list of Windows Azure enabled labs.
 

Obiective invatare / Abilitati dobandite

After completing this course, students will be able to:
•Write SELECT queries
•Query multiple tables
•Use built-in functions
•Use subqueries
•Execute stored procedures
•Use set operators
•Implement error handling
•Implement transactions
•Use table expressions
•Sort and filter data
•Use window ranking, offset and aggregate functions
•Query SQL Server metadata
•Program with T-SQL
•Improve query performance

Trainer

Marian Pandilica

Marian Pandilica este trainer de peste 12 ani in cadrul Centrului de Training Pro Management, timp in care a instruit peste 3000 de administratori de retea si ingineri de sistem pe produse Windows Server. Este certificat pentru sustinerea cursurilor de Network Infrastructure, Active Directory, Security and Internet Services, System Server Management and Maintaining, Collaboration & Messaging, Database Administration, Project Server si Client, SharePoint si Cloud Infrastructure Public and Private. Marian isi foloseste expertiza sa tehnica si experienta profesionala pe care le combina cu pasiunea de a transmite cursantilor sai cunostintele si abilitatile practice de care acestia au nevoie pentru a sti cum sa aplice toate acestea in infrastructurile reale, pentru a face fata cu succes responsabilitatilor unui IT Professional de top in companiile unde activeaza. A promovat peste 26 de examene Microsoft si detine urmatoarele certificari: - Microsoft Certified Learning Consultant - Microsoft Certified Trainer din 2001 - 2012 - MCTS Desktop & Server Virtualization Technology - MCITP Virtualization Administrator - Microsoft Certified Solution Associate, - MCTS AD, NI, AS, MCITP Server & Enterprise Administrator WinServer 2008 R2 - MCSA/MCSE Security & Messaging Win Server 2000/2003 - MCTS Vista/ Windows 7/ Exchange 2007/2010 - Certiport IC3 Authorized Instructor: Computing Fundamentals, Key Applications, Living Online Promotor al celor mai noi tehnologii Private si Public Cloud (Office 365, Windows 7, Windows Server 2003 R2, Windows Server 2008R2, SBS 2003 si 2008, Exchange Server 2007/2010, SharePoint 2007/2010, System Center Configuration Manager, Virtual Machine Manager si Operation Manager), Marian este nelipsit de la sesiunile internationale “train the trainer” fiind permanent la zi cu tot ce este nou in IT&C. O latura importanta a activitatii sale este publicarea de articole si webcast-uri pentru produsele noi lansate de Microsoft, fiind recunoscut ca un reputat specialist si un excelent speaker. Alaturi de Microsoft Romania a gestionat proiecte de mare amploare privind instruirea partenerilor Microsoft din Romania pentru noile tehnologii Windows Server 2008 si SBS 2003.
Cui se adreseaza?

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

 

 

Before attending this course, students must have:
•Working knowledge of relational databases.
•Basic knowledge of the Microsoft Windows operating system and its core functionality.
Before attending this course, students should have:
•Basic understanding of virtualization technology (Classroom labs utilize virtual machines)
To help you prepare for this class, review the following resources:


•Book: T-SQL Fundamentals for Microsoft SQL Server 2012 and SQL Azure
•MCTS Self Paced Training Kit 70-461

Adresa / Locatie desfasurare curs
Str. Dr. Raureanu, Nr. 1, Et. 1, Sector 5 (Pe Calea Victoriei, vis a vis de Muzeul National de Istorie)
Imagine
Course 10774A Querying Microsoft SQL Server 2012