Database and SQL for Beginners

About this course

This course covers the following topics:What is a DatabaseDBMS and RDBMSRelational Database Terminology - Primary key, Foreign key etc.Structured Query Language (SQL)Types of SQL commands - DDL, DCL, DML and QueryHow to use SQLite Database SystemHow to install SQLite Studio and use it to create SQLite Database and interact with itDesigning and creating TablesConstraints and Data Integrity - how to implement integrity rulesQuerying data using SELECT commandProjection - selecting a few columnsSelection - selecting a few rowsORDER BY clause and how to order by multiple columns SQL Operators - BETWEEN .. AND, IN and LIKE Manipulating data using INSERT, DELETE and UPDATE commandsTransaction Management - COMMIT and ROLLBACKWhat is a function and how to use it in SQL commandsHow to use Numeric functionsHow to use String function to process stringsHow to use DateTime functions How to use Miscellaneous functions to deal with null valuesHow to use Group functions to get aggregatesGrouping data using GROUP BY clauseSelecting rows and then grouping them Using HAVING clause to select groupsJoining tablesUsing NATURAL JOIN and JOIN clausesHow to use outer joinSubqueriesUsing subqueries in DML and DDLNested and multiple subqueriesCorrelated SubqueryHow to use Join, Subquery and Grouping togetherWhat is a viewWhere view is needed and its advantagesHow to create a view and use itWhat is an Index<

Course objectives

• teach the basics of database systems
• provide practical experience with SQL
• enable participants to manage and retrieve data effectively