Data Analytics - SQL Lesson 00 - Course Overview.pptx

SQL

1. Structured Query Language (SQL) Course Overview

2. Course Objectives Understand Relational Database Management Systems (RDBMS) with a popular RDBMS, i.e., MySQL Learn to install MySQL and leverage tools to import and export databases and tabular data Be able to perform Create, Read, Update and Delete (CRUD) operations on RDBMS with Structured Query Language (SQL) Learn to combine multiple tables and perform data analytics for deriving insights from data Develop high-level understanding about NoSQL databases

3. Course Pre-requisites NO specific pre-requisites SQL is a declarative language and can be learnt easily It is important to develop good understanding of database concepts

4. Topics Covered Introduction to Databases Introduction to SQL Installation of MySQL Server and MySQL Workbench Basics of SQL – DDL and DML Statements Modifying Database Structures Importing and Exporting Data Data Analytics Working with Multiple Tables Advance SQL – OLAP, Indexing, Built-in functions, etc. SQL vs NoSQL

5. Queries?