• views: 193
• date: 19 March 2025
• posted by: AD-TEAM

every sql topic includig, most complex topics like triggers, stored proc were explained easily for better understanding.

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

Requirements
No programming knowledge required, Learner must have a laptop/computer to pracice
Completely for beginners to make you expert.

Description
Why SQLStore large number of recordsShare huge data set among many peopleAdd and edit data easilyQuick and easy to find informationRDBMS TERMINOLOGYColumn as Attribute Row as Entity InstanceTable as EntityAlternateKey as UniqueKeyRELATIONSHIPS Cardinality90% 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 tablesone to oneone to manymany to manyTables can have a single / multiple relationships or may not have relationships.Structured data - 2 dimensional data Rows,ColumnsPrimaryKey in one table will be given as ForiegnKey in another table to build relationship.DATA MODELINGRDBMSPrimaryKey & ForiegnKey with relationship between them.1 to 1 - any PrimaryKey can become ForiegnKey1 to many employees in a departmentPK of parent table will be FK in child tableDepartment 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 CycleRequirement Analysis & Design Development Testing ReleaseDomain expert(SRS documentation) Architect SQL developers Testers Deployers(TL/Manager)ERD(Entity Relationship Diagram)Peter Chan-Used to design DatabaseReferential Integrity SQL server performs existence check when we create relationship.SELF REFERENTIAL TABLESA 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 CONSTRAINSNull DefaultPrimaryKey UniqueKeyForiegnKeyCheckAuto Incrementviewsoperatorsquery writingjoinssub queryderived tableViews IndexesStored ProceduresTriggers FunctionsCursors

Who this course is for:
Beginner who is planning to learn mysql completely,SQL for professional learners and working professionals and developers

For More Courses Visit & Bookmark Your Preferred Language Blog
From Here: - - - - - - - -




   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.