Web #2: Database

  1. Introduction
    • Don't expect to see DBAs. You can't build applications without knowing database.
    • What is a database? Collection of data
    • It's also about storing and finding data. Efficiently!
  2. Working with data, such as data analysis, is one of the biggest job market in computer industry. Why?
    • Business IntelligenceUsing data to make smarter decisions for your company.
    • There's data in everything we do. Every company wants to know how they're doing.
  3. Let's talk about databases for a moment.
    • What is SQL?
    • What is a table, view and stored procedure?
    • When you search for data in a database, you don't have to worry about which algorithm to use.
    • It's bad design to have all data in one table. So what is normalizationReducing data redundancy.?
  4. Data Structures vs. DatabaseData structure is in memory. After pulling data from a db, you store it in a data structure. Database is raw data stored in a server.
  5. Different types of databases
    • Microsoft Excel. Not really a database, but it's an early way we learned to store data.
    • MySQLOpen-source, free.
    • Microsoft SQL ServerThis is the database we'll use in future examples. / Azure SQL
    • Amazon AWS / S3Amazon's Simple Storage Solution. Store pictures, data in flat files, etc. We will not cover this.
    • And more...
  6. Here's a sample querySyntax for retrieving data. to get data from a SQL Server database:
    SELECT * FROM SongTable
    WHERE Singer LIKE '%Taylor Swift%'
    ORDER BY Title
  7. Let's open SQL Server and start pulling data.
  8. Create a simple Employee database.
    • You'll need to download SQL Server (SSMS). What is thisFree software that can connect and manage "real" databases.?
    • What should the tables and fields be?
  9. Go to the next lesson - MVC with data