Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
Web Design Fundamentals is a survey of Web design and development techniques and technologies, fundamental concepts, terms, and best practices involved in professional web design. Instructor James Williamson examines popular web development tools, server-side software solutions, content management solutions, and cloud-based software, providing a high-level overview of the world of Web publishing.
SQL, or Structured Query Language, is the standard for managing and retrieving information from databases. Web applications typically use SQL or some form of it to update, create, delete, or retrieve information from relational databases. Relational databases are the most common form of data storage used by web applications. Relational database store related data in one or more tables. If you've never dealt with databases before, picture an Excel Spreadsheet. Data is stored in rows and columns with the columns describing the data and the row restoring the data itself.
Using simple SQL queries, web applications can parse and use this data within the application. SQL uses simple logical syntax that is very easy for most people to learn. Common statements like Select, Insert, Update, and Delete make it very easy to retrieve or manipulate data. And SQL queries can be refined to filter data sets even further or join related tables together to create a larger dataset. Take this simple SQL query. As you might imagine, this request would parse the data in the Tours table and find Tours price below $200.
Further manipulation, allows us to display the tours in alphabetical order, by Tour name. The data returned from our Tours table is referred to as Dataset and could be used by a web application to populate a table on a web page, display data based on user searches or any number of data related tasks within the site. While SQL is relatively easy to learn, it should be noted that there are several different versions of it and most feature proprietary extensions to the language that are unique for each version. SQL queries are typically found as strings inside web application syntax and passed to the database as the page is processed.
There are many dedicated applications that use SQL to manage databases and many web applications use database management applications such as MySQL to control data within the application itself. Now, for most of you, that might be more information about SQL than you ever wanted to learn. This, of course, poses the question. Do web designers needed to know SQL? Well, the short answer is No. Web or programmers will write the code that will perform most data manipulation within your sites. However, on smaller sites or sites where you need to perform simple web application scripting, a basic knowledge of SQL is a good thing.
Learning the basics of it is simple. So it is a good idea for any new web designers to spend some time working with simple queries and becoming comfortable with the syntax. This will make life easier for you if you ever need to manipulate a query within your application or tackle some basic data manipulation yourself.
There are currently no FAQs about Web Design Fundamentals (2010).
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
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.