Search for tag: "sql"

mod6_11_sqlite_p2

SQLite Part II

From  Hugo Valle 0 likes 7 plays 0  

mod6_10_sqlite

SQLite part I

From  Hugo Valle 0 likes 9 plays 0  

mod6_01_Welcome

Welcome

From  Hugo Valle 0 likes 13 plays 0  

SQLite Database Practise on Repl

From  Kim Murphy 0 likes 139 plays 0  

TiO Intro - Learning About Databases

This is a brief introduction to the Try It Out Activity, Learning About Databases.

From  Kim Murphy 0 likes 30 plays 0  

Databases - Wrapping Up

Review the terminology and SQL commands used in this activity.

From  Kim Murphy 0 likes 54 plays 0  

Use JOIN, ON and WHERE to create information

Now add WHERE to the JOIN and ON statement to narrow the information returned.

From  Kim Murphy 0 likes 91 plays 0  

Use ON with JOIN to create information

Add ON to the SQL JOIN statement to get data that makes sense from two tables at once.

From  Kim Murphy 0 likes 101 plays 0  

Use JOIN to work with two tables

Use the SQL JOIN statement to get data from two tables at once.

From  Kim Murphy 0 likes 102 plays 0  

Using UPDATE to change values

Use a SQL UPDATE statement to the change values in a record.

From  Kim Murphy 0 likes 95 plays 0  

Using INSERT to add a record to the database

Use the SQL INSERT statement to add a record to the database.

From  Kim Murphy 0 likes 123 plays 0  

Using WHERE and ORDER BY

Write a SQL SELECT statement using WHERE and ORDER BY.

From  Kim Murphy 0 likes 103 plays 0  

Writing a SELECT statement

In this video we write a SQL SELECT statement.

From  Kim Murphy 0 likes 101 plays 0  

Introduction to Database Terminology

This is activity is about databases. This video provides an overview of the terminology and SQL commands we will use.

From  Kim Murphy 0 likes 140 plays 0  

cs3550_mod7_05_FinalProject

Final MySQL project

From  Hugo Valle 0 likes 85 plays 0  

cs3550_mod7_03_validateInstallation

Validate db installation

From  Hugo Valle 0 likes 72 plays 0