Course
Data Science
Business
Business Essentials
Data Analysis
Data/Business
Continuing Education

Structured Query Language (SQL) Fundamentals Certificate (Learn-by-doing, 24/7, Online, Self-Paced, Gamified, Realtime Instructional Support)

0 credit hours

Credits awarded upon completion

Self-Paced

Progress at your own speed

20 hours

Estimated learning time

About the Course

Description

SQL Fundamentals (NCLab): This online, self-paced, learn-by-doing course provides a comprehensive, hands-on introduction to relational databases and Structured Query Language (SQL). Learners explore key database concepts, including the structure and purpose of data, relational vs. non-relational databases, referential integrity, the ACID principles, and SQL syntax across different database systems. Using PostgreSQL, students write real SQL queries to retrieve, filter, group, and summarize data with commands like SELECT, WHERE, GROUP BY, and HAVING. They gain experience working with multiple tables, modifying table structures, and joining datasets using inner joins. The course also covers constraints, default values, and table management techniques. Through engaging, real-world practice using sample databases like Northwind and World, learners build essential skills for careers in data analytics, software development, and information systems.

Topics

  • Introduction to Data, Databases and SQL
  • SQL Queries (Northwind Practice)
  • Creating and Managing Tables
  • Joining Tables and Combining Data.

Prerequisites

  • NCLab's Workplace Math RECOMMENDED

Sections

Schedule

Asynchronous

Delivery method

Online

Deliverables

  • 0 Credits

    Academic Excellence

    Earn necessary number of credit hours for completing this content

  • Professional Program

    Launch of Career

    Structured Query Language (SQL) Certificate of Completion

  • Hone Important Skills

    Total Upgrade

    Such as Data, Databases and SQL, SQL Queries (Northwind Practice), Creating and Managing Tables, Joining Tables and Combining Data.

Outcomes

Become a subject matter expert in these topics: Introduction to Data, Databases and SQL; SQL Queries (Northwind Practice); Creating and Managing Tables; Joining Tables and Combining Data.

Outcomes Image