Search
START TYPING AND PRESS ENTER TO SEARCH

    Have a Question About This Course?





    Image

    SQL Querying: Fundamentals

    Database Series
    Organisations typically store their most critical information, the information used to manage day-to-day operations, within a database. The ability to retrieve and analyse this information is essential to the functioning of the organization. Structured Query Language (SQL) is the primary language used to accomplish such tasks. Essentially, SQL is the language you use to interact with a database.

    The ability to write SQL is an essential job skill for those who need to manage large volumes of data, produce reports, mine data, or combine data from multiple sources. Even if someone else on your team creates reports for you, having a fundamental understanding of SQL querying will help you ask the right questions and know what you're looking for in your data analysis tools.

    This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.

    SQL Querying: Fundamentals Objectives

    • In this course you will compose SQL queries to retrieve desired information from a database. You will:
    • Connect to the SQL Server database and execute a simple query.
    • Include a search condition in a simple query.
    • Use various functions to perform calculations on data.
    • Organise the data obtained from a query before it is displayed onscreen.
    • Retrieve data from multiple tables.
    • Export the results of a query.

    Need Assistance Finding the Right Training Solution

    Our Consultants are here to assist you
    Arrange a consultation

    Key Point of Training Programs

    • SQL Querying: Fundamentals Outline

      Lesson 1: Executing a Simple Query

      Topic A: Connect to the SQL Database

      Topic B: Query a Database

      Topic C: Save a Query

      Topic D: Modify and Execute a Saved Query

      Lesson 2: Performing a Conditional Search

      Topic A: Search Using One or More Conditions

      Topic B: Search for a Range of Values and NULL Values

      Topic C: Search Data Based on String Patterns

      Lesson 3: Working with Functions

      Topic A: Perform Date Calculations

      Topic B: Calculate Data Using Aggregate Functions

      Topic C: Manipulate String Values

      Lesson 4: Organizing Data

      Topic A: Sort Data

      Topic B: Rank Data

      Topic C: Group Data

      Topic D: Filter Grouped Data

      Topic E: Summarize Grouped Data

      Topic F: Use PIVOT and UNPIVOT Operators

      Lesson 5: Retrieving Data from Multiple Tables

      Topic A: Combine the Results of Two Queries

      Topic B: Compare the Results of Two Queries

      Topic C: Retrieve Data by Joining Tables

      Lesson 6: Exporting Query Results

      Topic A: Save Query Results as a Text File

      Topic B: Save Query Results as an XML File

      Appendix A: The Pub1 Databases

    • SQL Querying: Fundamentals Format

      In-Person

      Online

    • SQL Querying: Fundamentals Prerequisites

      Basic end-user computer skills and some familiarity with database terminology and structure are required. To fulfill the first requirement, consider taking one of the following Logical Operations courses:

      Using Microsoft® Windows® 11 (with Copilot)
      Microsoft® Windows® 11: Transition from Windows® 10
      Using Microsoft® Windows® 10 (Second Edition)
      To fulfill the second requirement, consider taking the following Logical Operations course:

      Database Design: A Modern Approach