• Open Daily: 10am - 10pm
    Alley-side Pickup: 10am - 7pm

    3038 Hennepin Ave Minneapolis, MN
    612-822-4611

Open Daily: 10am - 10pm | Alley-side Pickup: 10am - 7pm
3038 Hennepin Ave Minneapolis, MN
612-822-4611
What Is SQL ?: Fundamentals of SQL, T-SQL, PL/SQL and Datawarehousing.

What Is SQL ?: Fundamentals of SQL, T-SQL, PL/SQL and Datawarehousing.

Paperback

Programming

Publisher Price: $28.92

ISBN10: 1477246444
ISBN13: 9781477246443
Publisher: Authorhouse
Published: Dec 26 2012
Pages: 430
Weight: 1.38
Height: 0.96 Width: 6.00 Depth: 9.00
Language: English
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.

Also in

Programming