YOUR CART
- No products in the cart.
Subtotal:
€0
Overview
This course starts by explaining what a database is, and moving on to creating databases
containing tables and views, and stored procedures.
To understand how databases work. To help develop good SQL habits. To examine
common SQL functions
Course Objectives
If you are 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 learn SQL the language used to work with
databases then this course will benefit you
Content
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
Creating Relationships between Tables
- Using Relationships to Link Tables
- Referential Integrity
- Relationship Types
Multi Table Queries
- Using Joins to Combine Tables
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
SQL Basics
- SELECT
- WHERE
- AND, OR, NOT
- DISTINCT
- ORDER BY
- TOP or LIMIT
- BETWEEN
- Creating Aliases – AS
- Multiple Values – IN
- LIKE and WILDCARDS * % _ ?
More Complex SQL
- GROUP BY
- Aggregating Functions
- Creating a Database
- Removing a Database
- Creating a Table
- Inserting Values into Table
- Updating or Modifying Data
- Deleting Data from a Table
- Deleting a Table
- Deleting all values in Table
- SP_HELP / DESCRIBE
- Altering Table Structure
- Combining Tables
You will learn how to
- 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
Audience
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.
Classroom and Virtual training
options
Duration
2 Days
More Courses...
Contact us...
Relevant, industry-focused learning and development
Our expert trainers have a wealth of experience in providing corporate training. Whether you pick off-the-shelf professional diplomas or a customised online L&D Program, we provide relevant, engaging content for all employees.
