Intermediate to Advanced SQL: : Move Beyond the Basics to Master Complex Concepts / Taylor, Allen.

Format:

Video

Author/Creator:

Taylor, Allen, author.

Language:

English

Subjects (All):

SQL (Computer program language).

Relational databases.

Database management.

Genre:

Electronic videos.

Physical Description:

1 online resource (1 video file, approximately 1 hr., 35 min.)

Edition:

1st edition

Other Title:

Intermediate to advanced Structured Query Language

Place of Publication:

Apress, 2018.

System Details:

video file

Summary:

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.

Participant:

Presenter, Allen Taylor.

Notes:

Online resource; Title from title screen (viewed September 14, 2018)

Title from resource description page (Safari, viewed October 17, 2018).

OCLC:

1057309671