- Azure Data Fundamentals: Explore core data concepts
- Explore roles and responsibilities in the world of data
- Describe concepts of relational data
- Explore concepts of non-relational data
- [Explore concepts of data analytics ](https://docs.microsoft.com/en-us/learn/modules/explore-concepts-of-data-analytics/?ns-enrollment-type=LearningPath&ns-enrollment-id=learn.wwl.azure-data-fundamentals-
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create TABLE #hierarchy | |
( | |
element_id INT IDENTITY(1, 1) NOT NULL, /* internal surrogate primary key gives the order of parsing and the list order */ | |
parent_ID INT,/* if the element has a parent then it is in this column. The document is the ultimate parent, so you can get the structure from recursing from the document */ | |
Object_ID INT,/* each list or object has an object id. This ties all elements to a parent. Lists are treated as objects here */ | |
NAME NVARCHAR(2000),/* the name of the object */ | |
StringValue NVARCHAR(MAX) NOT NULL,/*the string representation of the value of the element. */ | |
ValueType VARCHAR(10) NOT null /* the declared type of the value represented as a string in StringValue*/ | |
) | |
My Gist | Udemy Course | Packt Book |
---|---|---|
My Tablo Learn Gist | Udemy Cert Prep | Packt Tablo Book |
Connecting to & Preparing Data ( Packt chapter 2 )
- Contoso needs to protect their Internet-facing web apps from common attacks. Which Azure service(s) offers out-of-box implementation of Open Web Application Security Project (OWASP) vulnerability rule sets? Choose all that apply?
See "Azure Web Application Firewall (WAF) on Azure Application Gateway" at https://docs.microsoft.com/en-us/azure/web-application-firewall/ag/ag-overview and "Azure Front Door" at https://docs.microsoft.com/en-us/azure/frontdoor/front-door-application-security [Describe Security, Privacy, Compliance, and Trust]
MS docs: There are two options when applying WAF policies in Azure. WAF with Azure Front Door is a globally distributed, edge security solution. WAF with Application Gateway is a regional, dedicated solution. Uhhh.. ...does that mean Front Door is more expensive?
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from flask import Flask | |
from flask_restful import Resource, Api | |
app = Flask(__name__) | |
api = Api(app) | |
class SimpleRest(Resource): | |
def get(self): | |
return { |
Categorical Propositions for SQL Study
Name | IS-A | HAS-A | CAN-BE-A | WHADEY Heckin' Deal??? |
---|---|---|---|---|
Proposition | Assertion | Predicate | A proposition is the contents of an assertion which can be true or false. One of two propositions contains a term called a predicate that can be used to support the conclusion of a syllogism. Sep 9, 2016 https://philosophy.stackexchange.com If all of a predicate' s variables are bound, the resulting formula is a proposition. (WikiDiff) an instance of a ' predicate whose terms are all constant — e.g., P(2,3) — acts as a proposition. | |
Assertion | Predicate | True result; Affirmation | Proposition | assertion is (computing) a statement in a program asserting a condition expected to be true at a particular point. https://wikidiff.com/predicate/assertion |
Predicate | E |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- how many columns in my table? | |
-- have to count null elements too | |
DECLARE @rowString AS VARCHAR(MAX) | |
DECLARE @StringToCount1 AS VARCHAR(100) = '</' | |
DECLARE @StringToCount2 AS VARCHAR(100) = '/>' | |
DECLARE @StringCount AS INT | |
DECLARE @ColCount AS INT | |
SELECT @rowString = (SELECT TOP 1 * FROM PE_CS_CUBE ORDER BY LASTUPDATED DESC FOR XML PATH, ELEMENTS XSINIL ) | |
SET @StringCount = (LEN(@rowString) - LEN(REPLACE(@rowString, @StringToCount1,'')))/COALESCE(NULLIF(LEN(@StringToCount1), 0), 1) | |
+ (LEN(@rowString) - LEN(REPLACE(@rowString, @StringToCount2,'')))/COALESCE(NULLIF(LEN(@StringToCount2), 0), 1) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
VERSION 5.00 | |
Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} frmReadXML | |
Caption = "Read XML Data" | |
ClientHeight = 4920 | |
ClientLeft = 120 | |
ClientTop = 465 | |
ClientWidth = 9165 | |
OleObjectBlob = "frmReadXML.frx":0000 | |
StartUpPosition = 1 'CenterOwner | |
End |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
' from https://vba-corner.livejournal.com/4623.html | |
'Before you can do anything with the Internet Explorer, of course you'll need one, and you'll need something to address it. The following function achieves exactly this by creating a new instance of the Internet Explorer and returning a pointer to it. | |
'returns new instance of Internet Explorer | |
Function GetNewIE() As SHDocVw.InternetExplorer | |
'create new IE instance | |
Set GetNewIE = New SHDocVw.InternetExplorer | |
'start with a blank page | |
GetNewIE.Navigate2 "about:Blank" | |
End Function |