On successful Completion of the course you will get a sound understanding of:
Review and describe the characteristics of a data warehouse
Describe all of the components of an enterprise architecture
Examine different data warehouse architectures
List various types of data that may be considered for the warehouse
Identify the requirements of a decision support query environment
Outline the steps to building a data warehouse
Describe how to determine the first increment according to the value proposition and return on investment
Know the different modeling techniques, specifically entity relationship modeling
Identify the modeling conventions and terminology used, specifically in the Oracle environment
Define metadata and describe why it is important to the warehouse and users
Identify types of metadata for every aspect of warehouse operation, management, and access
Identify the organizational and technical uses of metadata
Evaluate sources for metadata currently in your enterprise
Conduct gap analysis and appreciate where this occurs in the Data Warehouse Method
In this course Students are introduced to the data warehouse environment in the context of the enterprise architecture. Students learn to identify each component of the architecture and its role in the overall system. Students learn how specific business needs can influence the data warehouse design, and also learn how to translate business issues into subject areas.
On successful Completion of the course you will get a sound understanding of:
Describe the Big Data landscape including examples of real world big data problems including the three key sources of Big Data: people, organizations, and sensors
Explain the V’s of Big Data (volume, velocity, variety, veracity, valence, and value) and why each impacts data collection, monitoring, storage, analysis and reporting
Get value out of Big Data by using a 5-step process to structure your analysis
Identify what are and what are not big data problems and be able to recast big data problems as data science questions
Provide an explanation of the architectural components and programming models used for scalable big data analysis
Summarize the features and value of core Hadoop stack components including the YARN resource and job management system, the HDFS file system and the MapReduce programming model
Install and run a program using Hadoop
This course is for those new to data science and interested in understanding why the Big Data Era has come to be. It is for those who want to become conversant with the terminology and the core concepts behind big data problems, applications, and systems. It is for those who want to start thinking about how Big Data might be useful in their business or career. It provides an introduction to one of the most common frameworks, Hadoop, that has made big data analysis easier and more accessible; increasing the potential for data to transform our world.
On successful Completion of the course you will get a sound understanding of:
Understanding Big Data
Business Motivations and Drivers for Big Data Adoption
Big Data Adoption and Planning Considerations
Enterprise Technologies and Big Data Business Intelligence
Storing and Analyzing Big Data
Big Data Storage Concepts
Big Data Processing Concepts
Big Data Storage Technology
Big Data Analysis Techniques
This course covers the essentials of Big Data, primarily from a business perspective. Businesses need to understand that Big Data is not just about technology—it is also about how these technologies can propel an organization forward. This second set of topics shifts from providing a high-level understanding of Big Data and its business implications to covering key concepts related to the two main Big Data concerns: storage and analysis.
On successful Completion of the course you will get a sound understanding of:
Recognize different data elements in your own work and in everyday life problems
Explain why your team needs to design a Big Data Infrastructure Plan and Information System Design
Identify the frequent data operations required for various types of data
Select a data model to suit the characteristics of your data
Apply techniques to handle streaming data
Differentiate between a traditional Database Management System and a Big Data Management System
Appreciate why there are so many data management systems
Design a big data information system for an online game company
In this course, you will experience various data genres and management tools appropriate for each. You will be able to describe the reasons behind the evolving plethora of new big data platforms from the perspective of big data management systems and analytical tools. Through guided hands-on tutorials, you will become familiar with techniques using real-time and semi-structured data examples. Systems and tools discussed include: AsterixDB, HP Vertica, Impala, Neo4j, Redis, SparkSQL. This course provides techniques to extract value from existing untapped data sources and discovering new data sources.
On successful Completion of the course you will get a sound understanding of:
Retrieve data from example database and big data management systems
Describe the connections between data management operations and the big data processing patterns needed to utilize them in large-scale analytical applications
Identify when a big data problem needs data integration
Execute simple big data integration and processing on Hadoop and Spark platforms
This course covers Big Data Integration and Processing including the various aspects of data retrieval for NoSQL data, as well as data aggregation and working with data frames. You will be introduced to MongoDB and you will learn how to retrieve data from them.
On successful Completion of the course you will get a sound understanding of:
Understand Big Data Analysis Techniques
Understand Graph Theory
Describe Graph Tools and Technologies
Understand Neo4j
Understand Graph Analytics
Understand Graph Databases
Model a problem into a graph database and perform analytical tasks over the graph in a scalable manner
This course gives you a broad overview of the field of graph analytics so you can learn new ways to model, store, retrieve and analyze graph-structured data. After completing this course, you will be able to model a problem into a graph database and perform analytical tasks over the graph in a scalable manner. Better yet, you will be able to apply these techniques to understand the significance of your data sets for your own projects.
On successful Completion of the course you will get a sound understanding of:
Define big data and the business drivers for advanced, big data analytics
Describe why and how Data Science is different to traditional Business Intelligence
Describe the roles and skills required in a big data analytics team
Explain the phases and activities of the data analytics lifecycle and identify the main activities and deliverables
Explore and make an initial analysis of the data, using R
Select and execute appropriate advanced analytic methods for candidate selection, categorization, and predictive modeling
Describe the challenges and tools for analyzing text and other unstructured data
Describe the importance and benefits of advanced techniques such as in-database analytics and how extensions and other advanced functions add value
The Data Science and Big Data Analytics course educates students to a foundation level on big data and the state of the practice of analytics. The course provides an introduction to big data and a Data Analytics Lifecycle to address business challenges that leverage big data.
On successful Completion of the Career Enabler: Big Data Analysis with R & Apache Spark course you will be able to:
Apache Spark a popular cluster computing framework used for performing large scale data analysis
Learn about R a popular statistical programming language with a number of extensions that support data processing and machine learning tasks
Learn about SparkR an R package that provides a light-weight front end to use Apache Spark from R
Learn how SparkR provides a distributed data frame implementation that supports operations like selection, filtering, aggregation etc. (similar to R data frames, dplyr) but on large datasets
Learn how SparkR also supports distributed machine learning using MLlib
Certification: This course will assist in preparation for the Microsoft, IBM and Oracle Data Science and Machine Learning Certification exams.
On successful Completion of the Career Enabler: Apache Spark Fundamentals course you will be able to:
the purpose of Spark and understand why and when you would use Spark
how to list and describe the components of the Spark unified stack
the basics of the Resilient Distributed Dataset, Spark's primary data abstraction
Learn how Spark performs at speeds up to 100 times faster than Map Reduce for iterative algorithms or interactive data mining.
Learn how Spark provides in-memory cluster computing for lightning fast speed and supports Java, Python, R, and Scala APIs for ease of development
Learn how Spark can handle a wide range of data processing scenarios by combining SQL, streaming and complex analytics together seamlessly in the same application
Learn how Spark runs on top of Hadoop, Mesos, standalone, or in the cloud. It can access diverse data sources such as HDFS, Cassandra, HBase, or S3
how to download and install Spark standalone
an overview of Scala and Python
Certification: This course will assist in preparation for the Microsoft, IBM and Oracle Data Science and Machine Learning Certification exams.
Career Enabler: Introduction to Data Science, AI & Machine Learning CBT
Data Science
£79.99
On successful Completion of the Career Enabler: Introduction to Data Science, AI & Machine Learning course you will be able to:
Translate business questions into Machine Learning problems to understand what your data is telling you
Explore and analyze data from the Web, Word Documents, Email, Twitter feeds, NoSQL stores, Relational Databases and more, for patterns and trends relevant to your business
Build Decision Tree, Logistic Regression and Naïve Bayes classifiers to make predictions about your customers’ future behaviors as well as other business critical events
Use K-Means and Hierarchical Clustering algorithms to more effectively segment your customer market or to discover outliers in your data
Discover hidden customer behaviors from Association Rules and Build Recommendation Engines based on behavioral patterns
Use biologically-inspired Neural Networks to learn from observational data as humans do
Investigate relationships and flows between people, computers and other connected entities using Social Network Analysis
Certification: This course will assist in preparation for the Microsoft, IBM and Oracle Data Science and Machine Learning Certification exams.
This course introduces students to the fundamentals of SQL using Oracle Database 11g database technology. In this course students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.
On successful Completion of the course you will be able to accomplish the following:
Understand Relational Database Modelling
Identify Oracle Database Development Tools
Install your Oracle Software
Understand the Oracle Database 11g Enterprise Edition Options
Understand the Oracle Database Architecture
Identify the major structural components of the Oracle Database 11g
Manage objects with data dictionary views
Manage schema objects
Run data definition language (DDL) statements to create and manage schema objects
Retrieve row and column data from tables with the SELECT statement
Create reports of sorted and restricted data
Display data from multiple tables using the ANSI SQL 99 JOIN syntax
Create reports of aggregated data
Use the SET operators to create subsets of data
Run data manipulation statements (DML) to update data
Employ SQL & PL/SQL functions to generate and retrieve customized data
SHARE THIS PAGE!