- 8
- 5 975
Indo-RNO
เข้าร่วมเมื่อ 16 ก.ย. 2023
Indonesian Radio Network Optimization (RNO) Consultant Community
Create AWS Cloud Database Server using MySQL/Aurora and Connect it to MySQL Workbench
Speaker:
Aldindha Octa Airlangga
Login to AWS:
aws.amazon.com/
Download MySQL Workbench 8.0.36:
downloads.mysql.com/archives/workbench/
Create Read-Only User:
CREATE USER 'angga'@'%' IDENTIFIED BY 'angga123';
GRANT SELECT ON *.* TO 'angga'@'%';
FLUSH PRIVILEGES;
Check all users:
SELECT user, host FROM mysql.user;
Check the privilege of a user:
SHOW GRANTS FOR 'read_only_user'@'%';
Disable safe mode to delete rows:
SET SQL_SAFE_UPDATES = 0;
Timestamp:
00:00 Opening
01:25 Select MySQL Workbench version 8.0.36
02:28 Login to AWS
03:49 Install MySQL Workbench
04:17 Using RDS service
04:35 Create and Setting AWS MySQL
08:40 Create and Setting AWS Aurora
09:23 Setting Inbound Rule
10:20 Connect MySQL Workbench to AWS MySQL
11:25 Create Database and Tables
13:28 Create Read-Only user
18:17 Connect MySQL Workbench to AWS Aurora
20:35 Check Billing and Cost
21:24 Delete RDS Instances
Aldindha Octa Airlangga
Login to AWS:
aws.amazon.com/
Download MySQL Workbench 8.0.36:
downloads.mysql.com/archives/workbench/
Create Read-Only User:
CREATE USER 'angga'@'%' IDENTIFIED BY 'angga123';
GRANT SELECT ON *.* TO 'angga'@'%';
FLUSH PRIVILEGES;
Check all users:
SELECT user, host FROM mysql.user;
Check the privilege of a user:
SHOW GRANTS FOR 'read_only_user'@'%';
Disable safe mode to delete rows:
SET SQL_SAFE_UPDATES = 0;
Timestamp:
00:00 Opening
01:25 Select MySQL Workbench version 8.0.36
02:28 Login to AWS
03:49 Install MySQL Workbench
04:17 Using RDS service
04:35 Create and Setting AWS MySQL
08:40 Create and Setting AWS Aurora
09:23 Setting Inbound Rule
10:20 Connect MySQL Workbench to AWS MySQL
11:25 Create Database and Tables
13:28 Create Read-Only user
18:17 Connect MySQL Workbench to AWS Aurora
20:35 Check Billing and Cost
21:24 Delete RDS Instances
มุมมอง: 155
วีดีโอ
Calculate Inter-Site Distance (ISD) with consider Azimuth Direction using QGIS and Python
มุมมอง 4353 หลายเดือนก่อน
Speaker: Aldindha Octa Airlangga Article by Ridho Bustami: www.linkedin.com/pulse/nearest-neigbor-calculation-pygis-ridho-bustami-6sswf/?trackingId=v6c2gYGQ5Rk1DDadROxygQ Code: github.com/aldindha/QGIS/blob/main/ISD Cell to Site by Azimuth and Beamwidth.py Raw Data: github.com/aldindha/QGIS/blob/main/ISD Cell to Site by Azimuth and Beamwidth - RAW.zip Timestamp: 00:00 Article 02:14 CSV Template...
Python Basic for Excel/CSV File Analysis and AI Leverage
มุมมอง 5854 หลายเดือนก่อน
Speaker: Aldindha Octa Airlangga Code: github.com/aldindha/Python/blob/main/RNO.ipynb Raw Data: 1drv.ms/f/s!Ari-fJDiX6PzkZ8gVKGtPHXm4UgC4w?e=unb0eh Timestamp: 00:00:00 Create Python File 00:00:39 Import Pandas 00:02:22 Import Excel File 00:04:41 Add Comment 00:05:35 Remove Duplicates 00:07:10 See top 50 rows 00:08:08 Set Maximum Display of Rows 00:09:08 Observe Columns 00:12:27 Check Distinct V...
Bongkar Rahasia Kontrak Kerja bersama R. Sosuharon W. Nababan, S.H.,CLA
มุมมอง 1954 หลายเดือนก่อน
Speaker: R. Sosuharon W. Nababan, S.H.,CLA Host: Aldindha Octa Airlangga and Bennie Ferdiansyah Dihadiri oleh pakar hukum sebagai narasumber untuk mengupas tuntas apa-apa saja yang perlu diperhatikan ketika calon karyawan hendak menyetujui sebuah kontrak kerja. Lindungi hakmu sebelum terlambat!
SQL and Python Installation for Data Analyst
มุมมอง 3704 หลายเดือนก่อน
Speaker: Aldindha Octa Airlangga SQL Server: www.microsoft.com/en-us/sql-server/sql-server-downloads SSMS: learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms Access Database Engine 32 Bit: www.microsoft.com/en-us/download/details.aspx?id=54920 Visual Studio Code: code.visualstudio.com/download Python Libraries/Modules: pip install pandas pip install requests pip insta...
Power BI Basic Tutorial Bahasa Indonesia - Part 2
มุมมอง 2957 หลายเดือนก่อน
Technical sharing session by Indo-RNO community Part 2 Topic: Power BI Basic Tutorial Speaker: Aldindha Octa Airlangga 1. Download and Install Power BI and Plugins: www.microsoft.com/en-us/download/details.aspx?id=58494 daxstudio.org/downloads/ www.datavizioner.com/power-bi-exporter 2. Download Link for Materials: 1drv.ms/f/s!Ari-fJDiX6PzkPtfsLbOir4zgPcxTw?e=x3fBq1 3. Download Link for Tutorial...
Power BI Basic Tutorial Bahasa Indonesia - Part 1
มุมมอง 1.1K7 หลายเดือนก่อน
Technical sharing session by Indo-RNO community Part 1 Topic: Power BI Basic Tutorial Speaker: Aldindha Octa Airlangga 1. Download and Install Power BI and Plugins: www.microsoft.com/en-us/download/details.aspx?id=58494 daxstudio.org/downloads/ www.datavizioner.com/power-bi-exporter 2. Download Link for Materials: 1drv.ms/f/s!Ari-fJDiX6PzkPtfsLbOir4zgPcxTw?e=x3fBq1 3. Download Link for Tutorial...
QGIS Basic Tutorial Bahasa Indonesia
มุมมอง 2.9Kปีที่แล้ว
1st sharing session by Indo-RNO community Topic: QGIS Basic Tutorial Speaker: Aldindha Octa Airlangga QGIS Version: 3.16.14 - Hannover Download Materials: 1drv.ms/f/s!Ari-fJDiX6PzjdtKNf54-7SDyoJYrw Download Tutorial Update: 1drv.ms/f/s!Ari-fJDiX6PzjdtLtgAu9ZPRvZO3Hw Download QGIS Version: ftp.osuosl.org/pub/osgeo/download/qgis/windows/QGIS-OSGeo4W-3.16.14-1.msi Timestamp: 00:00 Introduction 04:...
luar biasa, makasih ilmu nya
tengkyu om ilmunya, otw migrasi mapinfo ke QGIS
mantap om
barakallah tutorial nya om, semoga tutorial nya berkelanjutan
Keren omku 🔥
thanks pak ilmumya
Thanks om Al..semoga bermanfaat buat smua ,di lancarkan rejeki y. Amin
Code: github.com/aldindha/Python/blob/main/RNO.ipynb Raw Data: 1drv.ms/f/s!Ari-fJDiX6PzkZ8gVKGtPHXm4UgC4w?e=unb0eh
Jazakallah khiran sharingnya & semoga ilmunya makin berkah serta rejeki makin melimpah.. aamiin
Timestamp: 00:00 Formatting Visual 02:07 Slicer 05:03 Filter 06:04 Filter Top N 08:25 Add Title Dynamically 09:45 Add Constant Line Dynamically 16:51 Edit Interactions 21:10 Basic Mapping 23:46 Heatmap 24:53 Bubble Map 26:26 Filled Map 29:30 Custom Map with Shapefile (SHP) 35:30 Power BI and Premium Feature 36:25 Publish to Web 41:00 Get More Visuals
Timestamp: 00:00:00 Opening 00:02:50 Why Learn Data Analytics 00:07:03 BI Tools 00:10:00 Why Power BI 00:11:04 Disclaimer 00:12:38 Installation 00:13:10 Basic Principle 00:23:55 Get Data Excel 00:25:10 User First Row as Headers 00:26:10 Get Data CSV 00:27:00 Remove Top Rows 00:30:18 Remove Bottom Rows 00:31:46 Replace Values 00:32:33 Split Column 00:36:02 Split Column by Multi Delimiter 00:37:50 Remove Columns 00:40:28 Copying Steps 00:43:51 Get Data Excel 00:46:00 Get Data Folder 00:50:05 Get Data SQL 00:54:30 Get Data Google Sheets 00:55:50 Get Data Web 00:58:06 Fill Down 00:59:42 Enter Table Manually 01:12:50 Split Column 01:21:24 Load SQL Query as Table 01:25:07 Import vs DirectQuery 01:28:42 Change Data Source 01:29:14 Merge Columns 01:30:30 Search Column 01:31:14 Extract 01:34:12 Append Table 01:38:50 Merge Table 01:41:40 Join Table Concept 01:51:37 Conditional Column - IF THEN ELSE 01:54:27 Calculated Column - Custom Column 01:55:25 Extract Date and Time 01:58:00 Format Column Text 01:59:20 Group By 02:04:27 Pivot Column - Unpivot Column 02:10:40 Time Efficiency - Duplicate, Reference, Disable Load 02:14:46 Error Handling 02:16:56 Advanced Editor 02:19:23 Overview of Canvas, Table view, Model view 02:20:00 Insert Shape 02:22:00 Enter Table Manually 02:23:00 Add New Column 02:25:01 Join Table and RELATED/VLOOKUP 02:29:27 DAX Basic Concept 02:31:35 DAX Calculate SUM 02:38:20 DAX Calculate First Non Blank 02:45:23 DAX FILTER 02:48:14 DAX Studio 02:50:30 Add New Measure NUM DENUM 02:54:20 DAX Benchmark 02:57:40 Change Format of Column 02:58:37 DAX Calendar 02:59:23 DAX Cumulative 03:02:10 DAX Progress Tracker 03:04:46 Sorting Column for Canvas 03:05:46 Don't summarize 03:08:29 Frequent Used Visuals 03:08:36 Area Chart 03:10:45 Stacked Bar Chart 03:12:17 Treemap 03:13:45 Change Canvas Setting 03:14:17 Fit to Width 03:14:27 Line Chart 03:15:28 Change data type 03:17:34 Column Chart 03:19:10 Pie Chart 03:20:45 Scatter Chart 2D 03:23:56 Add Constant Line 03:28:12 Add Text 03:29:20 Gauge 03:30:05 KPI 03:37:42 Scatter Chart 3D 03:48:36 Matrix 03:50:26 Conditional Formatting Color 03:51:45 Ribbon Chart 03:52:10 Copy Visual 03:54:26 Formatting Visual
Barokallah mas sharing knowledge dan waktunya, lanjutkan mas :)
Asli bagus banget ini om makasih untuk sharing ilmunya, mungkin kalau ada training online or offline saya bisa di share linknya
mantap om, apakah di Qgis bisa membuat spiderline relasi neighbour om ? misal klo dimapinfo pake tools comMon
Bisa cek spidergraph di tutorial pdf terbaru. Linknya ada di pinned comment.
siap terimakasih banyak om@@Indo-RNO
Appreciate Detail skali summary materinya 🙏🙏
Terima kasih buat om" kontributor...smoga bermanfaat buat temen" smua
makasih tutorialnya, sangat membantu
haturnuhun om Aldindha,, sempet lihat di awal slide ada hadist ""When a man dies, his deeds come to an end except for three things: ceaseless charity, a knowledge which is beneficial, and a pious son who prays for him (for the deceased)."" , semoga mendapatkan pahala yg terus mengalir, melalui "Ilmu yg bermanfaat" yg sudah dibagikan ini..
Download Link for Materials: 1drv.ms/f/s!Ari-fJDiX6PzjdtKNf54-7SDyoJYrw Download Link for Tutorial Update: 1drv.ms/f/s!Ari-fJDiX6PzjdtLtgAu9ZPRvZO3Hw
maaf om, kok kosong ya ga ada file tutorial nya
@@suhariseputra7969 sign in dulu pake akun microsoft mas. Atau bisa lewat link berikut. drive.google.com/file/d/1jjHOUU85WI0GoxChul5zLV1JsZ1mwHIk/view?usp=sharing
Dangke banyak Om Al.
Hatur nuhun pak Aldindha Octa Airlangga