Introduction to SQL Course

Course 925

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

In this Introduction to SQL course, you will learn how to optimise the accessibility and maintenance of data with the SQL programming language, including how to:

  • Write the SQL language to develop database applications
  • Build, query, and manipulate databases
  • Work with the PostgreSQL database product or Microsoft SQL Server
  • identify deviations from the standard in Oracle and Microsoft SQL Server

Introduction to SQL Programming Training Delivery Methods

  • In-Person

  • Online

Introduction to SQL Programming Training Benefits

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

Choose from on-demand and instructor-led blended learning options

Gain access to an exclusive LinkedIn group for peer and community support

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

Unlimited Access SQL Premium Blended Training

This on-demand course/bundle will give you access to a library of Microsoft on-demand courses including SQL, Windows, Exchange and more.

At any time during your annual access to this offering, you may attend one of our one-day review sessions focused specifically on Writing SQL Queries.

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Introduction to SQL Programming Training FAQs

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 is the standard language for relational database management systems. Your ability to produce good database applications will be highly dependent on your knowledge of SQL.

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. One of the benefits of taking this course is that it will cover all of the topics using product-specific features of the latest versions of both Oracle and Microsoft SQL Server.

No. While many of the same points are covered, taking the instructor-led Introduction to SQL Programming course provides the deepest dive into that area. This offering is intended for those who wish to gain a broad knowledge of the topics described in the course outline above - including SQL.

Once you are enroled in the programme, specific details and dates will be sent to you.

An outline of the content you will receive can be seen above. You will also get access to any new on-demand content that becomes available during your annual enrolment period.

You will get access 19 pre-configured lab bundles spanning the Microsoft curriculum.

17 practice exams spanning the Microsoft curriculum are included

Once payment is received, you will receive an email from Learning Tree with all the links and information you need to get started.

Once payment is received, you will receive details for your Unlimited Access Training Bundle via email. At that time, you may call or email our customer service team for assistance in enroling in the event date of your choice.