SQL For Data Analyst

COURSE OVERVIEW

Information is all around us. You can put it to use by learning SQL basics. Used in data science, analytics, and engineering, SQL makes it easy to work with data and make more informed strategy, operations, and business decisions. It’s a helpful skill for anyone who works with data (even in non-tech roles). In this SQL course, you’ll learn how to manage large datasets and analyze real data.

Skills you'll gain

  • Work with databases using SQL
  • Create queries for tables
  • Build SQL projects

WHAT YOU WILL GET AFTER COMPLETION THE SERIES OF WEBINAR

  • Recorded Lectures
  • Practice Files
  • Notes

WHAT YOU WILL LEARN

  • Database
  • Types of Databases
  • What is SQL?
  • Download & Install My SQL
  • Database Structure
  • Data Types in SQL
  • Types of SQL Commands
  • DQL – DDL – DML Commands
  • Database Related Queries
  • Table Related Queries
  • Keys
  • Constraints
  • Select Statement
  • Where Clause
  • Order By
  • SQL Operators
  • Top Clause
  • Aggregation Functions
  • Group By & Having Clause
  • Relationships in SQL
  • Joins
  • SQL Views