Home » Courses » Developer Courses » Database Courses » Intro to Relational Databases

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

To get Dates, Pricing & more info please enter your details and we will get back to you.

Or call us on 01 434 7600 

Course Enquiry

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

*Required info. We treat your data with care, please see our Privacy Policy for more details

IACT - Ireland's leading training provider