This database design and database management site aims to provide book reviews and free ebook on oracle, pl sql, dba, sqlplus, mysql sql, php my sql, my sql tutorial, ms sql tutorial, db2 database, db2 tutorial, sybase sql,sysbase tutorial, Access tutorial, data mining, data modelling, data warehousing, and information retrieval, etc

Teach Yourself SQL in 21 Days, Second Edition

Authors: : Ryan K. Stephens, Ronald R. Plew, Bryan Morgan, and Jeff Perkins
© Copyright, Macmillan Computer Publishing.
Overview
The first 14 days of this book show you how to use SQL to incorporate the power of modern relational databases into your code. By the end of Week 1, you will be able to use basic SQL commands to retrieve selected data.
NOTE: If you are familiar with the basics and history of SQL, we suggest you skim the first week's chapters and begin in earnest with Day 8, "Manipulating Data."
At the end of Week 2, you will be able to use the more advanced features of SQL, such as stored procedures and triggers, to make your programs more powerful. Week 3 teaches you how to streamline SQL code; use the data dictionary; use SQL to generate more SQL code; work with PL/SQL, Transact-SQL, and SQL*Plus; and handle common SQL mistakes and errors.
The syntax of SQL is explained and then brought to life in examples using Personal Oracle7, Microsoft Query, and other database tools. You don't need access to any of these products to use this book--it can stand alone as an SQL syntax reference. However, using one of these platforms and walking though the examples will help you understand the nuances.

Popular Posts

Followers

Search for unlisted Ebooks