Skip to navigation
Skip to navigation
Skip to search form
Skip to login form
Skip to footer
Skip to main content
Accessibility options
Accessibility profiles
Visual impairment
Seizure and epileptic
Color vision deficiency
ADHD
Learning
Content adjustments
Readable font
Highlight titles
Highlight links
Stop animations
Text size
+
+ +
+ + +
Line height
+
+ +
+ + +
Text spacing
+
+ +
+ + +
Color adjustments
Dark contrast
Light contrast
High contrast
High saturation
Low saturation
Monochrome
Orientation adjustments
Reading guide
Reading Mask
Big black cursor
Big white cursor
Email: it@huph.edu.vn
Email: it@huph.edu.vn
Các khóa học
Đổi giao diện
Giao diện cũ
Giao diện mới
en
English
Data Science Courses
Become a Data Analyst - (ETL, SQL, Power BI, Python,R )
0 students
Last updated
Jan 2025
Enrol now
Overview
Course content
Instructors
About the course
Show more...
Course content
Sections:
10
•
Activities:
1
•
Resources:
120
Expand all
Section 1
SQL for Data Analysis
Announcements
007 MySQL Database Download for Windows E1Zu gitir
008 MySQL Database Download for Mac DjDq gitir
009 Introduction to MySQL Workbench I9QP gitir
010 Installing MySQL Workbench for Mac LI5M gitir
011 Basic database concepts mQSA gitir
012 What is a Schema XN4K gitir
013 Database Schemas ZaFi gitir
014 MySQL Data Types nkF5 gitir
015 SQL basics Select Where From nIdF gitir
017 INNER JOIN IID7 gitir
018 LEFT JOIN rFRQ gitir
019 RIGHT JOIN bgil gitir
020 SELF JOIN fIz4 gitir
021 SQL Group By z8qn gitir
022 SQL Having AZtf gitir
023 SQL Order By aOFE gitir
024 SQL Distinct aGOD gitir
025 SQL Character Function LgaB gitir
026 SQL Concat Function Gy5i gitir
027 Introduction to Aggregate Functions mK6W gitir
028 AVG Function P60z gitir
029 COUNT Function UD0L gitir
030 SUM Function G4pL gitir
031 MIN Function JK32 gitir
032 MAX Function iN9D gitir
034 SQL BETWEEN OfK4 gitir
035 SQL IN fIC1 gitir
036 SQL LIKE rI6J gitir
037 SQL UNION iKxK gitir
038 SQL Subquery sLkl gitir
039 Nested Sub query xXKK gitir
Section 2
Setting Up Environment for ETL
046 What is SQL Server 9Zmr gitir
047 SQL Server Version qwjB gitir
049 SQL Server Download 7UN6 gitir
050 SQL Server Installation G1YS gitir
051 Install SQL Server Management studio SSMS dKHK gitir
052 Connect SSMS to SQL Server 44sC gitir
053 Restore sample database eCw5 gitir
054 Restore sample data warehouse database 2CSx gitir
055 What is Visual Studio a8ck gitir
056 Install Visual studio 7IPk gitir
057 Visual studio workloads bgSK gitir
058 Install SQL Server Data Tools SSDT 1bDd gitir
059 Install SSDT Extensions QN7O gitir
Section 3
Implementing and ETL Process with SSIS
060 Introduction to SSIS Aw5q gitir
061 Create a new SSIS Project RYFT gitir
062 Add and configure flat file connection manager adWy gitir
063 Remap column data types 0N0D gitir
064 Add and configure OLE DB Connection manager IW2F gitir
065 Add a data flow task gtvw gitir
066 Add and configure flat file source jR82 gitir
067 Add and configure lookup transformation h29w gitir
068 Add and configure lookup DateKey Transformation Tqc7 gitir
069 Add and configure OLE DB Destination J8d6 gitir
070 Test and run SSIS Package wNCF gitir
072 What is Jupyter Notebook kZQO gitir
Section 4
Python Setup
073 Install Python on Windows CiW8 gitir
074 Install Python on Mac 7QHq gitir
075 Install Jupyter Notebook with Anaconda xf6E gitir
076 Running Jupyter Notebook ICwf gitir
077 Some Jupyter Notebook Commands CRso gitir
078 Jupyter Notebook components qmxk gitir
079 Jupyter Notebook dashboard xN0h gitir
080 Jupyter Notebook Interface pIsv gitir
081 Creating a new Notebook 3D86 gitir
Section 5
Python Basics
082 Python Expressions Lkac gitir
083 Python Statements cLiB gitir
084 Python Code Comments vhEq gitir
085 Python Data Types yCEM gitir
086 Casting Data Types GWgI gitir
087 Python Variables vjbW gitir
088 Python List Zqi9 gitir
089 Python Tuples 1cc5 gitir
090 Python Dictionaries XRHQ gitir
091 Python Operators ib5d gitir
092 Python Conditional Statements 9qNh gitir
093 Python Loops wm51 gitir
094 Python Functions rgTn gitir
Section 6
Data Analysis and Data Visualization with Python
097 The dataset vlnj gitir
098 Tabular Data ovJy gitir
099 Exploring Pandas DataFrame DRkq gitir
100 Manipulating Pandas DataFrame LOXP gitir
101 What is data cleaning uhjx gitir
102 Perform Data cleaning 7gA0 gitir
103 What is data visualization hbKs gitir
104 Visualizing qualitative data mlbQ gitir
105 Visualizing quantitative data My1D gitir
Section 7
Introduction to R
107 Installing R for windows yccu gitir
110 Installing R Studio on Windows stVW gitir
112 Exploring R Studio default interface GMYE gitir
113 Creating a new project in R Studio IRuE gitir
115 How to install Packages Ko9B gitir
117 Loading Packages L8zj gitir
Section 8
Data Analysis and Visualization with R
118 Importing data into R Studio aESB gitir
119 How to read data in a csv file with R 8RtY gitir
120 Installing the Janitor Package vYPw gitir
121 Selecting a subset of the data g1Qv gitir
122 Performing multiple operations using Pipe Operator PTxI gitir
123 Cleaning columns k6rI gitir
124 Creating new columns from existing columns Plw4 gitir
130 Perform Data Wrangling UWbr gitir
131 Create a Scatter Plot xvNN gitir
132 Create a bar graph vL0b gitir
Section 9
Introduction to Power BI
134 Setup Microsoft 365 bDJz gitir
135 Getting started with Microsoft 365 dxuM gitir
136 Adding user to Microsoft 365 xskT gitir
137 Installing Power BI Desktop yUPD gitir
138 Exploring Power BI Interface 8Rd5 gitir
139 Power BI Overview Part 1 ud0o gitir
140 Power BI Overview Part 2 HNCn gitir
141 Power BI Overview Part 3 O7rD gitir
142 Components of Power BI vdv8 gitir
143 Exploring Power BI Service 93mt gitir
Section 10
Data Analysis and Visualization with Power BI
144 Connect to web based data 04yn gitir
145 Clean and transform data Part 1 tt4D gitir
146 Clean and transform data Part 2 KeIV gitir
147 Combining data sources giE4 gitir
148 Creating Visualizations Part 1 V5zY gitir
149 Creating Visualizations Part 2 e7JD gitir
150 Publishing Reports to Power BI Service v0vT gitir
Instructors
Enrolment options
Become a Data Analyst - (ETL, SQL, Power BI, Python,R )
Course modified date:
11 Jan 2025
Enrolled students:
There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Continue
Enrol now
This course includes
Forums
Resources
Share this course
Scroll to top
×
Close
×
Close