Real Views: 13
Rate this article:
Useful DNN SQL Commands — The Gorilla Learning Lab (#4)In this episode of The Gorilla Learning Lab, Chris Behling shows us some helpful ways to utilize the DNN SQL Console.
Check out the rest of our Gorilla Learning Lab videos here:
https://youtube.com/playlist?list=PLiVOtnTcreYCdaG0vkVvZcB9cJ2S1SlfF&si=ta_Dt4nhDfAWUxrl
10 Pound Gorilla is a United States-based website development, design, & digital marketing firm leading the industry in innovation and delivering top-notch solutions since 2003. Often referred to as the Navy Seals of Web Development, 10 Pound Gorilla's elite team of designers and developers create websites and applications optimized to increase conversions and mainstream business processes. Their full-circle marketing strategies focus on driving traffic, engaging visitors, generating leads, and increasing ROI.
Visit our website:
https://10poundgorilla.com/
0:00 Intro
0:55 What it is
2:12 Caution
5:05 Exporting the Results
5:45 Saving a Query
7:02 Base Tables vs Views
8:33 Investigating: Information_schema.tables
10:44 Use to Perform QA Testing
11:34 Example: Export all Email Addresses
13:34 Example: Portal Data Sync
15:17 Tinkering: Thank-You Google
16:10 Example: Skin & Layout Files
17:30 Example: Containers Usage
17:55 Example: EDN Category Audit
19:30 Example: Find and Replace
20:38 Tips & Takeaways
Link to original article