IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Group Home

WEEKLYLESSON
Week 30 Lesson◄╣

MY
GROUPSETTINGS
-Collapse +Expand DBA Store
PRESTWOODSTORE
   ► All GroupsDBA Group   Print This    All Groups  

Weekly DBA Lesson

Week 30, Posted Monday 7/26/2021

Content changes every Monday @ 1AM!! Check back once per week. Learn! Review! Test Yourself!

Weekly DBA Lesson

[Print Lesson]

Week 30, Posted Monday 7/26/2021

Content changes every Monday @ 1AM!! Check back once per week. Learn! Review! Test Yourself!

FAQ of the Week
Question: Is there a way to reverse order a select statement?

Answer:

Yes. Use the DESC keyword in your order by clause on each column you want ordered descending. Use ASC for ascending.

select * from Customer 
Order by Age Desc, City Asc, State Asc
Tip of the Week
Tip: The three normal forms can be summed up in the following phrase: “All the fields of a table should relate to the key, the whole key, and nothing but the key.”
Definition of the Week
Master Table:  A master table in a multitable relationship is the primary table. For every record in the master table, there can be many records in the detail table. If you are only dealing with one table, then it is the master table. A detail table in a multitable relationship is the table whose records are subordinate to those of the master table. A detail table is also called a slave table, a child table, or a many table.
Link of the Week
Windows Virtualization List of resources provided by Microsoft about Windows Virtualization which was introduced with Vista.
File of the Week
Oracle Berkely DB XML

Lastest DBA Flashcard

Our flashcards are part of our library of tidbits.

Tidbits are FAQs, Definitions, Tips, and Code Snippets from our knowledge base.

Tip: theglobalreviews
Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


©1995-2021 Prestwood IT Solutions.   [Security & Privacy]