SQL Database DB201
Home
|
DB201
Chapter 1
Chapter 1 Exercises
Chapter 2
Chapter 2 Questions
Chapter 2 Exercises
Chapter 3
Chapter 3 Questions
Chapter 3 Exercises
Chapter 4
Chapter 4 Questions
Chapter 4 Exercises
Chapter 6
Chapter 5 Questions
Chapter 5 Exercises
Chapter 6
Chapter 6 Questions
Chapter 6 Exercises
Final Project
Final Project ERD
Contains All Entries and Attributes
Tables and Fields displayed
Primary Keys indicated by underlines
A select all view of all tables
Players Table
Player Characters
NPC Table
NPC Zones Table
A select where statement that returns Players and Characters without an active subscription
A select where characters with active descriptions are ordered by level
A count showing the total number of player characters in the system
A select using distinct to show players with characters without duplicate player numbers
A delete command to delete all the URBAN type NPC Zones
A rollback of the previous command
An Inner Join showing player names and levels
Back to
Classes Index
or
Email Feedback
