September 2018
Intermediate to advanced
1h 34m
English
on-demand course
Intermediate to Advanced SQL: Move Beyond the Basics to Master Complex Concepts
with Allen Taylor
Closed Captioning available in English
Overview
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.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.