SQL

Store and retrieve data using SQL

What is SQL?

SQL is called Structured Query Language, it is used in many applications to store information. There are many relational database management systems like MySQL, PostgreSQL, MongoDB and Oracle which help us to use SQL and manipulate the data stored in the database. We will be using MySQL for this course. It is one of the skills required for a data science-related job.

📚 Prerequisites
Python
Data Science
⏳ Duration
15 – 20 hrs
What you will learn in the course?

In this course, you will learn all the important and widely used operations in SQL called CRUD(create, read, update and delete). The course is made in such a way that it will make you able to write SQL queries to perform the CRUD operations. The first few lessons will be about SQL clauses, operators and statements. The other lessons will be about joining database tables and adding constraints.

  • Introduction
  • SELECT Query
  • SQL Clauses
  • SQL Operators
  • SQL Statements
  • SQL Constraints
    • PRIMARY KEY
    • NOT NULL Constraint
    • UNIQUE KEY
    • FOREIGN KEY
  • SQL JOINS
  • SQL EXECUTION ORDER
  • SQL WITH Python
  • 2 Projects

By the course end . . .

You will be in a good position to use databases to store and modify data. Also, this course is asked by many employers to be mentioned in your resume. This course will teach you how to connect Python with MySQL.

About Us

Learn and Grow with the best courses of aiadventures. Read more about us here