SQL For Audit, Revenue Assurance and Data Science
What you'll learn
- Oracle download and Installation
- Toad for Oracle Download and Installation
- Data analysis and Visualization
- Auditing and Revenue Assurance Techniques
- Database Design
- Manipulate and Analyse Data using SQL
- Basic Computer Knowledge
Have you ever wanted to learn Data analysis on your own but all to no avail?. Have you ever thought of having a Database platform on your system?. This course answers all your questions. In this course, you will learn how to install oracle database and client on your system, Write SQL (Structured Query Language) to analyze, manipulate and visualize data. You will not only learn THEORIES, but you will also learn how to GET IT DONE.
In the first section, you will be introduced to SQL fundamentals. After that, you will learn how to download and install the analytic tools for the course. In the third section, you will learn how to design database and establish relationships amongst the tables in the Database.
Furthermore, in the fourth section, you will begin to write queries and use Functions in SQL, after that, you will learn how to use SQL JOINS to combine tables together and analyse them. This course will not be ended without application of SQL – you will learn how to use it for Revenue assurance as applicable in the Insurance and Banking Sectors. Finally, you will be imparted with the knowledge of how to use SQL to download data to Microsoft Power BI for Visualizations. The Data and SQL Scripts used in the course are attached in the FIRST SECTION of the course. Wish you a great learning experience !!.
Who this course is for:
- Accountants, Auditors, Revenue Assurance Professionals and IT Specialists
A passionate and business oriented IT consultant. He holds a Bachelor’s Degree in Computer Science, a CISA and CISM . He has diverse skills in the following IT related areas - Programming, Website Design & Development, Digital Marketing, Computer Networks and Servers, Revenue Assurance, Information Systems Audits, Control and Security,Data analysis and visualizations.
With work experience of over 7 years , He has implemented audit processes for Banks, manufacturing and Insurance Companies in Nigeria, instituted controls to mitigate IT risks, revenue leakages and cyber fraud. He has also turned data into information for business process owners for strategic business decisions.
He has passion for teaching, He taught in the high school and helped students with their academics. As a consultant, he has also taught participants from different organisations. Samuel is a well experienced professional, he has worked with top brands and his valuable contribution to the growth of business is second to none. His current research areas include cybersecurity, penetration testing and data science.