BigQuery Tutorial for Beginners | Google BigQuery Tutorial

Поділитися
Вставка
  • Опубліковано 12 лис 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

КОМЕНТАРІ • 56

  • @sogaita
    @sogaita 11 місяців тому +11

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

    • @vidivacademy
      @vidivacademy  11 місяців тому

      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 2 місяці тому +1

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

    • @vidivacademy
      @vidivacademy  2 місяці тому

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

  • @harshkumargupta1348
    @harshkumargupta1348 7 місяців тому +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  7 місяців тому +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..!!

  • @sumitborkar111
    @sumitborkar111 17 днів тому

    Great video !!

    • @vidivacademy
      @vidivacademy  17 днів тому

      Thanks for watching this video. If you found this helpful, consider subscribing for more content like this!

  • @rashmiyadav1973
    @rashmiyadav1973 5 місяців тому

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

    • @vidivacademy
      @vidivacademy  5 місяців тому

      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 3 місяці тому

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

    • @vidivacademy
      @vidivacademy  3 місяці тому

      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!

  • @albertosoto10
    @albertosoto10 4 місяці тому

    What a great video! Thanks!

    • @vidivacademy
      @vidivacademy  4 місяці тому

      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.

  • @VinodKumar-gv7cm
    @VinodKumar-gv7cm Місяць тому

    Great job 👍

    • @vidivacademy
      @vidivacademy  Місяць тому

      Hi Vinod, thanks for watching this video. If you found this helpful, consider subscribing for more content like this!

  • @KaushikMitra-g2u
    @KaushikMitra-g2u 10 місяців тому

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

    • @vidivacademy
      @vidivacademy  10 місяців тому

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

  • @Call_me_Parry
    @Call_me_Parry 3 місяці тому

    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  3 місяці тому +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 👍

  • @kevinrambo
    @kevinrambo 7 місяців тому

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

    • @vidivacademy
      @vidivacademy  7 місяців тому

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

  • @satyakalad
    @satyakalad 6 місяців тому +1

    Thanks for this Video

    • @vidivacademy
      @vidivacademy  6 місяців тому

      Thanks Satyakala for watching this video!

  • @prasannakumar7097
    @prasannakumar7097 6 місяців тому +1

    Nice video on BQ. Please do more videos on BQ

    • @vidivacademy
      @vidivacademy  6 місяців тому

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

  • @anuradhasinghsheoran374
    @anuradhasinghsheoran374 6 місяців тому

    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  6 місяців тому +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.

  • @reshmamurugesan9489
    @reshmamurugesan9489 Рік тому

    Thanks for this video.Very useful

    • @vidivacademy
      @vidivacademy  Рік тому

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

  • @vandananarale5802
    @vandananarale5802 8 місяців тому

    Thanks a lot ❤

    • @vidivacademy
      @vidivacademy  8 місяців тому

      Thanks for watching this video Vandana..!!

  • @-Gunashekhar
    @-Gunashekhar Місяць тому

    Thanks bro

    • @vidivacademy
      @vidivacademy  Місяць тому

      Hi Gunashekhar, thanks for watching this video. If you found this helpful, consider subscribing for more content like this!

  • @vasub4540
    @vasub4540 3 місяці тому

    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  3 місяці тому

      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 3 місяці тому

      @@vidivacademy thanks for your response

  • @m.v-135
    @m.v-135 Рік тому

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

    • @vidivacademy
      @vidivacademy  Рік тому

      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 Рік тому

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

  • @TMerritt2024
    @TMerritt2024 25 днів тому

    🎉🎉🎉🎉🎊

    • @vidivacademy
      @vidivacademy  22 дні тому

      thanks for watching this video. If you found this helpful, consider subscribing for more content like this!

  • @PrashantNadavinamani
    @PrashantNadavinamani 4 місяці тому

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

    • @vidivacademy
      @vidivacademy  4 місяці тому

      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  4 місяці тому

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

    • @PrashantNadavinamani
      @PrashantNadavinamani 4 місяці тому

      @@vidivacademy Got it Thank you

    • @vidivacademy
      @vidivacademy  4 місяці тому

      @PrashantNadavinamani no problem

  • @lokeshjindal6448
    @lokeshjindal6448 3 місяці тому

    👏👏👏👏👏👏👏👏👏👏

    • @vidivacademy
      @vidivacademy  3 місяці тому

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

  • @chandanpatra1053
    @chandanpatra1053 3 місяці тому

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

    • @vidivacademy
      @vidivacademy  3 місяці тому

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

    • @chandanpatra1053
      @chandanpatra1053 3 місяці тому

      @@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  3 місяці тому

      @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  3 місяці тому

      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.

  • @verakum2341
    @verakum2341 Рік тому

    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  11 місяців тому

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