Vi ste ovdje
Overview/Description
Database maintenance is an ongoing task for SQL Server 2008 R2 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 2008 R2 Transact-SQL provides DBCC statements, which in turn provides statements to maintain the database and database files. An administrator can also use maintenance plans to run a series of tasks on specific databases using a schedule or on demand. This course demonstrates how to confirm the...
Overview/Description
To keep SQL Server 2008 R2 databases running as efficiently as possible, administrators use a variety of performance tuning and monitoring tools. The SQL Server Profiler enables administrators to use trace files and logs to analyze a database's performance. They can also use the Windows System Monitor to monitor SQL Server 2008 R2 using counters, which monitor specific aspects of the server for performance issues. SQL Server 2008 R2 includes the Activity Monitor, which provides an overview of the system's performance in real-time. And the Database Engine Tuning Advisor...
Overview/Description
In order to keep SQL Server 2008 R2 running as efficiently as possible, SQL Server 2008 R2 provides a variety of performance tuning and optimization utilities. Among these utilities are the SQL Server Profiler and the Database Engine Tuning Advisor. The SQL Server Profiler allows you to use trace files and logs to analyze your databaseâs performance. The Database Engine Tuning Advisor allows you to analyze a databaseâs workload and effectively configure the physical design structure of databases based on your analysis. SQL Server 2008 R2 offers the ability to view the...
Overview/Description
SQL Server 2008 R2 provides several key features that improve the availability of servers and databases so that downtime for users is minimized. These solutions include database mirroring, log shipping, replication, and failover clusters. These reliability features help administrators maintain multiple sets of data that help ensure that critical systems remain accessible, and can be fully recovered in the event of a disaster. This course addresses how to configure database mirroring, log shipping, replication, and failover clusters to ensure that SQL Server 2008 R2...
Overview/Description
In SQL Server 2008 R2 you can use Transact-SQL statements to access data in the databases. Transact-SQL statements can be grouped together in a number of ways to create more complex queries when one Transact-SQL statement will not retrieve the desired results. You can group Transact-SQL statements by creating programming objects within a database. These programming objects include stored procedures, functions, and triggers (based on either DML or DDL statements). SQL Server 2008 R2 provides integration with Common-runtime language (CLR). This enables a developer to create...
Overview/Description
SQL Server 2008 R2 is a comprehensive database platform, consisting of components and management tools such as SQL Server Management Studio, Business Intelligence Development studio, and the SQL Server Database Engine. These tools allow administrators and developers to build and maintain software solutions, and perform required functions in a server environment. This course identifies SQL Server 2008 R2 components and management tools, and outlines the requirements for installing SQL Server 2008 R2. The steps required to complete a fresh installation of a SQL Server 2008...
Overview/Description
SQL Server 2008 R2's core component is its Database Engine, which provides storage, processing, and security for enterprise data through its controlled access and rapid transaction processing. Another feature of SQL Server 2008 R2 is the SQL Server Management Studio graphical user tool which allows administrators and developers to create and configure instances and databases on an enterprise level. SQL Server 2008 R2 also includes the SQL Server Configuration Manager for managing SQL Server services, SQL Server network configuration, and SQL Native Client. This course...
Overview/Description
SQL Server 2008 R2 provides many components to ensure that database developers can perform many tasks within the database without having to create custom applications. SQL Server's Service Broker component allows developers to create applications that can work with other SQL Server components to complete a specific task by communicating using messages to relay the task information within the instance or between instances of SQL Server 2008 R2. SQL Server 2008 R2 also offers a way for developers to track changes within the database using either change tracking or change...
Overview/Description
Transact-SQL offers advanced query techniques, such as built-in aggregate, scalar, and ranking functions, and common table expressions to manipulate the result set for a query. To manipulate the result sets and generate rollup information, such as totals, the CUBE, GROUPING SETS, and ROLLUP operators can be used with the GROUP BY statement. UNION, INTERSECT, and EXCEPT can be used to gather specific results in a query. Transact-SQL also provides features that manage international concerns with regards to stored data, such as the collation and sort order. This course...
Overview/Description
XML has been integrated into SQL Server 2008 R2 so that XML data can be stored within databases using the XML data type. You can query this data using the XQuery language within the XML data type methods. SQL Server 2008 R2 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 data type, XML schema collations, and how to create XML indexes. It also explores how to retrieve data using FOR XML, process XML data using OPENXML,...
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
