Duration
3 days
Course Overview
This is an introductory course on Databases and SQL Querying. There are no pre-requisities for this course. If you are looking to get acquainted with the concept of Databases and Queries for maybe your next interview as an analyst, this is the right course for you. All you need is a windows machine and we will walk through step by step, right from setting up your environment to creating your first table to writing your first query. This course is structured in a way that you can follow along with me. At the end of this course, you should be comfortable writing simple queries including queries related to Dates, String manipulation, Aggregation etc.
Introduction
- Choosing a GUI
- Connecting to our Database
- Connection Properties
Database Creation
- Database Tables Explained
- Creating a Database Table
- Inserting Records
- Exercise: Inserting Records
Data Manipulations I
- Data Types
- Dropping a Table
- Start Querying your data using SELECT
- Counting Records
- Previewing your records
Data Manipulations II
- Filtering records and numeric data types
- Filtering records using Greater Than operator
- Filtering records using Less Than operator
- Using the BETWEEN condition
- Counting a subset of records
Data Manipulations III
- Intro to AND
- Using the OR condition
- Sorting data with ORDER BY
- Ordering by ordinal column
- The LIKE operator
- The NOT LIKE operator
- THE IN operator
- Using MIN and MAX
- Rounding and other Arithmetic
Programme scope, delivery arrangements and suitability are confirmed during enquiry.