Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

SQL (Structured Query Language)

From: Building an Online Shopping Cart (2006)

Video: SQL (Structured Query Language)

SQL stands for Structured Query Language. This is the universal way to talk to databases. It's a simple elegant language that does what we call CRUD- create, read, update and delete data to and from databases. That's it's sole purpose. It's not an application development language. The application development languages use SQL to communicate with databases. Therefore, it's a universal way to talk to databases, that's a real plus in that. You have one common denominator in your development platform.

SQL (Structured Query Language)

SQL stands for Structured Query Language. This is the universal way to talk to databases. It's a simple elegant language that does what we call CRUD- create, read, update and delete data to and from databases. That's it's sole purpose. It's not an application development language. The application development languages use SQL to communicate with databases. Therefore, it's a universal way to talk to databases, that's a real plus in that. You have one common denominator in your development platform.

You talk to databases the same way and whether you're talking to MySQL database or Microsoft SQL Server or Access, we use SQL to communicate with all of these. So let's look at an example of a SQL statement and to see what an elegant and simple language it is. This is what's known as a Select Statement. You are saying SELECT and the star (*) there means All. So it's all fields from the table that you will declare. FROM would be from employees. Let's say you have a table in your database it's about employees. So it's telling the database to pull the information from that table.

A WHERE clause means where employee name, this would be a field in that table, equals Fred. So Select All From employees where the name is Fred, and it's just that simple and elegant of a language. Now it can get very powerful with joins and other things, but that goes beyond what we need to talk about. It's just good to know that it's a powerful, elegant, simple way to communicate universally with databases. Now it is integrated or implemented a little differently in each language, but the SQL is pretty much the same for all. Some databases have made little augmentations to SQL. Microsoft has done that with SQL Server.

But overall a good solid SQL statement is going to work with all databases. Take the time to get acquainted with it. You don't need to learn the language completely but it really helps to know enough about it, to where you can look at a SQL statement and get a good idea of what's being done there. Check with database query builders. Microsoft Access has a excellent query builder that helps you visually build SQL statements and you can see what happens. You check on references online, if you type-in SEQUEL statements or SQL statements or language and Google you will get lot of hits, there are a lot of good references online.

Dreamweaver also has a Record Set Builder that actually creates SQL commands for you. It doesn't get too complex, but it does create simple queries for you and so it is a visual way to create SQL statements there. And most of all I'd highly recommend that you get the book on SQL, it's a small $14-15 book that you can order at Amazon or wherever. It's Sam's Teach Yourself SQL in Ten Minutes by Ben Forta. Great little reference book to have by your computer. What I did with mine is I cut the spine off of it and took it down to an Office Depot and had it spiral bound, so it would open flat on the desk.

It's a great little tool to have right there while you are working, and if you need to build a SQL command or you want to know what the one you are looking at does, the book is right there. It's a quick easy reference.

Show transcript

This video is part of

Image for Building an Online Shopping Cart (2006)
Building an Online Shopping Cart (2006)

48 video lessons · 28428 viewers

Lawrence Cramer
Author

 
Expand all | Collapse all
  1. 1m 51s
    1. Welcome
      1m 51s
  2. 18m 27s
    1. The elements of e-commerce
      6m 21s
    2. SSL (Secure Sockets Layer) certificate essentials
      5m 6s
    3. Acquiring and installing an SSL certificate
      7m 0s
  3. 21m 58s
    1. Accepting credit cards online
      3m 47s
    2. Payment methods
      5m 40s
    3. Choosing between a payment gateway and a processor
      7m 2s
    4. Merchant accounts
      5m 29s
  4. 23m 58s
    1. ''Static'' e-commerce sites
      3m 53s
    2. Dynamic e-commerce sites
      3m 6s
    3. Static vs. dynamic sites
      4m 58s
    4. Which application language to use
      7m 40s
    5. SQL (Structured Query Language)
      3m 2s
    6. Hosted vs. stand-alone sites
      1m 19s
  5. 16m 12s
    1. Database overview
      7m 37s
    2. Choosing a database
      8m 35s
  6. 7m 34s
    1. Securing the database
      4m 56s
    2. Securing the website
      2m 38s
  7. 8m 1s
    1. Building a custom cart vs. buying off the shelf
      1m 5s
    2. How to choose a shopping cart
      6m 56s
  8. 16m 49s
    1. E-commerce essentials
      1m 32s
    2. The store and the catalog
      4m 19s
    3. The cart
      2m 23s
    4. Checking out
      4m 40s
    5. Online store administration
      3m 55s
  9. 44m 3s
    1. Setting up the development environment
      6m 48s
    2. Installing the Cartweaver Extension Suite into Dreamweaver
      3m 18s
    3. Setting up the site
      4m 4s
    4. Installing the Cartweaver application into a new site
      10m 49s
    5. Setting up the DSN (Data Source Name)
      4m 22s
    6. Testing the installation
      2m 30s
    7. Code structure
      7m 35s
    8. A word about design
      4m 37s
  10. 29m 35s
    1. Choosing and preparing the host
      4m 48s
    2. Uploading the site
      4m 22s
    3. Setting up the host DSN
      3m 17s
    4. Testing and troubleshooting
      8m 0s
    5. Setting up the payment gateway or processor
      9m 8s
  11. 45m 36s
    1. Admin walk-through
      6m 7s
    2. Changing the store password
      3m 25s
    3. Global store settings
      6m 2s
    4. Product options
      3m 8s
    5. Categorizing products
      4m 1s
    6. Shipping cost setup
      6m 30s
    7. Adding products
      9m 59s
    8. Customers and orders
      6m 24s
  12. 10m 41s
    1. Customer service and policies
      10m 41s
  13. 22s
    1. Goodbye
      22s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Building an Online Shopping Cart (2006).

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.