IT Career Guides & Free Resources
Expert roadmaps, tutorials, salary guides and interview prep across Data Science, Generative AI, Python, Cloud & Analytics — written by GloryTecks trainers in Hyderabad.
All articles
Scheduling Queries in BigQuery
A scheduled query is SQL that BigQuery runs for you on a timetable. This guide covers the run parameters, destination table templates checked against Google's own examples, backfills, credentials and notifications, and shows on real data why an appending statement doubles on a rerun while a MERGE does not.
Athena Federated Queries Explained
Athena Federated Query lets one SQL statement read from sources outside S3, such as DynamoDB, MySQL or Redshift, and join them with data lake tables. This guide explains connectors, predicate pushdown, passthrough queries, the documented limits, how billing works, and when copying the data is the better design.
SQL for Data Analysts: The Queries You Need Daily
The SQL an analyst writes every day, each query run on a real sample database: profiling a table before trusting it, reconciling totals, monthly reports that keep empty months, share of total with a window, period-over-period change with LAG, new versus returning customers and the latest record per customer.
SQL for Data Science: Queries Every Data Scientist Must Know
The SQL queries data scientists write every week, each run on a real sample database with its output: joining and aggregating, the join fan-out that inflated revenue ninefold, finding what is missing with an anti-join, CTEs and window functions for running totals and top-N per group, and counting around NULLs.
BigQuery Federated Queries Explained
A federated query lets BigQuery ask a live operational database a question and join the answer to warehouse tables, with no pipeline in between. This guide explains EXTERNAL_QUERY, shows on a sample database how much pushdown saves and where it stops, and covers connections, pricing, regions and when to replicate.