BigQuery Tutorial for Beginners | Google BigQuery Tutorial

แชร์
ฝัง
  • เผยแพร่เมื่อ 3 ต.ค. 2024
  • 2023 Latest BigQuery Tutorial for Beginners.
    If you are a beginner in GCP and wondering how to learn Google BigQuery then this video is for you. This Google BigQuery Tutorial will teach you everything about the BigQuery that a GCP Developer should know.
    BigQuery Documentation:
    cloud.google.c...
    Amazon Redshift Migration Documentation:
    cloud.google.c...
    *************** Announcement ***************
    If you are interested in 1:1 coaching in English or Hindi then I can provide you and I can assure you that you'll learn more than any coaching Institutes and that with a minimal cost.
    Drop me an email at vidivacademy@gmail.com for more details.
    --------------------------- ViDiv Academy -------------------------
    Thank you so much for watching this video. Don't forget to explore more interesting playlists on my channel.
    Keep Learning & Keep Sharing..!!
    ------------------------------------------------------------------------------
    Topics Covered:-
    Create dataset in BigQuery
    Create tables in BigQuery
    Save Results in BigQuery
    Save Views in BigQuery
    How to create views in BigQuery
    Explore Data in BigQuery
    How to translate any SQL Query into BigQuery Query
    How to format Query in BigQuery
    How to Export Data in BigQuery
    How to import data in BigQuery
    How to track fetched queries in BigQuery
    ------------------------------------------------------------------------------
    Tags:-
    bigquery, data warehouse, serverless, big query, google bigquery, google big query, big query google, google cloud bigquery, aws redshift, gcp bigquery, snowflake data warehouse, amazon redshift, google cloud big query, bigquery free, data lake house, aws serverless, bigquery pricing, data warehouse architecture, gcp big query, snowflake db, bigquery console, cloud, serverless framework, edw, dwh, cloud data warehouse, snowflake architecture, google cloud platform bigquery, data warehouse tools, bigquery cloud, bigquery gcp, snowflake cost, big query free, big query google analytics, snowflake aws, segment data warehouse, bigquery data warehouse, azure serverless, data vault modeling, bigquery cost, enterprise data warehouse, big query pricing, google analytics to bigquery, bigquery sandbox, oracle data warehouse, google bigquery pricing, gcp serverless, the data warehouse toolkit, aws serverless services, data warehouse solutions, serverless postgres, big query google cloud, google bigquery console, data warehouse design, big query gcp, google bigquery free, cloud based data warehouse, modern data warehouse architecture, kimball data warehouse, data lake and data warehouse, azure datawarehouse, bigquery download, warehouse tables, amazon data warehouse, google cloud serverless, data lake data warehouse, datawarehousing, microsoft data warehouse, cloud big query, data warehouse toolkit, data lake house architecture, big query costs, databricks sql warehouse, google data warehouse, serverless mysql, free bigquery, bigquery free account, azure data warehouse architecture, data vault architecture, google big query free, aws data warehouse architecture, bigquery google cloud platform, gartner data warehouse, redshift serverless, oracle adw, big query console, firebase bigquery, google bigquery data warehouse, BigQuery tutorial for beginners, BigQuery Tutorial, How to Load Data into BigQuery, How to Insert rows in BigQuery tables, Loading Data into BigQuery, Best way to insert data into a Bigquery table, Storing Data with BigQuery's INSERT INTO Syntax, Data manipulation language (DML) statements in BigQuery, Dml statements in bigquery, What is BigQuery ?, How to get started with BigQuery, Google BigQuery Tutorial, Analyze Data in BigQuery, Google Cloud Platform, Google BigQuery Tutorial, Google BigQuery Tutorial for beginners, Google Big Query Full Tutorial 2024, Create Temporary Table to Store the Result in BigQuery, Introduction to BigQuery in hindi, Partitioning and Clustering in Google BigQuery for beginners, GCP Big Query, GCP BigQuery Tutorial, Create datasets and tables using different options in BigQuery, GCP tutorial for beginners, GCP Services, GCP tutorial, google data warehouse, big query, bigquery tutorial, bigquery, bigquery tutorial, bigquery, big query, google bigquery, gcp bigquery, google big query, gcp tutorial for beginners, google bigquery tutorial, big query tutorial, gcp big query, what is bigquery, bigquery gcp, gcp bigquery tutorial, bigquery sql, bigquery google, bigquery interview questions, bigquery project, gcp, how to use bigquery, google cloud big query, what is big query, bigquery for beginners, google cloud, google cloud platform tutorial, big query gcp, big query google, bigquery architecture, bigquery course, bigquery in gcp, google cloud bigquery, big query ml, bigquery api, bigquery full course, bigquery studio, cloud functions gcp, cloud sql, data analysis, data operations, data warehouse concepts

ความคิดเห็น •

  • @sogaita
    @sogaita 10 หลายเดือนก่อน +7

    Man, that's the reason why Indians are so nice to work with. Many thanks for sharing this.

    • @vidivacademy
      @vidivacademy  10 หลายเดือนก่อน

      Hi Raphael,
      Thank you so much for your kind words! I'm glad to hear that you've had positive experiences working with Indians.
      Thanks for watching this video..!!

  • @ShobhaPoojariM
    @ShobhaPoojariM หลายเดือนก่อน +1

    Amazing. I never forget this. Many many thanks from me 😊

    • @vidivacademy
      @vidivacademy  28 วันที่ผ่านมา

      Thanks for watching this video and I'm glad you found it helpful. If you enjoyed it, consider subscribing for more content like this!

  • @anuradhasinghsheoran374
    @anuradhasinghsheoran374 4 หลายเดือนก่อน +1

    Hey brother, what a wonderful video. It was super easy to learn bigQuery because of you. Thank you very much! I am certainly subscribing to your channel today and look forward to exploring more content. Additionally, can you kindly cover Looker as well? It would be super helpful. Thank you again!

    • @vidivacademy
      @vidivacademy  4 หลายเดือนก่อน +1

      Thanks Anuradha for your kind words. I'm glad that this video helped you. Thanks for subscribing to my channel and yeah sure I'll try to upload the Looker Studio tutorial as well. In the meantime, you can check out my Azure DE playlist.

  • @harshkumargupta1348
    @harshkumargupta1348 6 หลายเดือนก่อน +1

    Kya bhai... kya sikhate ho....
    Dil chu liya... i never thought that BigQuery will be this easy 👌👌
    Keep up with the great work and your explanation is fabulous.

    • @vidivacademy
      @vidivacademy  6 หลายเดือนก่อน +1

      Hi Harsh, thank you so much for your kind words. Bht khusi milti hai aise comments padh kar, motivation milti hai aage aur video bnane ki. Thank you for watching this video..!!

  • @-Gunashekhar
    @-Gunashekhar 10 วันที่ผ่านมา

    Thanks bro

  • @rashmiyadav1973
    @rashmiyadav1973 4 หลายเดือนก่อน

    explained this BigQuery in a very simple and easy to understand way. Thanks a lot :)

    • @vidivacademy
      @vidivacademy  4 หลายเดือนก่อน

      Thank you so much for your kind words! Glad you found it helpful. If you enjoyed it, consider subscribing for more content like this.

  • @ravitiwarirt9020
    @ravitiwarirt9020 หลายเดือนก่อน

    its a great video for learn about the big query very clearly explain the every topics , thanks🙏🙏

    • @vidivacademy
      @vidivacademy  หลายเดือนก่อน

      Thanks Ravi for watching this video and I'm glad you found it helpful. If you enjoyed it, consider subscribing for more content like this!

  • @Call_me_Parry
    @Call_me_Parry หลายเดือนก่อน

    very curious to learn Big Query, office meinc kuch colleagues ko aata hai...khud pe sharm aati hai...but have no confidence that I can learn that....biggest reason is my concentration and programming etc se dar lagta hai...will definitely watch and try to understand this vid....whats amazing I noticed is your reply to each msg....

    • @vidivacademy
      @vidivacademy  หลายเดือนก่อน +1

      Thanks for watching this video and don't worry bro, work hard and be consistent nd dekhna ek din tm v ek achhe developer bn jaoge. Daily practise kro jo v chiz sikhna chahte ho life me. Aaj se hi promise kro khud se ki daily atleast 1hr coding kroge chahe kuchh v ho jaye nd believe me you'll see a big change in yourself. Nothing is hard, just believe in yourself and start implementing now 👍

  • @albertosoto10
    @albertosoto10 2 หลายเดือนก่อน

    What a great video! Thanks!

    • @vidivacademy
      @vidivacademy  2 หลายเดือนก่อน

      Thank you so much Alberto for your kind words! Glad you found it helpful. If you enjoyed it, consider subscribing for more content like this.

  • @kevinrambo
    @kevinrambo 6 หลายเดือนก่อน

    Thank you for posting this, it was very helpful. Very well done.

    • @vidivacademy
      @vidivacademy  6 หลายเดือนก่อน

      Thanks Kevin for watching this video. I'm glad that you found this video helpful.

  • @satyakalad
    @satyakalad 4 หลายเดือนก่อน +1

    Thanks for this Video

    • @vidivacademy
      @vidivacademy  4 หลายเดือนก่อน

      Thanks Satyakala for watching this video!

  • @prasannakumar7097
    @prasannakumar7097 4 หลายเดือนก่อน +1

    Nice video on BQ. Please do more videos on BQ

    • @vidivacademy
      @vidivacademy  4 หลายเดือนก่อน

      Sure Prasanna, will try to make more videos on BigQuery. And thanks for watching this video!

  • @KaushikMitra-g2u
    @KaushikMitra-g2u 9 หลายเดือนก่อน

    Very nice explanation. Keep up the good work !!!

    • @vidivacademy
      @vidivacademy  9 หลายเดือนก่อน

      Thank you Kaushik for watching this video..!! And also thanks for your kind words 😊

  • @reshmamurugesan9489
    @reshmamurugesan9489 11 หลายเดือนก่อน

    Thanks for this video.Very useful

    • @vidivacademy
      @vidivacademy  11 หลายเดือนก่อน

      Thank you Reshma for watching this video..!! Do visit my channel for more informative videos.

  • @vandananarale5802
    @vandananarale5802 7 หลายเดือนก่อน

    Thanks a lot ❤

    • @vidivacademy
      @vidivacademy  7 หลายเดือนก่อน

      Thanks for watching this video Vandana..!!

  • @vasub4540
    @vasub4540 2 หลายเดือนก่อน

    Hello sir,
    Just had one question i am using bigquery in my java web application can i have sollution to write junit on mocking bigquery?

    • @vidivacademy
      @vidivacademy  2 หลายเดือนก่อน

      Hello Vasu,
      I never tried this but I think you can do this task using Mockito. Also you can go through this blog
      groups.google.com/g/google-appengine-go/c/UQn1MuXQK20

    • @vasub4540
      @vasub4540 2 หลายเดือนก่อน

      @@vidivacademy thanks for your response

  • @chandanpatra1053
    @chandanpatra1053 2 หลายเดือนก่อน

    your tutorial started without knowing a tool architecture. How can this be possible?

    • @vidivacademy
      @vidivacademy  2 หลายเดือนก่อน

      O is it...why don't you take my paid course where I'll cover all the things including the architecture!

    • @chandanpatra1053
      @chandanpatra1053 2 หลายเดือนก่อน

      @@vidivacademy then you should directly say in the starting of the video that I am not going to teach everything like architecture. If you want you can take my paid courses. Why you need someone else comment to say this? Don't you have guts. Don't talk like a politician.

    • @vidivacademy
      @vidivacademy  2 หลายเดือนก่อน

      @chandanpatra1053 Dude mind your language and don't behave as an illiterate person. Don't expect it for free from anyone. Instead of embracing the free course you are just commenting nonsense thing. You can never grow in your life. Read other's comments as well and don't act as a Stupid guy.

    • @vidivacademy
      @vidivacademy  2 หลายเดือนก่อน

      We're not forcing you to watch this video. You watched because you wanted to watch. If you're getting some free knowledge then you should appreciate it. This is what our teachers teaches us unfortunately I think you might have not attended the school and treating as an illiterate person. Even illiterate persons are better than you as they always says Thank you nd all.

  • @PrashantNadavinamani
    @PrashantNadavinamani 3 หลายเดือนก่อน

    Is it possible to download data exceeding 50GB from BigQuery to Excel?

    • @vidivacademy
      @vidivacademy  3 หลายเดือนก่อน

      Ideally, the maximum size of output file is 500 MB. But, you can export up to 1 GB of table data to a single file. To export more than 1 GB of data, you can use a wildcard to export the data into multiple files. When you export data to multiple files, the size of the files varies. In some cases, the size of the output files is more than 1 GB.
      Also if I talk about Google Sheets, then a maximum of 10,000 rows of data can be extracted from BigQuery into Google Sheets.

    • @vidivacademy
      @vidivacademy  3 หลายเดือนก่อน

      So, the simple answer is no as per my knowledge.

    • @PrashantNadavinamani
      @PrashantNadavinamani 3 หลายเดือนก่อน

      @@vidivacademy Got it Thank you

    • @vidivacademy
      @vidivacademy  3 หลายเดือนก่อน

      @PrashantNadavinamani no problem

  • @m.v-135
    @m.v-135 11 หลายเดือนก่อน

    Hi, i would like to know whether big query and plx script both r same?

    • @vidivacademy
      @vidivacademy  11 หลายเดือนก่อน

      Hi Niharika,
      BigQuery is a Data Warehouse which is used to store the data (current & historical data) where plx script is a module which helps to improve python portability which means if you write your python Program on windows then you can run the same program on Linux or Mac OS and vice-versa.
      So, both are different. Hope this answers your question.
      Thanks for watching this video.
      Do visit my channel for more informative videos.!

    • @m.v-135
      @m.v-135 11 หลายเดือนก่อน

      Thanks.! But I am unable to write a group by query in plx script. The syntax is different when compared to my sql.

  • @lokeshjindal6448
    @lokeshjindal6448 หลายเดือนก่อน

    👏👏👏👏👏👏👏👏👏👏

    • @vidivacademy
      @vidivacademy  หลายเดือนก่อน

      Hi Lokesh, thanks for watching this video. If you enjoyed it, consider subscribing for more content like this!

  • @verakum2341
    @verakum2341 10 หลายเดือนก่อน

    Hi Thanks for these videos, Can I write Geo quereies like distance between two co-ordianartes etc, Have you written any such so far?

    • @vidivacademy
      @vidivacademy  10 หลายเดือนก่อน

      Hi Vera, thanks for watching this video. No, I've not written such queries so far.