-
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathBigquerry-sql.html
More file actions
246 lines (197 loc) · 14.1 KB
/
Bigquerry-sql.html
File metadata and controls
246 lines (197 loc) · 14.1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta content="width=device-width, initial-scale=1.0" name="viewport">
<title>Portfolio Details</title>
<meta content="" name="description">
<meta content="" name="keywords">
<!-- Favicons -->
<link href="assets/img/Favicon-1.png" rel="icon">
<link href="assets/img/Favicon-1.png" rel="apple-touch-icon">
<!-- Google Fonts -->
<link href="https://fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i|Raleway:300,300i,400,400i,500,500i,600,600i,700,700i|Poppins:300,300i,400,400i,500,500i,600,600i,700,700i" rel="stylesheet">
<!-- Vendor CSS Files -->
<link href="assets/vendor/aos/aos.css" rel="stylesheet">
<link href="assets/vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
<link href="assets/vendor/bootstrap-icons/bootstrap-icons.css" rel="stylesheet">
<link href="assets/vendor/boxicons/css/boxicons.min.css" rel="stylesheet">
<link href="assets/vendor/glightbox/css/glightbox.min.css" rel="stylesheet">
<link href="assets/vendor/swiper/swiper-bundle.min.css" rel="stylesheet">
<!-- Creating a python code section-->
<link rel="stylesheet" href="assets/css/prism.css">
<script src="assets/js/prism.js"></script>
<!-- To set the icon, visit https://fontawesome.com/account-->
<script src="https://kit.fontawesome.com/5d25c1efd3.js" crossorigin="anonymous"></script>
<!-- end of icon-->
<!-- Template Main CSS File -->
<link href="assets/css/style.css" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.3/css/all.min.css" integrity="sha384-oGqqFhf3ELCpQk69FVb6jGrwPOTR5SO5FeECBbCFgrFJzVpXJFLHc06dL/iPzCBJe" crossorigin="anonymous">
<!-- =======================================================
* Template Name: iPortfolio
* Updated: Sep 18 2023 with Bootstrap v5.3.2
* Template URL: https://bootstrapmade.com/iportfolio-bootstrap-portfolio-websites-template/
* Author: BootstrapMade.com
* License: https://bootstrapmade.com/license/
======================================================== -->
</head>
<body>
<!-- ======= Mobile nav toggle button ======= -->
<i class="bi bi-list mobile-nav-toggle d-xl-none"></i>
<!-- ======= Header ======= -->
<header id="header">
<div class="d-flex flex-column">
<div class="profile">
<img src="assets/img/myphoto.jpeg" alt="" class="img-fluid rounded-circle">
<h1 class="text-light"><a href="index.html">Arun</a></h1>
<div class="social-links mt-3 text-center">
<a href="https://www.linkedin.com/in/arunp77/" target="_blank" class="linkedin"><i class="bx bxl-linkedin"></i></a>
<a href="https://github.com/arunp77" target="_blank" class="github"><i class="bx bxl-github"></i></a>
<a href="https://twitter.com/arunp77_" target="_blank" class="twitter"><i class="bx bxl-twitter"></i></a>
<a href="https://www.instagram.com/arunp77/" target="_blank" class="instagram"><i class="bx bxl-instagram"></i></a>
<a href="https://arunp77.medium.com/" target="_blank" class="medium"><i class="bx bxl-medium"></i></a>
</div>
</div>
<nav id="navbar" class="nav-menu navbar">
<ul>
<li><a href="index.html#hero" class="nav-link scrollto active"><i class="bx bx-home"></i> <span>Home</span></a></li>
<li><a href="index.html#about" class="nav-link scrollto"><i class="bx bx-user"></i> <span>About</span></a></li>
<li><a href="index.html#resume" class="nav-link scrollto"><i class="bx bx-file-blank"></i> <span>Resume</span></a></li>
<li><a href="index.html#portfolio" class="nav-link scrollto"><i class="bx bx-book-content"></i> <span>Portfolio</span></a></li>
<li><a href="index.html#skills-and-tools" class="nav-link scrollto"><i class="bx bx-wrench"></i> <span>Skills and Tools</span></a></li>
<li><a href="index.html#language" class="nav-link scrollto"><i class="bi bi-menu-up"></i> <span>Languages</span></a></li>
<li><a href="index.html#awards" class="nav-link scrollto"><i class="bi bi-award-fill"></i> <span>Awards</span></a></li>
<li><a href="index.html#professionalcourses" class="nav-link scrollto"><i class="bx bx-book-alt"></i> <span>Professional Certification</span></a></li>
<li><a href="index.html#publications" class="nav-link scrollto"><i class="bx bx-news"></i> <span>Publications</span></a></li>
<!-- <li><a href="index.html#extra-curricular" class="nav-link scrollto"><i class="bx bx-rocket"></i> <span>Extra-Curricular Activities</span></a></li> -->
<!-- <li><a href="#contact" class="nav-link scrollto"><i class="bx bx-envelope"></i> <span>Contact</span></a></li> -->
</ul>
</nav><!-- .nav-menu -->
</div>
</header><!-- End Header -->
<main id="main">
<!-- ======= Breadcrumbs ======= -->
<section id="breadcrumbs" class="breadcrumbs">
<div class="container">
<div class="d-flex justify-content-between align-items-center">
<h2></h2>
<ol>
<li><a href="content-page.html" class="clickable-box">Content section</a></li>
<li><a href="index.html" class="clickable-box">Home</a></li>
</ol>
</div>
</div>
</section><!-- End Breadcrumbs -->
<!------ right dropdown menue ------->
<div class="right-side-list">
<div class="dropdown">
<button class="dropbtn"><strong>Shortcuts:</strong></button>
<div class="dropdown-content">
<ul>
<li><a href="cloud-compute.html"><i class="fas fa-cloud"></i> Cloud</a></li>
<li><a href="AWS-GCP.html"><i class="fas fa-cloud"></i> AWS-GCP</a></li>
<li><a href="amazon-s3.html"><i class="fas fa-cloud"></i> AWS S3</a></li>
<li><a href="ec2-confi.html"><i class="fas fa-server"></i> EC2</a></li>
<li><a href="Docker-Container.html"><i class="fab fa-docker" style="color: rgb(15, 15, 15);"></i> Docker</a></li>
<li><a href="Jupyter-nifi.html"><i class="fab fa-python" style="color: rgb(19, 18, 18);"></i> Jupyter-nifi</a></li>
<li><a href="snowflake-task-stream.html"><i class="fas fa-snowflake"></i> Snowflake</a></li>
<li><a href="data-model.html"><i class="fas fa-database"></i> Data modeling</a></li>
<li><a href="sql-basics.html"><i class="fas fa-table"></i> QL</a></li>
<li><a href="sql-basic-details.html"><i class="fas fa-database"></i> SQL</a></li>
<li><a href="Bigquerry-sql.html"><i class="fas fa-database"></i> Bigquerry</a></li>
<li><a href="scd.html"><i class="fas fa-archive"></i> SCD</a></li>
<li><a href="sql-project.html"><i class="fas fa-database"></i> SQL project</a></li>
<!-- Add more subsections as needed -->
</ul>
</div>
</div>
</div>
<!-- ======= Portfolio Details Section ======= -->
<section id="portfolio-details" class="portfolio-details">
<div class="container">
<div class="row gy-4">
<h1>Cloud Computing: Revolutionizing the Digital Landscape</h1>
<div class="col-lg-8">
<div class="portfolio-details-slider swiper">
<div class="swiper-wrapper align-items-center">
<div class="swiper-slide">
<img src="assets/img/portfolio/google_bigquery_logo.png" alt="" style="max-width: 400px; max-height: 400px;">
</div>
<div class="swiper-slide">
<img src="assets/img/portfolio/google-bigquery-Data-Flow2.png" alt="" style="max-width: 800px; max-height: 600px;">
</div>
</div>
<div class="swiper-pagination"></div>
</div>
</div>
<h3>Introduction</h3>
<p>Google BigQuery is a fully managed, serverless, and highly scalable data warehouse and analytics platform offered by Google Cloud.
It allows organizations to store and analyze massive volumes of data quickly and efficiently. BigQuery also provides features such as
built-in machine learning, geospatial analysis, and business intelligence.</p>
<h3>Key Features</h3>
<ul style="list-style-type: disc; margin-left: 30px;">
<li><strong>Serverless:</strong> BigQuery is a serverless platform, which means users don't have to manage infrastructure or worry about scalability. It automatically handles the allocation of resources as needed.</li>
<li><strong>High Speed:</strong> BigQuery is known for its high-performance query processing. It can analyze large datasets in seconds or minutes, making it suitable for real-time analytics.</li>
<li><strong>SQL Query Language:</strong> Users can write SQL queries to analyze data stored in BigQuery. It supports standard SQL with some extensions for working with nested and repeated data.</li>
<li><strong>Scalability:</strong> BigQuery can scale seamlessly, allowing you to analyze data ranging from gigabytes to petabytes. This makes it suitable for both small-scale and enterprise-level projects.</li>
<li><strong>Integration:</strong> It integrates with various Google Cloud services, making it easy to ingest and export data from and to other Google Cloud products, such as Google Cloud Storage and Google Cloud Dataprep.</li>
<li><strong>Security:</strong> BigQuery provides strong security features, including data encryption at rest and in transit, identity and access management, and auditing capabilities.</li>
<li><strong>Machine Learning:</strong> Google BigQuery ML enables users to build, train, and deploy machine learning models directly within BigQuery.</li>
</ul>
<h3>Use cases</h3>
<ul style="list-style-type: disc; margin-left: 30px;">
<li><strong>Data Analytics:</strong> Organizations use BigQuery to perform data analysis, generate insights, and make data-driven decisions. It's commonly used for business intelligence and reporting.</li>
<li><strong>Real-time Analytics:</strong> BigQuery can handle real-time data streams, making it suitable for monitoring and analyzing live data.</li>
<li><strong>Data Warehousing:</strong> It serves as a cloud-based data warehouse for storing and managing large datasets, offering high-performance querying and analytical capabilities.</li>
<li><strong>Log Analysis:</strong> Many organizations use BigQuery for analyzing logs and events to gain insights into system and application performance.</li>
<li><strong>Predictive Analytics:</strong> With integrated machine learning capabilities, BigQuery enables the development of predictive models to make forecasts and recommendations.</li>
<li><strong>Geospatial Analysis:</strong> BigQuery supports geospatial data types and functions, making it suitable for location-based analysis and mapping.</li>
<li><strong>Market Research:</strong> BigQuery is used for market research and sentiment analysis by analyzing social media data and other online content.</li>
</ul>
<h3>Reference:</h3>
<ul style="margin-left: 30px;">
<li>Visit the <a href="https://www.w3schools.com/postgresql/index.php">"Learn about PostgreSQL"</a></li>
<li>Visit the <a href="https://www.tutorialspoint.com/dbms/index.htm">"DBMS Tutorials page"</a></li>
<li>Visit my <a href="https://github.com/arunp77/SQL">"Github repository on SQL"</a> to learn about basics and some example projects.</li>
<li>Visit my <a href="https://github.com/arunp77/Database-datapipeline-ETL/tree/main/Database">"Github repository"</a> to learn about databases.</li>
</ul>
<div class="navigation">
<a href="index.html" class="clickable-box">
<span class="arrow-left">Go home</span>
</a>
<a href="sql-basics.html" class="clickable-box">
<span class="arrow-right">Go to QL page</span>
</a>
</div>
</div>
</div>
</section><!-- End Portfolio Details Section -->
</main><!-- End #main -->
<!-- ======= Footer ======= -->
<footer id="footer">
<div class="container">
<div class="copyright">
© Copyright <strong><span>Arun</span></strong>
</div>
</div>
</footer><!-- End Footer -->
<a href="#" class="back-to-top d-flex align-items-center justify-content-center"><i class="bi bi-arrow-up-short"></i></a>
<!-- Vendor JS Files -->
<script src="assets/vendor/purecounter/purecounter_vanilla.js"></script>
<script src="assets/vendor/aos/aos.js"></script>
<script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="assets/vendor/glightbox/js/glightbox.min.js"></script>
<script src="assets/vendor/isotope-layout/isotope.pkgd.min.js"></script>
<script src="assets/vendor/swiper/swiper-bundle.min.js"></script>
<script src="assets/vendor/typed.js/typed.umd.js"></script>
<script src="assets/vendor/waypoints/noframework.waypoints.js"></script>
<script src="assets/vendor/php-email-form/validate.js"></script>
<!-- Template Main JS File -->
<script src="assets/js/main.js"></script>
<script>
document.addEventListener("DOMContentLoaded", function () {
hljs.initHighlightingOnLoad();
});
</script>
</body>
</html>