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

Ebai, Victor

ISBN 10: 1477246444 / ISBN 13: 9781477246443

Verlag: AuthorHouseUK, 2012

In. Bestandsnummer des Verkäufers ria9781477246443_new

Inhaltsangabe:

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.

Reseña del editor: 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.

Bibliografische Details

Titel: What Is SQL ?: Fundamentals Of SQL,T-SQL,PL/...
Verlag: AuthorHouseUK
Erscheinungsdatum: 2012
Einband: Softcover
Zustand: New