Basics of SQL

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

As a data scientist, one must know how to extract the data, modify it and use it to get the insights. You have to perform the CRUD operations on the company’s database. For this purpose, there is no other tool as flexible and scalable as SQL. In this course, you will learn all the fundamentals of SQL using small exercises. Build capstone projects to strengthen your learnings.

What Will You Learn?

  • In this course, you will learn about
  • Overview of SQL and databases
  • Basics of designing and creating databases
  • How to read data from a single table
  • Aggregate functions in SQL
  • Reading data from multiple tables
  • Inserting, updating and deleting data
  • Understanding and using MySQL functions
  • All concepts will be taught using small exercises. You will do a project on an e-commerce dataset to understand how all pieces tie together
  • You will learn about
  • Syntax, SQL fundamentals, basics of designing databases
  • In the end, you will be able to
  • Extract data, update the data and create databases

Course Content

SQL

  • Overview of SQL
    00:00
  • Creating Databases
    00:00
  • Reading data from a single table
    00:00
  • Aggregate Functions
    00:00
  • Regular Expressions
    00:00
  • Reading data from multiple tables
    00:00
  • Inserting, Updating and Deleting Data
    00:00
  • MySQL functions
    00:00
  • Creating views
    00:00
  • Stored Procedures
    00:00
  • Triggers and Events
    00:00
  • Transactions and concurrency
    00:00
  • Data Types
    00:00