This course teaches you how to design and manage databases for accurate and relevant data analysis, comply with data protection regulations, and understand how real-world activities are represented in databases.
Database plays an essential role in almost all areas where computers are used in modern society. When people deposit or withdraw funds, make airline reservations, and enroll in university courses, they will interact with databases to retrieve, record, or update their data.
Data fuels information systems to work properly and generate relevant output for data analytics. Designing and managing database is, therefore, critical in data analytics. Improper database design will likely impact on inaccurate and irrelevant analysis.
Furthermore, personal data stored in the database requires careful attention and compliance with relevant jurisdictional regulations.
This 2-day workshop will equip you with system thinking to understand how the real-world activities are represented in database. You will then be guided to design a data model and develop a physical database using popular database management systems.
You will also be facilitated to be aware of and comply with data protection-related requirements when working with personal data. Multiple case studies are used to help you fully comprehend database management and data protection issues.
Who Should Attend
Accountants
Auditors
What You Will Learn
System and Representational Model Concept
Understand the system thinking to generate database design that are faithful representations of the focal real-world phenomena
Conceptual Foundation of Relational Model
Learn the conceptual foundation of the relational model, the meaning and importance of primary keys, foreign keys, and related terminology
Data Modelling
Learn the basic stages of database development. Understand the purpose and role of a data model and practice on how to create an E-R diagram from source documents
Transforming Data Models into Database Design
Apply how to transform E-R data models into relational designs and a process for normalizing relations
Structured Query Language (SQL)
Learn and apply SQL statements for database administration
Data Protection and Privacy
Understand the general rules of data protection and privacy when working with personal data processing
SITLEARN Professional Development is the lifelong learning division of Singapore Institute of Technology (SIT), Singapore's first University of Applied Learning. We focus on providing lifelong learning opportunities for working adults to upgrade their skills and knowledge for the workplace.
We aim to be a key continuing education and training partner in Singapore, supporting the SkillsFuture movement by cultivating thinking tinkerers, lifelong learners, and catalysts for workforce transformation.
We empower learners to innovate with industry, keeping pace with the ever-changing needs of the workforce. With a strong focus on authentic learning in a real-world environment, we aim to equip learners with the skills and knowledge they need to excel in their careers and make a meaningful contribution to society.
Oracle Cloud Infrastructure 2023 Architect Professional certification is the Professional level OCI Architect certification that serves as the next level of credential for those who have already earned an OCI Architect Associate title.
The main purpose of this course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
This course has been created for people already acquainted with SQL. The course introduces you into secrets common to all SQL databases as well as MySQL specific syntax, functions and features.
Learn how SQL, a powerful relational database management system can make your life easier and fun! This class covers all the basics and will get you on your way to database mastery, with a solid foundation in SQL.
Acquire the essential knowledge on Big Data, and NoSQL and its application in organizations.Learn the different NoSQL databases, HBase, Cassandra, Redis Fit, and Hadoop Distributed File System
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy