Introduction to Database Design & SQL Training
Introduction to Database Design & SQL Training Course Description
This 2-days SQL training course focusing on the fundamentals of relational database, understand database models, and create SQL queries to analyze and test data. We will teach you to apply data analytics and business intelligence in a practical scenario-based training. You will be presented with a typical client scenario with hands-on exercises ranging from strategy, data analysis, design and execution.
Audience & Prerequisites
This course is designed for requirements analyst and testers without any database experience.
Use@Work Benefits
*Ability to read data models
*Understand business from a data model
*Analyze data
*Test and validate data
Training Outline
Day 1
*Understand Relational Database
*Understand Data Models
*Learn SQL Structure
*Basic SQL
*Hands-On Exercises
Day 2
*Intermediate SQL
*Aggregate
*Join, Union, Sub-Select
*CRUD
*Hands-On Exercises
Use@Work with RRP’s Scenario-based Training
Our training topics cover Business Intelligence, Data Warehouse, Big Data Framework &
Software Development.
We believe in presenting our materials with key points, simple explanation and easy to understand exercises with a fast-track training approach.
RRP’s proprietary Use@Work Scenario-based Training Methodology provides a progressive hands-on practical training which encompasses the following three main elements of action and assessment.
Tools
Our tools include procedures, checklist, conceptual models, infrastructure, platform applications.
Tactics
We integrate the tools into strategies to deliver the scenario-based training. This includes the business case, data modeling, design strategy and action plan which includes redacted actual data, infrastructure access, and staging the data for analysis.
Hands-On
Our highly experienced and skilled instructors correlate the tools and tactics through lectures, discussion and interactive hands-on exercises.
