The Complete SQL Bootcamp for Data Analysis – Level 1

The Complete SQL Bootcamp for Data Analysis – Level 1, available at $59.99, has an average rating of 4.25, with 31 lectures, 3 quizzes, based on 24 reviews, and has 2525 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone interested in learning about data analysis with SQL It is particularly useful for Anyone interested in learning about data analysis with SQL.

Enroll now: The Complete SQL Bootcamp for Data Analysis – Level 1

Summary

Title: The Complete SQL Bootcamp for Data Analysis – Level 1

Price: $59.99

Average Rating: 4.25

Number of Lectures: 31

Number of Quizzes: 3

Number of Published Lectures: 31

Number of Published Quizzes: 3

Number of Curriculum Items: 34

Number of Published Curriculum Objects: 34

Original Price: $129.99

Quality Status: approved

Status: Live

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

Who Should Attend

Anyone interested in learning about data analysis with SQL

Target Audiences

Anyone interested in learning about data analysis with SQL

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.

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!

Course Curriculum

Chapter 1: Getting Started!

Lecture 1: Welcome to Level 1!

Lecture 2: Our Learning Objectives

Lecture 3: DB Installation

Chapter 2: Databases – Terminology Overview

Lecture 1: Overview – Database, DBMS, SQL

Lecture 2: Tables, Columns, Rows

Lecture 3: Primary and Foreign Keys

Lecture 4: Relational Model, ER Diagram

Lecture 5: Schema, Metadata, Data Dictionary

Lecture 6: Null Values

Lecture 7: Indexes

Lecture 8: Partitions

Chapter 3: SQL – Creating Databases, Schemas and Tables

Lecture 1: Overview

Lecture 2: Creating – Database and Schema

Lecture 3: Creating Tables – Introduction

Lecture 4: Creating Tables – Constraints

Lecture 5: Inserting Data

Lecture 6: Update and Delete

Chapter 4: SQL – Retrieving Data with Queries

Lecture 1: Overview

Lecture 2: Query Data (SELECT)

Lecture 3: Filtering Conditions (WHERE) – Part 1

Lecture 4: Filtering Conditions (WHERE) – Part 2

Lecture 5: Alias for Tables and Columns

Lecture 6: Searching Patterns (Wildcards)

Lecture 7: Distinct Values (DISTINCT)

Lecture 8: Sorting Rows (ORDER BY)

Lecture 9: Grouping Rows (GROUP BY and HAVING)

Lecture 10: Data-Type Conversions (CAST)

Lecture 11: Database Dictionary

Chapter 5: Course Summary

Lecture 1: Let’s Recap!

Lecture 2: Level 1 – Final Project

Lecture 3: *** BONUS ***

Instructors

Idan Gabrieli
Online Teacher | Data, Cloud, AI

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 2 votes

4 stars: 13 votes

5 stars: 9 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!