Free courses
4 courses
- BeginnerFree first lessonData Analysis for Excel and Google SheetsWork as the analyst for a wholesaler. Answer real business questions with formulas, pivot summaries and charts, and pass a timed skills test.
- Write formulas that stay right when they are copied: relative and absolute references, totals, averages and percentages
- Make decisions in a sheet with IF, AND, OR and IFERROR
- Clean a messy list: stray spaces, mixed capitals, numbers stored as text, blanks and duplicates
- BeginnerFree first lessonSQL for Data Analysis: Work as an AnalystWork as the analyst for three companies. Answer real business questions in SQL, build three portfolio projects, and pass a timed skills test.
- Turn a manager's question into a query, check the result, and say the answer in one sentence
- Clean and validate messy data (missing values, duplicates, stray text, wrong types) before you trust a number
- Join, group and rank with confidence: CTEs, subqueries, window functions, top-N per group, month-over-month change
- BeginnerFree first lessonPrep for the AWS Certified Cloud Practitioner (CLF-C02) examThe AWS Cloud Practitioner exam's four areas, in plain words, with full-length practice exams
- Explain what the cloud gives a business: paying as you go, scaling up and down, and reaching the world quickly
- Say who looks after what under the shared responsibility model, for any kind of service
- Pick the right AWS service for a common need in compute, storage, databases, networking and security
- BeginnerFree first lessonHow networks workWhat happens between your device and the website, in plain words
- Explain what a network is and what an IP address and a MAC address are for
- Tell switching from routing, and say why a device needs a default gateway
- Describe what DNS, DHCP, ports and HTTPS do when you open a website