Schulung Brochure :
|
Querying Microsoft SQL Server 2012
Beschreibung
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.
Publikum
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.
Voraussetzungen
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
Ziele
-
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
Programm
-
The complete program is available here
|
|