- Please find Session 1 folder.
- There will be 3 files where you can check the DB Schema, DB Sample Data, DB Queries.
- MSSQL Server
Q1 -
Q2 -
- Please find Session 3 folder.
- First Challenge:
- Retrieve data from open source api https://www.programmableweb.com/api/truthy-osome-rest-api and write the data to a suitable location so it can be used for reporting. The data should be modelled in such a way that it is easy for a user to access.
- Second Challenge:
- Create a solution that crawls for articles for articles from a news website (e.g. https://www.bbc.co.uk/ or https://www.theguardian.com/uk/london), cleanses the responses and then stores the data responses in a SQLLite database. You should look to scrap info reading at least 100 articles and the data stored in the SQL Lite database should contain the article title, text, date of article and source URL.
- The image below shows the SQLite database populated with all the information taken from the Guardian main page.
