In code, you use conditional expressions to make decisions and determine which tasks to run. SQL gives you this same ability. You use the keyword WHERE like you would when using an if in PHP. Let’s talk about how you filter to grab the content you want.
Labs
Labs are hands-on coding projects that you build along with Tonya as she explains the code, concepts, and thought processes behind it. You can use the labs to further your code knowledge or to use right in your projects. Each lab ties into the Docx to ensure you have the information you need.
Each lab is designed to further your understanding and mastery of code. You learn more about how to think about its construction, quality, maintainability, programmatic and logical thought, and problem-solving. While you may be building a specific thing, Tonya presents the why of it to make it adaptable far beyond that specific implementation, thereby giving you the means to make it your own, in any context.
WordPress to Database Relationship
This episode is very important. Make sure you get it! Let’s explore the relationship between WordPress and its database. You’ll look at where the content comes from in the database that populates the back-end interface for a post. You’ll explore each of the columns in wp_posts, fields in the wp_postmeta, featured thumbnail image and where it resides, and the author (which relates to the wp_users and wp_usermeta tables. You’ll learn about the glue that binds pieces of information together, such as post metadata and how these are glued to the associated record in the posts database table. The primary database […]
Your First SQL Query
Let’s query the posts database table by writing some SQL within your favorite GUI, i.e. phpMyAdmin or Sequel Pro. We’ll walk through the SQL commands and how to grab information that is conditional upon some value. Your query will be: Then you’ll adapt the query to grab more information.
The Big Picture
In this episode, you will be introduced to databases and SQL. You’ll use either phpMyAdmin or Sequel Pro to explore the actual WordPress database tables. You’ll learn about: What a relational database is Columns Rows and records Schema Primary keys and more
Lab Introduction
Let’s talk about what a database is, what one WordPress uses, and what this lab will do for you.
Lab Introduction
Let’s introduce you to this lab. Before you move into the computer and data, you need to a big picture view of the computing machine, i.e. your computer.
1990s, Modern Day, and the Future
In this topic, we explore technology of 1990s to now and into the future. We look at HTTP, HTML, URI, and Moore’s Law. World Web Web The ability to network computers and computer systems led to major advancements in our ability to communicate, share, and work. In 1989 Tim Berners-Lee, a software engineer and British researcher at the CERN physics lab in Geneva, Switzerland, changed our world when he invented the global network he called the World Wide Web (WWW). In his proposal, he outlined his vision which included a specific set of technical rules or specifications for the distribution […]
Operating Systems and Application Packages
In the mid to late 1960s, technology advanced to the point where the human was the bottleneck in the computing process. It took time for the computer operator to prepare and load the next job. The tasks of loading the various programs, linking the programs together, and then executing the programs required separate manual steps. The solution was to automate these computer-specific tasks by developing software to control the computer and determine which programs to run. This era brought us the operating system (OS). Think about the computer that is presenting this course to you. There are many different programs running it. […]
Birth of High-Level Languages
Throughout this era, machines became more powerful and programmers sought the means to abstract (hide away) the machine code into a form that was more easily written, expanded, and controlled. Programming all day in binary or hex codes at the machine level was not efficient. There had to be a way to invent a translator, which converted some language into the binary that the computer needs. Incrementally throughout this period and even today, computer scientists strive for more efficient and powerful forms of language to push the computer. Short Code (or Short Order Code) was the first “translated” language. Developed […]
Early Days of Computing
Before there were programmable computers, humans were the only computers. Processes were broken down into sequential steps, which a pool of people worked on, hour-after-hour, day-after-day. This process was labor-intensive and prone to error. Mathematicians sought to find a more efficient means of simulating the human computer. During this period, our world of computing progressed, as sequential tasks were finally captured into a form that a machine could process. This period brought the world relay-logic, the precursor to modern day computer circuits. People worked as programmers, converting sequential instructions into the form machines and circuits could execute. The first commercial […]
