What You Will Learn!
- 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
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 Should Attend!
- Data analysts looking to learn SQL
