SQL Introduction Training Course Glasgow

SQL Introduction Training Course

The outcome of attending The SQL Introduction Training Course – you will learn database development skills, to manage data and learn basic understanding to create tables/forms/queries/reports for useful applications.

This session is aimed at the person who is new to SQL and is looking to learn some of the fundamental aspects of the software.

The course will demonstrate background knowledge as well as the practical skills to use the package.

You will be led step by step through a series of hands on exercises and provided with full course handout.

Course Content:

SQL and databases introduction
What Is SQL?
What Is A Relational Database ?
Example Uses
Web Database
Data Warehousing
Analytics
Overview of Data Mining
Table Creation
 Operations (Including Primary And Unique Keys)
Designing and Create
ALTER TABLE Statement
Drop TABLE Statement
DROP INDEX Statement
Optimal Database Design (Normalization)
Table And Record Manipulation
INSERT Statement
UPDATE Statement
DELETE Statement
TRUNCATE
VALUES
Unique Identifier Data
Creating / Editing Queries
SELECT
WHERE
LIKE
DISTINCT
COUNT
GROUP BY
ASC / DESC
Advanced Queries

Joins (Inner Vs Outer)
Sub Queries
Other advanced topics
Views
Creating  / Editing / Argument
Inserting / Deleting Rows
Stored Queries
SQL Access Levels
Customer-specific advanced topics
Client main usage discussion
Web – Sanitising Input
Protecting Against SQL Injection
Deeper Analytics
SQL Dashboards
MS SQL
     Installation
Backup
Restore
…….To Name A Few
Questions and Answers:

This session is aimed at the person who is new to SQL and is looking to gain good understanding of the fundamental aspects of the software. The course will demonstrate background knowledge as well as the practical skills necessary to being able to use the package.    The student will be led step by step through a series of hands on exercises and provided with full course documentation.