Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now

SQL (Structured Query Language)


From:

Building an Online Shopping Cart (2006)

with Lawrence Cramer

Video: SQL (Structured Query Language)

Now let's take a minute to talk about SQL. 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.
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. 25m 56s
    1. ''Static'' e-commerce sites
      3m 53s
    2. Dynamic e-commerce sites
      3m 5s
    3. Static vs. dynamic sites
      4m 58s
    4. Which application language to use
      9m 40s
    5. SQL (Structured Query Language)
      3m 2s
    6. Hosted vs. stand-alone sites
      1m 18s
  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 0s
    1. Building a custom cart vs. buying off the shelf
      1m 5s
    2. How to choose a shopping cart
      6m 55s
  8. 16m 47s
    1. E-commerce essentials
      1m 32s
    2. The store and the catalog
      4m 18s
    3. The cart
      2m 22s
    4. Checking out
      4m 40s
    5. Online store administration
      3m 55s
  9. 44m 0s
    1. Setting up the development environment
      6m 47s
    2. Installing the Cartweaver Extension Suite into Dreamweaver
      3m 17s
    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 29s
    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

please wait ...
Watch the Online Video Course Building an Online Shopping Cart (2006)
4h 5m Advanced Nov 14, 2006

Viewers: in countries Watching now:

By 2007, 77% of internet users over the age of 13 -- about 131.3 million people -- will shop online. In these tutorials, instructor Lawrence Cramer helps give business owners the tools to harness this market effectively. Using an in-depth case study and other varied examples, Lawrence demonstrates how to seamlessly create and incorporate a shopping cart and back end to support online customers. Building an Online Shopping Cart covers everything from the general concepts of e-commerce to the nitty-gritty of setting up and customizing credit card and order processing features. The training also covers security, customer privacy, building a store, and developing and integrating customer service and policies.

Subjects:
Developer Web
Author:
Lawrence Cramer

SQL (Structured Query Language)

Now let's take a minute to talk about SQL. 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.

There are currently no FAQs about Building an Online Shopping Cart (2006).

 
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.

* Estimated file size

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

Upgrade to View Courses Offline

login

With our new Desktop App, Annual Premium Members can download courses for Internet-free viewing.

Upgrade Now

After upgrading, download Desktop App Here.

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 ?

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:

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.

Learn more, save more. Upgrade today!

Get our Annual Premium Membership at our best savings yet.

Upgrade to our Annual Premium Membership today and get even more value from your lynda.com subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

Start your FREE 10-day trial

Begin learning software, business, and creative skills—anytime,
anywhere—with video instruction from recognized industry experts.
lynda.com provides
Unlimited access to over 4,000 courses—more than 100,000 video tutorials
Expert-led instruction
On-the-go learning. Watch from your computer, tablet, or mobile device. Switch back and forth as you choose.
Start Your FREE Trial Now
 

A trusted source for knowledge.

 

We provide training to more than 4 million people, and our members tell us that lynda.com helps them stay ahead of software updates, pick up brand-new skills, switch careers, land promotions, and explore new hobbies. What can we help you do?

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.