What Is Sql ?: Fundamentals of Sql,T-Sql,Pl/Sql and Datawarehousing.

Victor Ebai

Dez. 2012 · AuthorHouse

Über dieses E-Book

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.

Autoren-Profil

Victor Ebai is an independent business intelligence consultant with twelve years’ experience in the business intelligence industry, covering database, report, data warehouse, and SQL query development. Database programming is a passion of Victor’s, and he’s helped several FTSE 100 companies attain their Business Intelligence objectives. He was educated in Coventry University, United Kingdom, where he currently works and resides.