SQL Fundamentals Course

Read more about the SQL Fundamentals course overview, prices and how to book.

Course Objectives: What Will I Learn?

Delegates who complete the SQL Fundamentals course will be able to:

• Understand the principles of the relational database model, in particular entity and referential integrity.
• Create tables and fields using SQL.
• Insert, update and delete data from a database using SQL.
• Selectively extract and sort data from a database.
• Use aggregate functions to summarise data.
• Create SQL queries across multiple tables.
• Understand the use of the command line and text editors in executing SQL instructions.

Intended Audience: Is This The Right Course For Me?

This course is intended for:

• The SQL Fundamentals course is intended for anyone who needs to use SQL to update or query databases, either on its own or within another development environment.

Course Prerequisites: Am I Ready For The Course?

A basic understanding of relational databases will be an advantage.

Please ensure you meet the prerequisites for the SQL Fundamentals Course before you attend the course. Read the importance of course prerequisites to understand why this is necessary.

Course Contents: What Does The Course Cover?

Database Fundamentals

Introduction to databases and SQL. •  Tables, fields, and records. •  Relationships. •  Primary and foreign keys. •  Entity and referential integrity. •  Normalisation.

Data Definition Commands

Creating the database structure. •  Creating table structures. •  Defining fields and field types. •  Creating primary keys. •  Creating foreign keys.

Data Management Commands

Inserting data into tables. •  Saving table contents. •  Correcting and updating table data. •  Deleting data from tables. •  Using COMMIT and ROLLBACK.

Data Query Commands

The SELECT statement. •  Restricting columns. •  Using the WHERE clause to restrict rows. •  Arithmetic, comparison and logical operators. •  Special SQL operators: BETWEEN, IS NULL, LIKE, IN. •  Ordering and sorting selected data. •  Aggregate functions: SUM, AVERAGE, MAX, MIN and COUNT. •  Grouped queries.

Advanced Data Query Commands

Creating sub-queries. •  Using joins in SELECT queries. •  Eliminating duplicates. •  Using aliases. •  The UNION operator.

Advanced Data Management Commands

Modifying existing tables. •  Column constraints. •  Creating views.

Download the SQL Fundamentals course contents in PDF format for easy printing.

Home   |    Top of this page   |    Contact Us    Schedule   |    Course List   |    FAQ   |    Sitemap

Essential Skills for IT