Access: Databases and SQL for AnalystsDB-SQL-A

Currently there are no scheduled dates

Available on demand, at time and place convenient to you, for groups of at least 3 participants.

4.8/5 (222)
Stars
exempt from VAT

Price: £ 990

refreshments included

computer station included

Category: Databases and SQL

The course is intended for experienced Excel users – especially data analysts – who want to learn about relational databases. Default database used during this course is MS Access; on demand it can be any other relational database (contact us for details).

The course focus on SQL languages as a tool to retrieve and analyse large data. As natural consequence this course including also database designing module and data manipulation module. This is mayor difference between this course and the other Access courses, which mostly teach how to use Access interface effectively.

Duration

3 days

Agenda

  1. Introduction to relational databases
    • Understanding relations
    • Table, row, column
    • Key, primary key
    • Foreign key, references between tables
  2. SQL syntax
    • Writing simple queries – SELECT statement
    • Using functions and operators
    • Using criteria – WHERE clause
    • Sorting – ORDER BY clause
    • Extremes – TOP clause
    • Using multiple tables – JOIN clause
    • Aggregation – GROUP BY clause
    • Criteria for aggregated sets – HAVING clause
    • Subqueries
    • Combining query results – UNION operator
  3. Designing databases
    • Design process
    • Design notation
    • Best practices and typical problems
  4. Database schema (DDL)
    • Understanding data types
    • Creating tables – CREATE TABLE statement
    • Constraints
    • Using AutoNumber
  5. Inserting, modifying and deleting data
    • Adding data – INSERT statement
    • Editing data – UPDATE statement
    • Removing data – DELETE statement

Download as PDF

Audience and prerequisites

The course is intended for experienced Excel users, as well as both novice and experienced Access users, who want to learn SQL language.

Before attending this course, students must have:

  • Basic computer knowledge, such as keyboard and mouse skills.
  • Basic file-management skills. The student should know how to navigate to folders and files on a computer running Windows Vista / Windows 7.
  • Basic familiarity with writing Excel formulas is recommended.

No prior database experience is required.

Certificates

Course participants receive completion certificates signed by ALX.

There are currently no entries

Enter your e-mail address and we will notify you about future dates

Question?

Ask us anything about this training

* I hereby give my consent to the processing of my personal data by ALX Training Ltd. for the purpose of this request.