UK flag UK
+44 (0) 207 874 5000
+44 (0) 207 874 5000

Introduction to SQL Course

Course 925

  • Duration: 3 days
  • Labs: Yes
  • Language: English
  • Level: Foundation

Learning Tree's Introduction to SQL Course is designed to provide an introduction to the SQL programming language, which is the standard language for relational database management systems. The course covers the basics of SQL, including creating tables, manipulating data, and querying databases. Students who complete the course will be equipped to write SQL queries, work with Microsoft SQL Server or PostgreSQL.

The course is suitable for beginners with no prior experience in SQL or database management, as well as professionals who want to refresh their skills. Overall, Learning Tree's Introduction to SQL Course is an excellent starting point for anyone looking to learn SQL and become proficient in database management and data engineering.

SQL Course Delivery Methods

  • In-Person

  • Online

SQL Course Information

In this course, you will learn how to:

  • Write SQL code based on Wrap in ANSI/ISO standards to build database structures.
  • Update database content with SQL and transaction handling.
  • Retrieve data with filter conditions and from multiple tables using various types of joins.
  • Process data with row and aggregate functions.
  • Leverage continued support with after-course one-on-one instructor coaching and computing sandbox.

Prerequisites

None.

Introduction to SQL Instructor-Led Course Outline

  • Outlining SQL as the cornerstone of database activity
  • Applying the ANSI/ISO standards
  • Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys

Creating tables and columns

  • Building tables with CREATE TABLE
  • Modifying table structure with ALTER TABLE
  • Adding columns to an existing table
  • Removing tables with DROP TABLE

Protecting data integrity with constraints

  • Guaranteeing uniqueness with primary key constraints
  • Enforcing integrity with foreign key constraints
  • Imposing business rules with check constraints

Improving performance with indexes

  • Expediting data retrieval with indexes
  • Recommending guidelines for index creation

Modifying table contents

  • Adding table rows with INSERT
  • Changing row content with UPDATE
  • Removing rows with DELETE

Applying transactions

  • Controlling transactions with COMMIT and ROLLBACK
  • Deploying BEGIN TRANSACTION in SQL Server

Writing Single Table queries

  • Retrieving data with SELECT
  • Specifying column expressions
  • Sorting the result with ORDER BY
  • Handling NULL values in expressions

Restricting rows with the WHERE filter

  • Testing for equality or inequality
  • Applying wildcard characters
  • Avoiding NULL value pitfalls

Applying the ANSI/ISO standard join syntax

  • Matching related rows with INNER JOIN
  • Including nonmatched rows with OUTER JOIN
  • Creating a Cartesian product with CROSS JOIN

Combining results with set operators

  • Stacking results with UNION
  • Identifying matching rows with INTERSECT
  • Utilising EXCEPT to find nonmatching rows

Processing data with row functions

  • Conditional formatting with the CASE expression
  • Utilising the CASE expression to simulate IF tests
  • Dealing with NULL values

Performing analysis with aggregate functions

  • Summarising data using SUM, AVG and COUNT
  • Finding the highest/lowest values with MAX and MIN
  • Defining the summary level with GROUP BY
  • Applying filter conditions with HAVING

Applying subqueries in filter conditions

  • Creating correlated vs. noncorrelated subqueries
  • Testing the existence of rows

Including subqueries in expressions

  • Placing subqueries in the column list
  • Creating complex expressions containing subqueries
  • Handling subqueries that return no rows

Breaking down complex problems

  • Selecting data from a query result set
  • Using subqueries in the FROM clause

Creating views in a database

  • Building reusable code
  • Creating updateable vs. non-updateable views
Get This Course £1,975 For Team Prices Call: 44 (0) 207 874 5000
  • 3-day instructor-led training course

  • After-course coaching available

  • After-course computing sandbox
  • Learning Tree end-of-course exam included

Get the Advantage £2,995
  • Take this course and gain unlimited access to more than 300 virtual instructor-led courses
  • Future-proof your career with more than 100 sought-after certifications in the market
  • Build real skills through hands-on learning in more than 180 virtual labs
  • Grow your skills and capabilities with more than one course at a time and save
Thank you for choosing subscriptions!
#925
  • Guaranteed to Run - you can rest assured that the class will not be cancelled.
    Dec 5 - 7 9:00 AM - 4:30 PM GMT
    Virtual
  • Guaranteed to Run - you can rest assured that the class will not be cancelled.
    Dec 13 - 15 2:00 PM - 9:30 PM GMT
    Virtual
  • Jan 3 - 5 2:00 PM - 9:30 PM GMT
    Virtual
  • Jan 10 - 12 2:00 PM - 9:30 PM GMT
    Washington, DC or Virtual
  • Guaranteed to Run - you can rest assured that the class will not be cancelled.
    Jan 17 - 19 2:00 PM - 9:30 PM GMT
    Virtual
  • Jan 24 - 26 9:00 AM - 5:00 PM GMT
    London or Virtual
  • Guaranteed to Run - you can rest assured that the class will not be cancelled.
    Jan 31 - Feb 2 2:00 PM - 9:30 PM GMT
    Herndon, VA or Virtual
  • Mar 5 - 7 9:00 AM - 5:00 PM GMT
    London or Virtual
  • Mar 13 - 15 1:00 PM - 8:30 PM GMT
    Ottawa or Virtual
  • Guaranteed to Run - you can rest assured that the class will not be cancelled.
    Mar 26 - 28 1:00 PM - 8:30 PM GMT
    Virtual
  • Apr 10 - 12 3:00 PM - 10:30 PM BST
    Austin or Virtual
  • Apr 10 - 12 9:00 AM - 5:00 PM BST
    London or Virtual
  • Apr 24 - 26 2:00 PM - 9:30 PM BST
    Virtual
  • May 22 - 24 2:00 PM - 9:30 PM BST
    Virtual
  • May 29 - 31 2:00 PM - 9:30 PM BST
    Virtual
  • Jun 5 - 7 9:00 AM - 5:00 PM BST
    London or Virtual
  • Jun 5 - 7 2:00 PM - 9:30 PM BST
    Washington, DC or Virtual
  • Jun 12 - 14 2:00 PM - 9:30 PM BST
    New York or Virtual
  • Jun 26 - 28 2:00 PM - 9:30 PM BST
    Toronto or Virtual
  • Jul 10 - 12 2:00 PM - 9:30 PM BST
    Herndon, VA or Virtual
  • Jul 17 - 19 9:00 AM - 5:00 PM BST
    London or Virtual
  • Jul 17 - 19 2:00 PM - 9:30 PM BST
    Virtual
  • Jul 24 - 26 2:00 PM - 9:30 PM BST
    Virtual
  • Jul 31 - Aug 2 2:00 PM - 9:30 PM BST
    Virtual
  • Aug 7 - 9 2:00 PM - 9:30 PM BST
    Ottawa or Virtual
  • Aug 14 - 16 2:00 PM - 9:30 PM BST
    Virtual
  • Aug 28 - 30 2:00 PM - 9:30 PM BST
    Virtual
  • Sep 4 - 6 3:00 PM - 10:30 PM BST
    Austin or Virtual
  • Sep 11 - 13 9:00 AM - 5:00 PM BST
    London or Virtual
  • Sep 11 - 13 2:00 PM - 9:30 PM BST
    Virtual
  • Sep 18 - 20 2:00 PM - 9:30 PM BST
    Virtual
  • Sep 25 - 27 2:00 PM - 9:30 PM BST
    New York or Virtual

Scroll to view additional course dates

  • Bring this or any training to your organisation

  • Full-scale programme development

  • Delivered when, where, and how you want it
  • Blended learning models
  • Tailored content
  • Expert team coaching

Get the Advantage £2,995
  • Take this course and gain unlimited access to more than 300 virtual instructor-led courses
  • Future-proof your career with more than 100 sought-after certifications in the market
  • Build real skills through hands-on learning in more than 180 virtual labs
  • Grow your skills and capabilities with more than one course at a time and save
Thank you for choosing subscriptions!
#925
Questions about this course?
* Required Fields
Customise Your Team Training Experience

Fill out the form below or call 44 (0) 207 874 5000

* Required Fields
Preferred method of contact:

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Contact Us

SQL Course FAQs

This course is designed to introduce you to the structured query language (SQL), the cornerstone of database activity, and how to use SQL to optimise data accessibility, maintenance, and data engineering. It covers a variety of topics including building and querying databases, working with different types of joins, data analysis, and data integrity.

A database model is a type of database that organises data in a structured way, and SQL is a programming language used to store and retrieve data from relational database management systems (RDBMS) such as Microsoft SQL Server.

This course teaches you how to write SQL code based on ANSI/ISO standards, to build, query and manipulate databases, and to identify deviations from the standard in Oracle and Microsoft SQL Server.

Anyone interested in learning SQL or pursuing a career in data analysis, data engineering, or database management should take this course. It is also suitable for database administrators and SQL developers who want to improve their skills.

You will learn how to write SQL code based on ANSI/ISO standards, to build database structures, update database content, and retrieve data using various types of joins. You will also learn how to process data with row and aggregate functions, construct nested queries, and develop in-line and stored views.

In addition, the course covers how to protect data integrity with constraints, improve performance with indexes, and apply transactions to database management.

No. This course was designed to teach you the fundamentals of the SQL language. You will learn SQL over 3 days with instructor-led training and hands-on experience using either the PostgreSQL database product or Microsoft SQL Server 2016.

SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is one of the primary database products used in this course, alongside PostgreSQL. SQL Server is an important tool for SQL developers and administrators who work with Microsoft systems, and this course provides hands-on experience using this platform.

Learning SQL is a valuable skill that can help you pursue a career in data analysis, data engineering, or database management. SQL is widely used in the industry and is an important tool for managing and analysing data. This course will provide you with a solid foundation in SQL, which will be beneficial to your career growth.

Oracle and Microsoft SQL Server are both types of relational database management systems. Although all relational database management systems use SQL, unfortunately, different products have different dialects of SQL. Therefore, one benefit of this course is that it will cover all topics using product-specific features of the latest Oracle and Microsoft SQL Server versions.

Stored procedures are a type of database object that contains SQL statements and are stored in the database itself. They are often used to perform complex database operations and are an important tool for database management. This course covers the basics of stored procedures and how to use them to improve database performance.

Data integrity is the process of maintaining the accuracy and consistency of data in a database. This course covers various ways to ensure data integrity, such as using constraints like primary key and foreign key, which guarantee uniqueness and enforce data relationships respectively.

Structured Query Language (SQL) is a programming language used to store, manipulate and retrieve data from relational database management systems (RDBMS). It is one of the primary tools for managing data in the industry, and this course will teach you the fundamentals of SQL.

This course covers how to build, query and manipulate databases using SQL, which is a widely used tool for storing data. By learning SQL, you will gain the skills to create and maintain databases in a variety.

Related Courses

  • Learning Tree
    Writing SQL Queries Training

    Attend this 1-day, hands-on Writing SQL Queries course for an introduction to the SQL language used by all relational database products.

    Foundation
    1 day
    Online or In-class
    Starts from £579
  • Learning Tree
    Advanced SQL Course

    In this Advanced SQL course, you learn how to write robust sql queries, test your queries & avoid common errors & pitfalls. Attend in-class or online.

    Advanced
    3 days
    Online or In-class
    Starts from £1,975
  • Learning Tree
    Introduction to Power BI Training

    In this Introduction to Power BI course, you will gain the basic skills and knowledge to manage and analyse data in Power BI.

    Foundation
    3 days
    Online or In-class
    Starts from £1,465
  • Learning Tree
    Oracle® PL/SQL Training

    In this hands-on Oracle PL/SQL training course, you will learn how to execute PL/SQL programmes, build stored procedures, execute modular applications & more.

    Intermediate
    5 days
    Online or In-class
    Starts from £2,565