by Allen Taylor | Released September 2018 | ISBN: 9781484239780

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 LearnDesign and manage complex, real-world data setsGroup and order data with advanced SQL statements Craft queries to pull data from multiple tablesImplement security to restrict access to data Who This Video Is ForProgrammers who are new to databases, as well as non-programmers who must retrieve information from databases.  Show and hide more

1. Overview 00:01:21
2. A More Realistic Data Model 00:09:03
3. Multiple Related Tables 00:09:03
4. Retrieving Information with WHERE Clauses 00:06:01
5. Comparison Predicate Recap 00:06:01
6. The BETWEEN Predicate 00:02:06
7. IN and NOT IN 00:02:41
8. LIKE or NOT LIKE 00:05:11
9. The NULL Predicate 00:02:21
10. The Exists Predicate 00:03:01
11. The ALL, ANY, and SOME Predicates 00:05:00
12. Other Modifying Clauses 00:04:14
13. Grouping Related Items with GROUP BY Clauses 00:04:14
14. Selecting within a Group with a HAVING Clause 00:01:49
15. Ordering a Result Set with an ORDER BY Clause 00:03:02
16. Multitable Queries 00:04:01
17. The Cross Join 00:04:01
18. The Equi-join 00:03:58
19. The Natural Join 00:02:37
20. The Condition Join 00:02:37
21. The Column Name Join 00:02:51
22. The Inner Join 00:02:49
23. The Outer Join 00:07:44
24. The Self Join 00:03:54
25. SQL Does More than Just Ask Questions 00:05:25
26. Data Manipulation Language 00:05:25
27. Data Definition Language 00:06:06
28. Data Control Language 00:06:51
Show and hide more