Database And SQL Fundamentals For Data Analytics
Database And SQL Fundamentals For Data Analytic
Public Class
1 Day
HRDF Claimable
Certificate of Attendance
Reference Book
Light Refreshment
In-house
1 Day
HRDF Claimable
Certificate of Attendance
Reference Book
All of our in-house classes can be customised to your organisation’s needs
- Course Details
- Course Outline
Introduction
This is ideal for an individual with no or limited computer programming background who aspires to improve data analytics competencies for existing and/or future data-centric responsibility. Mastering SQL is key to starting your career in data. SQL, stands for “Structured Query Language”, it is also an English like language so anyone who can use English at a basic level can write SQL query easily. In the process of learning SQL, an individual can adapt the skills to specialize as a Data Citizen, Citizen Data Scientist, data analyst, developer, programmer, manager, and more. Possible use cases will be discussed. In addition, there will be hands-on assignments for participants to practise and apply the topics covered.Who Should Attend
Data or Business Analysts Accountants or Finance Personnels Digital Transformation Team Managerial roles ExecutivesCourse Objectives
Delegates who have taken the Python for Accountants, should be able to:
Investigate your dataset, visualise and identify structure easily Integrates SQL from diferent sources by joining them Deals with large datasets in databasesPre-requisites
Basic computer software skill (e.g.: Excel) Basic internet skill
Introduce to Database
Basic concept of database and RDBMS for beginners
Understanding the basis of IT eco-system and database
Learning the database components, structure and architecture
Key and Essential Functions of SQL Data manipulations (Select, Update, Insert, Delete) Fact finding (Display, Sort, Filter, Output) Statistic computing (Count, Sum, Average, Range) Getting related data from multiple tables (Join)
Entity-Relationship Model and Applications Describe cardinality, one-to-one, one-to-many, many-to-one, many-to-many Database models, data normalization and transactions Applications, trend and limition in using SQL
Key and Essential Functions of SQL Data manipulations (Select, Update, Insert, Delete) Fact finding (Display, Sort, Filter, Output) Statistic computing (Count, Sum, Average, Range) Getting related data from multiple tables (Join)
Entity-Relationship Model and Applications Describe cardinality, one-to-one, one-to-many, many-to-one, many-to-many Database models, data normalization and transactions Applications, trend and limition in using SQL
Methodology
This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.
Computer System Requirement
As this course involves hands-on, please bring your own laptop with minimum system requirement equivalent of Intel Core i3, 8GB ram in memory, 40GB Hard Disk Storage Space
Who you will learn with?
MG Ong
Digital Transformation Trainer