Vi ste ovdje
Overview/Description
SQL Server 2012's core component is its Database Engine instance, which provides storage, processing, and security for enterprise data through its controlled access and rapid transaction processing. SQL Server 2012 also provides additional features and components to manage and view data, these include Analysis Services and Reporting Services.SQL Server 2012 provides tools to manage the features and components which includes Server Management Studioâs graphical user tool which allows administrators and developers to create and configure instances and databases on an...
Overview/Description
SQL Server 2012 provides various features and utilities to manage data stored in the databases within a SQL Server instance. This includes support for storing large unstructured data, such as files and documents within or outside the database. The ability to store large data is supported through the FILESTREAM database feature. This enables large unstructured data to be store outside the database on the file system by providing integration between the file system and SQL Server. FileTables is another database feature that allows large data to be store within tables, but...
Overview/Description
Database maintenance is an ongoing task for SQL Server 2012 administrators. This requires the integrity of the database to be checked, the database size to be kept to a minimum by ensuring the files are the correct sizes, and maintenance tasks to be run regularly. SQL Server 2012 Transact-SQL provides DBCC, which is a command that provides statements to maintain the database and database files. An administrator can also create jobs using SQL Server Agent to automate administrative tasks in the SQL Server Database Engine and throughout the enterprise by having the jobs run...
Overview/Description
SQL Server 2012 provides features to allow administrators to ensure that data is accessed efficiently, this includes the use of indexes, table and index partitions, and full-text search. Indexes in SQL Server 2012 database allow data to be accessed quickly using keys that are stored in a B-tree structure. Indexes need to be created and managed to ensure for the best database performance. SQL Server 2008 provides table and index partitioning to allow data to be stored across multiple filegroups within a database. This makes tables and indexes that contain large amounts of...
Overview/Description
XML has been integrated into SQL Server 2012 so that XML data can be stored within databases using the xml data type. SQL Server 2012 also allows for relational data already stored in a database to be changed to XML, and for data to be loaded as XML using various methods. You can query this data using the XQuery language within the XML data type methods. SQL Server 2012 also provides support for using FOR XML to extract relational data from a database in XML format and the use of OPENXML to generate relational views from XML. This course demonstrates how to use the xml...
Overview/Description
Microsoft SQL Server 2012 Transact-SQL offers advanced query techniques, such as built-in aggregate, analytic, scalar, and ranking functions, as well as common table expressions, or CTEs and derived tables to manipulate the result set for a query. To manipulate the result sets and generate summarization information, such as totals, the CUBE, GROUPING SETS, and ROLLUP operators can be used with the GROUP BY statement. The UNION, INTERSECT, and EXCEPT operators can be used to combined the result set of multiple queries. SQL Server 2012 also offers the use of CTEs and...
Overview/Description
SQL Server 2012 includes the SQL Server Management Studio which allows access to SQL Server databases and enables you to access database data. This data can be retrieved and modified through the use of Transact-SQL within the Query Edit window of the Management Studio tool. Using Transact-SQL you can select data from a databaseâs tables and filter the results to include only the data that you require. Transact-SQL statements also allow you to update, change, and remove data from tables. This course identifies the basic Transact-SQL statements that can be used to...
Overview/Description
Microsoft SQL Server 2012 provides enhanced security features to ensure that each instance is secure. Using SQL Server 2012 security features, administrators can guarantee that access to a SQL Server instance is granted only to specified users, using either Windows Authentication or Mixed Mode Authentication by creating logins and then mapping the logins to the databases within the instance. Administrators also have the ability to encrypt a SQL Server instance using transparent data encryption (TDE) and to encrypt the data within a database using encryption certificates...
Overview/Description
To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.
Target Audience
Individuals seeking practice in a structured testing environment,...
Overview/Description
To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.
Target Audience
Individuals seeking practice in a structured testing environment,...
Koraci do učenja
Prijavite se, a ako nemate korisničko ime, registrirajte se.
Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.
Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.
Trebate pomoć?
- Česta pitanja - FAQ
- telefon: +385 1 6558 440
- email: support@cognita.hr
- Kontakt forma
