What Is SQL ? : Fundamentals of SQL, T-SQL, PL/SQL and Datawarehousing.

Victor Ebai

ISBN 10: 1477246444 / ISBN 13: 9781477246443

Editore: Authorhouse UK, 2012

Riguardo questo articolo

nach der Bestellung gedruckt Neuware - Printed after ordering - 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. Codice articolo 9781477246443

Dati bibliografici

Titolo: What Is SQL ? : Fundamentals of SQL, T-SQL, ...

Casa editrice: Authorhouse UK

Data di pubblicazione: 2012

Legatura: Taschenbuch

Condizione: Neu

Descrizione articolo

Riassunto:

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.

L'autore:

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.