SQL or C

SQL: A Beginner's Guide

Author: Andy Oppel

Essential Skills--Made Easy!

Written to the SQL:2006 ANSI/ISO standard, this easy-to-follow guide will get you started programming in SQL right away. You will learn how to retrieve, insert, update, and delete database data, and perform management and administrative functions. SQL: A Beginner's Guide, Third Edition covers new features, including SQL/XML, and is loaded with updated SQL examples along with notes on using them with the latest RDBMS software versions such as MySQL 5.0, SQL Server 2008, and Oracle Database 11g.

Designed for Easy Learning:

• Key Skills & Concepts--Lists of specific skills covered in the chapter
• Ask the Experts--Q&A sections filled with bonus information and helpful tips
• Try This--Hands-on exercises that show how to apply your skills
• Notes--Extra information related to the topic being covered
• Self-Tests--Chapter-ending quizzes to test your knowledge
• Annotated Syntax--Example code with commentary that describes the programming techniques being illustrated

Andrew J. (Andy) Oppel has designed and implemented hundreds of databases for a wide range of applications. He is the author of Databases Demystified and SQL Demystified.

Robert Sheldon is a consultant and technical writer. He has designed and implemented various Access and SQL Server databases

New interesting textbook: Liderança Eficaz e Gestão em Assistência

C (For Dummies Series): All-in-One Desk Reference for Dummies

Author: Dan Gookin

* Covers everything users need to get up to speed on C programming, including advanced topics to take their programming skill to the next level
* Walks C programmers through the entire development cycle of a C program-designing and developing the program, writing source code, compiling the code, linking the code to create the executable programs, debugging, and deployment
* Provides thorough coverage of keywords, program flow, conditional statements, constants and variables, numeric values, arrays, strings, functions, pointers, debugging, prototyping, and much more
* Addresses some advanced programming topics such as graphics and game programming as well as Windows and Linux programming
* Includes dozens of sample programs that readers can adapt and modify for their own uses
* Written by the author of the first-ever For Dummies book-a man known for his ability to take complex material and present it in a way that makes it simple and fun

Table of Contents:

Bk. I	Hello, C	7
Ch. 1	Your basic C program	9
Ch. 2	How it all works	19
Ch. 3	More basics, comments, and errors	33
Ch. 4	Introducing numbers and variables	47
Ch. 5	More variables and basic I/O	61
Ch. 6	Decision time	79
Ch. 7	Looping	89
Ch. 8	Using constants	101
Ch. 9	Mysterious math	109
Ch. 10	It's only logical	123
Bk. II	Middle C	133
Ch. 1	Variables from beyond infinity	135
Ch. 2	The madness of printf()	149
Ch. 3	Maniacal math functions	165
Ch. 4	Not truly random	181
Ch. 5	While going loopy	193
Ch. 6	More decision making	205
Ch. 7	The goto chapter	217
Bk. III	Above C level	221
Ch. 1	Asking for arrays	223
Ch. 2	I sing of strings	243
Ch. 3	Messing with characters	265
Ch. 4	Stinkin' structures	271
Ch. 5	Creating your own functions	293
Ch. 6	Quitting before you're done	319
Ch. 7	More variable nonsense	329
Bk. IV	Advanced C	347
Ch. 1	Introduction to evil pointers	349
Ch. 2	Getting to the [superscript *]point	373
Ch. 3	Binary bits	381
Ch. 4	The myth of the array	403
Ch. 5	Pointers and strings	417
Ch. 6	Crazy arrays of pointers	429
Ch. 7	Functions and pointers	451
Ch. 8	Structures, pointers, and the Malloc deity	471
Ch. 9	Does anyone have the time?	485
Ch. 10	Building big programs	497
Ch. 11	Help!	511
Bk. V	Disk drive C	521
Ch. 1	Just your standard I/O	523
Ch. 2	Interacting with the command line	537
Ch. 3	Hello, disk!	547
Ch. 4	More formal file writing and reading	561
Ch. 5	Random access files	575
Ch. 6	Folder folderol	585
Ch. 7	Under new file management	607
Bk. VI	The joy of linked lists	615
Ch. 1	Why linked lists?	617
Ch. 2	Dawn of the database	629
Ch. 3	Storing a linked list on disk	643
Ch. 4	The nightmare of the double-linked list	655
Bk. VII	Appendixes	667
App. A	The stuff you need to know before reading everything else in this book	669
App. B	ASCII table	681
App. C	Answers to exercises	685
App. D	C language keywords and operators	763
App. E	C language variable types	767
App. F	Escape sequences	769
App. G	Conversion characters	771