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.
Hinweis: Dieser Artikel kann nur an eine deutsche Lieferadresse ausgeliefert werden.
Hinweis: Dieser Artikel kann nur an eine deutsche Lieferadresse ausgeliefert werden.