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.



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
  • Utilizing EXCEPT to find nonmatching rows

Processing data with row functions

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

Performing analysis with aggregate functions

  • Summarizing 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

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

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 optimize 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 organizes 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 analyzing 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.

Chat With Us