Tomeki
Cover of Sams teach yourself SQL in 10 minutes

Sams teach yourself SQL in 10 minutes

By Ben Forta

4.33 (3 Ratings)
25 Want to read4 Currently reading2 Have read

Publish Date

2004

Publisher

Sams

Language

eng

Pages

242

Description:

Sams Teach Yourself SQL in 10 Minutes, 2E is a tutorial-based book, organized into a series of easy-to-follow, 10-minute lessons. These well targeted lessons teach you in 10 minutes what some books take several hours or days to teach. Instead of dwelling of database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data.The reader of this book will learn how to:Retrieve and sort dataFilter data using comparisons and wildcardsUse the aggregate functions to analyze dataPerform insert, update, and delete operationsJoin relational tables using inner, outer, and self joinsCombine queries using unionsUse viewsCreate and use stored procedures, triggers, and other advanced database features