bipp – SQL Tutorial for Data Analyst

The SQL tutorial provides basic and advanced concepts of SQL, designed for beginners and professionals. No prior DB experience is required. The following concepts are explained with examples: SQL Tutorial for Data Analyst | bipp Analytics

Basic SQL

  • SQL SELECT Statement
  • SQL ORDER BY and SQL LIMIT
  • Using SQL WHERE Clause With Comparison Operators
  • Using Logical Operators in WHERE clause
  • SQL BETWEEN and SQL LIKE in WHERE Clause
  • SQL IS NULL Operator in WHERE Clause
  • SQL Data Types
  • SQL CASE Clause in SQL Queries

Intermediate SQL

  • SQL GROUP BY Clause in a SELECT Query
  • Aggregation Functions in SQL
  • SQL Having Clause
  • SQL Subqueries: The Super Powerful SQL Feature
  • SQL DISTINCT Clause
  • SQL Date and Time Data Types and Functions
  • SQL String Functions

Advanced SQL

  • SQL Correlated Subqueries Increase the Power of SQL
  • SQL Window Functions
  • SQL Window Function Examples
  • Selecting Data From Multiple Tables: SQL JOINS
  • Visual Representation of SQL JOINS
  • Query Optimization

submitted by /u/thumbsdrivesmecrazy
[link] [comments]


Go to Source of this post
Author Of this post: /u/thumbsdrivesmecrazy
Title Of post: bipp – SQL Tutorial for Data Analyst
Author Link: {authorlink}