|Business and Data Analysis with SQL
|Database and Datawarehouse Design
|Introduction to Databases- A History
|SQL Statement Categories
|Capture data requirements
|Physical Vs Logical Data Representations
|Entity Relationship Diagrams (ERD’s)
|Extract, Transform and Load (ETL)
|Structured Query Language (SQL) - Fundamentals
|MySQL Server Setup
|MySQL Server Start and stop Service
|Connect to database
|Comments in SQL
|Select data from a table
|Table and Column Aliases
|Inner Join Tables
|Left and Right Outer Table Joins
|Union (all) Results
|Project Management (Agile Methodology)
|Prioritise Requirements using MoSCoW
|Sales Project – Introduction
|Create and Drop Database
|Sales Project – Part 1 – Data Capture
|Sales Project – Part 2 – Data Analysis
|Sales Project – Part 3 – Data Summary
|Sales Project – Part 4 – Send to production
|MySQL Query Explain Plan
|Common Table Expressions (WITH)
|Data Control Language (DCL)
|MySQL Set Windows Environment Variable
|MySQL Command Line
|Export results to Excel
|Setup MySQL ODBC (Open Database Connector)
|Creating a report in Microsoft Excel
Data analysis is one of the most crucial factors that determine a business’s success. And here’s the thing, the majority of the people out there don’t know how to do data analysis and they are looking for a good business and data analysis course. That is why we created this Business and Data Analysis with SQL Online Course.
You will learn computational and data investigational methods. You will also learn how to run your own data projects, work with databases and manage large datasets and provide meaningful business intelligence reports to your team.
Data is the most important asset a business has, without proper data analysis you will not get the results that you want. Learn the Structured Query Language (SQL) fundamentals and become an indispensable asset to your organisation.
If you want to learn data analysis with SQL then this is the course you need. Enrol now!
From the Business and Data Analysis with SQL Online Course you will learn about:
The Business and Data Analysis with SQL Online Course is great for business professionals who work with data of all sizes. The Business and Data Analysis with SQL Online Course is a great way to get introduced to the fundamentals of business intelligence and basic data warehouse development.
If you want to learn how to do data analysis using SQL then this course is for you.
Knowing how to do data analysis will help you in many ways.
The Business and Data Analysis with SQL Online Course will help you kickstart your career as a:
The Business and Data Analysis with SQL Online Course course is open to all. There are no specific requirements and you can take the course from anywhere in the world. The course is accessible via any modern device with an internet connection and you can study at your own pace.
After successfully completing the Business and Data Analysis with SQL Online Course course by passing the assessment, you will be qualified to get a CPD accredited certificate. We provide both PDF and hardcopy certificates.
You can get a PDF certificate for £4.99, hardcopy certificate for £9.99 and both for only £11.99.