Video description
In this SQL training course, expert author Guy Vaccaro teaches you how to use SQL to manage data that is held in relational databases. This training course is designed for beginners who have no previous experience with SQL of any kind. Guy uses Microsoft SQL Server as an example platform, while keeping the SQL query examples applicable to any modern relational database.
You will start by learning how to use SQL (Structured Query Language) to select and filter data from a database, including sorting the data, filtering date columns, and working with null or empty values. Guy then teaches you about common SQL functions, such as text manipulation, and how to group and summarize. This video tutorial also covers topics such as joining tables, data modification, and creating new tables and views. Finally, you will learn about the powerful subquery, and the main variances in SQL between database types.
Once you have completed this computer based training course, you will have a fundamental knowledge of what SQL is and how you can apply it to different database types. Working files are included, allowing you to follow along with the author throughout the lessons.
Publisher resources
Table of contents
-
Getting Started With Databases And SQL
- Relational Databases And Key Terms Explained 00:08:09
- About The Author 00:01:31
- What Are The SQL Commands 00:02:41
- Select Syntax And Examples 00:04:58
- Where Can I Use SQL? 00:05:35
- Installing Sample Databases And Working Files 00:04:13
-
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
- Filtering Date Columns 00:04:34
- Working With Null Or Empty Values 00:06:51
- Using Comments Within SQL 00:06:02
- Use Of Wildcards In Filtering 00:09:14
- Multiple Criteria Using And Or In 00:06:11
-
Functions, Grouping And Summarizing
- Add A Calculating Column To A SQL Statement 00:03:14
- Text Manipulation Functions 00:09:04
- Differences In Date Functions Within SQL 00:07:10
- Calculating Age 00:06:25
- Concatenate Data Columns 00:05:54
-
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
- Group And Summaries Within Joined Table SQL 00:07:04
-
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
- Create A New Table 00:07:10
- Changing A Tables Structure 00:04:59
- What Is A View And How To Create One 00:07:00
- Alter Or Delete A View 00:03:12
-
SQL Summary
- The Main Variances In SQL Between Databases 00:05:38
- The Powerful Subquery 00:07:00
-
Conclusions
- Wrap Up 00:05:14
Product information
- Title: Learning SQL
- Author(s):
- Release date: March 2014
- Publisher(s): Infinite Skills
- ISBN: 9781771372237
You might also like
video
Big Data Analytics with Excel
In this Big Data Analytics with Excel training course, expert author Guy Vaccaro teaches you how …
video
SQL in Motion
"The concepts are covered at a comfortable pace and the methods used to demonstrate those concepts …
video
SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL
SQL skills are in demand. Learn to master SQL using MySQL. Become a SQL Guru today! …
video
Python Fundamentals
51+ hours of video instruction. Overview The professional programmer’s Deitel® video guide to Python development with …