Vi ste ovdje
Overview/Description
SQL Server 2012 is a robust database system that provides a number of database objects used to store and view data. In order to configure a SQL Server 2012 database to meet business requirements, administrators and developers must fully understand how to design, create, and configure these database objects. These objects include tables for storing data in the database, views to allow access to the data within specific tables, and indexes to optimize the performance of the database for data retrieval. This course identifies each of these database objects and demonstrates...
Overview/Description
In SQL Server 2012 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 can include user-defined functions and DML triggers. When creating programming objects Transact-SQL provides control-of-flow keywords to ensure transaction are completed in a specific sequence and...
Overview/Description
SQL Server 2012 allows programming objects to be created to group multiple statements together. These objects work with data in the databases. One type of programming object is the stored procedure. Stored procedures can help reduce network traffic between clients and servers by enabling more than one statement to be set to the server at a time. They do this by executing statements as batches. They also provide greater security. Within stored procedures and other programming objects such as functions and triggers, error handling can be implemented to enable errors to be...
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...
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
