English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 1h 34m | 159 MB
Learn the basics of creating, maintaining, protecting, and querying relational databases using SQL, the standard language used to communicate with all relational databases. Building on the author’s previous course, Beginning SQL, SQL expert Allen Taylor provides five more lessons to continue your journey to mastery of one of the most important topics in IT. This video course guides you step-by-step in the design, creation, and operation of databases, using graphics, animation, and audio commentary to reinforce concepts and enhance learning.
Intermediate to Advanced SQL covers complex data models, making highly selective retrievals, and grouping and ordering results. You’ll also learn how to use multi-table queries, and to protect your data from mistakes or hacking attempts. After watching the course, along with the previous course, you will have a solid foundation in SQL and be able to apply it to any relational database.
What You Will Learn
- Design and manage complex, real-world data sets
- Group and order data with advanced SQL statements
- Craft queries to pull data from multiple tables
- Implement security to restrict access to data
Who This Video Is For
Programmers who are new to databases, as well as non-programmers who must retrieve information from databases.
Table of Contents
01 Overview
02 Multiple Related Tables
03 Comparison Predicate Recap
04 The BETWEEN Predicate
05 IN and NOT IN
06 LIKE or NOT LIKE
07 The NULL Predicate
08 The Exists Predicate
09 The ALL, ANY, and SOME Predicates
10 Grouping Related Items with GROUP BY Clauses
11 Selecting within a Group with a HAVING Clause
12 Ordering a Result Set with an ORDER BY Clause
13 The Cross Join
14 The Equi-join
15 The Natural Join
16 The Condition Join
17 The Column Name Join
18 The Inner Join
19 The Outer Join
20 The Self Join
21 Data Manipulation Language
22 Data Definition Language
23 Data Control Language
Resolve the captcha to access the links!