
Already know some of this? A 2-minute test skips the lessons you know.
Take the placement testA free 92-lesson course built from freeCodeCamp.org's 19h 24m of YouTube video. 12 days at 90 minutes a day, with study notes and a quiz in every lesson. A 2-minute placement test skips what you already know.
Taught by freeCodeCamp.org on YouTube. Videos play in YouTube's own player, so the creator keeps every view.
Learn the five core skills (SQL, BI tools, Excel, Python, cloud platforms), a 6-month roadmap, and job-search strategies including recruiters and LinkedIn.
Download SQL Server Management Studio and Express, create a database, and build employee demographics and salary tables with INSERT scripts.
Query tables and 57,
Filter rows with comparison operators, IN, LIKE wildcards, IS NULL, and BETWEEN to retrieve specific subsets of data.
Aggregate data with GROUP BY, sort results with ORDER BY on single or multiple columns, and use column position numbers.
Combine tables with INNER, LEFT, RIGHT, and FULL OUTER joins; understand match logic and NULL handling for unmatched rows.
Stack result sets with UNION (distinct) and UNION ALL (duplicates kept); align column counts and data types.
Create conditional logic in queries to transform values, bucket data, or calculate derived columns like salary adjustments.
Modify existing rows with UPDATE, remove rows with DELETE, and improve readability with column and table aliases.
Apply aggregate functions per partition without reducing row count; compare with GROUP BY to see differences.
Create persistent temporary tables with ##, insert data via SELECT INTO, and use DROP IF EXISTS for idempotent scripts.
Clean text with TRIM, REPLACE, SUBSTRING, UPPER/LOWER; parse addresses with PARSENAME and fuzzy-match with SUBSTRING.
Create parameterized stored procedures with CREATE PROCEDURE, ALTER PROCEDURE, and EXEC to reduce network traffic and centralize logic.
Nest queries in SELECT, FROM, and WHERE clauses; compare subqueries with CTEs and temp tables for performance.
Import CSV data, join tables, explore global and per-country infection/death rates, create views for Tableau, and save queries to GitHub.
Import CSV data, join tables, explore global and per-country infection/death rates, create views for Tableau, and save queries to GitHub.
Import CSV data, join tables, explore global and per-country infection/death rates, create views for Tableau, and save queries to GitHub.
Import CSV data, join tables, explore global and per-country infection/death rates, create views for Tableau, and save queries to GitHub.
Import CSV data, join tables, explore global and per-country infection/death rates, create views for Tableau, and save queries to GitHub.
Import CSV data, join tables, explore global and per-country infection/death rates, create views for Tableau, and save queries to GitHub.
Import CSV data, join tables, explore global and per-country infection/death rates, create views for Tableau, and save queries to GitHub.
Standardize dates, populate missing addresses with self-joins, split address fields, convert SoldAsVacant with CASE, deduplicate with ROW_NUMBER CTE, and drop unused columns.
Standardize dates, populate missing addresses with self-joins, split address fields, convert SoldAsVacant with CASE, deduplicate with ROW_NUMBER CTE, and drop unused columns.
Standardize dates, populate missing addresses with self-joins, split address fields, convert SoldAsVacant with CASE, deduplicate with ROW_NUMBER CTE, and drop unused columns.
Standardize dates, populate missing addresses with self-joins, split address fields, convert SoldAsVacant with CASE, deduplicate with ROW_NUMBER CTE, and drop unused columns.
Standardize dates, populate missing addresses with self-joins, split address fields, convert SoldAsVacant with CASE, deduplicate with ROW_NUMBER CTE, and drop unused columns.
Build pivot tables to summarize bike sales by store, product, and date; use slicers for interactive filtering by region and education.
Calculate extremes, conditional logic, text length, substring extraction, and modern XLOOKUP with match modes and horizontal sums.
Replace VLOOKUP with XLOOKUP for exact/wildcard matches, search modes, and horizontal lookups with SUM aggregation.
Highlight duplicates, top/bottom rules, data bars, color scales, and custom formula rules with proper range anchoring.
Create column, line, pie, map, and density visualizations; switch rows/columns, filter totals, and customize colors and labels.
Remove duplicates, standardize text case, fix date formats, split columns, drop unused fields, and paste values to break formulas.
Clean raw survey data, build pivot charts and slicers for marital status, education, region, and gender, and assemble an interactive dashboard.
Download Tableau Public, connect to CSV, navigate the UI, and build a simple bar chart with video game sales data.
Create calculated fields for profit, use bins to group continuous measures, and apply them to visualizations.
Create dual-axis charts, density maps, scatter plots, box-and-whisker, and area charts; customize colors and labels.
Switch from relationships to physical joins; configure inner, left, right, full outer joins on EmployeeID and fix unmatched rows.
Join listings, calendar, and reviews; build map with zip-code pricing, time-series revenue by week, and bedroom-count analysis; add slicers for education and region.
Download Power BI Desktop, transform apocalypse food prep data in Power Query, and build clustered column and gauge visualizations.
Remove top rows, promote headers, change data types, unpivot columns, and filter out milk products in the Power Query editor.
Create and edit model relationships; switch from inferred relationships to explicit joins for multi-table control.
Write SUM vs SUMX for row-level profit, use WEEKDAY for day-of-week analysis, and create IF-based order-size column.
Enable drill-down on store→product hierarchy, expand all levels, and toggle drill mode for interactive exploration.
Apply background colors, data bars, and rule-based formatting to tables and matrices for quick outlier detection.
Group numeric fields into bins (age, date) and categorical fields into lists (customer tiers) for cleaner visualizations.
Build stacked bar, 100% stacked column, line-and-clustered-column, scatter, donut, card, and table visuals; format titles and data labels.
Clean survey data (drop duplicates, standardize text, convert salary), build KPI cards, bar charts, gauges, pie charts, and apply Seaborn themes.
Download Anaconda, launch Jupyter Notebook, navigate the UI, and create a Python 3 kernel for the bootcamp series.
Assign integers, strings, lists; reassign variables; use snake_case, camelCase, PascalCase; unpack multiple values.
Identify int, float, complex, bool, str, list, tuple, set, dict; use type() and understand mutability and nesting.
Apply >, <, ==, !=, and/or/not, in/not in on strings, lists, and ranges for conditional logic.
Write conditional blocks with elif chains, nested ifs, and one-line ternary-style if/else for flow control.
Iterate over lists, tuples, strings, dictionaries; use range, enumerate, and loop variables for repeated operations.
Run loops until a condition fails; use break, continue, and else clauses for advanced control flow.
Define functions with positional, keyword, arbitrary positional (*args), and arbitrary keyword (**kwargs) arguments.
Cast strings to int/float, convert list↔tuple↔set, dict keys/values to list, and long strings to character lists.
Prompt for weight and height, convert inputs to integers, compute BMI = weight*703/height^2, and classify weight category.
Scan a folder, create CSV/PNG/TXT subfolders, move files by extension with os/shutil, and schedule with time.sleep.
Use browser dev tools to inspect DOM, locate tags, classes, IDs, and table structures for targeted scraping.
Fetch page with requests.get, parse with BeautifulSoup(html.parser), and prettify HTML for readability.
Extract titles with find(id=...), pull all rows with find_all('tr'), and isolate TD text with list comprehensions.
Scrape sortable table, clean headers, loop TR/TD rows, append to DataFrame with loc[len], export CSV with index=False.
Load CSV/Excel/JSON with read_csv/read_excel/read_json; set display options for floats; inspect dtypes and nulls.
Filter with boolean indexing, isin, str.contains, loc/iloc; sort_values by single or multiple columns with ascending flags.
Label-based loc, integer-based iloc, set_index, reset_index, and select_dtypes for column-type filtering.
Group by single/multiple columns; apply mean, sum, min, max, count, describe; use agg with dict for per-column functions.
Merge on keys with how=inner/left/right/outer/cross; join on index with suffixes; concat with ignore_index; compare merge vs join.
Plot line, bar, area, pie, box, scatter; customize figsize, style sheets (seaborn), and hue legends for categorical splits.
Drop duplicates, drop columns, strip/replace last names, standardize phone numbers with regex, split address, fill nulls, drop null rows, reset index.
Profile with info/describe/isnull/nunique; sort top populations; correlate numeric columns; heatmap; groupby continent stats; boxplots for outliers.
Automize product loop through product pages, extract title/price/rating, handle pagination, clean data, and export to CSV for portfolio.
Pull CoinMarketCap API with headers, normalize JSON, add timestamp, schedule with time.sleep, compute avg % changes, pivot with stack/unstack, visualize with Seaborn lineplot.