Skip to main content
by learnformula
Explore courses
search
For Business
Team license & compliance management
For Higher Education
Academic partnerships
For Government Agencies
Government training solutions
For Instructors & Course Creators
Teach on our marketplace
Become a Sponsor
Reach professionals where they learn
Log inStart 7-Day Free TrialStart Free TrialStart Free Trial
search
Explore courses
  1. Courses
  2. /Information Technology
  3. /Programming Language

SQL for Non-Technical Users

What you need to know to get started

Created byBigger Brainsworkspace_premiumBest Instructor
IntermediateUpdated Jul 23, 2026

What You'll Learn

  • check_circleDefine basic SQL terminology and list seven types of clauses in an SQL statement
  • check_circleWrite an SQL query that retrieves data from one table
  • check_circleClean your query results by sorting, filtering, and adding column aliases
  • check_circleUse the WHERE clause to filter results based on comparisons to numbers and strings
  • check_circleWrite an SQL query that retrieves data from multiple tables using inner joins and WHERE clause joins
  • check_circleUse outer joins to retrieve results where one of the tables does not have matching records
  • check_circleUse date functions to format dates in your results (DATEPART, DATENAME) and to calculate the difference between two dates (DATEDIFF)
  • check_circleConcatenate columns using string functions (+, TRIM) and summarize a column using aggregate functions (SUM, AVG)
  • check_circleCollect data across multiple records and group results using the GROUP BY clause and filter based on grouped data using the HAVING clause.
  • check_circleUse subqueries to retrieve more complex results that cannot be achieved with a single SQL query

About This Course

Learn to write simple queries to get the information you need to do your job

Do you often have to ask others to write SQL queries for you? Are you intimidated by the idea of writing your own SQL query? It’s time to take matters into your own hands.

In this course, you’ll learn how to write a basic SQL query from start to finish. This course will quickly teach you what you need to know to get started. By the end of the course, you’ll be able to retrieve data from multiple tables, sort and filter query results, and use simple calculations. We’ll cover commonly used functions, so you can format dates and text as well as calculate sums and averages.

These lessons will help you learn the fundamentals of the SQL language while also introducing you to some of the more advanced topics. If you’re ready to stop waiting on someone else to pull data for you, this course is for you.

Note: This course uses SQL Server Management Studio, but the language of an SQL query is not specific to any one tool.

Topics covered include:

  • Retrieving data from one or multiple tables
  • Using aliases to simplify your queries
  • Filtering data with the WHERE clause
  • Using Outer Joins
  • Working with functions: DATEPART, DATENAME, DATEDIFF, TRIM, SUM, AVG
  • Using the GROUP BY and HAVING clauses to retrieve and filter summarized data
  • Writing subqueries including nested subqueries

Enjoy seventy-five minutes of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!

Course Content

4 activities • 11 videos • duration: 1h 15m

  • videocamIntroduction
    Duration 1:21
  • videocamFundamentals and Terminology
    Duration 6:25

Your Instructors

Bigger Brains

Powering Productivity, One Brain at a Time!

menu_book105 courses
star3,412 reviews

Combining TV-style video production with modern graphics and animation, Bigger Brains courses are popular with both learners and training professionals around the world. Our top teachers and subject matter experts have real-world experience and create the most realistic and comprehensive training courses possible. Bigger Brains courses are built in a unique “Teacher/Learner” style, featuring two people on camera to recreate some of the interactivity and physiological benefits of classroom training, including dialogue, humor, and practical use case examples. This Uniquely Engaging™ video-based format is more enjoyable and more effective than traditional eLearning formats.

PW

Peggy Ward

Peggy Ward has almost two decades of experience facilitating classroom and virtual training for personal and professional development and software applications. As a Microsoft Certified Trainer (MCT), Peggy has educated thousands of professionals in Office Applications such as Excel, Access, Word, PowerPoint, Outlook, and Office 365. She also conducts training in programming languages including VBA and SQL. Peggy has a passion for personal and professional growth and her interest in helping others, as well as her drive for excellence, knowledge, and growth, have made her an outstanding teacher, mentor, and coach.

Credit Information

What Students Are Saying

4.6 out of 5
Student's Choice
96 reviews
  • SW
    Samuel W.
    starstarstarstarstar

    Very interactive teaching sessions through the instructor and the learner. They interacted nicely to bring out the way for a non-technical users to use SQL to get results. The example database is useful for our understanding too.

  • MB
    Michael B.
    starstarstarstarstar

    Yes. I would like to learn how to write queries and create reports from the database.

  • TK
    Tom K.
    starstarstarstarstar

    I really like the format of this course, it was very functional, not just a set of powerpoint slides but actual experience. I knew a good deal about SQL before going in, but I was still taught new things like subqueries and joins. It is a very progressive course for beginners or intermediate SQL query writers!

  • CD
    Carol Haiyan D.
    starstarstarstarstar

    Great course. Step by step instruction and thorough.

Frequently Asked Questions

We are a registered provider with 300+ associations and regulatory bodies worldwide. We operate across 27 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.

You May Also Like

  • Engineering: Laws & Rules

    Florida Laws and Rules for Professional Engineers - Biennium Cycle 2025-2027

    starRated5.0out of 5,(19 reviews)
    1 CPD hr
  • Engineering: Engineering Ethics

    Ethics-Standards of Conduct

    starRated4.9out of 5,(104 reviews)
    1 CPD hr
  • Engineering: Engineering Management

    AI Management Systems for Engineering Organisations

    starRated5.0out of 5,(21 reviews)
    1 CPD hr