Data Engineering Certification

Focused View

Step2C Education

7:34:44

11 View

1 - Introduction

1 - Introduction.mp4

08:08

2 - Data & Database Design

2 - What is Data.mp4

01:29

3 - What is Database.mp4

02:01

4 - What is DBMS.mp4

04:41

3 - How To Design a Data Base

5 - 7 Steps For Designing A Database.mp4

03:57

6 - Design A Database With Single Table.mp4

04:07

7 - Design Database With Multiple Table Part 1.mp4

04:55

8 - Design Database With Multiple Table Part 2.mp4

05:31

9 - Design Database With Multiple Table Part 3.mp4

07:24

4 - MySQL & MYSQL Workbench

10 - Install MySQL.mp4

08:55

11 - Use MYSQL Workbench.mp4

08:09

5 - MySQL Basics

12 - Introduction To MYSQL & SQL.mp4

01:20

13 - CREATE DATABASE.mp4

07:10

14 - CREATE TABLE.mp4

07:57

15 - INSERT DATA.mp4

05:05

16 - FETCH DATA FROM TABLE SELECT Statement.mp4

05:57

17 - Use Basic Where Conditions.mp4

05:20

18 - Use Order By To Sort Your Data.mp4

05:00

19 - REMOVE DATA.mp4

04:48

20 - UPDATE DATA.mp4

04:31

21 - Summary Of MySQL Basics.mp4

01:14

22 - ALTER TABLE Rename To In MYSQL.mp4

01:57

23 - Alter Table Add & Remove Columns From A Table.mp4

03:32

24 - Remove A Table From Our Database.mp4

01:17

6 - GROUP BY

25 - Group By.mp4

08:09

26 - Demo Group By.mp4

01:42

7 - Excel Beginners

27 - Introduction To Excel.mp4

05:22

28 - Add Numbers In Excel.mp4

08:22

29 - Save Time By Filling Cells Automatically.mp4

07:53

30 - Split Data Using Flash Fill in Excel.mp4

03:55

8 - Excel Data Analysis Basics

31 - Excel Sort with 1 criteria.mp4

03:28

31 - Sort-with-1-criteria.xlsx

32 - Excel Sort with 2 or more criteria.mp4

05:36

32 - Sort-Filter-with-more-than-1-criteria.xlsx

33 - Excel Sort by color.mp4

02:47

33 - Sort-Filter-With-Colour.xlsx

34 - Excel Filter Data Based On Single Column.mp4

08:53

34 - Sort-Filter-with-more-than-1-criteria.xlsx

35 - Excel Filter with 2 or more criteria.mp4

02:09

35 - Sort-Filter-with-more-than-1-criteria.xlsx

36 - Excel Filter by color.mp4

01:23

36 - Sort-Filter-With-Colour.xlsx

9 - Introduction To Python & Jupyter Notebook

37 - Installing Python And Anaconda.mp4

05:19

38 - Opening Jupyter Notebook.mp4

10:38

39 - Shortcuts In Jupyter notebook.mp4

11:25

10 - Numpy Data science and analysis Using Python 1

40 - Introduction.mp4

05:53

41 - ndarray.html

42 - Create Numpy ndarray.mp4

13:26

43 - Numpy Index Single Dimensional Array Indexing.mp4

05:24

44 - Numpy Index Multiple dimensions Part 1.mp4

07:37

45 - Numpy Index Multiple dimensions Part 2.mp4

06:29

11 - Mastering Power BI

46 - Install Power BI.mp4

02:57

47 - Introduction To Power BI Project.mp4

01:39

47 - salesnew.zip

48 - Data Source.html

49 - Import Data Into Power BI.mp4

05:23

50 - Fix The Column Issue Using Power Query Transform Data.mp4

01:37

51 - Data Preparation Deriving New ColumnData Using Add Columns.mp4

05:35

52 - Data Preparation Basic Data Cleaning Using Power BI.mp4

05:20

53 - Power BI Visualization Add Slicers.mp4

04:59

53 - blue2.zip

54 - Power BI Visualization Add Cards.mp4

06:09

55 - Power BI Visualization Create A Power BI Bar and column charts.mp4

03:56

56 - Power BI Visualization Create A Power BI Bar and column charts.mp4

07:57

57 - Power BI Visualization MapBased Visualization in Power BI.mp4

03:05

12 - Fundamentals of cloud computing

58 - What is Cloud Computing.mp4

04:56

59 - Public Cloud vs Private Cloud vs Hybrid Cloud.mp4

02:28

60 - IAAS vs PAAS vs SAAS.mp4

07:02

61 - Availability Scalability Elasticity Agility Fault Tolerance Important Concepts.mp4

08:44

13 - DP203 Data Engineering on Microsoft Azure Part 1

62 - How To Create Free Azure Account.mp4

06:21

63 - What Is Azure Storage Account.mp4

07:06

64 - Demo Azure Storage Account Creations And Uses.mp4

06:48

65 - How To Use Storage Explore From Portal.mp4

09:08

66 - How To Use Storage Explore Desktop Version.mp4

10:59

67 - Redundancy In Primary And Secondary Region.mp4

11:14

68 - Read Access To Data in The Secondary Region.mp4

03:03

69 - What is Azure Data Lake V2.mp4

04:43

14 - Data Engineering on Microsoft Azure Part 2

70 - Create Azure Data Lake Gen 2 And Azure Databricks.mp4

04:22

71 - Register an application with Azure AD and create a service principal.mp4

05:42

72 - Assign Roles To The Application To Provide The Service Principal Permissions.mp4

02:47

73 - Add application secret to the Azure Key Vault.mp4

03:39

74 - Create a Secret Scope in Azure Databricks.mp4

03:45

75 - Create Containers bronze Raw silver Processed and goldFinal.mp4

01:40

76 - Create Your First Cluster in Databricks.mp4

05:06

77 - Create A Notebook.mp4

03:35

78 - Mount Azure Data Lake without Key Vault.mp4

08:33

79 - Read CSV file from Data Lake.mp4

02:22

80 - Mount Data lake using Azure Key Vault.mp4

07:18

15 - Introduction To ETL Using Alteryx

81 - Install Alteryx Designer Studio.mp4

03:38

82 - Introduction To Alteryx Designer Studio.mp4

06:37

83 - Creating Your first Application Using Alteryx ETL.mp4

12:01

84 - How To Use Anchors.mp4

03:36

85 - Load Data From Excel.mp4

03:22

86 - Load Multiple Excel files using a Single Input Tool.mp4

05:17

Description

Become A Data Engineering

What You'll Learn?

How To Design A Database
How To Install MySQL
Steps To Design A Simple Data base
Understand the difference between Data / Database and DBMS
Fundamentals of cloud computing
DP-203 : Data Engineering on Microsoft Azure Part 1
How to Use Microsoft Excel For Data Analysis
How To Design Dashboards Using Power BI
Introduction To Python & Jupyter Notebook
Numpy: Data science and analysis Using Python 1

Who is this for?

Any student

Student who want to lean data engineering concepts

What You Need to Know?

You should have an internet connection

Use mobile phone or laptop to watch this videos

More details

Description
Data Engineer Technical Skills
To become a data engineer, you should be very good at SQL, and you should know thoseÂ programming languages used for statistical modeling and data analysis. Also you should know, how to design a data warehousing solutions, and how to build data pipelines.
Database design:
You should know SQL. SQL is the standard programming language for building and managing relational database systems.
Data warehousing solutions:
ETL tools.:
In computing, extract, transform, load (ETL) is the general procedure of copying data from one or more sources into a destination system which represents the data differently from the source(s) or in a different context than the source(s). The ETL process became a popular concept in the 1970s and is often used in data warehousing.
Data extraction involves extracting data from homogeneous or heterogeneous sources; data transformation processes data by data cleaning and transforming them into a proper storage format/structure for the purposes of querying and analysis; finally, data loading describes the insertion of data into the final target database such as an operational data store, a data mart, data lake or a data warehouse
Machine learning:
Machine learning (ML) is the study of computer algorithms that improve automatically through experience and by the use of data.Â It is seen as a part of artificial intelligence. Machine learning algorithms build a model based on sample data, known as "training data", in order to make predictions or decisions without being explicitly programmed to do so.Â Machine learning algorithms are used in a wide variety of applications, such as in medicine, email filtering, speech recognition, and computer vision, where it is difficult or unfeasible to develop conventional algorithms to perform the needed tasks

Who this course is for:
Any student
Student who want to lean data engineering concepts

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Step2C Education

Instructor's Courses

This account is managed by Step2c Education. We create high-quality technology training content. We aim to teach technology the right way but at the same time putting emphasis on each of our students.Our instructors have over 10 years of experience so our courses include their practical experience that can help students to learn and master cloud computing and ETL process.We've been teaching for 10+ years. Now my focus is on Udemy. It's our mission to bring you the best training for cloud computing.We have a team that includes a web developer, database developer, database architecture, data scientist, data visualization expert. software engineers, python developers.For more information and for any one on one training please visit our website.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.