every sql topic includig, most complex topics like triggers, stored proc were explained easily for better understanding.
Note: Course Free for limited time and limited users(500 limit) so Enroll ASAP. If not free it means you are late. Scroll Down and click Enroll Now button to get enrolled
Scroll Down and click Enroll Now Button to get enrolled into the Free Course
Apply Coupon Code: E6AA065383AF13CEB15E
What you’ll learn
- Learns how to install mysql workbench
- Learns how to work with mysql commands
- Learns how data is stored and modified in SQL
- Will provide complete knowledge on all database objects of sql
- Data analytics, Data engineering, Data science, Database development
This course includes:
- 20 hours on-demand video
- 1 article
- 1 downloadable resource
- Access on mobile and TV
- Full lifetime access
- Certificate of completion
Course content
18 sections • 31 lectures • 19h 46m total lengthCollapse all sections
Introduction
- Introduction and Installation of MYSQL
- Introduction to mysql part – 1
- Introduction to mysql part -2
Commands and Data Types
- Commands
- Commands Part 2
- Commands Part 3
Constraints
- Constraints
- Constraints Part 2
Query Writing
- Query
Sample tables
- Banking tables Creation
Joins in SQL
- Joins
- Self Join
Sub Query
- Sub Query
Derived Table
- Derived table
Views
- Views
Stored Procedures
- Stored Prcedure
- Stored Procedure 2
- Stored Procedure 3 & Intro to Error Handling
Indexes
- Indexing
Triggers
- Triggers Intro
- Triggers Part 2
- Triggers Part 3
Error Handling
- Error Handling/Exception Handling
Functions
- Functions In SQL
- Functions Part 2
- Functions Part 3
Transaction Control Language & Data Control Language
- TCL & DCL
- TCL & DCL Part 2
Cursors & Wild Card Operators
- Cursors & Wild Card
Interview Questions
- Interview
Evaluate Your SQL skill for beginner
- How to enroll to SQL test
Requirements
- No programming knowledge required, Learner must have a laptop/computer to pracice
- Completely for beginners to make you expert.
Description
Why SQL
Store large number of records
Share huge data set among many people
Add and edit data easily
Quick and easy to find information
RDBMS TERMINOLOGY
Column as Attribute
Row as Entity Instance
Table as Entity
AlternateKey as UniqueKey
RELATIONSHIPS Cardinality
90% of the tables in database will be linked with another tables.
10%of the tables will be independent.
There are three types of relationships between tables
one to one
one to many
many to many
Tables can have a single / multiple relationships or may not have relationships.
Structured data – 2 dimensional data Rows,Columns
PrimaryKey in one table will be given as ForiegnKey in another table to build relationship.
DATA MODELING
RDBMS
PrimaryKey & ForiegnKey with relationship between them.
1 to 1 – any PrimaryKey can become ForiegnKey
1 to many employees in a department
PK of parent table will be FK in child table
Department table Deptid(PK),DeptName,
Employees Table Empid,EmpName,DeptId(FK)
many to many(students and teachers,patients & doctors,Hospital & Doctors)(TeacherId,TeacherName)(StudentId,StudentName,TeacherId)
New table will be created and extra column will be added(Bridge Table)
Patient Table(PatientNo(PK),PatientName,Adress),
Doctors Table(DoctorNo(PK),Name,Qualification,Salary, DateOfJoining, DateOfResigning)
Patient Doctor Table()
SDLC-Software Development Life Cycle
Requirement
Analysis & Design
Development
Testing
Release
Domain expert(SRS documentation)
Architect
SQL developers
Testers
Deployers(TL/Manager)
ERD(Entity Relationship Diagram)
Peter Chan-Used to design Database
Referential Integrity
SQL server performs existence check when we create relationship.
SELF REFERENTIAL TABLES
A table which has both PrimaryKey and ForiegnKey in it & ForiegnKey refering the primary key in the same table.
You are going to learn
commands (DDL,DML,DQL,DCL,TCL)
datatypes
constraints
CONSTRAINS
Null
Default
PrimaryKey
UniqueKey
ForiegnKey
Check
Auto Increment
views
operators
query writing
joins
sub query
derived table
Views
Indexes
Stored Procedures
Triggers
Functions
Cursors
Who this course is for:
- Beginner who is planning to learn mysql completely
- SQL for professional learners and working professionals and developers
Show less
Note: The course is free for a limited time and limited to 500 users. Enroll as soon as possible. If it is no longer free, it means you are late, and it has already exceeded its limits.
🎫 After adding the course into Cart at Checkout page, Apply Coupon Code➛. E6AA065383AF13CEB15E Note:- After applying coupon, if it says ”This coupon has exceeded its maximum possible redemptions…”, then it means you’re Late, and first 500 coupons already redeemed.
