This listing has ended. The seller has relisted this item or another one like this.
Item:SQL Tuition Set - SQL, MySQL and SQL Server 2005 incl.

SQL Tuition Set - SQL, MySQL and SQL Server 2005 incl.

Item condition:--
Ended:17 Nov, 200921:17:08 GMT
Price:£6.25
Postage:FREE P&P Royal Mail 1st Class StandardSee more services 

Country:
Postcode:
Service and other details:
Service
Estimated delivery*
Price
Royal Mail 1st Class Standard
3-4 business days
Free
*The estimated delivery time is based on the seller's dispatch time, the postal service selected, and the payment method selected. Sellers are not responsible for shipping service transit times. Transit times may vary, particularly during peak periods.

 See discounts 

 |  See all details
Estimated delivery within 3-4 business days
Payments:
Returns:
Returns accepted | Read details

A reserve price is the minimum price the seller will accept. This price is hidden from bidders. To win, a bidder must have the highest bid and have met or exceeded the reserve price.

 
Seller info
99.6% Positive feedback
Registered as a Business Seller
Other item info
Item number:230389885367
Item location:Worldwide sales, United Kingdom
Post to:N. and S. America, Europe, Australia, Japan
Last updated on 20:18:36 GMT, 16 Nov, 2009 View all revisions
Your pages title here
 
 

SQL Tuition Set & Workshop - 67 tutorials
Including: SQL, MySQL, SQL Server: 2000, 2003, 2005, PostgreSQL, PLSQL, Transact SQL

Please read the full description before buying. By buying, you accept the information stated in the description. By buying
you agree that you have read the whole description and agree to the purchase the product that is for sale.
Please see our FAQ before buying.

A huge collection of text-based tutorials on disc for you to use as needed to learn, improve or reference!

MASTER THE MOST PARAMOUNT DATABASE LANGUAGE!
Over 500MB of tutorials...

Whether you want to learn how to use one of the Microsoft Server products, learn MySQL to create professional websites, pass the MySQL exams or learn SQL for use in your Access or Oracle databases, this tuition set is all that you will need to get started and go all the way with the learning process.

In this tuition set you will get a huge 68 tutorials for SQL - Over 500MB!  That's 16 SQL tutorials, 19 MySQL tutorials and 33 SQL server tutorials.  This set is useful for any database module or exam that you may be taking as it covers the SQL language in complete depth.

Work your way up from complete beginner, through to intermediate and then to advanced usage of SQL, SQL server and MySQL!

SQL
16 Tutorials

A massive 16 tutorials to help you get to grips with SQL

Including PostgreSQL and TransactSQL...

"SQL (commonly expanded to Structured Query Language) is the most popular computer language used to create, modify, retrieve and manipulate data from relational database management systems. The language has evolved beyond its original purpose to support object-relational database management systems. It is an ANSI/ISO standard." [Wikipedia]
Learn the basics of the SQL language:
Relational models
Data types – Numbers, characters, Boolean, Datetimes, ROW, User-defined types
Constraints
SQL in client/server apps
Creating tables
Queries
Subqueries
Nested queries
Transactions and Functions
Users and privileges
Referential integrity
Normalisation
Adding data
FROM and WHERE clause
Comparison predicates
Logical connectives
Relational operators
Recursion
ODBC and JDBC
SQL with XML
Indexes and Joins

And then branch out to the more advanced syntax and features
View merge
Temporary tables
UNION ALL
SQL join
SQL union
NULL
Time
TIMESTAMP
IDENTITY data type
Keyword searching queries
INSERT INTO
UPDATE
Graphs
SQL worms
Error handling

MySQL
19 Tutorials

These 19 MySQL tutorials cover all you need to know to use MySQL.

"MySQL is a multithreaded, multi-user, SQL Database Management System (DBMS) with more than six million installations. MySQL AB makes MySQL available as free software under the GNU General Public License (GPL), but they also dual-license it under traditional proprietary licensing arrangements for cases where the intended use is incompatible with the GPL." [Wikipedia]

Installation on Windows, MAC and Linux
Admin and security
Creating a database
Creating tables
Editing and deleting tables
Database import and export
Inserting data into tables
Setting up user accounts
Entities and Attributes
Relationships
Normal forms (Normalisation)
Indexing
The command line interface
Security and passwords
Debugging
MySQL with PHP
MySQL with ODBC
MySQL with JDBC
MySQL with Perl
Commands reference, Including:
CREATE DATABASE
CREATE TABLE
DESCRIBE
ALTER TABLE
DELETE FROM
INSERT INTO
SELECT
SHOW TABLES
UNION
UPDATE
FLUSH
KILL
RESET
SHOW
CHECK TABLE
GRANT
VIEW

SQL Server
32 Tutorials

33 great tutorials on Microsoft SQL server.  Covering versions 7, 2000, 2003 and 2005!

"Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL) used by both Microsoft and Sybase. SQL Server is commonly used by businesses for small- to medium-sized databases, but the past five years have seen greater adoption of the product for larger enterprise databases." [Wikipedia]

Topics including:
Installations
Creating tables and relationships
Queries
connecting to servers
Mobile databases
User interfaces
Database mail
Backup and preventing data loss
Transactions
Constraints and triggers
Reporting services
Table expressions
Error handling
T-SQL
DDL Triggers
Indexes
Table partitions
.NET integration
The common language runtime
CLR
SQL server with XML
XQuery
Access Projects with SQL server
Stored procedures
Security and encryption
Service broker
Automation
Securing data
Monitoring
Maintaining your system
Integration services
Mirroring databases
Notification services
Using multiple servers
Analysis services

What is a Tutorial/Tuition Set?

Listed above is not even 1% of the content in these tutorials.  They really are huge!  The tutorials are packed full of code examples, illustrations, diagrams, exercises and quizzes to aid the learning process, making our tutorials true learning workshops.

Our Tuition sets contain many tutorials.  These tutorials are very in depth and real value for money.  For example, if we say the Java Set contained 43 tutorials, we do not mean that one tutorial is “How to create an array in Java” another is “How to manipulate strings in Java”.  43 tutorials means 43 huge text based tutorials.  Each tutorial has hundreds, and in some cases, thousands of pages.  So one Java tutorial may mean a 750 page tutorial on Java Beans!  An amazing electronic tuition set, supplied on a CD-ROM with software for viewing.  This is NOT paper based. Please see our FAQ for more information.
 

On the CD is everything you need to use the set. This is not information that can be downloaded from the internet and you will not find this collection for download anywhere on the web. All buyers are provided with the CD, not a link for downloading. These are not unauthorised copies.

Bonus Assembly Language Tuition Set
Included free with this purchase!

Get to the lowest level with our FREE Assembly language package, containing 12 Assembly language tutorials!

"Assembly language commonly called assembly or asm, is a human-readable notation for the machine language that a specific computer architecture uses. Machine language, a pattern of bits encoding machine operations, is made readable by replacing the raw values with symbols called mnemonics." [Wikipedia]

Learn to program in Assembly language, covering topics such as:

CPU registers,
Compilation and execution,
Making sound,
Binary and hexadecimal,
Data representation,
Computer architecture,
Instruction sets,
Interrupts and I/O addressing,
Using strings,
Constants, variables and data types,
Character sets,
Arrays,
Using files,
Procedures,
Low level control structures,
Mixing assembly language with other languages,
Arithmetic,
Debugging,
Assembly language in LINUX and WINDOWS,
Turbo Assembler...


On 25-Aug-07 at 08:41:08 BST, seller added the following information:

Pay instantly with your debit or credit card through PayPal.
Pay me securely with any major credit card through PayPal.


00033
Postage and packaging
Item location: Worldwide sales, United Kingdom
Dispatches to: N. and S. America, Europe, Australia, Japan
Change country:
Postcode:
 
Postage and packaging
To
Service
Estimated delivery*
Free P&P
United Kingdom
Royal Mail 1st Class Standard
3-4 business days
*The estimated delivery time is based on the seller's dispatch time, the postal service selected, and when the seller receives cleared payment. Sellers are not responsible for shipping service transit times. Transit times may vary, particularly during peak periods.
Domestic dispatch time
Will usually dispatch within 2 working days of receiving cleared payment.
Return policy
Returns accepted
Most Buy It Now purchases are protected by the Distance Selling Regulations, which allow you to cancel the purchase within seven working days after the day you receive the item. Find out more about your rights as a buyerand exceptions.
Payment details
Payment methodPreferred/AcceptedBuyer protection on eBay
Credit or debit card through PayPal
Accepted
Seller's payment instructions
CHECK OUR FAQ BEFORE SENDING ENQUIRIES OR IF YOU HAVE ANY QUERIES. Please ensure you pay the correct postage amount as items cannot be dispatched until the full amount is received. Our preferred payment is via Paypal. Please see the item description for more information on other payment methods.
Seller assumes all responsibility for this listing.

About eBay | Announcements | Safety Centre | Partner Centre | VeRO: Protecting Intellectual Property | Policies | Feedback Forum | Site Map | Help
Copyright © 1995-2009 eBay Inc. All Rights Reserved. Designated trademarks and brands are the property of their respective owners. Use of this Web site constitutes acceptance of the eBay User Agreement and Privacy Policy.
eBay official time