Name: Data Analyst Bootcamp
Price: 10.00 USD
Availability: InStock

Présentation de la formation

YouTube's first FREE Data Analyst Bootcamp!! Complete all of the videos and projects and earn a free certificate!

Objectifs d'apprentissage

Suivre et valider l integralite des 84 lecons du parcours
Maitriser les concepts cles de Développement & Tech
Reussir l examen final et obtenir le certificat YouCert

Programme des cours (84 modules)

1. FREE Data Analyst Bootcamp!!
2. How to Become a Data Analyst in 2023 (Completely FREE!)
3. Installing MySQL and Creating Databases | MySQL for Beginners
4. Select Statement in MySQL | Beginner MySQL Series
5. Where Clause in MySQL | Beginner MySQL Series
6. Group By + Order By in MySQL | Beginner MySQL Series
7. Having vs Where in MySQL | Beginner MySQL Series
8. Limit + Aliasing in MySQL | MySQL Beginner Series
9. Joins in MySQL | Intermediate MySQL
10. Unions in MySQL | Intermediate MySQL
11. String Functions in MySQL | Intermediate MySQL Series
12. Case Statements in MySQL | Intermediate MySQL
13. Subqueries in MySQL | Intermediate MySQL
14. Window Functions in MySQL | Intermediate MySQL
15. CTEs in MySQL | Advanced MySQL Series
16. Temp Tables in MySQL | Advanced MySQL Series
17. Stored Procedures in MySQL | Advanced MySQL Series
18. Triggers and Events in MySQL | Advanced MySQL Series
19. Data Cleaning in MySQL | Full Project
20. MySQL Exploratory Data Analysis | Full Project
21. Pivot Tables in Excel | Excel Tutorials for Beginners
22. Formulas in Excel | Excel Tutorials for Beginners
23. XLOOKUP in Excel | Excel Tutorials for Beginners
24. Conditional Formatting in Excel | Excel Tutorials for Beginners
25. Charts in Excel | Excel Tutorials for Beginners
26. Cleaning Data in Excel | Excel Tutorials for Beginners
27. Full Project in Excel | Excel Tutorials for Beginners
28. How to Install Tableau and Create First Visualization | Tableau Tutorials for Beginners
29. How to use Calculated Fields and Bins in Tableau | Tableau Tutorials for Beginners
30. How to Create Visualizations in Tableau | Tableau Tutorials for Beginners
31. How to use Joins in Tableau | Tableau Tutorials for Beginners
32. Full Beginner Project in Tableau | Tableau Tutorials for Beginners
33. How to Install Power BI | Building First Visualization | Microsoft Power BI for Beginners
34. How to use Power Query in Power BI | Microsoft Power BI for Beginners
35. How to Create and Manage Relationships in Power BI | Microsoft Power BI for Beginners
36. How to use DAX in Power BI | Microsoft Power BI for Beginners
37. How to use Drill Down in Power BI | Microsoft Power BI for Beginners
38. How to use Conditional Formatting in Power BI | Microsoft Power BI for Beginners
39. How to use Bins and Lists in Power BI | Microsoft Power BI for Beginners
40. Popular Visualizations in Power BI | Microsoft Power BI for Beginners
41. Full Power BI Guided Project | Microsoft Power BI for Beginners
42. Installing Jupyter Notebooks/Anaconda | Python for Beginners
43. Variables in Python | Python for Beginners
44. Data Types in Python | Python for Beginners
45. Comparison, Logical, and Membership Operators in Python | Python for Beginners
46. If Else Statements in Python | Python for Beginners
47. For Loops in Python | Python for Beginners
48. While Loops in Python | Python for Beginners
49. Functions in Python | Python for Beginners
50. Converting Data Types in Python | Python for Beginners
51. Building a BMI Calculator with Python | Python Projects for Beginners
52. Building an Automated File Sorter in File Explorer using Python | Python Projects for Beginners
53. Inspecting Web Pages with HTML | Web Scraping in Python
54. BeautifulSoup + Requests | Web Scraping in Python
55. Find and Find_All | Web Scraping in Python
56. Scraping Data from a Real Website | Web Scraping in Python
57. Reading in Files in Pandas | Python Pandas Tutorials
58. Filtering Columns and Rows in Pandas | Python Pandas Tutorials
59. Indexes in Pandas | Python Pandas Tutorials
60. Group By and Aggregate Functions in Pandas | Python Pandas Tutorials
61. Merging DataFrames in Pandas | Python Pandas Tutorials
62. Creating Visualizations using Pandas Library | Python Pandas Tutorials
63. Data Cleaning in Pandas | Python Pandas Tutorials
64. Exploratory Data Analysis in Pandas | Python Pandas Tutorials
65. Amazon Web Scraping Using Python | Data Analyst Portfolio Project
66. Automating Crypto Website API Pull Using Python | Data Analyst Project
67. How to Create a Portfolio Website for FREE
68. Create the Perfect Data Analyst Resume | Free Templates!
69. Solving Easy SQL Interview Questions on Analyst Builder
70. Solving Medium SQL Interview Questions on Analyst Builder
71. Solving HARD SQL Interview Questions on Analyst Builder
72. Solving VERY HARD SQL Interview Questions on Analyst Builder
73. Azure Account Setup + $200 Free Credits | Azure Fundamentals
74. Blob Storage and Storage Accounts in Azure | Azure Fundamentals
75. How to use Azure SQL Databases | Azure Fundamentals
76. Getting Started in Azure Data Factory | Azure Fundamentals
77. Getting Started in Azure Synapse Analytics | Azure Fundamentals
78. AWS Setup and UI Walkthough | AWS
79. S3 Storage in AWS | AWS Essentials
80. Amazon Athena in AWS | AWS Fundamentals
81. AWS Glue DataBrew and Glue | AWS Essentials
82. AWS Quicksight | AWS Essentials
83. Top 3 Tips on Using LinkedIn to Land a Job
84. How To Download Your Data Analyst Bootcamp Certification (Congrats!!)

Certification Numérique Vérifiable

Cette formation est certifiante. Après validation des modules et de l'examen en ligne, vous recevez un Certificat de Réussite officiel YouCertAcademy muni d'un QR Code unique vérifiable publiquement à l'adresse https://www.youcertacademy.com/verify.

Dispensé par : Alex The Analyst