• Post category:StudyBullet-17
  • Reading time:6 mins read

The Complete SQL Bootcamp for Data Analysis – Level 1
Learn SQL A-to-Z for Data Analysis Projects

What you will learn

Use SQL to query data in databases

Perform data analysis and extract useful insights

Install and use PostgresSQL

Create database objects – databases, schemas and tables

Load datasets from external CSV files

Query data with various types of filtering conditions

Explore and count distinct values across the dataset

Aggregate rows into groups

Description

Data is Everywhere

It is not a secret that data is everywhere; data is collected, processed, and accumulated in massive databases across all industry domains. As the technologies for handling data are evolving rapidly, the industry challenge is more focused on data utilization than data collection and storage. As a result, many organizations are looking for the right mix of people, tools, and products to help them pick up those piles of data, extract valuable insights and constantly gain market advantage.

Becoming an SQL Wizard

SQL is the most popular language to extract, load, and query data from databases. If you master SQL, you gain the amazing and useful flexibility to explore, filter and aggregate almost any raw data in multiple dimensions. SQL Wizards are needed everywhere.


Get Instant Notification of New Courses on our Telegram channel.


Level 1 – We are starting from scratch!

The complete training program is divided into multiple sequential levels to let you grow your knowledge and understanding of SQL and data analysis. This level, level one is designed to kick off your knowledge about SQL and learn to perform various data analysis tasks:

  • Understand the industry terminology of SQL and databases
  • Learn and practice the SQL syntax in step by step
  • Create and load data into databases, schemas, and tables
  • Analyze data using various filtering conditions and search patterns
  • Explore and count distinct values across the dataset attributes
  • Group rows and perform a calculation using aggregation functions
  • Use alias for columns and tables
  • And more

We will use quizzes and exercises to practice and sharpen your understanding of the learning objectives. In any case, I am here for any questions.

I wish you AWESOME learning and hope to see you inside!

English
language

Content

Getting Started!

Welcome to Level 1!
Our Learning Objectives
DB Installation

Databases – Terminology Overview

Overview – Database, DBMS, SQL
Tables, Columns, Rows
Primary and Foreign Keys
Relational Model, ER Diagram
Schema, Metadata, Data Dictionary
Null Values
Indexes
Partitions
Quiz #1 – Database Terminology

SQL – Creating Databases, Schemas and Tables

Overview
Creating – Database and Schema
Creating Tables – Introduction
Creating Tables – Constraints
Inserting Data
Update and Delete
Quiz #2 – Creating Databases, Schemas and Tables

SQL – Retrieving Data with Queries

Overview
Query Data (SELECT)
Filtering Conditions (WHERE) – Part 1
Filtering Conditions (WHERE) – Part 2
Alias for Tables and Columns
Searching Patterns (Wildcards)
Distinct Values (DISTINCT)
Sorting Rows (ORDER BY)
Grouping Rows (GROUP BY and HAVING)
Data-Type Conversions (CAST)
Database Dictionary
Quiz #3 – Retrieving Data with Queries

Course Summary

Let’s Recap!
Level 1 – Final Project
*** BONUS ***