• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register

BUY THIS COURSE (USD 45 USD 139)
4 (276 reviews)
( 3310 Students )

 

Career Path - Data Architect

Define data standards & principles for visualizing & designing an organization's enterprise data management framework & end-to-end data architecture.
( add to cart )
Save 68% Offer ends on 30-Jun-2024
Course Duration: 300 Hours
Preview Career Path - Data Architect course
  Price Match Guarantee   Full Lifetime Access     Access on any Device   Technical Support    Secure Checkout   Course Completion Certificate
Popular
Cutting-edge
Job-oriented
Instant access

Students also bought -

Completed the course? Request here for Certificate. ALL COURSES

The Data Architect Career Path by Uplatz consists of the following courses:

1. SQL Programming with MySQL Database

2. Oracle PL-SQL Programming

3. Oracle 21c DBA

4. Talend

5. Business Intelligence & Data Analytics

6. SAP BO

7. Tableau

8. Power BI

9. Python Programming

10. R Programming

11. Data Visualization with Python

12. Data Visualization with R

13. Data Science with Python

14. Data Science with R

 

15. Cloud Computing Basics

 

Data Architecture refers both to the IT systems that facilitate the collection, storage, distribution, and consumption of data within an organization, and to the policies that govern how data is collected, stored, distributed, and accessed within an organization. From an IT standpoint, an organization’s data architecture typically includes data storage and warehousing systems (e.g., databases), computer networks that serve as data pipelines and provide access to stored data, and software platforms and analytics applications that process data in order to further an organization’s goals. In terms of organizational structure, data architecture may encompass personnel who have access to relevant and potentially sensitive data, policies governing data access, and the protocols for the secure distribution of data to relevant parties, including analytics specialists, operations managers, marketing departments, and others, depending on the size and type of the organization.

 

Data Architects visualize and design an organization's enterprise data management framework, aligned with enterprise strategy and business architecture. As a general rule, data architects are professions who have formal training and/or professional experience in IT management, computer programming, and data systems engineering, as well as in the processes by which data is mined, sorted, stored, and analyzed. Data architects typically interact with and respond to the needs of non-technical managers and business administrators within an organization, which may require some training in professional communication. And it may be helpful for data architects to have familiarity and/or experience with business intelligence systems, data mining tools, and data analytics operations.

Data architects design and manage vast electronic databases to store and organize data. They investigate a company’s current data infrastructure and develop a plan to integrate current systems with a desired future state. Data architects then write code to create new, secure framework for databases that may be used by hundreds or thousands of people.

 

Data Architect Roles

Data architects are senior visionaries who translate business requirements into technology requirements and define data standards and principles. The data architect is responsible for visualizing and designing an organization's enterprise data management framework. This framework describes the processes used to plan, specify, enable, create, acquire, maintain, use, archive, retrieve, control, and purge data. The data architect also provides a standard common business vocabulary, expresses strategic requirements, outlines high-level integrated designs to meet those requirements, and aligns with enterprise strategy and related business architecture.

 

Uplatz provides a deep dive into Data Architecture with this course covering different technologies and tools associated with data architecture. This Data Architect Career Path program will help you become a successful data and/or solution architect in any organization.

Course/Topic 1 - SQL Programming with MySQL Database - all lectures

  • In this video get an in-depth introduction to the terminology, concepts, and skills you need to understand database objects, administration, security, and management tools. Plus, explore T-SQL scripts, database queries, and data types

    • 30:09
  • In this video learn basic of SQL Programming and overview the SQL basic commands and how we use these commands in SQL Programming. This SQL tutorial will teach you basics on how to use SQL in MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.

    • 42:45
  • In this video we talk about DDL (DATA DEFINATION LANGUAGE) and also cover all the basic techniques of DDL.In this video we will learn about the SQL commands – DDL, DML, DCL; SQL Constraints – Keys, Not Null, Check , Default, and also MYSQL Hands-on and basic Querying

    • 33:59
  • In this video session we learn SQL commands and how to use these commands like select command, insert command, delete command etc. In this video we will learn about hands-on experience on the terminal, creating database, Tables and manipulating data.

    • 38:49
  • In this video we learn about SQL Basic and Aggregate Functions and also cover different functions of SQL. This tutorial teaches us about clauses and the update command. We will also cover making records, updating and modifying rows.

    • 37:02
  • In this session we talk about SQL Regular Expression and we also cover all techniques of SQL Regular Expression.This tutorial teaches us about clauses and the update command. We will also cover making records, updating and modifying rows and EML commands.

    • 36:07
  • In this video we learn about SQL Comparison Clauses and how we use Comparison Clauses in SQL. This tutorial covers Comparison Operators by relating values by a mathematical symbol which is used to compare two values. Learn about comparison operators result - TRUE, FALSE, or UNKNOWN

    • 28:30
  • In this session we learn about SQL String and also cover all types of string in SQL and how we can use SQL Strings. In this video we will learn about the basic string functions such as concat_ws, file format, and insert function, L-case, u case, and lower case. We will also learn about basic functions such as upper functions.

    • 30:31
  • In this session we cover advance level string function and also cover all different commands we use in SQL String Function. This video is a sequel for string functions tutorial. In this tutorial we will learn few most useful string functions such as spaces and null issue as well, L-Pad command.

    • 38:20
  • In this SQL String function part 3 we learn select Repeat function and Select Replace function and also cover different between Select Repeat function and Select Replace function. This tutorial is another sequel to string functions, however, these functions are used less and not used that frequently. We will further learn here about the repeat function, absolute function, ceiling, and floor and down functions.

    • 23:20
  • In this session we learn about SQL Numeric Functions and how we use Numeric functions in SQL. In this video, we will be covering numerical functions. Learn about the basic date functions and also about truncate functions.

    • 36:50
  • In this video session we learn about SQL Numeric Function and also cover the basic functionality of SQL Numeric Function. SQL Data Functions. In this video we will learn about few more Date functions. We will further look into the day function option as well. This tutorial covers basic querying over a single table.

    • 46:38
  • : In this video we talk about SQL Joins Introduction and Demonstration and basic join’s function and how to make table using joins. In this tutorial learn about joints in SQL. This tutorial teaches us how to connect two different tables with joints. We will also cover the topic of querying two or more tables and about subquery .

    • 36:52
  • In this lecture last session we talk about MySQL Workbench and procedures and Views and MySQL Workbench functionality. In this tutorial learn about SQL in automating things. This tutorial covers stroll procedure, functions and views which are helpful for automation purposes in SQL.

    • 21:22

Course/Topic 2 - Oracle PL/SQL - all lectures

  • Overview of PL/SQL

    • 27:21
  • Declaring PL/SQL Variables

    • 13:02
  • Writing Executable Statements

    • 13:07
  • Interacting with Oracle DB Server

    • 9:37
  • Writing Control Structure

    • 39:35
  • Working with Composite Data Types

    • 43:14
  • Using Explicit Cursors

    • 22:03
  • Handling Exceptions

    • 22:34
  • Creating Procedures

    • 15:39
  • Creating Functions

    • 12:37
  • Creating Packages

    • 10:02
  • Working with Packages

    • 10:27
  • Using Oracle-supplied Packages in Application Development

    • 05:59
  • Using Dynamic SQL

    • 11:58
  • Design considerations for PL/SQL Code

    • 13:35
  • Creating Triggers - Creating Compound, DDL, and Event Database Triggers

    • 22:37
  • Using PL/SQL Compiler

    • 16:00
  • Managing PL/SQL Code

    • 08:55
  • Managing Dependencies

    • 12:35

Course/Topic 3 - Oracle 21c DBA - all lectures

  • Episode 1 - Installation of Oracle Linux 8 on Oracle VM

    • 21:57
  • Episode 2 - Introduction to Oracle 21c Database

    • 01:20
  • Episode 3 - Oracle 21c Architecture

    • 17:46
  • Episode 4 - Practice 1 - Creating a CDB

    • 43:37
  • Episode 5 - Practice 2 - Creating PDBs from the Seed

    • 21:05
  • Episode 6 - Practice 3 - Performing Basic CDB Administration Tasks

    • 32:43
  • Episode 7 - Practice 4 - Managing Common and Local Users

    • 43:16
  • Episode 8 - Practice 5 - Backup and Recovery in CDB and PDBs

    • 38:18
  • Episode 9 - Practice 6 - Flashback and Point-in-time Recovery

    • 41:34

Course/Topic 4 - Talend - all lectures

  • Lecture 1 - Talend Introduction

    • 15:06
  • Lecture 2 - Architecture and Installation - part 1

    • 49:38
  • Lecture 3 - Architecture and Installation - part 2

    • 54:24
  • Lecture 4 - Architecture and Installation - part 3

    • 47:31
  • Lecture 5 - File - Java - Filter Components

    • 53:39
  • Lecture 6 - tAggregateRow - tReplicate - tRunJob Components - part 1

    • 53:40
  • Lecture 7 - tAggregateRow - tReplicate - tRunJob Components - part 2

    • 06:17
  • Lecture 8 - Join Components - part 1

    • 38:00
  • Lecture 9 - Join Components - part 2

    • 19:34
  • Lecture 10 - Sort Components

    • 29:26
  • Lecture 11 - Looping Components

    • 24:19
  • Lecture 12 - Context - part 1

    • 37:48
  • Lecture 13 - Context - part 2

    • 33:37
  • Lecture 14 - Slowly Changing Dimensions (SCD)

    • 44:55
  • Lecture 15 - tMap Components - part 1

    • 31:15
  • Lecture 16 - tMap Components - part 2

    • 37:47
  • Lecture 17 - tMap Components - part 3

    • 33:42
  • Lecture 18 - tMap Components - part 4

    • 13:43
  • Lecture 19 - Talend Error Handling

    • 56:03
  • Lecture 20 - Audit Control Jobs

    • 47:55
  • Lecture 21 - How to use tJAVA components with scenario

    • 54:12
  • Lecture 22 - Talend Big Data Hadoop Introduction and Installation

    • 31:57
  • Lecture 23 - Talend HIVE Components - part 1

    • 47:34
  • Lecture 24 - Talend HIVE Components - part 2

    • 24:42
  • Lecture 25 - Talend HDFS Components

    • 57:50
  • Lecture 26 - Talend TAC

    • 30:31

Course/Topic 5 - Business Intelligence and Data Analytics - all lectures

  • In this lecture session we discuss about Bi concepts, examples and application of business intelligence and data analytics and also cover other concepts of BI.

    • 14:48
  • In this lecture session we learn about basic concepts of BI and also cover factors of business intelligence in brief.

    • 19:22
  • In this lecture session we learn about data warehouse data access and data dashboarding and also cover presentation in BI.

    • 24:10
  • In this lecture session we learn about product database, advertise database and customer demographic database and also cover data analyst concepts.

    • 19:54
  • In this lecture session we learn about basic introduction of business intelligence and also cover factors of business intelligence in brief.

    • 31:10
  • In this lecture session we learn about introduction of predictive modeling and also cover functions of predictive modeling in brief.

    • 1:05:08
  • In this lecture session we learn about data related to customer services and also talk about customer relation databases in brief.

    • 32:37
  • In this lecture session we learn about introduction of NoSQL and also cover basic functions of NoSQL in business intelligence.

    • 33:46
  • In this lecture session we learn about graph stores and also talk about the advantages and disadvantages of graph stores in BI.

    • 25:52
  • In this lecture session we learn about hierarchical clustering in business intelligence and also talk about clustering factors in BI.

    • 29:58
  • In this lecture session we learn about introduction of salesforce in business intelligence and also talk about some basic uses of salesforce.

    • 34:25
  • In this lecture session we learn about introduction to NLP and also cover what is natural language processing in artificial intelligence.

    • 18:30
  • In this lecture session we learn about natural language processing speech to text conversion and also cover the importance of natural language processing.

    • 25:22
  • In this lecture session we learn about introduction of apache server in business intelligence and also talk about basics of apache server.

    • 44:24
  • In this lecture session we learn about deep drive into business intelligence and also talk about factors or deep drive in business intelligence.

    • 30:54
  • In this lecture session we learn about data warehousing in business intelligence and data analytics and also talk about factors and features of data warehousing.

    • 39:54
  • In this lecture session we learn about types of data in business intelligence and also talk about different types of data in BI.

    • 25:07
  • In this lecture session we learn about mobile BI and also talk about open source BI software replacing vendor offering.