Sql Essentials - Thinking In Sql For Beginners

Learn SQL for beginners with hands-on and practice exercise

What you'll learn

Writing simple to complex SQL queries and answer business questions

Learn joins, group by, aggregates, and many other SQL clauses

Handling date, time, strings, and working with SQL functions

Master your skills with 50+ practice questions

Requirements

No prior knowledge of database and SQL is required

A Recent 64-bit Windows/Mac Machine with 8 GB RAM & Internet Connection

Description

SQL Essentials is a beginner's course that will help you learn SQL programming from the basics and become proficient in writing medium to complex SQL queries and answering business questions.This course is designed using ANSI SQL standard and uses one of the most in-demand skills - Spark SQL. These skills also apply to other major SQL databases, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and more.This course will help you learn the following topics.Writing simple to complex SQL queries and answering business questionsLearn joins, group by, aggregates, and many other SQL clausesHandling date, time, strings, and working with SQL functionsMaster your skills with 50+ practice questionsThis course specialises in the following complex aggregation and advanced SQL problems.Selecting and FilteringDifferent types of JoinSubqueriesCTE in SQLString functionsDate and Time ArithmeticSimple aggregationGrouping AggregationMulti-level aggregationWindowing AggregationThis course also includes practice questions and hands-on exercises.This course is ANSI SQL compliant and big data enabled - You will learn and practice SQL using Apache Spark SQL and be prepared to work as a Big Data Engineer using Apache Spark.This is the best course for you if you are looking forward to growing as a Data Engineer.

Overview

Section 1: Before you start

Lecture 1 About the course

Lecture 2 How to download your resources

Section 2: Introduction to Database and SQL

Lecture 3 What is Database and SQL

Lecture 4 What can you do with Databases and SQL

Lecture 5 How to set up your SQL learning environment

Lecture 6 How to test your SQL environment

Section 3: Getting started with SQL

Lecture 7 SQL Classification

Lecture 8 Microproject – Requirement

Lecture 9 Design your data model

Lecture 10 Implement your data model

Lecture 11 Working with databases

Lecture 12 Working with tables

Lecture 13 Inserting data into a table

Lecture 14 Inserting from source, updating and deleting

Lecture 15 Selecting data from tables

Lecture 16 Microproject – Solution

Section 4: The power of the SELECT clause

Lecture 17 Selecting columns

Lecture 18 Using mathematical expressions

Lecture 19 Creating logical expressions

Lecture 20 Designing conditional expressions

Section 5: The power of the WHERE clause

Lecture 21 Filter Expressions

Lecture 22 CASE and CTE in Filters

Lecture 23 Subquery Filters

Lecture 24 Correlated Query Filter

Section 6: Joining Tables, Subqueries and CTE

Lecture 25 Introduction to join

Lecture 26 Inner Join queries

Lecture 27 Outer joins

Lecture 28 Other types of joins

Section 7: The power of SQL functions

Lecture 29 Using SQL Functions

Lecture 30 Mathematical Functions

Lecture 31 String Functions

Lecture 32 Date Time Functions

Section 8: Grouping and aggregation

Lecture 33 Simple Aggregation

Lecture 34 Grouping Aggregation - Part 1

Lecture 35 Grouping Aggregation - Part 2

Lecture 36 Grouping Aggregation Filters

Lecture 37 Multilevel Aggregation - Part 1

Lecture 38 Multilevel Aggregation - Part 2

Lecture 39 Introduction to Window Aggregation

Lecture 40 Window Aggregates Part 1

Lecture 41 Window Aggregates Part 2

Lecture 42 Window Aggregates Part 3

Section 9: Other SQL Statements

Lecture 43 Set Operations

Lecture 44 Pivoting Data Sets

Lecture 45 Unpivot Data Sets

Lecture 46 Data Views

Lecture 47 Auxiliary Statements

This course is designed for everyone who wants to learn and develop the skills of writing SQL queries and solving business problems using SQL language.,This course is also designed for students who are absolute beginners in SQL programming.