SQL Masterclass Zero to Hero
SQL From Zero to Hero in Single Course
Topics Covered
What is the Database?
CRUD Types of Databases
Installation of the Tools Relational Database
What is SQL?
Non-Relational Databases (no SQL, Not just SQL)
Database Queries
Table Structure
Relationships:
SQL Commands
Data definition language (DDL)
Data manipulation language (DML):
Keys , Keys in Databases Data Types in SQL
SQL Operations Data insertion and
CRUD Count the items Deleting Rows from
Tables Update Rows Like Operator
DROP DATABASE
ALTER TABLE
TRUNCATE TABLE
Mini Project CRUD
Project #1 -Student and Courses Project
Project #2 - Customer and Orders, with Products (CRM)
SQL Joins
SQL Constraints
Null Functions:
PROCEDURE
TRIGGERS
Delete All
Interview Questions
CRUD Types of Databases
Installation of the Tools Relational Database
What is SQL?
Non-Relational Databases (no SQL, Not just SQL)
Database Queries
Table Structure
Relationships:
SQL Commands
Data definition language (DDL)
Data manipulation language (DML):
Keys , Keys in Databases Data Types in SQL
SQL Operations Data insertion and
CRUD Count the items Deleting Rows from
Tables Update Rows Like Operator
DROP DATABASE
ALTER TABLE
TRUNCATE TABLE
Mini Project CRUD
Project #1 -Student and Courses Project
Project #2 - Customer and Orders, with Products (CRM)
SQL Joins
SQL Constraints
Null Functions:
PROCEDURE
TRIGGERS
Delete All
Interview Questions
Course Curriculum
Pramod Dutta
Founder of The Testing Academy, a YouTube Channel with 95K subscribers where Pramod teaches about Software testing & Test Automation. With overall 10+ years of experience in Software Testing & Test Automation, he has mentored 10,000+ students in Software Testing, API Testing, Test Automation.
Pramod Dutta is working as SDET Manager at Tekion | Ex BrowserStack Employee & BrowserStack Champion & Certified Scrum Master. Pramod has a vast range of experience handling from Manual Testing, Mobile & Web Automation, Desktop & cloud services like AWS, GCP extra.
By joining this Automation Testing Course , you’ll have the opportunity to take control of your life, work in an exciting industry with infinite possibilities and live the life you want.