What Is SQL ?: Fundamentals Of SQL,T-SQL,PL/SQL and datawarehousing. - Couverture souple

Ebai, Victor

 
9781477246443: What Is SQL ?: Fundamentals Of SQL,T-SQL,PL/SQL and datawarehousing.
Couverture souple
ISBN 10 : 1477246444 ISBN 13 : 9781477246443
Editeur : AuthorHouseUK, 2012

Synopsis

What Is SQL guides beginners, experts, and intermediate readers through the most important aspects of declarative and procedural SQL. Knowledge gained includes the following: ? Designing, building, and querying relational databases in the latest versions of oracle and SQL server databases ? Performing data-quality operations that eliminate corrupted data from databases ? Extending the functionality of SQL using PL/SQL and programmable T-SQL ? Building and loading data warehouses without using an expensive ETL tool ? Troubleshooting and tuning SQL code and database designs ? Extensive use of built-in functions to retrieve and transform data ? Translating complex business rules into database constraints ? Creating advanced queries that answer complex business questions ? Manipulating data within tables ? Creating recoverable business transactions ? Perform nonstandard SQL operations such as deleting duplicate rows Obtain a free sample of oracle11i and SQL server 2012 databases.

Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.

Présentation de l'éditeur

What Is SQL guides beginners, experts, and intermediate readers through the most important aspects of declarative and procedural SQL. Knowledge gained includes the following: ? Designing, building, and querying relational databases in the latest versions of oracle and SQL server databases ? Performing data-quality operations that eliminate corrupted data from databases ? Extending the functionality of SQL using PL/SQL and programmable T-SQL ? Building and loading data warehouses without using an expensive ETL tool ? Troubleshooting and tuning SQL code and database designs ? Extensive use of built-in functions to retrieve and transform data ? Translating complex business rules into database constraints ? Creating advanced queries that answer complex business questions ? Manipulating data within tables ? Creating recoverable business transactions ? Perform nonstandard SQL operations such as deleting duplicate rows Obtain a free sample of oracle11i and SQL server 2012 databases.

Biographie de l'auteur

Victor Ebai is a business intelligence consultant and has almost twelve years of experience in the business intelligence industry in database, report, data warehouse, and SQL query development. SQL performance tuning is a passion of Victors, and hes won corporate optimization awards. He was educated in Coventry, United Kingdom, where he currently resides.

Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.

Éditeur
AuthorHouseUK
Date d'édition
2012
Langue
anglais
ISBN 10 
1477246444
ISBN 13 
9781477246443
Reliure
Broché
Nombre de pages
430
Coordonnées du fabricant
non disponible
Personne responsable
KreGa Onlinehandel GmbH
4950000000000
info@krega-onlinehandel.de

Birkenweg 31
Brakel
33034
Allemagne