Tabla de Contenidos: “…Using the UNPIVOT Clause -- Performing Top-N Queries -- Using the FETCH FIRST Clause -- Using the OFFSET Clause -- Using the PERCENT Clause -- Using the WITH TIES Clause -- Finding Patterns in Data -- Finding V-Shaped Data Patterns in the all_sales2 Table -- Finding W-Shaped Data Patterns in the all_sales3 Table -- Finding V-Shaped Data Patterns in the all_sales3 Table -- Summary -- Chapter 9: Changing Table Contents -- Adding Rows Using the INSERT Statement -- Omitting the Column List -- Specifying a Null Value for a Column -- Including Quote Marks in a Column Value -- Copying Rows from One Table to Another -- Modifying Rows Using the UPDATE Statement -- Returning an Aggregate Function Value Using the RETURNING Clause -- Removing Rows Using the DELETE Statement -- Database Integrity -- Enforcement of Primary Key Constraints -- Enforcement of Foreign Key Constraints -- Using Default Values -- Merging Rows Using MERGE -- Database Transactions -- Committing and Rolling Back a Transaction -- Starting and Ending a Transaction -- Savepoints -- ACID Transaction Properties -- Concurrent Transactions -- Transaction Locking -- Transaction Isolation Levels -- A SERIALIZABLE Transaction Example -- Query Flashbacks -- Granting the Privilege for Using Flashbacks -- Time Query Flashbacks -- System Change Number Query Flashbacks -- Summary -- Chapter 10: Users, Privileges and Roles -- A Very Short Introduction to Database Storage -- Users -- Creating a User -- Changing a User's Password -- Deleting a User -- System Privileges -- Granting System Privileges to a User -- Checking System Privileges Granted to a User -- Making Use of System Privileges -- Revoking System Privileges from a User -- Object Privileges -- Granting Object Privileges to a User -- Checking Object Privileges Made -- Checking Object Privileges Received -- Making Use of Object Privileges…”

Accés Lliure
Accés Lliure
Accés lliure

Accés Lliure
Accés Lliure
Accés lliure

Accés lliure
Accés lliure

Tabla de Contenidos: “…Nivel de correlación entre Competencias TIC y Autorregulación parael aprendizaje en línea en los estudiantes del área I-Ciencias de laSalud.110 -- 3.3.3. Nivel de correlación entre Competencias TIC y Autorregulación parael aprendizaje en línea en los estudiantes del área II-Arquitectura eIngenierías111 -- 3.3.4. …”

Tabla de Contenidos: “…Jean Heiss, Ulric Obrecht, l'Alsace et la propagation des traités de Westphalie en France (de 1684 à 1739) -- X. …”