SQL foundations.

Format:

Video

Contributor:

Simpson, Scott, instructor.

Pearson (Firm), publisher.

Language:

English

Subjects (All):

SQL (Computer program language).

Relational databases.

Database management.

Physical Description:

1 online resource (1 video file (3 hr., 34 min.)) : sound, color.

Edition:

[First edition].

Place of Publication:

[Place of publication not identified] : Pearson, 2026.

Summary:

Whether you're in business, tech, or any field that touches data, these foundational skills will make you more effective at your job. SQL allows us to get data from databases, and to store and modify information in those databases. Most knowledge work involves using data, and in business and many other fields, this data is stored in databases. So, learning to access this data using SQL is a critical skill for modern workers. This course takes you from database basics to practical, real-world usage. You'll start by understanding how databases differ from spreadsheets and how tables, , columns, rows, and relationships work together. Then, you'll learn to retrieve and filter data with SELECT and WHERE, sort and limit results, and use aggregate functions to summarize information. You'll explore joining multiple tables to answer complex questions, and learn to insert, update, and delete records as needed. The course includes hands-on challenges where you'll design databases, create reports, and manipulate data just like you would do on the job. You'll even explore how AI tools can assist with SQL, giving you a complete toolkit for working with databases in today's world. Skill Level : Beginner-Intermediate Learn How To : Access and work directly with data using SQL, the universal language for relational databases used across industries Understand how databases organize information so you can analyze data confidently without relying on pre-built reports Apply SQL fundamentals to real-world scenarios like reporting, analysis, and decision-making Build practical, hands-on skills using a real-world database and free toolswithout getting overwhelmed by academic terms or overly-technical theory Course requirement: Pre-requisites: Learners should have a basic proficiency with using a computer and installing software. Experience working with Excel is recommended, and experience with programming will be helpful Who Should Take This Course : Job titles: Data Analyst Business Analyst Sales Manager Salesperson Entry-Level Developer Researcher / Scientist About Pearson Video Training: Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include IT Certification, Network Security, Cisco Technology, Programming, Web Development, Mobile Development, and more. Learn more about Pearson Video training at http://www.informit.com/video.

Notes:

OCLC-licensed vendor bibliographic record.

ISBN:

9780135940969

OCLC:

1593463235