|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
This course will focus on how to design databases that fit business requirements and make software construction easier. Participants will learn data integrity, null values, keys, table relationships (one-to-one, one-to-many, and many-to-many) and data types and learn the process designers should follow in building a new database or improving an existing one. They will also be able to explain relational database concepts. Instructional materials are included. Schedule
This class is an overview of SQL database systems and concepts. Participants will learn unique aspects of relational databases, understand SQL components including basic objects, data types, and predicates, study the Data Definition Languages of SQL, practice a variety of database query elements, including SELECT, WHERE, IN, LIKE, EXISTS, FROM, GROUP BY, HAVING, ORDER BY, JOIN and others. Schedule
|
|
|
|
|
| | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|---|