SQL Certification – SQL For Beginners

Introduction

This 2-day course will cover the features, outlines and main components of SQL language. This course will include the materials to be able to gain the knowledge on how to effectively read the SQL language to create and alter database objects.

This course is a prerequisite for those who want to continue to do the client/server or database courses.

Prerequisites

In order to attend this course you must have the following prerequisites:

• Be computer literate
• Be familiar with the Windows graphical environment
• Have basic knowledge of 'syntax' as SQL
• Have experience in coding in a coding language

Who should attend this course?

This course is highly recommended for those who need to gain knowledge on SQL to access data

Learning Outcomes

Upon completion of this course, candidates will be able to:

• Have an in-depth knowledge on SQL language
• Have knowledge on how to effectively read the SQL language
• Gain the skills to create and alter database objects
• Gain the skills to safeguard the data with SQL language

Course Outline

This course will include the following topics:

• Introduction to SQL Language
• Features of SQL Language
• Key Concepts
• Where SQL language
• Relational Databases
• Data Manipulation Language
• Joining Tables
• Data Definition Language
• Views with Virtual Columns
• Restricted-Column Views
• Joined-Table Views
• Restricted-Tow Views
• View restrictions
• Summarised Queries
• Subqueries
• Set Operations
• Overview