SQL for Data Analysis (Introductory / Mid-Level)

Who can take the Course?
1. Project Managers
2. Business Analysts
3. Software Testers
4. Data Analyst
5. Developers

SQL is an incredibly important and valuable skill employer’s desire. So much of our business is digital now. Digital means data; data means databases, and, to access those databases, you need SQL. Try reading a business journal and NOT see something about business intelligence or analytics. As organizations seek to do more with their data, they will need more individuals with the skills to access and analyse that data. SQL is the skill that enables you to do just that.
The radical development in technology has resulted in explosion of data. Therefore, businesses are constantly head-hunting individuals with the right set of analytical and numerate skills to help them make sense of their data.

As a Business Analyst, Project Manager or Software Tester, your value in the job market will drastically increase if you have SQL skills. This does not mean that you will be an expert Data Analyst but SQL skills can help in making you a BA, PM or ST with Data Analysis skills.
Data Analysis is becoming increasingly in high demand across different industry sectors and this skill is critical for unearthing the values in raw data and turning them to actionable insights that drive important business decisions.

This course prepares you 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! SQL is a standard language for accessing and manipulating databases.

There are no prerequisites to learn SQL and it is easier to learn. It’s a query language with English like language. So, anyone who can use English at a basic level can learn and write SQL queries easily. The good thing is that most Database engines are compatible with the SQL code. Because SQL query syntax relies on common English words, even if you have no programming experience you can easily understand how to use it. But it may take somewhat longer to become proficient than if you had come in with some programming experience.

The sessions will run for 4 weeks. Delegates will attend a 2.5hrs sessions over the 4 weeks period.

Candidates will need to have their own laptop and access to data services but all other applications will be provided by Almond.

DAY 1 – MODULE 1

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

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

DAY 2 – MODULE 2

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

DAY 3 – MODULE 3

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

DAY 4 – MODULE 4

Data Definition and Control

  • Intro to data definition and control languages
  • CREATE DROP ALTER table
  • Tabular access permissions
  • Creating Views and Stored Procedures
  • Tabular access permissions
  • Creating Views and Stored Procedures

What is SQL?
SQL (Structured Query Language) is the primary language responsible for managing data and data structures contained within a relational database management system (RDBMS). Put simply, SQL is the language you use to interact with a database. There are four basic operations that SQL can perform: INSERTs, SELECTs, UPDATEs, and DELETEs (these are sometimes referred to as CRUD operations – create, read, update, delete).

What Can SQL do?
• SQL can execute queries against a database
• SQL can retrieve data from a database
• SQL can insert records in a database
• SQL can update records in a database
• SQL can delete records from a database
• SQL can create new databases
• SQL can create new tables in a database
• SQL can create stored procedures in a database
• SQL can create views in a database
• SQL can set permissions on tables, procedures, and views

Potential Job Roles
• Junior Data Analyst
• Technical Project Manager
• IT Business Analyst
• Data Project Manager
• Technical Business Analyst

  • Title

    SQL for Data Analysis

  • Type

    Training Workshop

  • Location

     

  • Duration

    4 Weeks

  • Course Fees

    £299 (Non-Almond Candidates)
    £199 (Almond Candidates)

UPCOMING BATCH

REGISTER NOW

£100

Payment will allow you book an upcoming Batch.

SUBSCRIBE TO THIS COURSE