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

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.