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

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.

Author: Victor Ebai
Publisher: Authorhouse UK
Published: 12/26/2012
Pages: 430
Binding Type: Paperback
Weight: 1.38lbs
Size: 9.00h x 6.00w x 0.96d
ISBN13: 9781477246443
ISBN10: 1477246444
BISAC Categories:
- Computers | Programming | General

This title is not returnable