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
