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.
SQL and databases introduction
What Is SQL?
What Is A Relational Database ?
Overview of Data Mining
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
Unique Identifier Data
Creating / Editing Queries
ASC / DESC
Joins (Inner Vs Outer)
Other advanced topics
Creating / Editing / Argument
Inserting / Deleting Rows
SQL Access Levels
Customer-specific advanced topics
Client main usage discussion
Web – Sanitising Input
Protecting Against SQL Injection
…….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.