SQL Foundations (Video Course)

Description

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.

Video Lessons are available for download for offline viewing within the streaming format. Look for the green arrow in each lesson.

Sample Content

Table of Contents

Learn the Foundations

Introducing databases and SQL
Learn about the database and SQL ecosystem
Set up tools and lab
Use AI tools to work with SQL

Discover Relational Databases

Learn the difference between databases and spreadsheets
Understand tables, rows, and columns
Understand SQL data types
Explore keys and relationships
Ensure data integrity
Normalize the database
Challenge: Design a database and tables
Solution: Design a database and tables

Using SQL with Databases

Use data from databases
Learn the types of SQL commands
Learn SQL syntax
Create a database and tables
Use an existing database
 Challenge: Create a database and tables
 Solution: Create a database and tables

Reading Data from a Table

Use SELECT to retrieve data
Set conditions for responses with WHERE
Logic and multiple conditions
Set the order of results with ORDER BY
 Limit responses
 Working with numbers
 Transform results
 Explore aggregate functions
 Group results
 Challenge: Retrieve data to create a report
 Solution: Retrieve data to create a report

Querying More than One Table

Using multiple queries at once
Apply JOIN statements
Understand JOIN types
Group joined results
 Challenge: Use JOIN to create a report
 Solution: Use JOIN to create a report

Manipulating Data

Insert new information
Update existing information
Remove existing information
Challenge: Make changes to information
Solution: Make changes to information

Making Changes to Tables

Add a table to a database
Change a tables schema
Remove a table from a database
Import and export data
Challenge: Make a change to a table
Solution: Make a change to a table

AI Tools and Real-World Usage

Use AI chatbots for SQL development
Explore natural language SQL query builders
Work with SQL using integrated AI tools
SQL in the Real World
Troubleshooting and tips
Discover next steps

Updates

Submit Errata