SQL Fundamentals for Data Analysts
Loại khoá học: IT Certifications
Everything you need to get started with SQL
Mô tả
Do you want to get a high-paying job in Data and Business Analytics? Want to be more productive in analyzing data? Are you tired of having a limited understanding of SQL? Hate manually transforming data, but need the value it provides? If the answer is "yes" then look no further. With the SQL Fundamentals Course, you'll gain fundamental knowledge related to the Structured Query Language or SQL, the language every database speaks.
You’ll learn:
How to connect, filter and retrieve data using SQL Queries (Select, Limit, Where, And)
Aggregate Data using Functions and Grouping Operations (Count, Sum, Avg & Group By)
How to use Conditional Logic to limit data to specific text or phrases (In, Between, Like)
Quick and easy to follow video tutorials along with step-by-step instructions make this course perfect for the SQL novice. By the end of this course, you will be able to analyze data faster and more efficiently.
I’ve worked in the data field for over 20+ years and have consulted at silicon valley’s largest companies. Now my focus is on sharing my passion and knowledge with others. If you enjoy this course, feel free to check out the rest of my library. I cover everything from SQL to Data Governance to Tableau.
Bạn sẽ học được gì
How to create and run SQL queiries to efficiently
Writing basic select statements
Limiting Results
Filtering Results with Where
More Ways to Filter Queries
Answering Analytical Questions with Aggregate Functions
Filtering Data with Aggregates
Handling NULL Values
Aliasing Columns and Tables
Using IN and BETWEEN Clauses
Filtering with LIKE Operator
Yêu cầu
- Basic understanding of data structures
Nội dung khoá học
Viết Bình Luận
Khoá học liên quan
Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!
Get khoá học giá rẻ ngay trước khi bị fix.
Đánh giá của học viên
Bình luận khách hàng