I love to study in online to develop my knowledge.
- What is a Database
- Installing Postgres
- Creating Tables
- SELECT Statement
- WHERE Clause
- AND & OR
- Filtering Operators
- ORDER BY
- LIMIT
- DISTINCT
- Renaming Columns
- Functions
- GROUP BY & HAVING Clauses
- Aggregation Queries
- Subqueries
- CASE Clause
- Correlated Subqueries
- Table Joins
- INNER and OUTER Joins
- UNION, UNION ALL and EXCEPT Clauses
- Window Functions for Analytics
- over 100 puzzles distributed throughout the course
- Creating effective spreadsheets
- Managing large sets of data
- Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)
- Create dynamic report with Excel PivotTables
- Unlock the power and versatility of Microsoft Excel's Add-In, PowerPivot
- Audit Excel Worksheet formulas to ensure clean formulas
- Automate your day to day Excel tasks by mastering the power of Macros and VBA
- PostgreSQL and PgAdmin, two of the world's most popular SQL tools
- basics of SQL syntax
- Analyzing data using aggregate functions with GROUP BY commands
- Running advanced queries with string operations and comparison operations
- logical operators to add logic flow to your SQL queries
- common SQL JOIN commands
- create tables and databases with constraints on data entries
- use Python to further advanced your SQL skills
- Programming with R
- Advanced R Features
- Using R Data Frames to solve complex tasks
- Use R to handle Excel Files
- Web scraping with R
- Connect R to SQL
- Use ggplot2 for data visualizations
- Use plotly for interactive visualizations
- Machine Learning with R, including:
- Linear Regression
- K Nearest Neighbors
- K Means Clustering
- Decision Trees
- Random Forests
- Data Mining Twitter
- Neural Nets and Deep Learning
- Support Vectore Machines