Video Description
If you need to understand how to query relational databases, this Learning Path will get you up and running quickly. Commands, joins, and views are the most fundamental elements of SQL (Structured Query Language) and with them you can make powerful insights into your data. In the just an hour and a half, you will learn how to use SQL to manage data that is held in relational databases. This Learning Path is designed for beginners who have no previous experience with SQL of any kind. Working files are included, allowing you to follow along with the instructor.
Table of Contents
-
Getting Started With Databases And SQL
- What Are The SQL Commands 00:02:41
- Select Syntax And Examples 00:04:58
-
Using SQL To Select And Filter Data
- Using Select To View Data 00:04:08
- Sorting The Data 00:05:57
- Adding A Where Clause To Filter Data 00:05:45
- Use Of Wildcards In Filtering 00:09:14
-
Joining Tables
- Which Tables Can I Join And How? 00:06:26
- Joining More Than Two Tables 00:04:23
- Using Different Join Types 00:05:51
- The Special Cross Or Cartesian Join 00:03:44
-
Data Modification
- Amend Data In Tables 00:08:29
- Adding Data To Tables With Insert 00:09:32
- Removing Data From Tables 00:08:40
-
Creating And Altering Database Objects
- What Is A View And How To Create One 00:07:00
- Alter Or Delete A View 00:03:12
Product Information
- Title: Learning Path: SQL Commands, Joins, and Views
- Author(s):
- Release date: March 2017
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781491986257