What Is SQL ? by Victor Ebai
Fundamentals Of SQL,T-SQL,PL/SQL and datawarehousing.

No critic rating

Waiting for minimum critic reviews

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.
 

About Victor Ebai

See more books from this Author
 
Published December 27, 2012 by AuthorHouse. 433 pages
Genres: Computers & Technology, Education & Reference. Non-fiction

Rate this book!

Add Review
×