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: 9781491986240
You might also like
video
Python Fundamentals
51+ hours of video instruction. Overview The professional programmer’s Deitel® video guide to Python development with …
video
Amazon Web Services AWS LiveLessons 2nd Edition
More Than 17 Hours of Video Instruction More than 17 hours of video instruction on Amazon …
video
Microsoft AZ-900 Certification Course: Azure Fundamentals
Not sure where to start with the Microsoft Azure platform? Whether an IT pro or new …
video
Linux Fundamentals
10+ Hours of Video Instruction Linux Fundamentals LiveLessons has more than 10 hours of comprehensive video …