Description: With its blend of visual tools and powerful Transact-SQL language, SQL Server 2012 will continue to enjoy large market share in the relational database management sphere. Database developers that use SQL Server will experience measurable benefits from obtaining Microsoft’s MCSE certification relating to SQL Server 2012. This course is one of a series in the Skillsoft learning path that covers the objectives for the Exam 70-464: Developing Microsoft SQL Server Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.
Target Audience: Database Administrator and developers who create and manage databases within their organization as part of their daily tasks. This can include creating the database objects, ensuring their security, implementing and ensuring data integrity, managing transactions and locks, and ensuring the server instance and database are running efficiently.
Duration: 01:30
Description: With its blend of visual tools and powerful Transact-SQL language, SQL Server 2012 will continue to enjoy large market share in the relational database management sphere. Database developers that use SQL Server will experience measureable benefits from obtaining Microsoft’s MCSE certification relating to SQL Server 2012. This course is one of a series in the Skillsoft learning path that covers the objectives for the Exam 70-464: Developing Microsoft SQL Server Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.
Target Audience: Database Administrator and developers who create and manage databases within their organization as part of their daily tasks. This can include creating the database objects, ensuring their security, implementing and ensuring data integrity, managing transactions and locks, and ensuring the server instance and database are running efficiently.
Duration: 01:30
Description: The relational database, such as SQL Server 2012, has been around for decades going back to E.F. Codd and his designs. Since then, many applications have been built upon this concept. In 1999, the internet was gaining momentum. Around the same time, a new hierarchica l concept for storing data was introduced: extensible markup language or XML. As the internet gained more prominence to its current ubiquitous standing, XML took on increasing significance for moving data around. Subsequently, it became equally important for relational and hierarchical data to be somewhat interchangeable between online data-based applications and services. This course introduces XML in relation to SQL Server and how to work with XML data in SQL Server 2012. This course is one of a series in the Skillsoft learning path that covers the objectives for the Exam 70-464: Developing Microsoft SQL Server Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.
Target Audience: Database Administrator and developers who create and manage databases within their organization as part of their daily tasks. This can include creating the database objects, ensuring their security, implementing and ensuring data integrity, managing transactions and locks, and ensuring the server instance and database are running efficiently.
Duration: 01:49
Description: SQL Server 2012 provides advanced features to enable large data to be stored and accessed within the database itself. By using the FILESTREAM and FileTable features documents are stored in the Windows file system but accessed through the database using T-SQL queries. SQL Server also allows these documents to be searched for words or phrases. Advanced query techniques can also be used to manipulate data to retrieve specific data. This course demonstrates how to configure FILESTREAM, FileTables, and Full-Text Search. It also demonstrates how to use advanced query technique such as PIVOT, UNPIVOT, CROSS APPLY, OUTER APPLY, and CTEs, as well as Spatial data. This course is one of a series in the Skillsoft learning path that covers the objectives for the Exam 70-464: Developing Microsoft SQL Server Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.
Target Audience: Database Administrator and developers who create and manage databases within their organization as part of their daily tasks. This can include creating the database objects, ensuring their security, implementing and ensuring data integrity, managing transactions and locks, and ensuring the server instance and database are running efficiently.
Duration: 01:42
Description: With its blend of visual tools and powerful Transact-SQL language, SQL Server 2012 will continue to enjoy large market share in the relational database management sphere. Database developers that use SQL Server will experience measureable benefits from obtaining Microsoft’s MCSE certification relating to SQL Server 2012. This course is one of a series in the Skillsoft learning path that covers the objectives for the Exam 70-464: Developing Microsoft SQL Server Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.
Target Audience: Database Administrator and developers who create and manage databases within their organization as part of their daily tasks. This can include creating the database objects, ensuring their security, implementing and ensuring data integrity, managing transactions and locks, and ensuring the server instance and database are running efficiently.
Duration: 01:11
Description: An effective strategy that database developers often employ to interface between applications and SQL Server 2012 involves the creation of programs using the Transact-SQL language and saving them as stored procedures or functions as database objects. Subsequently the applications can execute these programs as required and process results. This course introduces this powerful database programming concept and covers the types of programs available, design issues and implementation considerations. This course is one of a series in the Skillsoft learning path that covers the objectives for the Exam 70-464: Developing Microsoft SQL Server Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.
Target Audience: Database Administrator and developers who create and manage databases within their organization as part of their daily tasks. This can include creating the database objects, ensuring their security, implementing and ensuring data integrity, managing transactions and locks, and ensuring the server instance and database are running efficiently.
Duration: 01:18
Description: With its blend of visual tools and powerful Transact-SQL language, SQL Server 2012 will continue to enjoy large market share in the relational database management sphere. Database developers that use SQL Server will experience measureable benefits from obtaining Microsoft’s MCSE certification relating to SQL Server 2012. This course is one of a series in the Skillsoft learning path that covers the objectives for the Exam 70-464: Developing Microsoft SQL Server Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.
Target Audience: Database Administrator and developers who create and manage databases within their organization as part of their daily tasks. This can include creating the database objects, ensuring their security, implementing and ensuring data integrity, managing transactions and locks, and ensuring the server instance and database are running efficiently.
Duration: 01:31
Description: With its blend of visual tools and powerful Transact-SQL language, SQL Server 2012 will continue to enjoy large market share in the relational database management sphere. Database developers that use SQL Server will experience measureable benefits from obtaining Microsoft’s MCSE certification relating to SQL Server 2012. This course is one of a series in the Skillsoft learning path that covers the objectives for the Exam 70-464: Developing Microsoft SQL Server Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.
Target Audience: Database Administrator and developers who create and manage databases within their organization as part of their daily tasks. This can include creating the database objects, ensuring their security, implementing and ensuring data integrity, managing transactions and locks, and ensuring the server instance and database are running efficiently.
Duration: 01:48
Description: Microsoft SQL Server 2014 builds from version 2012 to provide optimal performance for applications using In-Memory OLTP, which is a memory-optimized database engine integrated into the SQL Server engine. SQL Server 2014 also provides the ability to create hybrid platform and cloud scenarios by enabling cloud backups and recoveries to decrease on premise costs for storage. This course will discuss and demonstrate the objectives for SQL Server 2014 for the 70-464 Microsoft SQL Server: Developing Databases certification exam, this will include the In-Memory OLTP feature and how to write scripts to automate backups to the cloud. It will also demonstrate other database development tasks, such as designing and creating database objects and programming objects and how to optimize and troubleshoot queries.
Target Audience: Database Administrator and developers who create and manage databases within their organization as part of their daily tasks. This can include creating the database objects, ensuring their security, implementing and ensuring data integrity, managing transactions and locks, and ensuring the server instance and database are running efficiently.
Duration: 02:06