Searching CertSprout…
Searching CertSprout…
A little curiosity goes a long way
Search certifications, learning topics, career paths, public profiles and help across CertSprout.
Showing 20 results · Page 2 for “sql”. More results are available below.
DP-800 · Identity and access
Authentication establishes who or what is requesting access. Authorization decides which actions that identity may perform on a resource. A successful sign-in therefore does not imply permis…
DP-800 · SQL querying
SQL joins determine which rows are combined, filters determine which remain, and aggregation summarizes the result. Confirm the intended grain before calculating a total. Joining one parent …
DP-900 · Describe core data concepts
…er loss because it is written to persistent storage. NoSQL systems sometimes relax these for scale, choosing eventual consistency. When a question describes a partial update being rolled bac…
DP-900 · Describe core data concepts
SQL statements fall into families. Data Definition Language creates and alters objects: CREATE, ALTER, DROP. Data Manipulation Language reads and changes rows: SELECT, INSERT, UPDATE, DELETE…
DP-900 · Identify considerations for relational data on Azure
Azure offers three ways to run SQL Server. Azure SQL Database is fully managed PaaS for individual databases or elastic pools, with automatic patching, backups and high availability but with…
DP-900 · Identify considerations for relational data on Azure
…n open-source relational engines. Azure Database for MySQL and Azure Database for PostgreSQL run the community engines as PaaS with automated backups, patching, scaling and high availability…
DP-900 · Identify considerations for relational data on Azure
…umns users see. A stored procedure is a named block of SQL logic with parameters that runs on the server, reducing network traffic and centralising business rules. An index is a structure, u…
DP-900 · Describe considerations for working with non-relational data on Azure
… can be queried by their fields, as in Cosmos DB for NoSQL or MongoDB. Column-family stores organise sparse data by column groups for wide tables, as in Cassandra or HBase. Graph databases s…
DP-900 · Describe considerations for working with non-relational data on Azure
…e Cosmos DB is a fully managed, globally distributed NoSQL database with single-digit millisecond latency backed by SLAs. It exposes several APIs so existing applications can move without re…
DP-900 · Describe considerations for working with non-relational data on Azure
…a network drive. Table Storage is a simple key-value NoSQL store with partition and row keys. Queue Storage holds messages for decoupling application components. Redundancy options range fro…
DP-900 · Describe an analytics workload on Azure
…lytics unifies data integration pipelines, a dedicated SQL pool for enterprise warehousing, serverless SQL for querying lake files, and Apache Spark pools, all inside Synapse Studio. Azure D…
DP-900 · Describe an analytics workload on Azure
…tional control. Azure Stream Analytics runs continuous SQL-like queries over those streams with windowing functions such as tumbling and sliding windows, and writes results to Power BI, Cosm…
DP-900 · Describe an analytics workload on Azure
…timised for reporting, with strong governance and fast SQL. A data lake stores raw data of any type cheaply in object storage with schema applied on read, ideal for exploration and machine l…
DataSys+ · SQL querying
SQL joins determine which rows are combined, filters determine which remain, and aggregation summarizes the result. Confirm the intended grain before calculating a total. Joining one parent …
GCP-ADP · Google Cloud data pipelines
…ords. Worked example A team needs a managed analytical SQL warehouse on Google Cloud. Which service fits? BigQuery BigQuery is designed for managed analytical querying rather than network pr…
GCP-CDL · Exploring data transformation with Google Cloud
… bytes stored and bytes scanned. Analysts use standard SQL, and BigQuery ML lets them build models with SQL alone. It integrates with Looker for dashboards, Dataflow for pipelines and Pub/Su…
GCP-CDL · Exploring data transformation with Google Cloud
Cloud SQL is managed MySQL, PostgreSQL or SQL Server for conventional relational apps within a region. Cloud Spanner is a relational database that scales horizontally across regions with str…
GCP-CDL · Modernize infrastructure and applications with Google Cloud
…ges such as swapping a self-managed database for Cloud SQL. Refactor or re-architect rewrites for cloud-native patterns like containers and microservices, delivering the most benefit at the …
GCP-PDBE · Google Cloud data pipelines
…ords. Worked example A team needs a managed analytical SQL warehouse on Google Cloud. Which service fits? BigQuery BigQuery is designed for managed analytical querying rather than network pr…
GCP-PDE · Google Cloud data pipelines
…ords. Worked example A team needs a managed analytical SQL warehouse on Google Cloud. Which service fits? BigQuery BigQuery is designed for managed analytical querying rather than network pr…
People search uses public names, handles and headlines. Private and unlisted profiles are excluded. Your goals are visible only to you in search.