會員登錄
軟體搜尋
您的位置： 網站首頁 >> 專業知識教學 >> 電腦教學認證 >> 商品詳情
商品詳情
|
商品編號：TIC2397 碟片數量：1片 銷售價格：200 瀏覽次數：37068 
【轉載TXT文檔】 |
您可能也喜歡：
DVDP4356--The Gnomon Workshop - Designing Spaceships for Games 遊戲太空船概念設計教學 英文教學版(DVD9一片裝 此片售價200元)
DVD29830--The Gnomon Workshop - The Art of Visual Storytelling 視覺故事概念設計教學 英文教學版(DVD一片裝)
TIC3086--新多益滿分講師授課：全新制NEW TOEIC多益閱讀高分關鍵＋狠準擬真試題＋解析 繁體中文教學版
DVDP4341--Unreal Engine 5 The Complete Automotive Cinematic Course (UE5 電影感車輛製作教學) 英文教學版(DVD9一片裝 此片售價200元)
DVD29802--Udemy - Blender Essential From Beginner to 3D Masterclass (B3D基礎教學) 英文教學版(DVD一片裝)
商品描述
MS 10776A Beta Part2 Virtual Machines Developing SQL Server 2012 視頻教學 英文正式版
軟體簡介:
About this Course
This 5-day instructor-led course introduces SQL Server 2012 and describes
logical table design, indexing and query plans. It also focusses on the
creation of database objects including views, stored procedures, along with
parameters, and functions. Other common aspects of procedure coding, such as
transactions, concurrency, error handling, triggers, and SQL CLR are also covered
in this course. Also this course helps you prepare for the Exam 70-464
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 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 Azure database in the cloud. Your instructor should be able to provide
a current list of Azure enabled labs. To acquire a trial Windows Azure account click here.
At Course Completion
After completing this course, students will be able to:
ntroduce the entire SQL Server platform and its major tools. It will cover editions,
versions, basics of network listeners, and concepts of services and service accounts.
etermine appropriate data types to be used when designing tables, convert data between
data types, and create alias data types.
e aware of good design practices regarding SQL Server tables and be able to create tables
using T-SQL. (Note: partitioned tables are not covered).
mplement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate
cascading FOREIGN KEY constraints.
etermine appropriate single column and composite indexes strategies.
reate tables as heaps and tables with clustered indexes. Also consider the design of a
table and suggest an appropriate structure.
ead and interpret details of common elements from execution plans.
esign effective non-clustered indexes.
esign and implement views
esign and implement stored procedures.
ork with table types, table valued parameters and use the MERGE statement to create stored
procedures that update data warehouses.
esign and implement functions, both scalar and table-valued. (Also describe where they can lead to performance issues).
erform basic investigation of a deadlock situation and learn how transaction isolation levels affect application concurrency.
se both traditional T-SQL error handling code and structured exception handling.
esign and implement DML triggers
earn appropriate uses for SQL CLR integration and implement an existing .NET assembly within SQL Server.
tore XML data and schemas in SQL Server.
erform basic queries on XML data in SQL Server.
ork with the GEOGRAPHY and GEOMETRY data types
mplement and query a full-text index
軟體簡介:
About this Course
This 5-day instructor-led course introduces SQL Server 2012 and describes
logical table design, indexing and query plans. It also focusses on the
creation of database objects including views, stored procedures, along with
parameters, and functions. Other common aspects of procedure coding, such as
transactions, concurrency, error handling, triggers, and SQL CLR are also covered
in this course. Also this course helps you prepare for the Exam 70-464
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 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 Azure database in the cloud. Your instructor should be able to provide
a current list of Azure enabled labs. To acquire a trial Windows Azure account click here.
At Course Completion
After completing this course, students will be able to:
ntroduce the entire SQL Server platform and its major tools. It will cover editions,
versions, basics of network listeners, and concepts of services and service accounts.
etermine appropriate data types to be used when designing tables, convert data between
data types, and create alias data types.
e aware of good design practices regarding SQL Server tables and be able to create tables
using T-SQL. (Note: partitioned tables are not covered).
mplement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate
cascading FOREIGN KEY constraints.
etermine appropriate single column and composite indexes strategies.
reate tables as heaps and tables with clustered indexes. Also consider the design of a
table and suggest an appropriate structure.
ead and interpret details of common elements from execution plans.
esign effective non-clustered indexes.
esign and implement views
esign and implement stored procedures.
ork with table types, table valued parameters and use the MERGE statement to create stored
procedures that update data warehouses.
esign and implement functions, both scalar and table-valued. (Also describe where they can lead to performance issues).
erform basic investigation of a deadlock situation and learn how transaction isolation levels affect application concurrency.
se both traditional T-SQL error handling code and structured exception handling.
esign and implement DML triggers
earn appropriate uses for SQL CLR integration and implement an existing .NET assembly within SQL Server.
tore XML data and schemas in SQL Server.
erform basic queries on XML data in SQL Server.
ork with the GEOGRAPHY and GEOMETRY data types
mplement and query a full-text index