Best SQL Classes Online

After studying this course, complete beginners will have a foundational understanding of SQL. In the first unit, students learn to use SQL for making selections, cleaning data, joining tables, and writing queries and subqueries for analyzing data. In the second unit, students learn tools for managing both relational and non-relational databases, including PostgreSQL and MongoDB. Each unit offers students the opportunity to complete a hands-on project with their new skills.

Beginners in this course learn the tools and concepts necessary for expert database management. Students work primarily with SQL as they gain experience with data manipulation before moving on to work with tables, clauses, queries, indexes, data warehouses, and schemas as they learn to structure queries. Students also learn to use industry-standard database management tools including Microsoft SQL Server and Visual Studio and Oracle Database. When they complete the course, students graduate with a certification issued by Austin Peay State University continuing education, recognized by the global CPD Certification Service.

In this course, students learn hands-on how to write and use SQL code. The class starts with an survey of the syntax before diving into working with data in databases and tables. Students learn to use commands, functions, and operators as they start analyzing data. By the end of the course, students will have also picked up helpful skills in JavaScript and NodeJS as they conclude with a project: developing a web application using MySQL.

In this course track, students develop a solid foundation in SQL. The course starts with an introduction to databases and SQL syntax before moving through using SQL to modify data and create reports. Students learn to write queries and Common Table Expressions before practicing on an example dataset. For troubleshooting and general studying support, students can turn to the Treehouse learning community of peer learners.

Designed for novice data analysts, this short course teaches students how to navigate and manipulate relational databases with SQL. Students begin by learning commands and operators for selecting and filtering data. Then, students learn about functions and aliases to begin sorting and grouping data. With 41 exercises, students get hands-on experience working with SQL.

After studying this short course, students will have a solid understanding of working with SQL in Microsoft SQL Server. The course starts with an introduction to statements and aggregate functions in SQL. Then, students discover joins and begin creating and manipulating their own tables. A total of 46 exercises gives students hands-on practice with their new SQL Server knowledge.

In this course track, students get a jump start on their education in SQL. Students work in MySQL, learning about database structures and data types. Students learn how to make queries and subqueries and use joins and views. Along the way, students complete a lab exercise to earn a digital badge.

With this course, students gain skills for using SQL-based data analytics in business contexts. Students start with an introduction to databases, SQL, and MySQL before working with queries, statements, functions, and joins. After, students get an introduction to data visualization with hands-on experience in Tableau. By the end of the course, students will understand the foundations of database management.

This short course introduces students to working in SQL for database management. Students get an orientation to the language before working with SQL relationships, strings, and date and time functions. Then, students learn about aggregate functions, transactions, and triggers before gaining practical experience with an example CRUD application. Quizzes help students test their new understanding of SQL, and course completion earns students a LinkedIn Learning certificate.

Designed for complete beginners to programing, this tutorial helps students gain foundational skills in SQL. The seminar starts with an orientation to the theory of relational databases before discussing how to use select statements on single and multiple tables. Students learn to use filters, joins, and subqueries before learning about case statements and aggregates. A total of three quizzes help students test their new understanding of SQL, and course completion earns students a LinkedIn Learning certificate.

Through this course track, students who have some familiarity with SQL get a complete orientation to building SQL databases. Highlights from the course track include index design, views, data integrity and stored procedures. Students also learn about triggers, functions, transactions, events, and performance metrics. At the end of the course track, students can earn a digital badge.

Starting with PostgreSQL and PgAdmin and finishing with an introduction to Python, this course covers important features to help students rapidly upskill in SQL. Students learn important SQL commands, including GROUPBY and JOIN, for analyzing data. They also discover how to generate tables and databases and use conditional expressions. Along the way, students quiz their newfound knowledge with tests at regular check-in points.