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.