SQL Beginner to Advanced For Data Professionals

4.8 /5

(8 Ratings)

Offered byCode Basics

SQL Beginner to Advanced For Data Professionals
at
Code Basics
Overview

From Novice to Pro. Comprehensive Guide for Data Experts to Excel in SQL Querying and Database Management

Duration	11 hours
Total fee	₹900
Mode of learning	Online
Official Website	Go to Website
Credential	Certificate

SQL Beginner to Advanced For Data Professionals

Table of contents

Overview
Highlights
Course Details
Curriculum
Faculty
+ 1 more item

SQL Beginner to Advanced For Data Professionals
at
Code Basics
Highlights

Earn a certification after completion

SQL Beginner to Advanced For Data Professionals
at
Code Basics
Course details

Skills you will learn

Excel OLAP NoSQL Database management Linux MySQL

Who should do this course?

Individuals new to SQL and database management

What are the course deliverables?

SQL Basics (SELECT, WHERE, BETWEEN, GROUP BY, ORDER BY, etc.)
Joins (LEFT, RIGHT, INNER, FULL, CROSS)
Subqueries, CTEs, Views, Temporary Tables
Fundamentals of ETL, Data Warehouse, OLAP, OLTP
User Defined Functions, Stored Procedures
Window Functions (Over, ROW_NUMBER, RANK, DENSE_RANK, etc.)

More about this course

Beginners to Advanced SQL course for those preparing for a data career (data analyst, data scientist, or data engineer)
This course is carefully curated to simulate real-time organizational experience to prepare you for the current job market and at the same time provides you with an ultimate learning experience through a storytelling mode that you would see in movies

SQL Beginner to Advanced For Data Professionals
at
Code Basics
Curriculum

Introduction

How Learning SQL can Help You in Your Career

Who is Peter Pandey?

SQL Basics: Data Retrieval - Single Table

Install MySQL: Windows

Install MySQL: Linux, Mac

SQL Basics: Data Retrieval - Multiple Tables

Why do We Need Multiple Tables?

SQL Joins (INNER, LEFT, RIGHT, FULL)

SQL Basics: Complex Queries

Subqueries

ANY, ALL Operators

SQL Basics: Database Creation & Updates

Database Normalization and Data Integrity

Entity Relationship Diagram (ERD)

AtliQ Hardware & Problem Statement

The Rise of Databases at AtliQ

Relational vs No-SQL Database

SQL Beginner to Advanced For Data Professionals
at
Code Basics
Faculty details

Dhaval Patel

I have 17 years of experience in Programming and Data Science working for big tech companies like NVIDIA and Bloomberg. I also run a famous YouTube channel called Codebasics where I pursue my passion for teaching.

Hemanand Vadivel

I’m a Mechanical Engineer who transitioned to a full-time Data & Analytics Manager in the UK & Germany. I have delivered 30+ analytics projects over 15+ countries and trained professionals at different levels to equip them with valuable analytics skills.