Select Page
Introduction To Databases And SQL

Suitable for all users. You will learn the foundations of this topic. If you are a beginner, or want to brush up on existing skills, this course will benefit you.

g

Suitable for All Levels

2 Day Classroom Course

Certification Awarded

i

Study materials included

Skills You will have at the end of the Course

  • Understand what a relational database is.
  • Examine the following database platforms
  • Microsoft Access.
  • Microsoft SQL Server.
  • Oracle
  • MySQL
  • Create a Database.
  • Understand Database Normalisation.
  • Create ad-hoc SQL Queries.
  • Create efficient SQL Queries.
  • Understand SQL errors, and how rectify them.
  • Indexing for Better Performance
  • Good database practices to be followed.
  • Examine different flavours of SQL
  • ANSI SQL
  • T-SQL
  • P/L-SQL

Course overview

This course starts by explaining what a database is, and moving on to creating databases containing tables and views, and stored procedures.

Requirements

None

Certification

At the end of the course, you’ll be Certified by the Irish Academy of Computer Training

Who would benefit

If you a Report Writer, Data Analyst, Software Developer, Web Developer, or a Programmer, then databases should be one of the technologies in your “To Learn” list. If you don’t know how modern databases work, or want to learnt SQL the language used to work with databases then this course will benefit you.

Why take the Course

To understand how databases work. To help develop good SQL habits. To examine common SQL functions.

Classroom only

Course curriculum

Section 1: Introduction to Databases
Section 1: Introduction to Databases

  • Understand what a database is.
  • Build a database.
  • Datasheet view.
  • Design view.
  • Field Data Types
  • Create database objects
  • Tables
  • Queries
  • Views
  • Stored Procedures
  • Primary Keys.
  • Foreign Keys.
  • Referential Integrity.
  • Relationship Types.
  • Working with
    • Microsoft Access
    • SQL Server Management Studio
    • Oracle SQL Developer
    • MySQL Workbench
Section 2: Creating Relationships between Tables
Section 2: Creating Relationships between Tables 

  • Using Relationships to Link Tables
  • Referential Integrity
  • Relationship Types
    • One To One
    • One To Many
    • Many To Many
Section 3: SQL Basics
Section 3: SQL Basics

  • Retrieving Values from Table – SELECT
  • Selecting specific data using a WHERE Clause
  • Selecting Data Using AND, OR, NOT
  • Selecting Distinct Values from Column – DISTINCT
  • Sorting the Data Using ORDER BY
  • Limiting the Data Retrieved Using TOP or LIMIT
  • Selecting Data with a Range – BETWEEN
  • Creating Table and Column Aliases – AS
  • Selecting Data which has one of Multiple Values – IN
  • Using LIKE and WILDCARDS * % _ ?
Section 4: More Complex SQL
Section 4: More Complex SQL

  • Grouping data – GROUP BY
  • Aggregating Functions
    • SUM
    • MIN
    • MAX
    • AVG
    • COUNT
    • ABS
    • SIGN
    • MOD
    • FLOOR
    • CEILING
    • POWER
    • ROUND
    • SQRT
  • Creating a Database – CREATE DATABASE
  • Removing a Database – DROP DATABASE
  • Creating a Table – CREATE TABLE
  • Inserting Values into Table – INSERT INTO
  • Updating or Modifying Data in a Table – UPDATE
  • Deleting Data from a Table – DELETE
  • Deleting a Table – DROP TABLE
  • Deleting all values in Table – TRUNCATE TABLE
  • Understand a Table’s structure SP_HELP / DESCRIBE
  • Altering a Table’s Structure – ALTER TABLE
  • Copy Table with INSERT INTO SELECT
  • Combine the Tables – UNION
Section 5: Multi Table Queries
Section 5: Multi Table Queries 

  • Using Joins to Combine Tables
    • INNER JOIN
    • LEFT JOIN
    • RIGHT JOIN
    • FULL JOIN

Contact us.

We'll reply quickly.

Enquiry

  • This field is for validation purposes and should be left unchanged.

I understand that my personal data is being processed in accordance with the privacy notice and accept the terms and conditions of use.

0
YOUR CART
  • No products in the cart.