Introduction to Databases
- Know the basics of relational algebra.
- Be able to use the SQL language to write queries.
- To have skills in building relationships between relational tables.
- Able to check the normalization of tables, bring the database to normal form. Able to formulate the result of query execution in the language of relational algebra.
- Able to form relationships between tables. Able to select the required fields in the final report. Able to use filters, sorting, aggregation and window functions. Selects a time-efficient way to write a query.
- Relational algebraTheme 1. Data types. The keys. The integrity of tables and data. Theme 2. Normalization of tables. Theme 3. Relations between tables.
- SQLTheme 4. Basic SQL syntax. Theme 5. Data aggregation and aggregation functions. Theme 6. Window functions. Theme 7. Subqueries and submissions.
- Batra, R. (2018). SQL Primer : An Accelerated Introduction to SQL Basics. New York: Apress. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1833706
- Rockoff, L. (2017). The Language of SQL (Vol. Second edition). Hoboken, NJ: Addison-Wesley Professional. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1601663
- Harrison, G. (2015). Next Generation Databases : NoSQLand Big Data. [Berkeley, California]: Apress. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1170316