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 and Insight Analytics? Our Admissions team is here to help you determine if this program is right for you and your goals. You can also:
- Attend an info session online
- Explore your financing options.
- Contact our helpdesk team on +44 (0) 203 143 3504 or send us an email at info@cedar-pro.com
DATA & INSIGHT ANALYTICS
Send download link to:
Add a Comment