Learn SQL Basics for Data Science

Coursera

Online Only

This Specialization is intended for a learner with no previous coding experience seeking to develop SQL query fluency. Through four progressively more difficult SQL projects with data science applications, you will cover topics such as SQL basics, data wrangling, SQL analysis, AB testing, distributed computing using Apache Spark, Delta Lake and more. These topics will prepare you to apply SQL creatively to analyze and explore data; demonstrate efficiency in writing queries; create data analysis datasets; conduct feature engineering, use SQL with other data analysis and machine learning toolsets; and use SQL with unstructured data sets.

 

WHAT YOU WILL LEARN

U​se SQL commands to filter, sort, & summarize data; manipulate strings, dates, & numerical data from different sources for analysis

- U​se the collaborative Databricks workspace and create an end-to-end pipeline that reads data, transforms it, and saves the result

- A​ssess and create datasets to solve your business questions and problems using SQL

- ​Develop a project proposal & select your data, perform statistical analysis & develop metrics, and present your findings & make recommendations

Details

Facebook Social Media Marketing

Coursera

Online Only

Whether you’ve been tinkering with social media platforms for your business already or are completely new to the field of digital marketing, you’ve come to the right place. This six-course program, developed by digital marketing experts at Aptly together with Meta marketers, includes an industry-relevant curriculum designed to prepare you for an entry-level role in social media marketing.

 

After an introduction to digital marketing and major social media platforms, you’ll learn to establish an online presence, create posts, build a following, and manage your social media accounts. You’ll develop skills in creating and managing advertising campaigns in social media and learn to evaluate the results of your marketing efforts.

 

Upon successful completion of the program, you’ll earn both the Coursera and the Meta Digital Marketing Associate Certification, proving your skills in social media marketing and in the use of Meta Ads Manager.

 

Once you earn your Meta Certification, you’ll get exclusive access to the new Meta Career Programs Job Board—a job search platform that connects Meta Certified professionals with 200+ top employers who have committed to sourcing talent through its certification programs. We’ll provide you with the link once you’ve completed all the courses and passed the exam.

 

The Professional Certificate is now ACE® recommended. You can learn more here.

 

This specialization is also offered in Arabic, Portuguese, and Spanish.

 

WHAT YOU WILL LEARN

Create and analyze an effective advertising campaign for your target audience 

- Create, edit, and troubleshoot ads in Meta Ads Manager

- Create a creative brief that includes the assets for your paid ad 

- Establish and manage a social media presence

 

Throughout the program, you’ll get to practice your new skills through hands-on projects. Our projects offer an opportunity to apply social media marketing skills practically. From establishing your business goals and brand to creating and evaluating an ad campaign in Meta Ads Manager, you’ll work directly within social media platforms to create engaging and relevant content, discover the ins and outs of each social media platform, practice analyzing metrics, and more. Your results will include a portfolio you can share with a future employer or use at your own business.

Details

IBM Cybersecurity Analyst

Coursera

Online Only

A growing number of exciting, well-paying jobs in today’s security industry do not require a college degree. This 8-course Professional Certificate will give you the technical skills to become job-ready for a Cybersecurity Analyst role. Instructional content and labs will introduce you to concepts including network security, endpoint protection, incident response, threat intelligence, penetration testing, and vulnerability assessment.

 

Cybersecurity is one of the most in-demand career fields.

 

- According to CyberSeek, from June 2019  through May 2020, there were 171,000 openings for Information Security Analysts, but only 125,000 workers are currently employed in those positions – an annual talent shortfall of 46,000 workers. On average, cybersecurity roles take 21% longer to fill than other IT jobs.

 

- The U.S. Bureau of Labor Statistics expects 31% hiring growth for Cybersecurity Analysts between 2019 and 2029, growing much faster than average in other careers.

 

This program is suitable for learners entering the workforce and professionals switching careers. You should be comfortable working with computers, be willing to develop new technical skills, and enjoy collaborative problem solving and communicating solutions.

 

By the end of this program, you will have completed a real-world security breach hands-on project and applied concepts through industry tool virtual labs to provide you with the confidence to start a career in cybersecurity.

 

WHAT YOU WILL LEARN

- Develop knowledge of cybersecurity analyst tools including data protection; endpoint protection; SIEM; and systems and network fundamentals.

- Gain skills for incident responses and forensics with real-world cybersecurity case studies.

- Learn about key compliance and threat intelligence topics important in today’s cybersecurity landscape.

- Get hands-on experience to develop skills via industry-specific and open-source Security tools.

 

Throughout the program, you will use virtual labs and internet sites that will provide you with practical skills with applicability to real jobs that employers value, including:

- Tools: Wireshark, IBM QRadar, IBM MaaS360, IBM Guardium, IBM Resilient, i2 Enterprise Insight Analysis

- Labs: SecurityLearningAcademy.com

- Libraries: Python

- Projects: Investigate a real-world security breach identifying the attack, vulnerabilities, costs and prevention recommendations.

Details

Excel Skills for Business

Coursera

Online Only

This specialization is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In the United States alone, millions of job advertisements requiring Excel skills are posted every day. Research by Burning Glass Technologies and Capital One shows that digital skills lead to higher income and better employment opportunities. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this specialization will position you way ahead of others.

 

In this Specialization, learners develop advanced Excel Skills for Business. Upon completing the four courses in this Specialization, learners can design sophisticated spreadsheets, including professional dashboards, and perform complex calculations using advanced Excel features and techniques. Learners have acquired the skills to manage large datasets efficiently, extract meaningful information from datasets, present data and extract information effectively. In addition, learners have mastered the skills needed to validate data and prevent errors in spreadsheets, create automation, apply advanced formulas and conditional logic to help make decisions and create spreadsheets that help forecast and model data.

 

WHAT YOU WILL LEARN

Be comfortable navigating the Excel user interface, entering, manipulating and formatting data.

- Analyze data and present the results in a user-friendly way. Create charts and tables that effectively summarize raw data.

- Use formulas and functions to perform calculations on data. Automate choices and data lookups using functions.

- Create easy-to-use spreadsheets. Validate data, find and correct errors. Create navigation aids for large workbooks.

 

The best way to learn Excel is to use Excel. In this specialization, learners will solve a broad range of business problems as they apply the Excel skills and techniques they learn along the way. This specialization uses downloadable Excel workbooks and full data sets with applied examples and practical challenge exercises. This provides learners with countless opportunities to practice their Excel skills while discovering new and useful productivity features of Excel for a variety of business contexts.

Details

IBM Data Analyst

Coursera

Online Only

Gain the job-ready skills for an entry-level data analyst role through this eight-course Professional Certificate from IBM and position yourself competitively in the thriving job market for data analysts, which will see a 20% growth until 2028 (U.S. Bureau of Labor Statistics).

 

Power your data analyst career by learning the core principles of data analysis and gaining hands-on skills practice. You’ll work with a variety of data sources, project scenarios, and data analysis tools, including Excel, SQL, Python, Jupyter Notebooks, and Cognos Analytics, gaining practical experience with data manipulation and applying analytical techniques.

 

This Professional Certificate does not require any prior programming or statistical skills and is suitable for learners with or without college degrees. All you need to get started is basic computer literacy, high school math, comfort working with numbers, willingness to learn, and a desire to enrich your profile with valuable skills.

 

Upon successful completion of this program, you’ll have analyzed real-world datasets, created interactive dashboards and presented reports to share your findings, giving you the confidence and the portfolio to begin a career as an associate or junior data analyst. You’ll also build the foundation for other data disciplines such as data science or data engineering.

 

WHAT YOU WILL LEARN

Demonstrate proficiency in using spreadsheets and utilizing Excel to perform a variety of data analysis tasks like data wrangling and data mining

- Develop working knowledge of Python language for analyzing data using Python libraries like Pandas and Numpy, and invoke APIs and Web Services

- Create various charts and plots in Excel & work with IBM Cognos Analytics to build dashboards. Visualize data using Python libraries like Matplotlib

- Describe data ecosystem and Compose queries to access data in cloud databases using SQL and Python from Jupyter notebooks

Details

Python for Everybody

Coursera

Online Only

This Specialization builds on the success of the Python for Everybody course and will introduce fundamental programming concepts including data structures, networked application program interfaces, and databases, using the Python programming language. In the Capstone Project, you’ll use the technologies learned throughout the Specialization to design and create your own applications for data retrieval, processing, and visualization.

 

WHAT YOU WILL LEARN

Install Python and write your first program

- Use variables to store, retrieve and calculate information

- Describe the basics of the Python programming language

- Utilize core programming tools such as functions and loops

Details

Google IT Automation with Python

Coursera

Online Only

This beginner-level, six-course certificate, developed by Google, is designed to provide IT professionals with in-demand skills -- including Python, Git, and IT automation -- that can help you advance your career.

 

Knowing how to write code to solve problems and automate solutions is a crucial skill for anybody in IT. Python, in particular, is now the most in-demand programming language by employers.

 

This program builds on your IT foundations to help you take your career to the next level. It’s designed to teach you how to program with Python and how to use Python to automate common system administration tasks. You'll also learn to use Git and GitHub, troubleshoot and debug complex problems, and apply automation at scale by using configuration management and the Cloud.

 

This certificate can be completed in about 6 months and is designed to prepare you for a variety of roles in IT, like more advanced IT Support Specialist or Junior Systems Administrator positions. Upon completion, you can share your information with potential employers, like Walmart, Sprint, Hulu, Bank of America, Google (of course!), and more.

 

We recommend that you have Python installed on your machine. For some courses, you’ll need a computer where you can install Git or ask your administrator to install it for you.

 

If you’d like to learn the fundamentals of IT support, check out the beginner-level Google IT Support Professional Certificate.

 

Check out all Google Career Certificates here.

 

WHAT YOU WILL LEARN

Automate tasks by writing Python scripts

- Manage IT resources at scale, both for physical machines and virtual machines in the cloud

- Use Git and GitHub for version control

- Analyze real-world IT problems and implement the appropriate strategies to solve those problems

Details

IBM Data Science

Coursera

Online Only

Data science is one of the hottest professions of the decade, and the demand for data scientists who can analyze data and communicate results to inform data-driven decisions has never been greater. This Professional Certificate from IBM will help anyone interested in pursuing a career in data science or machine learning develop career-relevant skills and experience.

 

It’s a myth that to become a data scientist you need a Ph.D. Anyone with a passion for learning can take this Professional Certificate – no prior knowledge of computer science or programming languages required – and develop the skills, tools, and portfolio to have a competitive edge in the job market as an entry-level data scientist.

 

The program consists of 9 online courses that will provide you with the latest job-ready tools and skills, including open-source tools and libraries, Python, databases, SQL, data visualization, data analysis, statistical analysis, predictive modeling, and machine learning algorithms. You’ll learn data science through hands-on practice in the IBM Cloud using real data science tools and real-world data sets.

 

Upon successfully completing these courses, you will have built a portfolio of data science projects to provide you with the confidence to plunge into an exciting profession in data science.

 

In addition to earning a Professional Certificate from Coursera, you'll also receive a digital badge from IBM recognizing your proficiency in data science.

 

WHAT YOU WILL LEARN

Learn what data science is, the various activities of a data scientist’s job, and the methodology to think and work like a data scientist  

- Import and clean data sets, analyze and visualize data, and build and evaluate machine learning models and pipelines using Python 

- Develop hands-on skills using the tools, languages, and libraries used by professional data scientists  

- Apply various data science skills, techniques, and tools to complete a project and publish a report  

 

This Professional Certificate has a strong emphasis on applied learning. Except for the first course, all other courses include a series of hands-on labs in the IBM Cloud that will give you practical skills with applicability to real jobs, including:

- Tools: Jupyter / JupyterLab, GitHub, R Studio, and Watson Studio

- Libraries: Pandas, NumPy, Matplotlib, Seaborn, Folium, python-sql, Scikit-learn, ScipPy, etc.

- Projects: random album generator, predict housing prices, best classifier model, Predicting successful rocket landing, dashboard and interactive map

Details

Google UX Design

Coursera

Online Only

Prepare for a career in the high-growth field of UX design, no experience or degree is required. With professional training designed by Google, get on the fast track to a competitively paid job. There are currently 99,000 U.S. job openings in UX design with a median entry-level salary of $92,000.

 

User experience (UX) designers focus on the interaction that users have with products, like websites, apps, and physical objects. They make those everyday interactions useful, enjoyable, and accessible.

 

Over 7 courses, gain in-demand skills that will prepare you for an entry-level job.

 

You will create designs on paper and in digital design tools like Figma and Adobe XD. By the end of the certificate program, you will have a professional UX portfolio that includes three end-to-end projects, so that you’re ready to apply for jobs. Upon completion, you can directly apply for jobs with Google and over 150 U.S. employers, including Walmart, Best Buy, and Astreya.

 

75% of Google Career Certificate Graduates in the United States report an improvement in their career trajectory (e.g. new job or career, promotion or raise) within 6 months of certificate completion.

 

This program includes over 200 hours of instruction and hundreds of practice-based activities and assessments that simulate real-world UX design scenarios and are critical for success in the workplace. The content is highly interactive and developed by Google employees with decades of experience in UX design.

 

You’ll learn how to complete the design process from beginning to end, including: Empathizing with users; Defining user pain points; Coming up with ideas for design solutions; Creating wireframes, mockups, and prototypes; Testing designs through usability studies; Iterating on designs based on feedback.

 

Through a mix of videos, readings, assessments, and hands-on activities, you’ll learn in-demand design tools, Figma and Adobe XD. You’ll even create a portfolio that includes three projects to share with potential employers to showcase the skills you learned in this program.

 

WHAT YOU WILL LEARN

- Follow the design process: empathize with users, define pain points, ideate solutions, create wireframes and prototypes, test and iterate on designs

- Apply foundational UX concepts, like user-centered design, accessibility, and equity-focused design

- Understand the basics of UX research, like planning research studies, conducting interviews and usability studies, and synthesizing research results

- Create a professional UX portfolio that includes 3 end-to-end projects: a mobile app, a responsive website, and a cross-platform experience

Details

Google IT Support

Coursera

Online Only

Prepare for a career in the high-growth field of IT, no experience or degree required. Get professional training designed by Google and get on the fast-track to a competitively paid job. There are 400,000 U.S. job openings in IT and a $52,000 median entry-level salary in IT support.

 

Over 5 courses, learn in-demand skills that prepare you for an entry-level job. Upon completion, you can directly apply for jobs with Google and over 150 U.S. employers, including Walmart, Best Buy, and Astreya.

 

75% of Google Career Certificate Graduates in the United States report an improvement in their career trajectory (e.g. new job or career, promotion or raise) within 6 months of certificate completion.

 

This program also prepares you for the CompTIA A+ exams, and the industry-standard certification for IT—you’ll earn a dual credential when you complete both.

 

This program is ACE® approved—when you complete it, you can earn up to 12 college credits, the equivalent of 4 associate degree-level courses.

 

If you’re interested in building on your IT foundations, check out the Google IT Automation with Python Professional Certificate.

 

Check out all Google Career Certificates here. Now $39 (save $10)!

 

WHAT YOU WILL LEARN

Gain skills required to succeed in an entry-level IT job

- Learn how to provide end-to-end customer support, ranging from identifying problems to troubleshooting and debugging

- Learn to perform day-to-day IT support tasks including computer assembly, wireless networking, installing programs, and customer service

- Learn to use systems including Linux, Domain Name Systems, Command-Line Interface, and Binary Code

 

This program includes over 100 hours of instruction and hundreds of practice-based assessments, which will help you simulate real-world IT support scenarios that are critical for success in the workplace.

 

The content is highly interactive and exclusively developed by Google employees with decades of experience in IT.

 

Through a mix of videos, assessments, and hands-on labs, you’ll be introduced to troubleshooting, customer service, networking, operating systems, and security — foundational IT skills required for an entry-level job.

Details

Subscribe to Certificate