TRAINING REQUISITE
There are no prerequisites for the Data & Insight Analytics training course. Whether you have some related previous work experience or you are a new starter, this Data Analytics program is for you. We have had delegates with no previous experience enrolled for this program and successfully secured a job once completed.
The training will not be a classroom-based type of training, it’s more of a discussion-based training where we spend the time with the candidates to be able to contribute in the data insight requirements of a Technology project, exposing you to the relevant skills, tools and technologies to position you for your next dream job.
COURSE FORMAT & SET-UP
Pre-Work- Complete a series of self-paced preparatory test and lessons before the course to match your strength & talent with your career path and get up to speed on the fundamentals of Data and Insight Analytics.
Online Instructor-Led Sessions- Learn by doing with help from an expert. Explore key concepts and tools, and then put them to work through hands-on activities grounded in real-world scenarios. The sessions will run for 4 weeks. Delegates will attend a 2-3hrs session over the 4 weeks period.
Homework - Apply what you’ve learned in class to cumulative assignments that build toward the final project.
Presentations- Share your presentations and receive feedback from your instructional team and classmates.
Live Project - With a strong portfolio of digitally driven programmes and projects, you will have the opportunity to gain practical work experience as a project management or business analysis professional with digital expertise.
COURSE OUTLINE
MODULE 1: Introduction to Data & Insight Analytics
- Introduction
- What is Data and why do businesses and institutions need data?
- What is reasons behind data storage?
- What is a database and why do we need a Datawarehouse?
- The concept of Relational Database Management Systems (RDBMS)?
- Available vendor / and vendor solutions?
- Introduction to SQL
- Data management and regulations
- SQL Server Installation
- Installation of SQL Server 2014/2016
- Database Configuration
- Table Storage
- Authentication and Administration Modes
- Installation of Datawarehouse ( your tutor will provide guidance on available databases)
- Important Database Concepts
- An intro to architecture of relational databases
- Entity Relationship Diagrams (ERD)
- Database Objects (Tables /Views ) Rows and Columns
- Constraints: Primary/ Secondary /Surrogate Keys
- Categorization of SQL languages
- Database security controls and permissions.
- SQL Data types
- Select Statements
- SELECT statement, fundamentals of running queries against a table.
- Eliminating Duplicates with DISTINCT clauses
- Using Column and Table aliases
- CASE Expressions
- T-SQL Scripts, Sets, Predicate Logic
- Logical Order of Operations in SELECT statements
- Summarize number of columns from database tables.
- Limiting Expressions and Filtering Rows
- Types of limiting expressions
- SQL operators
- Use a criterion of interest to limit results
- Comparison operators and match patterns, wildcards
MODULE 2: Table Groupings, SQL Queries & Access Management
- Table groupings, Joins, Grouping and Sorting.
- Aggregate functions
- Table aggregations and Single customer views
- Summarizing and grouping data for reporting purposes
- Arithmetic operations in SQL
- Joins- types of joins
- Managing SQL Queries
- System Tables
- Intro to SQL Optimisation
- Variable Control and flow
- Data Definition and Control
- Intro to data definition and control languages
- CREATE DROP ALTER table
- Tabular access permissions
- Creating Views and Stored Procedures
- Intro to User Access Management
- Database schemas
- Authorizing User Access to Objects
- Configuring and granting Permissions at the Schema Level
LEARNING OUTCOME
At the end of the training, delegates would have learned the concepts of
- SQL Server
- Relational Database Management Systems (RDBMS)
- Database Concepts
- SQL Queries
- User Access Management
POTENTIAL JOB ROLES
- Data Analyst
- Customer Insights Analyst
- Analytics Insight Manager
- Data Project Manager
- Technical Business Analyst
NEXT STEP
Have questions about our Data & Insight Analytics course? Our Admissions team is here to help you determine if this program is right for you and your goals. You can also:
- Attend a Taster session online.
- Explore your financing options.
- Contact us via WhatsApp on +44 (0) 737 567 8933 or send us an email at info@cedar-pro.com
DATA & INSIGHT ANALYTICS
Send download link to:
🕛 Duration (8 weeks)
💼 Work Experience (1 month)
🌏 Location (Online)
💷 Price(£650)