{"title":"Databases","description":null,"products":[{"product_id":"developing-sql-queries-for-oracle-databases","title":"Developing SQL Queries for Oracle Databases","description":"\u003cdiv\u003e\u003cp\u003eThis \u003cstrong\u003eOracle SQL Queries training\u003c\/strong\u003e course will help you increase productivity and maximize the potential of SQL to formulate intricate queries for Oracle databases. Learn to solve business problems easily, efficiently, and elegantly with only a few lines of SQL code, and gain the practical skills to choose the best query method — ensuring accuracy and avoiding common errors or pitfalls.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eDeveloping SQL Queries for Oracle Databases Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMaximize the potential of SQL to formulate complex queries.\u003c\/li\u003e\n\u003cli\u003eThoroughly test SQL queries and avoid common errors.\u003c\/li\u003e\n\u003cli\u003eSelect the most efficient solution to complex SQL problems.\u003c\/li\u003e\n\u003cli\u003eLeverage the analytical functions of Oracle.\u003c\/li\u003e\n\u003cli\u003eEmploy inner joins, outer joins, cross joins, and self joins.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eSQL and Oracle RDBMS knowledge at the level of:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCourse 925, Introduction to SQL Course\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eOracle SQL Queries Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introduction and Overview\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eThe uses of SQL queries\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWhy SQL can be both easy and difficult\u003c\/li\u003e\n\u003cli\u003eRecommendations for thorough testing\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eEnhancing query performance\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eQuery optimization\u003c\/li\u003e\n\u003cli\u003eChoosing the most efficient query method\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Leveraging SQL Functions to Build Queries\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eAggregate functions\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eGrouping in several levels\u003c\/li\u003e\n\u003cli\u003eGrouping and NULLs\u003c\/li\u003e\n\u003cli\u003eCUBE and ROLLUP\u003c\/li\u003e\n\u003cli\u003eBuilding crosstab reports\u003c\/li\u003e\n\u003cli\u003eUtilizing the PIVOT operator in Oracle 11\u003ci\u003eg\u003c\/i\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSingle-row functions\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eString-manipulation functions\u003c\/li\u003e\n\u003cli\u003eFunctions for date and time manipulation\u003c\/li\u003e\n\u003cli\u003eSimulating IF ... THEN ... ELSE with functions\u003c\/li\u003e\n\u003cli\u003eHandling regular expressions with Oracle 10\u003ci\u003eg\u003c\/i\u003e functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Performing Extensive Analysis with Analytical Functions\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eCalculating ranks\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eRANK and DENSE_RANK\u003c\/li\u003e\n\u003cli\u003eROW_NUMBER depending on ORDER BY\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eExtending the use of aggregates\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePartitioning in multiple levels\u003c\/li\u003e\n\u003cli\u003eComputing running totals\u003c\/li\u003e\n\u003cli\u003eComparing row and aggregate values\u003c\/li\u003e\n\u003cli\u003eDefining sliding window boundaries\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Developing Complex Joins\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eCreating inner and outer joins\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuilding multiple table joins\u003c\/li\u003e\n\u003cli\u003eGrouping and joins\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eHow and when to use self-joins\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eImplementing recursive self-joins with CONNECT BY\u003c\/li\u003e\n\u003cli\u003eCONNECT BY and join simultaneously\u003c\/li\u003e\n\u003cli\u003eOracle 10\u003ci\u003eg\u003c\/i\u003e enhancements to CONNECT BY\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eApplying the ANSI standard join syntax\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eINNER JOIN\u003c\/li\u003e\n\u003cli\u003eCROSS JOIN\u003c\/li\u003e\n\u003cli\u003eLEFT, RIGHT and FULL OUTER JOIN\u003c\/li\u003e\n\u003cli\u003eAdding filter conditions to OUTER JOINS\u003c\/li\u003e\n\u003cli\u003eDifferences between new ANSI and old Oracle style\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eManipulating the set operators\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUNION and UNION ALL\u003c\/li\u003e\n\u003cli\u003eINTERSECT\u003c\/li\u003e\n\u003cli\u003eMINUS\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Building Subqueries\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eNoncorrelated subqueries\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSubqueries that return NULL\u003c\/li\u003e\n\u003cli\u003eMultiple row subqueries\u003c\/li\u003e\n\u003cli\u003eMultiple column subqueries\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eHandling correlated subqueries\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eFetching main query values\u003c\/li\u003e\n\u003cli\u003eThe EXISTS operator\u003c\/li\u003e\n\u003cli\u003eAvoiding accidental correlation\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSubqueries in the FROM clause\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBreaking up a complex problem into manageable pieces\u003c\/li\u003e\n\u003cli\u003eFactoring subqueries for reusability\u003c\/li\u003e\n\u003cli\u003eApplying recursive factored subqueries in Oracle 11\u003ci\u003eg\u003c\/i\u003e R2\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSubqueries as expressions\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSubqueries as parameters to functions\u003c\/li\u003e\n\u003cli\u003eCorrelated and noncorrelated subqueries in expressions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Employing Views and Temporary Tables\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eOvercoming obstacles with views\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMultiple group levels in one query\u003c\/li\u003e\n\u003cli\u003eHow views impact performance\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eTemporary tables as alternatives to views\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAvoiding interference from other users\u003c\/li\u003e\n\u003cli\u003eTailoring temporary tables\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 7: Introducing Oracle 12c\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eLimiting the number of rows returned with FETCH\u003c\/li\u003e\n\u003cli\u003eRetrieving partly results with OFFSET\u003c\/li\u003e\n\u003cli\u003eSimulating joins with lateral views and APPLY\u003c\/li\u003e\n\u003cli\u003eDeclaring local functions in the WITH clause\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267B67US \/ 2026-07-21T09:00:00 \/ Herndon, VA","offer_id":47534212776155,"sku":"US-234-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"269C18US \/ 2026-09-15T09:00:00 \/ Herndon, VA","offer_id":48216577638619,"sku":"US-234-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26BA43US \/ 2026-11-17T09:00:00 \/ Herndon, VA","offer_id":48216577736923,"sku":"US-234-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"271A45US \/ 2027-01-19T09:00:00 \/ Herndon, VA","offer_id":48216577769691,"sku":"US-234-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"273A37US \/ 2027-03-16T09:00:00 \/ Herndon, VA","offer_id":48377299566811,"sku":"US-234-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"275A38US \/ 2027-05-18T09:00:00 \/ Herndon, VA","offer_id":48780667388123,"sku":"US-234-IL","price":2512.0,"currency_code":"USD","in_stock":true}]},{"product_id":"graph-databases-for-data-analytics-and-ai","title":"Graph Databases for Data Analytics and AI","description":"\u003cdiv\u003e\n\u003cp\u003eIn this \u003cstrong\u003eGraph Databases for Data Analytics and AI Training\u003c\/strong\u003e course, you will learn how databases for graph data can support data analytics and artificial intelligence in ways not practical with traditional relational databases. You will see practical and profitable use cases and understand the importance of graph data in today’s world. You will master the practical aspects of importing and exporting data for graph databases, and how graph databases are searched and queried.\u003c\/p\u003e\r\n\u003cp\u003eGraph databases are also ideal for the representation of human knowledge, not just simple facts. You will understand how knowledgebase graphs integrate with artificial intelligence systems and learn to use these systems to provide business analyses and insights.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eGraph Databases for Data Analytics and AI Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cb\u003eIn this course, you will:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLearn what graph data is and why graph data is critical in today’s business environment.\u003c\/li\u003e\n\u003cli\u003eSee how businesses and government agencies are using graph data.\u003c\/li\u003e\n\u003cli\u003eExplore the differences among the many graph database platforms.\u003c\/li\u003e\n\u003cli\u003eUnderstand the different file formats used to import and export graph data.\u003c\/li\u003e\n\u003cli\u003eQuery graph databases to obtain specialized data and important insights.\u003c\/li\u003e\n\u003cli\u003eUnderstand the differences among the different query languages for graph data.\u003c\/li\u003e\n\u003cli\u003eLearn how human knowledge can be represented using knowledge graphs.\u003c\/li\u003e\n\u003cli\u003eConstruct a database of knowledge, as opposed to simple facts.\u003c\/li\u003e\n\u003cli\u003eUse a “knowledgebase” to infer new insights not present in the stored data.\u003c\/li\u003e\n\u003cli\u003eUnderstand how the techniques of graph data and advanced neural networks can work together for advanced data analytic and artificial intelligence systems.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cb\u003eTraining Prerequisites\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eAttendees should have a general understanding of the fundamentals of databases, but database experience is not required. Experience with some programming or scripting language is expected, but a detailed knowledge or Python is not required.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eGraph Databases for Data Analytics and AI Training Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Why Graph Databases are Important\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eObjectives\u003c\/b\u003e:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand what graph data is and why it is important\u003c\/li\u003e\n\u003cli\u003eExplore a few or the many practical applications of graph databases\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eContents:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWhat are graphs?\u003c\/li\u003e\n\u003cli\u003eHow graphs are used to provide structure to data\u003c\/li\u003e\n\u003cli\u003eBusiness use-cases of graph databases\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Foundations of Graphs and Graph Data\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eObjectives:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eStoring graph data in simple files\u003c\/li\u003e\n\u003cli\u003eWhat is a relational database?\u003c\/li\u003e\n\u003cli\u003eHow graph databases differ from traditional relational databases\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eContents:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eHow graphs are used to provide structure to data\u003c\/li\u003e\n\u003cli\u003eGraph software\u003c\/li\u003e\n\u003cli\u003eGraph data in files\u003c\/li\u003e\n\u003cli\u003eFile format alternatives\u003c\/li\u003e\n\u003cli\u003eScripts for manipulating and characterising graph data\u003c\/li\u003e\n\u003cli\u003eDiagramming graphs\u003c\/li\u003e\n\u003cli\u003eDiagramming graphs with Python\u003c\/li\u003e\n\u003cli\u003eUsing GraphViz software\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Graph Database Platforms\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eObjectives:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExamine commercial graph database systems\u003c\/li\u003e\n\u003cli\u003eUnderstand the differences among graph database systems\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eContents:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eOptions for graph database systems\u003c\/li\u003e\n\u003cli\u003eIntroduction to Neo4j\u003c\/li\u003e\n\u003cli\u003eIntroduction to GraphDB\u003c\/li\u003e\n\u003cli\u003eIntroduction to CogniPy\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Querying and Analysing Graph Data\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eObjectives:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLearn how to query data in a graph database\u003c\/li\u003e\n\u003cli\u003eUnderstand the differences among graph database query languages\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eContents:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUsing the Neo4j browser\u003c\/li\u003e\n\u003cli\u003eThe Cypher® graph query language\u003c\/li\u003e\n\u003cli\u003eStructure of Cypher® queries\u003c\/li\u003e\n\u003cli\u003eViewing and interpreting query results\u003c\/li\u003e\n\u003cli\u003eOther graph query languages\u003c\/li\u003e\n\u003cli\u003eGraphQL\u003c\/li\u003e\n\u003cli\u003eGremlin\u003c\/li\u003e\n\u003cli\u003eSPARQL\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Using Graph Database APIs to Build Systems\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eObjectives:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand how APIs are used to build a system\u003c\/li\u003e\n\u003cli\u003eExplore some examples using Python\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eContents:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUsing Python to manage and query a Neo4j graph database\u003c\/li\u003e\n\u003cli\u003eHow graphs are used to provide structure to data\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Knowledge Graphs\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eObjectives:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLearn how human knowledge can be represented in graph data using semantic nets\u003c\/li\u003e\n\u003cli\u003eCreate a simple knowledge graph\u003c\/li\u003e\n\u003cli\u003eUnderstand ontologies\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eContents:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSemantic nets and the Resource Description Framework (RDF)\u003c\/li\u003e\n\u003cli\u003eFormats for representing RDF triples\u003c\/li\u003e\n\u003cli\u003eOntologies\u003c\/li\u003e\n\u003cli\u003eThe structure of ontology documents\u003c\/li\u003e\n\u003cli\u003eTools for creating and editing ontologies\u003c\/li\u003e\n\u003cli\u003eProtege and other Tools\u003c\/li\u003e\n\u003cli\u003eSemantic Nets and Knowledge graphs\u003c\/li\u003e\n\u003cli\u003eLoading knowledge graphs into a graph database\u003c\/li\u003e\n\u003cli\u003eApplying logic-based “reasoners” to knowledge graphs\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 7: Graph Neural Networks\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eObjectives:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand the Need for “Hybrid” AI\u003c\/li\u003e\n\u003cli\u003eApplying convolutional neural networks to graph data\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eContents:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003e“Hybrid” AI\u003c\/li\u003e\n\u003cli\u003eCreating graph neural networks\u003c\/li\u003e\n\u003cli\u003eApplying convolutional neural networks to graph data\u003c\/li\u003e\n\u003cli\u003eReview the basics of convolutional neural networks\u003c\/li\u003e\n\u003cli\u003eTraining the hybrid AI\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267D25US \/ 2026-07-08T09:00:00 \/ Herndon, VA","offer_id":48216547131611,"sku":"US-1294-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269C45US \/ 2026-09-09T09:00:00 \/ Herndon, VA","offer_id":48216547164379,"sku":"US-1294-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26BB30US \/ 2026-11-04T09:00:00 \/ Herndon, VA","offer_id":48216547197147,"sku":"US-1294-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271B29US \/ 2027-01-06T09:00:00 \/ Herndon, VA","offer_id":48216547229915,"sku":"US-1294-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"273B09US \/ 2027-03-10T09:00:00 \/ Herndon, VA","offer_id":48334734295259,"sku":"US-1294-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"275B17US \/ 2027-05-12T09:00:00 \/ Herndon, VA","offer_id":48762861191387,"sku":"US-1294-IL","price":2228.0,"currency_code":"USD","in_stock":true}]},{"product_id":"sql-server-reporting-services","title":"SQL Server Reporting Services","description":"\u003cdiv\u003e\u003cp\u003eGain an in-depth skillset to leverage on-premises \u003cabbr title=\"Structured Query Language\"\u003eSQL\u003c\/abbr\u003e Server Reporting Services (\u003cabbr title=\"SQL Server Reporting Services\"\u003eSSRS\u003c\/abbr\u003e) for extracting business intelligence from enterprise data. Attain the knowledge and skills to produce compelling reports with enhanced visualization features. This training course enables you to go beyond the limitations of legacy reporting to deliver and share information with others — when you want and how you want.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eSQL Server Reporting Services Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cp\u003eProduce reports for extracting business intelligence through the Web Portal\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eLeverage Visual Studio and Report Designer to create paginated reports\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eBuild reports for mobile devices with SQL Server Mobile Report Publisher\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eIntegrate parameters, filters, and interactive components into reports\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eDeploy reports through Report Server\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eCreate reports on SSAS cubes with Report Builder and Report Designer\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eLeverage continued support with after-course one-on-one instructor coaching and computing sandbox\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eSQL Server Reporting Services Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eSQL Server Reporting Services Course Information\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003ePrerequisites\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eLearning Tree \u003cspan data-cke-saved-href=\"\/courses\/2107\/\" title=\"Microsoft SQL Server® Introduction \" rel=\"follow noopener\" target=\"_blank\"\u003eMicrosoft SQL Server® Introduction \u003c\/span\u003eor equivalent experience with any relational database system\u003c\/li\u003e\n\u003cli\u003eVisual Studio knowledge and familiarity with simple scripting is recommended, but not required\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003cp\u003e\u003cb\u003eWho should attend?\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\n\u003cp\u003eThis course is for anyone with database experience who wants to design, create, or deliver reports from relational or MDX compliant data sources.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cp\u003e\u003cb\u003eExam Information\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\n\u003cp\u003eLearning Tree Exam provided at the end of class\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introduction to SQL Server Reporting Services\u003c\/h4\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eArchitecture and tools\u003c\/li\u003e\n\u003cli\u003eManaging web farm deployment\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Developing Reports\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eLeveraging Reporting Services tools\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eReport Building with Report Builder and Visual Studio\u003c\/li\u003e\n\u003cli\u003eAccessing the power of \u003cabbr title=\"Structured Query Language\"\u003eSQL\u003c\/abbr\u003e Server Mobile Report Publisher\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eDesigning fundamental reports\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eConnecting to relational and multidimensional sources\u003c\/li\u003e\n\u003cli\u003eGenerating a Tablix reporting structure\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eComposing expressions\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eComputing custom fields\u003c\/li\u003e\n\u003cli\u003eLinking expressions to properties\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eArranging and sorting data\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMultiple-level grouping and categorizing the results\u003c\/li\u003e\n\u003cli\u003eApplying aggregate functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eProducing various outputs from a Tablix\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCreating parallel dynamic group report formats\u003c\/li\u003e\n\u003cli\u003eCombining dynamic and static columns\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Integrating Parameters and Filters\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eIncorporating parameters into reports\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eYielding subsets of data with query parameters\u003c\/li\u003e\n\u003cli\u003eConstructing cascading report parameters\u003c\/li\u003e\n\u003cli\u003eTransmitting parameters to stored procedures\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eApplying filters to report data\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAugmenting performance with filters\u003c\/li\u003e\n\u003cli\u003eDetermining filters vs. query parameters\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Implementing Interactive Features\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eCombining multiple data regions in one report\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eApplying sequential and nested regions\u003c\/li\u003e\n\u003cli\u003eCreating master\/detail reports and linking subreports\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eShowing robust data with relevant detail\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDrilling through report detail and drilling down\u003c\/li\u003e\n\u003cli\u003eNavigating reports with document maps\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Deploying and Delivering Reports\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eDeploying reports to the server\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003ePublishing reports and configuring project properties\u003c\/li\u003e\n\u003cli\u003eVerifying results with Report Manager\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eIdentifying delivery options\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEnhancing performance with cached instances\u003c\/li\u003e\n\u003cli\u003eConfiguring snapshot history\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eDispatching subscription reports\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePublishing reports via e-mail and file share\u003c\/li\u003e\n\u003cli\u003eSeamlessly delivering reports by data-driven subscriptions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Safeguarding Reporting Services\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eStructuring content security\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eLeveraging existing Windows authentication\u003c\/li\u003e\n\u003cli\u003eEstablishing permission levels on report items\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eEnsuring the RS system\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eInstituting varying levels of administrative roles\u003c\/li\u003e\n\u003cli\u003eGranting and revoking system-level permissions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 7: Extended Reporting and Data Visualization\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eCreating reports on Analysis Services cubes\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eExploiting cubes as intuitive data sources for nontechnical and power users\u003c\/li\u003e\n\u003cli\u003eGenerating parameterized reports with \u003cabbr title=\"Multidimensional Expressions\"\u003eMDX\u003c\/abbr\u003e Builder Designing reports for data visualization\u003c\/li\u003e\n\u003cli\u003eImproving data visualization with sparklines, data bars, maps and indicators\u003c\/li\u003e\n\u003cli\u003eImplementing Key Performance Indicators (\u003cabbr title=\"Key Performance Indicators\"\u003eKPI\u003c\/abbr\u003es)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eDelivering reports to users\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAccessing and controlling reports using \u003cabbr title=\"Uniform Resource Locator\"\u003eURL\u003c\/abbr\u003es\u003c\/li\u003e\n\u003cli\u003eEmbedding reports in applications with the Report Viewer\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"268B22US \/ 2026-08-18T09:00:00 \/ Herndon, VA","offer_id":47534197801179,"sku":"US-140-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"267D42US \/ 2026-07-07T09:00:00 \/ Herndon, VA","offer_id":48216573608155,"sku":"US-140-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26BC23US \/ 2026-11-17T09:00:00 \/ Herndon, VA","offer_id":48216573673691,"sku":"US-140-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"271C13US \/ 2027-01-12T09:00:00 \/ Herndon, VA","offer_id":48216573706459,"sku":"US-140-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"273B65US \/ 2027-03-16T09:00:00 \/ Herndon, VA","offer_id":48377298485467,"sku":"US-140-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"275C04US \/ 2027-05-18T09:00:00 \/ Herndon, VA","offer_id":48780665225435,"sku":"US-140-IL","price":2512.0,"currency_code":"USD","in_stock":true}]},{"product_id":"oracle®-pl-sql-training","title":"Oracle® PL\/SQL Training","description":"\u003cdiv\u003e\n\u003cp\u003eThis \u003cstrong\u003eOracle® PL\/SQL training\u003c\/strong\u003e course will teach you to increase the productivity, performance, scalability, portability, and security of your Oracle database. With this training, you will learn how to execute PL\/SQL programs in Oracle, build stored procedures, design, and execute modular applications, and increase the efficiency of data movement — essential skills for any Oracle developer.\u003c\/p\u003e\r\n\u003cp\u003e\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eOracle® PL\/SQL Training Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this Oracle PL\/SQL Programming training, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDevelop efficient PL\/SQL programs to access Oracle databases. \u003c\/li\u003e\n\u003cli\u003eCreate stored procedures and functions for reuse and maintenance. \u003c\/li\u003e\n\u003cli\u003eDesign modular applications using packages. \u003c\/li\u003e\n\u003cli\u003eManage data retrieval for front-end applications. \u003c\/li\u003e\n\u003cli\u003eInvoke native dynamic SQL to develop high-level abstract code. \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eOracle PL\/SQL Programming Training Course Prerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eStudents taking this course should have basic knowledge of SQL as taught in Learning Tree course 925, Introduction to SQL Course.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eOracle PL\/SQL Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introduction and Overview\u003c\/h4\u003e\n\u003cp\u003ePL\/SQL fundamentals\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDeclaring and anchoring variables to database definitions\u003c\/li\u003e\n\u003cli\u003eFlow control constructs\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eOracle 11\u003ci\u003eg\u003c\/i\u003e and 12\u003ci\u003ec\u003c\/i\u003e PL\/SQL features\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePL\/Scope in Oracle 11\u003ci\u003eg\u003c\/i\u003e\n\u003c\/li\u003e\n\u003cli\u003eReturning implicit cursor results from stored procedures in Oracle 12\u003ci\u003ec\u003c\/i\u003e\n\u003c\/li\u003e\n\u003cli\u003eDeclaring local functions within SELECT statements in Oracle 12\u003ci\u003ec\u003c\/i\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Data Manipulation Techniques\u003c\/h4\u003e\n\u003cp\u003eMaintaining data with DML statements\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEmploying the RETURNING INTO clause\u003c\/li\u003e\n\u003cli\u003eSolving the fetch-across-commit problem\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eManaging data retrieval with cursors\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eImplications of explicit and implicit cursors\u003c\/li\u003e\n\u003cli\u003eSimplifying cursor processing with cursor FOR LOOPs\u003c\/li\u003e\n\u003cli\u003eEmbedding cursor expressions in SELECT statements\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eCursor variables\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eStrong vs. weak cursor variables\u003c\/li\u003e\n\u003cli\u003ePassing cursor variables to other programs\u003c\/li\u003e\n\u003cli\u003eDefining REF CURSORS in packages\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Developing Well-Structured and Error-Free Code\u003c\/h4\u003e\n\u003cp\u003eError handling using EXCEPTIONs\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePropagation and scope\u003c\/li\u003e\n\u003cli\u003e\"Retrying\" problem transactions with EXCEPTION processing\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDebugging PL\/SQL blocks\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSimplifying testing and debugging with conditional compilation\u003c\/li\u003e\n\u003cli\u003eInterpreting compiler messages\u003c\/li\u003e\n\u003cli\u003eApplying structured testing techniques\u003c\/li\u003e\n\u003cli\u003eBuilding and applying a test bed\u003c\/li\u003e\n\u003cli\u003eLeveraging the debugging facilities in SQL Developer\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Achieving Maximum Reusability\u003c\/h4\u003e\n\u003cp\u003eWriting stored procedures and functions\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCalling and invoking server-side logic\u003c\/li\u003e\n\u003cli\u003ePassing input and output parameters\u003c\/li\u003e\n\u003cli\u003eImplementing an autonomous transaction\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eCoding user-written functions\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCalling PL\/SQL functions from SQL\u003c\/li\u003e\n\u003cli\u003eBuilding table-valued functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDeveloping safe triggers\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEmploying :OLD and :NEW variables\u003c\/li\u003e\n\u003cli\u003eAvoiding unreliable trigger constructs\u003c\/li\u003e\n\u003cli\u003eExploiting schema and database triggers\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Exploiting Complex Datatypes\u003c\/h4\u003e\n\u003cp\u003eCollection types\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePL\/SQL tables, nested tables, VARRAYs\u003c\/li\u003e\n\u003cli\u003eStepping through dense and nonconsecutive collections\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eBulk binding for high performance\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMoving data into and out of PL\/SQL blocks\u003c\/li\u003e\n\u003cli\u003eBULK COLLECT INTO and FORALL\u003c\/li\u003e\n\u003cli\u003eBULK cursor attributes\u003c\/li\u003e\n\u003cli\u003eBULK EXCEPTION handling\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Invoking Native Dynamic SQL\u003c\/h4\u003e\n\u003cp\u003eFinessing the compiler\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eThe EXECUTE IMMEDIATE statement\u003c\/li\u003e\n\u003cli\u003eThe RETURNING INTO clause\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eTypes of dynamic SQL\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuilding SQL statements during runtime\u003c\/li\u003e\n\u003cli\u003eAutogenerating standard code\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 7: Package Tips and Techniques\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003ePackage structure: SPEC and BODY\u003c\/li\u003e\n\u003cli\u003eEliminating dependency problems\u003c\/li\u003e\n\u003cli\u003eOverloading for polymorphic effects\u003c\/li\u003e\n\u003cli\u003eEvaluating application frameworks\u003c\/li\u003e\n\u003cli\u003eDeclaring and using persistent global variables\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"269B35US \/ 2026-09-14T09:00:00 \/ Herndon, VA","offer_id":47591598096603,"sku":"US-493-IL","price":2680.0,"currency_code":"USD","in_stock":true},{"title":"268C75US \/ 2026-08-10T09:00:00 \/ Herndon, VA","offer_id":48216578031835,"sku":"US-493-IL","price":2680.0,"currency_code":"USD","in_stock":true},{"title":"26BA82US \/ 2026-11-30T09:00:00 \/ Herndon, VA","offer_id":48216578064603,"sku":"US-493-IL","price":2680.0,"currency_code":"USD","in_stock":true},{"title":"272A55US \/ 2027-02-01T09:00:00 \/ Herndon, VA","offer_id":48216578097371,"sku":"US-493-IL","price":2680.0,"currency_code":"USD","in_stock":true},{"title":"274A64US \/ 2027-04-05T09:00:00 \/ Herndon, VA","offer_id":48556121293019,"sku":"US-493-IL","price":2680.0,"currency_code":"USD","in_stock":true}]},{"product_id":"comptia-data-®-certification-training","title":"CompTIA Data+® Certification Training","description":"\u003cdiv\u003e\n\u003cp\u003eUnlock the power of data-driven decision-making with the \u003cstrong\u003eCompTIA Data+\u003c\/strong\u003e Certification Training! As the importance of data analytics continues to grow, more job roles are being created to set a context and better communicate vital business intelligence. This comprehensive course will teach you the skills required to facilitate data-driven business decisions, including mining, manipulating, visualizing, and reporting data. \u003c\/p\u003e\r\n\u003cp\u003eLearn to apply basic statistical methods and analyze complex datasets while adhering to governance and quality standards throughout the entire data life cycle. The course also covers data integration and collection methods, data governance tools, and how to express business requirements in a report format. \u003c\/p\u003e\r\n\u003cp\u003eUpon completing the course, you will receive a CompTIA Data+ Exam Voucher and the opportunity to work with an instructor for after-course one-on-one coaching. If you're a data analyst, reporting analyst, business intelligence analyst, clinical analyst, marketing analyst, operations analyst, or simply someone interested in data analytics, this course is for you!\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eCompTIA Data+® Certification Training Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eParticipate in Instruction from CompTIA-certifiedData+ Certification preparation course.\u003c\/li\u003e\n\u003cli\u003eReceive a CompTIA Data+ Exam Voucher included upon completion of the course.\u003c\/li\u003e\n\u003cli\u003eIdentify Data Concepts and Environments important in analytics.\u003c\/li\u003e\n\u003cli\u003eExecute techniques in Data Mining, Data Mining, and Visualization.\u003c\/li\u003e\n\u003cli\u003eSummarize the importance of Data Governance, Quality, and Controls.\u003c\/li\u003e\n\u003cli\u003eContinue learning and face new challenges with after-course one-on-one instructor coaching.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eTraining Prerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCompTIA recommends 18–24 months (about 2 years) of experience in a report\/business analyst job to succeed in this course.\u003c\/li\u003e\n\u003cli\u003eExposure to databases and analytical tools, a basic understanding of statistics, and data visualization experiences, such as Excel, Power BI (Business Intelligence), and Tableau.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eCertification Information\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCompTIA DA0-001\u003c\/li\u003e\n\u003cli\u003eTesting through Pearson VUE\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eCompTIA Data+ Instructor-Led Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Identifying Basic Concepts of Data Schemas\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn how to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIdentify Relational and Non-Relational Databases\u003c\/li\u003e\n\u003cli\u003eUnderstand the Way We Use Tables, Primary Keys, and Normalization\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Understanding Different Data Systems\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn how to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDescribe Types of Data Processing and Storage Systems\u003c\/li\u003e\n\u003cli\u003eExplain How Data Changes\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Understanding Types and Characteristics of Data\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn how to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand Types of Data\u003c\/li\u003e\n\u003cli\u003eBreak Down the Field Data Types\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Comparing and Contrasting Different Data Structures, Formats, and Markup Languages\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn how to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDifferentiate between Structured Data and Unstructured Data\u003c\/li\u003e\n\u003cli\u003eRecognize Different File Formats\u003c\/li\u003e\n\u003cli\u003eUnderstand the Different Code Languages Used for Data\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Explaining Data Integration and Collection Methods\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn how to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand the Processes of Extracting, Transforming, and Loading Data\u003c\/li\u003e\n\u003cli\u003eExplain \u003cabbr title=\"Application Programming Interface\"\u003eAPI\u003c\/abbr\u003e\/Web Scraping and Other Collection Methods\u003c\/li\u003e\n\u003cli\u003eCollect and Use Public and Publicly-Available Data\u003c\/li\u003e\n\u003cli\u003eUse and Collect Survey Data\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Identifying Common Reasons for Cleansing and Profiling Data\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn how to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLearn to Profile Data\u003c\/li\u003e\n\u003cli\u003eAddress Redundant, Duplicated, and Unnecessary Data\u003c\/li\u003e\n\u003cli\u003eWork with Missing Values\u003c\/li\u003e\n\u003cli\u003eAddress Invalid Data\u003c\/li\u003e\n\u003cli\u003eConvert Data to Meet Specifications\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 7: Executing Different Data Manipulation Techniques\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn how to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eManipulate Field Data and Create Variables\u003c\/li\u003e\n\u003cli\u003eTranspose and Append Data\u003c\/li\u003e\n\u003cli\u003eQuery Data\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 8: Explaining Common Techniques for Data Manipulation and Optimization\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn how to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUse Functions to Manipulate Data\u003c\/li\u003e\n\u003cli\u003eUse Common Techniques for Query Optimization\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 9: Applying Descriptive Statistical Methods\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn how to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUse Measures of Central Tendency\u003c\/li\u003e\n\u003cli\u003eUse Measures of Dispersion\u003c\/li\u003e\n\u003cli\u003eUse Frequency and Percentages\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 10: Describing Key Analysis Techniques\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn how to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eGet Started with Analysis\u003c\/li\u003e\n\u003cli\u003eRecognize Types of Analysis\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 11: Understanding the Use of Different Statistical Methods\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn how to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand the Importance of Statistical Tests\u003c\/li\u003e\n\u003cli\u003eBreak Down the Hypothesis Test\u003c\/li\u003e\n\u003cli\u003eUnderstand Tests and Methods to Determine Relationships Between Variables\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 12: Using the Appropriate Type of Visualization\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn how to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUse Basic Visuals\u003c\/li\u003e\n\u003cli\u003eBuild Advanced Visuals\u003c\/li\u003e\n\u003cli\u003eBuild Maps with Geographical Data\u003c\/li\u003e\n\u003cli\u003eUse Visuals to Tell a Story\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 13: Expressing Business Requirements in a Report Format\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn how to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eConsider Audience Needs When Developing a Report\u003c\/li\u003e\n\u003cli\u003eDescribe Data Source Considerations for Reporting\u003c\/li\u003e\n\u003cli\u003eDescribe Considerations for Delivering Reports and Dashboards\u003c\/li\u003e\n\u003cli\u003eDevelop Reports or Dashboards\u003c\/li\u003e\n\u003cli\u003eUnderstand Ways to Sort and Filter Data\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 14: Designing Components for Reports and Dashboards\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn how to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDesign Elements for Reports and Dashboards\u003c\/li\u003e\n\u003cli\u003eUtilize Standard Elements\u003c\/li\u003e\n\u003cli\u003eCreating a Narrative and Other Written Elements\u003c\/li\u003e\n\u003cli\u003eUnderstand Deployment Considerations\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 15: Distinguishing Different Report Types\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn how to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand How Updates and Timing Affect Reporting\u003c\/li\u003e\n\u003cli\u003eDifferentiate Between Types of Reports\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 16: Summarizing the Importance of Data Governance\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn how to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDefine Data Governance\u003c\/li\u003e\n\u003cli\u003eUnderstand Access Requirements and Policies\u003c\/li\u003e\n\u003cli\u003eUnderstand Security Requirements\u003c\/li\u003e\n\u003cli\u003eUnderstand Entity Relationship Requirements\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 17: Applying Quality Control to Data\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn how to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDescribe Characteristics, Rules, and Metrics of Data Quality\u003c\/li\u003e\n\u003cli\u003eIdentify Reasons to Quality Check Data and Methods of Data Validation\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 18: Explaining Master Data Management Concepts\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn how to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExplain the Basics of Master Data Management\u003c\/li\u003e\n\u003cli\u003eDescribe Master Data Management Processes\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"268A81US \/ 2026-08-31T09:00:00 \/ Herndon, VA","offer_id":47534191345883,"sku":"US-2043-IL","price":2680.0,"currency_code":"USD","in_stock":true},{"title":"26AB69US \/ 2026-10-19T09:00:00 \/ Herndon, VA","offer_id":48216570298587,"sku":"US-2043-IL","price":2680.0,"currency_code":"USD","in_stock":true},{"title":"26CB53US \/ 2026-12-14T09:00:00 \/ Herndon, VA","offer_id":48216570331355,"sku":"US-2043-IL","price":2680.0,"currency_code":"USD","in_stock":true},{"title":"272B46US \/ 2027-02-01T09:00:00 \/ Herndon, VA","offer_id":48216570364123,"sku":"US-2043-IL","price":2680.0,"currency_code":"USD","in_stock":true},{"title":"274B66US \/ 2027-04-12T09:00:00 \/ Herndon, VA","offer_id":48586425630939,"sku":"US-2043-IL","price":2680.0,"currency_code":"USD","in_stock":true}]},{"product_id":"administering-microsoft-azure-sql-solutions-dp-300-certification-training","title":"Implement scalable database solutions using Azure SQL (DP-300)","description":"\u003cdiv\u003e\u003cp\u003eThis Implement scalable database solutions using Azure SQL (DP-300)\u003cb\u003e \u003c\/b\u003e\u003cb\u003ecertification \u003c\/b\u003ecourse provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be helpful to individuals who develop applications that deliver content from SQL-based relational databases.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eImplement scalable database solutions using Azure SQL (DP-300) Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cb\u003eIn this Administering Microsoft Azure SQL Solutions (DP-300) course, you will learn how to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePlan, deploy and configure Azure SQL offerings.\u003c\/li\u003e\n\u003cli\u003eMonitor database performance and tune a database and queries for optimum performance.\u003c\/li\u003e\n\u003cli\u003ePlan and configure a High Availability Solution.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cb\u003eAdministering Microsoft Azure SQL Solutions (DP-300) Prerequisites\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eSuccessful Azure Database Administrators start this role with professional experience in database management and technical knowledge of cloud technologies. Specifically: \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWorking with, maintaining, and developing with SQL Server \u003c\/li\u003e\n\u003cli\u003eExperience with Azure, such as deploying and managing resources \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eAt a minimum, you should know the information in the following courses before attending the course:\u003ca title=\"Microsoft Azure Data Fundamentals Training (DP-900)\" href=\"https:\/\/www.learningtree.com\/courses\/microsoft-azure-data-dp-900-training\/\"\u003e\u003c\/a\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIntroduction to Cloud Infrastructure (AZ-900)\u003c\/li\u003e\n\u003cli\u003eMicrosoft Azure Data Fundamentals Training (DP-900)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cb\u003eAdministering Microsoft Azure SQL Solutions (DP-300) Exam Information\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eThis course can help you prepare for the following Microsoft role-based certification exam — \u003ca title=\"Exam DP-300: Microsoft Certified: Azure Database Administrator Associate\" target=\"_blank\" href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/exams\/dp-300\" rel=\"nofollow noopener\"\u003eExam DP-300: Microsoft Certified: Azure Database Administrator Associate\u003c\/a\u003e.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eDP-300 Certification Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eLearning Objectives\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003ePlan and implement data platform resources\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003ePrepare to maintain SQL Server-based databases on Azure\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand the role of Azure Database Administrator as it fits in with other data platform roles.\u003c\/li\u003e\n\u003cli\u003eDescribe the key differences between the SQL Server-based database options in Azure.\u003c\/li\u003e\n\u003cli\u003eDescribe other features for Azure SQL platforms available.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDeploy IaaS solutions with Azure SQL\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eExplore the basics of SQL Server in an Infrastructure as a Service (IaaS) offering\u003c\/li\u003e\n\u003cli\u003eLearn the available options for provisioning and deployment\u003c\/li\u003e\n\u003cli\u003eDeploy SQL Server into an Azure Virtual Machine\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDeploy PaaS solutions with Azure SQL\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eGain an understanding SQL Server in a Platform as a Service (PaaS) offering\u003c\/li\u003e\n\u003cli\u003eUnderstand PaaS provisioning and deployment options\u003c\/li\u003e\n\u003cli\u003eUnderstand elastic pools\u003c\/li\u003e\n\u003cli\u003eExamine Azure SQL Managed Instances\u003c\/li\u003e\n\u003cli\u003eConfigure a template for PaaS deployment\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eMigrate SQL Server workloads to Azure SQL Database\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eExplore the advantages, capabilities, and migration possibilities offered by Azure SQL Database.\u003c\/li\u003e\n\u003cli\u003eMigrate databases using Azure SQL Migration extension for Azure Data Studio and tracking database migration activities.\u003c\/li\u003e\n\u003cli\u003eUse transactional replication as an online method to migrate to Azure SQL Database.\u003c\/li\u003e\n\u003cli\u003eExplore several other methods for migrating SQL Server databases to Azure SQL Database.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eMigrate SQL Server workloads to Azure SQL Managed Instance\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eExplore the advantages, capabilities, and migration possibilities offered by Azure SQL Managed Instance.\u003c\/li\u003e\n\u003cli\u003eLearn how Log Replay Service works to migrate to Azure SQL Managed Instance.\u003c\/li\u003e\n\u003cli\u003eUnderstand how Managed Instance link feature works in a migration scenario.\u003c\/li\u003e\n\u003cli\u003eLoad and move data to and from Azure SQL Managed Instance.\u003c\/li\u003e\n\u003cli\u003eExplore several other methods for migrating SQL Server databases to Azure SQL Database.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eImplement a secure environment for a database service\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eConfigure database authentication and authorization\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eLearn about authentication options for Azure SQL\u003c\/li\u003e\n\u003cli\u003eCreate various security principals\u003c\/li\u003e\n\u003cli\u003eConfigure permissions within a SQL database\u003c\/li\u003e\n\u003cli\u003eIdentify authentication and authorization failures\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eProtect data in-transit and at rest\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand the data encryption options available in the various platforms\u003c\/li\u003e\n\u003cli\u003eImplement object level encryption\u003c\/li\u003e\n\u003cli\u003eUnderstand the difference between database and server firewall rules for Azure SQL Database\u003c\/li\u003e\n\u003cli\u003eExplore Always Encrypted with secure enclaves\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eImplement compliance controls for sensitive data\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003ePlan and implement data classification in Azure SQL Database\u003c\/li\u003e\n\u003cli\u003eUnderstand and configure row-level security and dynamic data masking\u003c\/li\u003e\n\u003cli\u003eUnderstand the usage of Microsoft Defender for SQL\u003c\/li\u003e\n\u003cli\u003eExplore how Ledger works\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eMonitor and optimize operational resources in Azure SQL\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDescribe performance monitoring\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eReview potential performance issues.\u003c\/li\u003e\n\u003cli\u003eIdentify critical Azure metrics.\u003c\/li\u003e\n\u003cli\u003eLearn how to collect metrics for an established baseline.\u003c\/li\u003e\n\u003cli\u003eUse extended events for performance analysis.\u003c\/li\u003e\n\u003cli\u003eUnderstand database watcher for Azure SQL Database and Azure SQL Managed Instance.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eConfigure SQL Server resources for optimal performance\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand your options for configuration of Azure storage\u003c\/li\u003e\n\u003cli\u003eLearn how to configure TempDB data files in SQL Server\u003c\/li\u003e\n\u003cli\u003eLearn how to choose the right type of VM for SQL Server workloads\u003c\/li\u003e\n\u003cli\u003eUnderstand the use cases and configuration of Resource Governor in SQL Server\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eConfigure databases for optimal performance\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand database scoped configuration options\u003c\/li\u003e\n\u003cli\u003eUnderstand maintenance tasks related to indexing and statistics\u003c\/li\u003e\n\u003cli\u003eUnderstand the features of Intelligent Query Processing (IQP)\u003c\/li\u003e\n\u003cli\u003eExplore the automatic tuning feature in Azure\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eOptimize query performance in Azure SQL\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eExplore query performance optimization\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eGenerate and save execution plans\u003c\/li\u003e\n\u003cli\u003eCompare the different types of execution plans\u003c\/li\u003e\n\u003cli\u003eUnderstand how and why query plans are generated\u003c\/li\u003e\n\u003cli\u003eExplain the purpose and benefits of the Query Store\u003c\/li\u003e\n\u003cli\u003eInvestigate the available reports and data in the Query Store\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eExplore performance-based database design\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eExplore normal forms and how they affect database design\u003c\/li\u003e\n\u003cli\u003eChoose appropriate datatypes for your data\u003c\/li\u003e\n\u003cli\u003eEvaluate appropriate index types\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eEvaluate performance improvements\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eDetermine when changing indexes or defining new ones can affect performance\u003c\/li\u003e\n\u003cli\u003eEvaluate wait statistics as an aid in finding areas for performance improvement\u003c\/li\u003e\n\u003cli\u003eUnderstand how query hints work, and when to use them\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eAutomate database tasks for Azure SQL\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eAutomate database deployment\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eDescribe the deployment models available on Azure\u003c\/li\u003e\n\u003cli\u003eDeploy database resources using PowerShell and Azure CLI\u003c\/li\u003e\n\u003cli\u003eDeploy an Azure Resource Manager template and Bicep\u003c\/li\u003e\n\u003cli\u003eUnderstand the difference between multiple command-line options\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eCreate and manage SQL Agent jobs\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eSchedule necessary maintenance activities for your databases.\u003c\/li\u003e\n\u003cli\u003eConfigure notifications and alerts on SQL Server Agent jobs, and SQL Server.\u003c\/li\u003e\n\u003cli\u003eConfigure alerts based on performance monitor values.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eManage Azure PaaS tasks using automation\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\n\u003cli style=\"list-style: none;\"\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand the benefits of Azure policy\u003c\/li\u003e\n\u003cli\u003eExplore the capabilities of Azure Automation\u003c\/li\u003e\n\u003cli\u003eConfigure elastic jobs\u003c\/li\u003e\n\u003cli\u003eUse Logic Apps for database workflow\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003ePlan and implement a high availability and disaster recovery environment\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDescribe High Availability and Disaster Recovery Strategies\u003c\/li\u003e\n\u003cli\u003eDescribe recovery time objective (RTO) and recovery point objective (RPO)\u003c\/li\u003e\n\u003cli\u003eExplore high availability and disaster recovery options\u003c\/li\u003e\n\u003cli\u003eDescribe Azure high availability and disaster recovery features for Virtual Machines\u003c\/li\u003e\n\u003cli\u003eDescribe high availability and disaster recovery for PaaS deployments\u003c\/li\u003e\n\u003cli\u003eExplore high availability and disaster recovery solutions for IaaS\u003c\/li\u003e\n\u003cli\u003eDescribe hybrid solutions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eExplore IaaS and PaaS Solutions for High Availability and Disaster Recovery\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDescribe failover clusters in Windows Server\u003c\/li\u003e\n\u003cli\u003eConfigure Always On Availability Groups\u003c\/li\u003e\n\u003cli\u003eDescribe active geo-replication for Azure SQL Database\u003c\/li\u003e\n\u003cli\u003eExplore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance\u003c\/li\u003e\n\u003cli\u003eMonitor availability\u003c\/li\u003e\n\u003cli\u003eExercise: Configure geo-replication for Azure SQL Database\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eBack Up and Restore Databases\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBack up and restore SQL Server running on Azure virtual machines\u003c\/li\u003e\n\u003cli\u003eBack up a SQL Server virtual machine\u003c\/li\u003e\n\u003cli\u003eBack up and restore a database for SQL Database and SQL Managed Instance\u003c\/li\u003e\n\u003cli\u003eExercise: Backup to URL\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"268B95US \/ 2026-08-04T09:00:00 \/ Herndon, VA","offer_id":47534216970459,"sku":"US-8576-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26AB24US \/ 2026-10-27T09:00:00 \/ Herndon, VA","offer_id":48216592351451,"sku":"US-8576-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"272A92US \/ 2027-02-02T09:00:00 \/ Herndon, VA","offer_id":48216592384219,"sku":"US-8576-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"275B26US \/ 2027-05-04T09:00:00 \/ Herndon, VA","offer_id":48738855518427,"sku":"US-8576-IL","price":2512.0,"currency_code":"USD","in_stock":true}]},{"product_id":"querying-data-with-microsoft-transact-sql-training-dp-080","title":"Query and modify data with Transact-SQL Training (DP-080)","description":"\u003cdiv\u003e\n\u003cp\u003eThis course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database, Azure Synapse Analytics, and Microsoft Fabric.\u003c\/p\u003e\r\n\u003cp\u003eThis course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eQuery and modify data with Transact-SQL Training (DP-080) Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUse SQL Server query tools.\u003c\/li\u003e\n\u003cli\u003eWrite SELECT statements to retrieve columns from one or more tables.\u003c\/li\u003e\n\u003cli\u003eSort and filter selected data.\u003c\/li\u003e\n\u003cli\u003eUse built-in functions to returned data values.\u003c\/li\u003e\n\u003cli\u003eCreate groups of data and aggregate the results.\u003c\/li\u003e\n\u003cli\u003eModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eNone.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eQuery and modify data with Transact-SQL Training (DP-080) Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introduction to Transact-SQL\u003c\/h4\u003e\n\u003cp\u003eThis module provides an introduction to relational databases, the SQL language and Transact-SQL. You'll learn what kinds of statements make up the SQL language and look at the SELECT statement in detail. \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter completing this module, you'll be able to: \u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand what SQL is for \u003c\/li\u003e\n\u003cli\u003eIdentify database objects in schemas \u003c\/li\u003e\n\u003cli\u003eIdentify SQL statement types \u003c\/li\u003e\n\u003cli\u003eUse the SELECT statement \u003c\/li\u003e\n\u003cli\u003eWork with data types \u003c\/li\u003e\n\u003cli\u003eHandle NULLs \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Sort and filter results in T-SQL \u003c\/h4\u003e\n\u003cp\u003eLearn how to sort and filter query results \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter completing this module, you will be able to: \u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSort your results \u003c\/li\u003e\n\u003cli\u003eLimit the sorted results \u003c\/li\u003e\n\u003cli\u003eReturn paged results \u003c\/li\u003e\n\u003cli\u003eRemove duplicates \u003c\/li\u003e\n\u003cli\u003eFilter data with predicates \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Combine multiple tables with JOINs in T-SQL \u003c\/h4\u003e\n\u003cp\u003eExplore T-SQL queries accessing data from multiple tables with various kinds of JOIN operations. \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter completing this module, you will be able to: \u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDescribe join concepts and syntax \u003c\/li\u003e\n\u003cli\u003eWrite queries that use inner and outer joins \u003c\/li\u003e\n\u003cli\u003eWrite queries that use cross joins \u003c\/li\u003e\n\u003cli\u003eWrite queries that use self joins \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Write Subqueries in T-SQL \u003c\/h4\u003e\n\u003cp\u003eLearn how to use subqueries to combine multiple SELECT statements and compose nested queries. \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter completing this module, you will be able to: \u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand what subqueries are \u003c\/li\u003e\n\u003cli\u003eUse scalar or multi-valued subqueries \u003c\/li\u003e\n\u003cli\u003eUse self-contained or correlated subqueries \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Use built-in functions and GROUP BY in Transact-SQL \u003c\/h4\u003e\n\u003cp\u003eLearn how to use functions in Transact-SQL, and how to group aggregated results. \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter completing this module, you will be able to: \u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCategorize built-in functions \u003c\/li\u003e\n\u003cli\u003eUse scalar functions \u003c\/li\u003e\n\u003cli\u003eUse ranking and rowset functions \u003c\/li\u003e\n\u003cli\u003eUse aggregate functions \u003c\/li\u003e\n\u003cli\u003eSummarize data with GROUP BY \u003c\/li\u003e\n\u003cli\u003eFilter groups with HAVING \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Modify data with T-SQL \u003c\/h4\u003e\n\u003cp\u003eLearn how to use Transact-SQL to insert, update, and delete data in a database. \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter completing this module, you will be able to: \u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eInsert data into a table \u003c\/li\u003e\n\u003cli\u003eGenerate automatic values \u003c\/li\u003e\n\u003cli\u003eUpdate data in a table \u003c\/li\u003e\n\u003cli\u003eDelete data from a table \u003c\/li\u003e\n\u003cli\u003eMerge data based on multiple tables\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"267C44US \/ 2026-07-27T09:00:00 \/ Herndon, VA","offer_id":47534205993179,"sku":"US-8597-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"26AB35US \/ 2026-10-19T09:00:00 \/ Herndon, VA","offer_id":48216588615899,"sku":"US-8597-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"271B54US \/ 2027-01-25T09:00:00 \/ Herndon, VA","offer_id":48216588648667,"sku":"US-8597-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"274B18US \/ 2027-04-26T09:00:00 \/ Herndon, VA","offer_id":48669331718363,"sku":"US-8597-IL","price":1640.0,"currency_code":"USD","in_stock":true}]},{"product_id":"postgresql-administration-hands-on-training","title":"PostgreSQL Administration: Hands-On Training","description":"\u003cdiv\u003e\u003cp\u003eUnlock the full potential of PostgreSQL with this comprehensive three-day, instructor-led course. Designed for database administrators and IT professionals, this hands-on training equips you with the skills to install, configure, manage, and optimize PostgreSQL databases across multi-platform environments. Learn to implement robust backup and recovery strategies, enhance performance and scalability, and ensure efficient routine maintenance. Whether you're transitioning to PostgreSQL or expanding your expertise, this course provides the practical knowledge needed to thrive in today’s database landscape.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003ePostgreSQL Administration: Hands-On Training Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eGain hands-on experience installing and configuring PostgreSQL on diverse platforms, ensuring you can adapt to any environment.\u003c\/li\u003e\n\u003cli\u003eMaster the skills to efficiently manage database clusters, schemas, roles, and tablespaces, enabling seamless organization and access control.\u003c\/li\u003e\n\u003cli\u003eLearn to implement reliable backup, recovery, and disaster recovery solutions to safeguard critical data.\u003c\/li\u003e\n\u003cli\u003eDiscover techniques to optimize PostgreSQL databases for peak performance, even as workloads grow.\u003c\/li\u003e\n\u003cli\u003eAcquire tools and strategies for routine database upkeep and server performance monitoring, ensuring long-term stability and efficiency.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cb\u003eBasic Knowledge of RDBMS Concepts:\u003c\/b\u003e Familiarity with relational database principles, SQL queries, and common database objects like tables, indexes, and views.\u003c\/li\u003e\n\u003cli\u003e\n\u003cb\u003eExperience with Command-Line Tools:\u003c\/b\u003e Comfort with using command-line interfaces for database administration tasks.\u003c\/li\u003e\n\u003cli\u003e\n\u003cb\u003eUnderstanding of Operating Systems:\u003c\/b\u003e Basic experience with Linux\/UNIX and Windows operating systems, including file systems and user account management.\u003c\/li\u003e\n\u003cli\u003e\n\u003cb\u003eTechnical Background:\u003c\/b\u003e Prior experience as a database administrator or similar technical role is beneficial but not required.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eExam Information\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eLearning Tree exam included.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003ePostgreSQL Administration Training Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eLearning Objectives\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eDay 1: Foundations of PostgreSQL Administration\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eChapter 1: Course Introduction\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eOverview of course materials and agenda.\u003c\/li\u003e\n\u003cli\u003eIntroductions and expectations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 2: Installation and Configuration\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003ePostgreSQL versioning.\u003c\/li\u003e\n\u003cli\u003eInstallation on Linux\/UNIX platforms.\u003c\/li\u003e\n\u003cli\u003eBasic server configuration.\u003c\/li\u003e\n\u003cli\u003ePost-installation setup and account management.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 3: PostgreSQL Architecture\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003ePostgreSQL instance overview.\u003c\/li\u003e\n\u003cli\u003eData processing, shared memory, and directory structures.\u003c\/li\u003e\n\u003cli\u003eConfiguration files and WAL architecture.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 4: Client Applications and Database Setup\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eIntroduction to client tools (psql, pgAdmin).\u003c\/li\u003e\n\u003cli\u003eDatabase creation, configuration, and management.\u003c\/li\u003e\n\u003cli\u003eTroubleshooting common client connection issues.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eDay 2: Advanced Administration and Security\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eChapter 5: PostgreSQL Schemas\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eSchema concepts and management.\u003c\/li\u003e\n\u003cli\u003eInformation and system catalog schemas.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 6: Role Management\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eRole creation, attributes, and membership.\u003c\/li\u003e\n\u003cli\u003eTroubleshooting role access issues.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 7: Fine-Grained Access Control\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eGrant and revoke commands.\u003c\/li\u003e\n\u003cli\u003eManaging column-level permissions and schema privileges.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 8: Index Creation and Management\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eIndex types and best practices.\u003c\/li\u003e\n\u003cli\u003ePartial, unique, and multi-column indexes.\u003c\/li\u003e\n\u003cli\u003eReindexing and maintaining indexes efficiently.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 9: Transactions and Concurrency\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eTransaction properties and isolation levels.\u003c\/li\u003e\n\u003cli\u003eMulti-version concurrency control.\u003c\/li\u003e\n\u003cli\u003eDeadlock detection and advisory locks.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eDay 3: Optimisation, Maintenance, and Recovery\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eChapter 10: Database Structure and Tablespaces\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003ePhysical storage layout.\u003c\/li\u003e\n\u003cli\u003eCreating and managing tablespaces.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 11: Logging and Extensions\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eConfiguring PostgreSQL logging.\u003c\/li\u003e\n\u003cli\u003eInstalling and managing extensions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 12: Backup and Recovery\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eMethods for database backup and restore.\u003c\/li\u003e\n\u003cli\u003epg_dump, pg_restore, and point-in-time recovery.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 13: Query Optimisation and Performance Tuning\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eUsing EXPLAIN and ANALYZE to optimise queries.\u003c\/li\u003e\n\u003cli\u003eIndex and query planner statistics.\u003c\/li\u003e\n\u003cli\u003eMemory settings and performance tuning parameters.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 14: Routine Maintenance and Monitoring\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eConfiguring autovacuum and routine cleanup tasks.\u003c\/li\u003e\n\u003cli\u003eMonitoring activities and statistics.\u003c\/li\u003e\n\u003cli\u003eEfficiently populating databases.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267B64US \/ 2026-07-29T09:00:00 \/ Herndon, VA","offer_id":47534202781915,"sku":"US-2112-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AA51US \/ 2026-10-28T09:00:00 \/ Herndon, VA","offer_id":48216558665947,"sku":"US-2112-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271A39US \/ 2027-01-27T09:00:00 \/ Herndon, VA","offer_id":48216558698715,"sku":"US-2112-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274A27US \/ 2027-04-28T09:00:00 \/ Herndon, VA","offer_id":48696372592859,"sku":"US-2112-IL","price":2228.0,"currency_code":"USD","in_stock":true}]},{"product_id":"build-ai-apps-with-azure-database-for-postgresql-ai-3019","title":"Build AI Apps with Azure Database for PostgreSQL (AI-3019)","description":"\u003cdiv\u003e\u003cp\u003eDiscover how to integrate Azure AI and Azure Machine Learning Services with Azure Database for PostgreSQL - Flexible Server to create cutting-edge AI-powered applications. This course covers practical techniques for leveraging Azure AI extensions to build apps with generative AI capabilities, semantic search, summarization, sentiment analysis, translation, and more.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eBuild AI Apps with Azure Database for PostgreSQL (AI-3019) Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuild innovative, AI-driven applications.\u003c\/li\u003e\n\u003cli\u003eLeverage Azure's advanced AI and ML tools.\u003c\/li\u003e\n\u003cli\u003eGain practical experience through hands-on exercises.\u003c\/li\u003e\n\u003cli\u003eAchieve intermediate-level proficiency in AI with PostgreSQL.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExperience with PostgreSQL databases.\u003c\/li\u003e\n\u003cli\u003eProficiency in writing SQL queries.\u003c\/li\u003e\n\u003cli\u003eBasic understanding of AI and Machine Learning concepts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eBuild AI Apps with Azure Database for PostgreSQL Training Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eLearning Objectives\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eGet Started with Generative AI in Azure Database for PostgreSQL\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eUnderstand generative AI language models.\u003c\/li\u003e\n\u003cli\u003eExplore schemas and AI extensions for integration.\u003c\/li\u003e\n\u003cli\u003eHands-on: Use Azure AI extensions for practical generative AI applications.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eEnable Semantic Search in Azure Database for PostgreSQL\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eLearn about vector embeddings and vector similarity.\u003c\/li\u003e\n\u003cli\u003eBuild semantic search functionalities using AI and PostgreSQL.\u003c\/li\u003e\n\u003cli\u003eHands-on: Create search and recommendation systems.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eSummarize Data with Azure AI Services\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eExplore extractive and abstractive summarization.\u003c\/li\u003e\n\u003cli\u003eLearn to condense complex content into summaries.\u003c\/li\u003e\n\u003cli\u003eHands-on: Apply summarization techniques with Azure AI.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003ePerform Sentiment Analysis and Opinion Mining\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eUse Azure AI to analyze sentiment and mine opinions.\u003c\/li\u003e\n\u003cli\u003eExtract actionable insights from textual data.\u003c\/li\u003e\n\u003cli\u003eHands-on: Perform sentiment analysis with Azure tools.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eExtract Insights Using Azure AI Language\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDive into key phrase extraction and entity recognition.\u003c\/li\u003e\n\u003cli\u003eRecognize and redact PII using Azure Database for PostgreSQL.\u003c\/li\u003e\n\u003cli\u003eHands-on: Extract insights with Azure AI Language services.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eTranslate Text with Azure AI Translator\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eTranslate PostgreSQL data into multiple languages.\u003c\/li\u003e\n\u003cli\u003eHands-on: Use Azure AI Translator for multilingual solutions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eUse Azure Machine Learning for Inferencing\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eTrain and deploy ML models with Azure ML.\u003c\/li\u003e\n\u003cli\u003eLearn inferencing techniques directly from PostgreSQL.\u003c\/li\u003e\n\u003cli\u003eHands-on: Perform automated machine learning and inference.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"267B18US \/ 2026-07-14T09:00:00 \/ Online","offer_id":47534202847451,"sku":"US-8729-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26AB98US \/ 2026-10-15T09:00:00 \/ Online","offer_id":48216576819419,"sku":"US-8729-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"271C43US \/ 2027-01-13T09:00:00 \/ Online","offer_id":48216576852187,"sku":"US-8729-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"274B92US \/ 2027-04-13T09:00:00 \/ Online","offer_id":48588043223259,"sku":"US-8729-IL","price":716.0,"currency_code":"USD","in_stock":true}]},{"product_id":"configure-and-migrate-to-azure-database-for-postgresql-dp-3021","title":"Configure and migrate to Azure Database for PostgreSQL (DP-3021)","description":"\u003cdiv\u003e\u003cp\u003eAzure Database for PostgreSQL is a robust Platform as a Service (PaaS) offering from Microsoft, built on the open-source PostgreSQL database. This course equips you to explore PostgreSQL architecture, configure and secure your database, optimize performance, and migrate data effectively to Azure Database for PostgreSQL Flexible Server. Learn essential skills like query tuning, concurrency management, and leveraging PostgreSQL's built-in features to enhance your database management experience.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eConfigure and migrate to Azure Database for PostgreSQL (DP-3021) Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eGain practical skills to configure and manage Azure Database for PostgreSQL.\u003c\/li\u003e\n\u003cli\u003eUnderstand PostgreSQL architecture and advanced features like multi-version concurrency control (MVCC).\u003c\/li\u003e\n\u003cli\u003eLearn to optimize query performance and implement security best practices.\u003c\/li\u003e\n\u003cli\u003eExplore hands-on data migration techniques, including online and offline methods.\u003c\/li\u003e\n\u003cli\u003eMaster advanced features like write-ahead logging, stored procedures, and tuning tools for efficient database operations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eFamiliarity with relational databases\u003c\/li\u003e\n\u003cli\u003eBasic understanding of SQL\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eConfigure and Migrate to Azure Database for PostgreSQL Training Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eLearning Objectives\u003c\/h4\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eExplore PostgreSQL Architecture\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eOverview of Azure Database for PostgreSQL.\u003c\/li\u003e\n\u003cli\u003eUnderstand architecture and shared memory.\u003c\/li\u003e\n\u003cli\u003eHands-on: Explore PostgreSQL on Azure.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eClient-Server Communication\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eConnection handling and PostgreSQL client tools.\u003c\/li\u003e\n\u003cli\u003eExercise: Utilize PostgreSQL client tools.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eQuery Processing\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eComponents of query processing and the EXPLAIN statement.\u003c\/li\u003e\n\u003cli\u003eExercise: Analyze queries with EXPLAIN.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eSecure Azure Database for PostgreSQL\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEncryption, authentication, and role-based permissions.\u003c\/li\u003e\n\u003cli\u003eExercise: Configure database permissions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eStored Procedures and Functions\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCreate reusable stored procedures and functions.\u003c\/li\u003e\n\u003cli\u003eExercise: Implement stored procedures in PostgreSQL.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eWrite-Ahead Logging\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand ACID compliance and logical decoding.\u003c\/li\u003e\n\u003cli\u003eExercise: List table changes using logical decoding.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eConfigure and Manage PostgreSQL\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSystem catalogs, metadata, and autovacuum configuration.\u003c\/li\u003e\n\u003cli\u003eExercise: Optimize database configurations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eConcurrency Management\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMulti-version concurrency control (MVCC), isolation levels, and locking.\u003c\/li\u003e\n\u003cli\u003eExercise: Explore locking mechanisms.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eQuery Tuning\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eQuery performance metrics and the Query Store.\u003c\/li\u003e\n\u003cli\u003eExercise: Assess and optimize queries.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eMigrate to Azure Database for PostgreSQL\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCompare online vs. offline migration methods.\u003c\/li\u003e\n\u003cli\u003eExercises: Perform online and offline migrations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"267B38US \/ 2026-07-20T09:00:00 \/ Online","offer_id":47534203076827,"sku":"US-8734-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26AC01US \/ 2026-10-19T09:00:00 \/ Online","offer_id":48216578621659,"sku":"US-8734-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"271C46US \/ 2027-01-22T09:00:00 \/ Online","offer_id":48216578654427,"sku":"US-8734-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"274B95US \/ 2027-04-21T09:00:00 \/ Online","offer_id":48619713003739,"sku":"US-8734-IL","price":716.0,"currency_code":"USD","in_stock":true}]},{"product_id":"develop-data-driven-applications-by-using-azure-sql-database-dp-3020","title":"Develop data-driven applications by using Azure SQL Database (DP-3020)","description":"\u003cdiv\u003e\u003cp\u003eThis hands-on course teaches developers and solution architects how to build, deploy, and secure data-driven applications using Azure SQL Database. Learn how to create and configure databases, automate deployment with CI\/CD pipelines, and develop APIs using Azure services. Gain practical experience in data manipulation, security best practices, and integrating external data sources to enhance your application’s performance and resilience.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eDevelop data-driven applications by using Azure SQL Database (DP-3020) Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLearn to develop and deploy cloud-based applications using Azure SQL Database.\u003c\/li\u003e\n\u003cli\u003eAutomate database publishing with GitHub Actions and Azure DevOps.\u003c\/li\u003e\n\u003cli\u003eCreate REST and GraphQL-based APIs with Azure Data API Builder.\u003c\/li\u003e\n\u003cli\u003eImport and export data using RESTful endpoints and Azure Functions.\u003c\/li\u003e\n\u003cli\u003eImplement security best practices, including authentication, managed identities, and advanced data security.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExperience using the Azure portal to create resources.\u003c\/li\u003e\n\u003cli\u003eBasic knowledge of security concepts like identities, permissions, and encryption.\u003c\/li\u003e\n\u003cli\u003eBasic knowledge of networking concepts like virtual networks, subnetting, and hybrid scenarios.\u003c\/li\u003e\n\u003cli\u003eBasic knowledge of Azure Policy and Azure Arc concepts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eDevelop Data-Driven Apps with Azure SQL Training Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eLearning Objectives\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eModule 1: Get Started with Azure SQL Database for Modern Application Development\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eOverview of deployment options and Hyperscale capabilities.\u003c\/li\u003e\n\u003cli\u003eUnderstanding the serverless compute tier.\u003c\/li\u003e\n\u003cli\u003eEnabling application resilience with Azure SQL Database.\u003c\/li\u003e\n\u003cli\u003eExploring AI capabilities for Azure SQL Database.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eModule 2: Develop for Azure SQL Database\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eCreating and configuring an Azure SQL Database.\u003c\/li\u003e\n\u003cli\u003eUsing SQL Database Projects for development.\u003c\/li\u003e\n\u003cli\u003eAutomating database deployment with GitHub Actions and Azure DevOps.\u003c\/li\u003e\n\u003cli\u003eSecuring and monitoring CI\/CD pipelines.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eModule 3: Develop a Data API for Azure SQL Database\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eIntroduction to Azure Data API Builder for REST and GraphQL endpoints.\u003c\/li\u003e\n\u003cli\u003eDeveloping a data API using Azure Static Web Apps.\u003c\/li\u003e\n\u003cli\u003eDeploying a data API with Azure Web App for Containers.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eModule 4: Explore Data Manipulation Options in Azure SQL Database\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eImporting data using RESTful endpoints.\u003c\/li\u003e\n\u003cli\u003eManipulating data with Azure Functions.\u003c\/li\u003e\n\u003cli\u003eExploring data movement tools for automation and integration.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eModule 5: Explore Security Practices for Azure SQL Database\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eAuthentication methods and configuring managed identities.\u003c\/li\u003e\n\u003cli\u003eImplementing firewall rules and advanced data security.\u003c\/li\u003e\n\u003cli\u003eSecuring access and monitoring database security threats. \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"267B40US \/ 2026-07-02T09:00:00 \/ Online","offer_id":47534198948059,"sku":"US-8740-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26AA12US \/ 2026-10-02T09:00:00 \/ Online","offer_id":47640581767387,"sku":"US-8740-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"271C48US \/ 2027-01-07T09:00:00 \/ Online","offer_id":48216579145947,"sku":"US-8740-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"274B97US \/ 2027-04-02T09:00:00 \/ Online","offer_id":48540679209179,"sku":"US-8740-IL","price":716.0,"currency_code":"USD","in_stock":true}]}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0691\/4143\/0491\/collections\/yp9Q1XtROGNNZqM3NY86_35708573-5f11-409c-ab54-b9325ddb8e03.webp?v=1780655622","url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/collections\/databases.oembed","provider":"Learning Tree International","version":"1.0","type":"link"}