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
Requirements
Basic understanding of data structures
Description
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.
Who this course is for
Data analysts looking to learn SQL
Homepage

https://www.udemy.com/course/sql-fundamentals-for-data-analysts/

Related Downloads :

{related-news}