4.50
(2 Ratings)

Fundamentals of SQL – Learn MySQL and Database Design

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

SQL is the preferred relational database management language. We live in a world that is driven by data, and many firms store their data in massive relational databases. This makes SQL a valuable tool for anyone who wants to be data literate, not only data scientists and engineers. Learn how to manage your SQL database for scalability, write effective SQL statements and clauses, and structure your database effectively.
This course provides students with a comprehensive understanding of SQL (Structured Query Language), the standard language for managing and manipulating relational databases. It covers the core concepts of SQL and teaches students how to perform various database operations, including querying, inserting, updating, and deleting data. Students will learn about SQL syntax, data types, tables, and relationships starting with the basics. They will also explore essential topics such as filtering data, sorting results, joining tables, and performing aggregate functions. By the end of this course, students will have the skills to work with databases efficiently using SQL.

Show More

What Will You Learn?

  • Understand the core concepts of SQL, including syntax, data types, and statements.
  • Perform data retrieval and filtering using SELECT statements.
  • Join multiple tables to retrieve data from related tables.
  • Modify and manipulate data in tables using INSERT, UPDATE, and DELETE statements.
  • Utilise aggregate functions to perform calculations on data.
  • Work with subqueries and derived tables for complex queries.
  • Understand database security concepts and apply best practices in SQL coding.

Course Content

Introduction to Databases and SQL

  • Overview of databases and their importance in web development.
    04:26
  • Introduction to SQL and its role in database management.
    04:25
  • Different types of databases (relational, non-relational).
    04:26
  • Setting up a database management system (MySQL, PostgreSQL, SQLite).
    04:26

SQL Basics

Querying Data with SELECT

Advanced Querying Techniques

Joining Multiple Tables

Data Modification and Manipulation

Aggregate Functions and Grouping

Subqueries and Derived Tables

SQL Views and Indexes

Database Security and Best Practices

Course Completion Quiz

Student Ratings & Reviews

4.5
Total 2 Ratings
5
1 Rating
4
1 Rating
3
0 Rating
2
0 Rating
1
0 Rating
2 years ago
The quality of the content and resources provided was exceptional.
2 years ago
Nice
Scroll to Top