SQLCourse - Lesson 2: Table Basics

The Wayback Machine - https://web.archive.org/web/20071011015528/http://sqlcourse.com:80/table.html

Internet.com - The Network for Technology Professionals

Events
- JupiterEvents
- JupiterWebcasts
Jobs
Partners
Solutions
- eBooks
- Video
Shop

Free Newsletters:
	DatabaseJournal
	DBANews

Interactive Online SQL Training

SQL Courses

1	What is SQL?
2	Table basics
3	Selecting data
4	Creating tables
5	Inserting into a table
6	Updating records
7	Deleting records
8	Drop a table
9	Advanced Queries
10	Standalone SQL interpreter
11	Advertise on SQLCourse.com
12	Database Links
13	Technology Jobs

internet.commerce

Partner With Us
Baby Photo Contest
Cell Phone Plans
Mortgage Refinance
Domain Registration
Complex Webhosting
Phone Systems
Franchise Directory
Mp3 Player Reviews
Promotional Items
GPS
Compare Prices
Televisions
Laptop Battery
Affiliate Programs

internet.com

IT
Developer
Internet News
Small Business
Personal Technology
International

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers

Whitepaper: The Top Five Most Common Hidden Infrastructure Costs. Learn about the steps you can take to reduce imaging and printing costs from your imaging and printing environment.

Table Basics

A relational database system contains one or more objects called tables. The data or information for the database are stored in these tables. Tables are uniquely identified by their names and are comprised of columns and rows. Columns contain the column name, data type, and any other attributes for the column. Rows contain the records or data for the columns. Here is a sample table called "weather".

city, state, high, and low are the columns. The rows contain the data for this table:

Weather

city state high low

Phoenix Arizona 105 90

Tucson Arizona 101 92

Flagstaff Arizona 88 69

San Diego California 77 60

Albuquerque New
Mexico 80 72

SQL Course Curriculum
<<previous	1	2	3	4	5	6	7	8	9	next>>

Internet.com Sitemap

IT Channel	All Linux Devices \| AntiOnline \| Apache Today \| ASPNews \| CPU Planet \| DatabaseJournal \| DBASupport.com \| Enterprise IT Planet \| HardwareCentral \| ISP Glossary \| ISP News \| ISP Planet \| Just Linux \| Linux Planet \| ServerCompare \| ServerWatch \| Solaris Guide \| SQLCourse.com \| SQLCourse2.com \| SysOpt \| The List: ASPs \| The List: Broadband \| The List: ISPs \| The List: WebHosts \| The List: WebDesigners \| Thin Planet \| Ultrawideband Planet \| VoIPPlanet \| WebVideoUniverse \| Wi-FIHotSpotList \| Wi-FiPlanet \| WinDrivers \| xSP News
Developer Channel	4GuysFromRolla.com \| 15 Seconds \| ASP101 \| ASP Wire \| FlashKit.com \| HierMenusCentral.com \| JavaScript.com \| JavaScriptSource \| PHPBuilder.com \| ScriptSearch \| StreamingMediaWorld \| The Counter \| The Guestbook \| VB Forums \| VB Wire \| Web Developer's Journal \| Web Developer's Virtual Library \| WebDeveloper.com \| Webreference \| XMLfiles.com
International Channel	asia.internet.com \| germany.internet.com \| japan.internet.com \| korea.internet.com \| turkey.internet.com
InternetNews Channel	Enterprise Linux Today \| Internetnews.com \| Linux Today \| NewsLinx
Personal Technology Channel	BlackBerryToday \| Jumbo \| Megapixel.net \| PocketPCWire \| Palm Boulevard \| PDAStreet \| SharkyExtreme.com \| Smart Phone Today \| WindowsMobileToday
Small Business Channel	ECommerce-Guide \| ECommerce News \| Refer-It \| SmallBusinessComputing \| Webopedia \| WinPlanet

EarthWeb Sitemap

IT Management Channel	bITa Planet \| CIO Update \| Datamation \| DRM Watch \| eCRM Guide \| eSecurityPlanet.com \| GridComputingPlanet \| Inside ID \| Intranet Journal \| IT Career Planet \| ITSMWatch.com \| Project Manager Planet \| Semantic Web
Networking & Communications Channel	EnterpriseNetworkingPlanet \| EnterpriseStorageForum \| Instantmessagingplanet \| OpenNetworksToday \| Optically Networked \| Practically Networked
Web Development Channel	HTML Goodies \| Javascripts.com
Hardware & Systems Channel	EarthWeb Hardware \| SysOpt.com \| Virtual Dr. \| WorkstationPlanet
Software Development Channel	CodeGuru.com \| Developer.com \| jGuru.com \| JARS.com \| Gamelan.com
IT News Channel	EarthWeb.com \| Earthweb News

DevX Channel

APIFinder | Architecture Zone | ASP.NET Zone | C++ Zone | Database Zone | DevX.com | DevXNews | Enterprise Zone | FreeVBCode | JavaBoutique | Java Zone | Mobile Zone | .NET Zone | Open Source Zone | Semantic Web | Visual Basic Zone | Web Dev Zone | XML Zone

MediaBistro Sitemap

Jobs Channel	Ad Agency Jobs \| Book Publishing Jobs \| Corporate Communications Jobs \| Design/Art/Photo Jobs \| Editing Jobs \| Journalism Jobs \| Magazine Publishing Jobs \| Media Sales Jobs \| Newspaper Jobs \| Online/New Media Jobs \| PR/Marketing Jobs \| Radio Jobs \| Teaching/Academia Jobs \| Television Jobs \| Writing Jobs
Education Channel	Corporate Training \| Courses \| Mediabistro On Demand
News Channel	Features \| FishbowlDC \| FishbowlLA \| FishbowlNY \| GalleyCat \| Media News Feed \| TVNewser \| Unbeige
Other Channel	Events \| Forums \| Freelance Marketplace

Graphics Sitemap

Graphics Channel

AdsOfTheWorld.com | CreativeBits.org | Dynamic Graphics | Graphic Design Forum | Graphics.com | Liquid Treat | STEP inside design

Whitepapers and eBooks	Ipswitch Whitepaper: The Changing Role of the Network Administrator \| Quest Software: Adaptive Management to Drive .NET Service Levels \| Electric Cloud: Agile Development--5 Steps to Continuous Integration \| Symantec: Disk-Based Data Protection--Achieve Faster Backups and Restores While Reducing Your Backup Windows \| OpSource PDF: A Step-by-Step Guide to Starting Up Your SaaS Operations \| Intel Article Series: Managing Multi-Core Projects, Part 1: HPC on the Parallelism Frontier \| Atempo Whitepaper: Restore on Storage Area Network \| HP Whitepaper: Benefits to the ITIL Approach to Service Management \| Symantec Whitepaper: Emerging Trends in Fighting Spam \| Verio Whitepaper: Sharks in the AppPool-- Managing Your Web Presence While Protecting Your Hosting Resources \| Swsoft Whitepaper: Top Ten Server Virtualization Technology Considerations \| Innotas Whitepaper: Implementing Project Portfolio Management in Digestible Bites \| Atempo Whitepaper: Integrated Data Protection for the SME \| SWsoft Whitepaper: An Introduction to OS Virtualization and Virtuozzo \| Ipswitch Whitepaper: Evolution from FTP to Secure File Transfer \| Quest Whitepaper: Realizing Continuous Performance Management Best Practices Documentation \| Avaya Whitepaper: SIP--Creating Next-Generation Telecom Applications \| Symantec Whitepaper: Advantages of Integrated Messaging Security
Webcasts	Fluke Networks: Deploy and Troubleshoot Wi-Fi in the Enterprise \| HP: The New Era of Service Management \| Ipswitch: Best Practices in Network Monitoring \| Innotas: 3 Easy Steps to Project Portfolio Management Success \| Tripwire: Preparing for an IT Audit \| DNF Storage: Enterprise iSCSI Storage Options and Applications \| Finisar: Cure Fabric Blindness and Optimize SAN Performance for Application Availability \| Rational Asset Manager: Succeed with Asset-based Development
Downloads and eKits	Sun Java Studio Creator \| IBM Rational Systems Development Solution e-Kit \| IBM SOA Development Survival Guide eKit \| Evaluate IBM Rational Build Forge Online \| IBM Enterprise Architect eKit for SOA \| Evaluate Rational Application Developer Online \| Iron Speed Designer Application Generator \| Symantec IM Detection Utility
Tutorials and Demos	Demo: Unify Your System i Test Efforts with IBM Rational Software \| JavaOne Online Technical Sessions and Labs \| Rational Functional Tester Tutorial: Create Robust, Reusable Automated Functional Tests \| Rational Software Modeler Tutorial: UML 2.0 Modeling \| DB2 9 Tutorial: Shrink Your Database Using Row Compression \| WhatsUp Gold v11 Demo: Discovery, Mapping, Reporting, & Monitoring

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info

Legal Notices, Licensing, Reprints, & Permissions, Privacy Policy.

Advertise | Newsletters | Tech Jobs | Shopping | E-mail Offers