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

What Is SQL ? : Fundamentals of SQL, T-SQL, PL/SQL and Datawarehousing. #34;What Is SQL #34; 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 DB in the latest versions of oracle and SQL server DB * Performing data-quality operations that eliminate corrupted data from DB * 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 DB designs * Extensive use of built-in functions to retrieve and transform data * Translating complex business rules into DB 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 Oracle 11i and SQL server 2012 DB. # Informasi Buku Format: Paperback | 430 pages Dimensions: 152 x 229 x 28mm | 599.99g Publication date: 27 Dec 2012 Publisher: AUTHORHOUSE Publication City/Country: United States Language: English Illustrations note: black amp; white illustrations ISBN10: 1477246444 ISBN13: 9781477246443