SQL Advanced Techniques 1 - May 2021

-

About this Event

Designed to expand beyond the learner's basic knowledge of SQL to leverage the functionality of their Oracle database and develop custom Argos applications. The learner will create custom functions and tables on the database using inserts, deletes and updates. Attendees will work on guided exercises throughout the class to apply the concepts in both SQL Developer and Argos. (This is part 1 of a 4-part class.)

 

Audience

Employees with a good grounding in how to create basic SQL and are looking to expand their knowledge to optimize SQL and leverage Oracle functionality to create custom functions and tables. This class does not cover basics of SELECT, FROM, WHERE.

 

Prerequisites

Completed Argos Advanced – DataBlock Designer training (or have similar familiarity with the tool).

Strong novice, with a good understanding of basic SELECT FROM WHERE statement and joins.

Attendees will also need:

• Strong internet connection

• Dual monitors

• Headset (for better audio and interaction)

• Once registered, print out all materials sent by trainer

 

Agenda

SQL Advanced Techniques (Part 1) Training is conducted remotely over three days.

The general agenda is as follows:

SQL Advanced Techniques (Part 1) Training

Days 1-3 (5 hrs. each day, 11:00am-4:00pm ET)

• Database concepts

• Alias and Data Dictionary

• Field security in Visual Designer

• Call Oracle functions in the select and where clause: upper, to_date, to_char, between, sysdate,

• Call a Banner function in the SELECT and WHERE clause

• Use the Object Source DataBlock to find a function and use it correctly

• Identify when to use a case statement

• Use a case order in a dropdown box

 Date and Time

Fri, May 7, 2021, 1:30 AM IST

 Fee : $1,000

Registration :  sql-advanced-techniques-1

Comments

Post a Comment

Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You

Popular Posts

Failed to execute the package or element. Build errors were encountered

-
Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element.   Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------   Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package
Read more

Exception deserializing the package "The process cannot access the file because it is being used by another process."

-
TITLE: Microsoft Visual Studio ------------------------------ Failed to start project ------------------------------ ADDITIONAL INFORMATION: Exception deserializing the package "The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process.". (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ While running SSIS package i got the error “The process cannot access the file ‘*.ispac’ because it is being used by another process”. I tried to close SSDT and run it again but, I still got the same error while compiling. Then, after searching over internet, I got
Read more

Temporary enable and disable SSRS subscriptions

-
--Code Snippet --To Check Subscription Status. USE ReportServer GO SELECT dbo . Subscriptions . Description ,        dbo . [Catalog] . Name ,        dbo . Users . UserName ,        InactiveFlags FROM dbo . Subscriptions      INNER JOIN dbo . [Catalog]      ON dbo . Subscriptions . Report_OID = dbo . [Catalog] . ItemID      INNER JOIN dbo . Users      ON dbo . Subscriptions . OwnerID = dbo . Users . UserID --Temporary disables subscriptions while data warehouse is unavailable UPDATE dbo . Subscriptions SET InactiveFlags = 1 GO --After this you can find, all the subscription where disabled until you again enable it. --Again enable subscriptions. UPDATE dbo . Subscriptions SET InactiveFlags = 0 GO
Read more