Home / Course catalog / Database Design & SQL Programming (9007310)

Computer Science → Data

Database Design & SQL Programming (9007310)


Description
Data is the foundation for any successful business. Organizations have a need to keep track of customer information, sales, student grades, inventory, etc. And databases are a critical piece to any software application. In this course we will walk thru the concepts of databases and data in general. We will also use a MySQL database to build a small sports stats database using the Structured Query Language (SQL).
Content
  • Introduction to Databases
  • Data and Databases
  • Register for JetBrains Account
  • Installing DataGrip
  • EXERCISE : Show DataGrip Application
  • Loading Sample Content
  • Overview of DataGrip IDE
  • EXERCISE: Import Academy Database
  • Introduction to SQL
  • SQL Select Values
  • EXERCISE: Using SQL to Select Data
  • SQL INsert
  • SQL Insert Statements
  • EXERCISE: Using SQL to add more data
  • SQL Insert with Columns
  • EXERCISE: INSERT Multiple Values
  • Conditional Selection
  • SQL WHERE with Words
  • Exercise : Select student records
  • SQL Multiple Conditions
  • EXERCISE : Select by school and name
  • SQL Count
  • SQL Count Function
  • EXERCISE : Count the number of students
  • EXERCISE : Count the number of black students
  • SQL SUM
  • SQL Sum Function
  • EXERCISE : Select the sum all the math scores
  • EXERCISE : Select the sum of math scores for black students
  • EXERCISE : Select the sum all the reading scores
  • EXERCISE : Select the sum of reading scores for black students
  • Exam
  • Database Structure
  • EXERCISE: Create a Student Table
  • Sort and OrderBy
  • Sorting Results
  • Table Relationships
  • Joining Tables
  • Wrap Up
  • Final Test
  • Conclusion
Completion rules
  • All units must be completed
  • Leads to a certification with a duration: Forever