SQL (Structured Query Language) is a domain-specific programming language used by various database systems to store, extract and manipulate data. If you are a software developer, business analyst or tester who wants to get hands-on exposure to SQL, this is the course for you. Because SQL is generic, it is used with most database systems e.g. Oracle, MS SQL Server, MySQL etc. This training can build a long-term career for you as SQL is a sought after skill. Or, it can enable you to use your newly acquired skill in your organisation.
During this one-day course, we will cover the following learning modules:
• Overview of SQL
• Table Structures Used
• DDL Statements (CREATE, ALTER)
• Database Relationships
• Primary & Foreign Keys, Data integrity
• DML Statements
• Writing SQL Statements
• Joins (INNER, OUTER)
• SQL Procedures/Functions
• Data consolidation using SQL
• Issues – database locking
• How to use SQL with scripts
• SQL for Software Development, Business Analysis & Testing
• Advanced SQL statements
This is a hands-on course, you will be given small tasks and quizzes to complete during the course of the day.
With this course, you will also receive guidance on how to progress your career after learning SQL.