KASHEF
UDDIN
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.
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
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
SQL For Data Analyst
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.
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
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
