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