SQL from basics to Advanced to become pro + Sql interview

Focused View

Challa venkata Tharun Reddy

19:46:35

46 View

1 - Introduction

1 - Introduction and Installation of MYSQL.mp4

30:18

2 - Introduction to mysql part 1.mp4

27:53

3 - Introduction to mysql part 2.mp4

23:26

2 - Commands

4 - Commands.mp4

39:18

5 - Commands Part 2.mp4

40:21

6 - Commands Part 3.mp4

39:40

3 - Constraints

7 - Constraints.mp4

42:35

8 - Constraints Part 2.mp4

44:07

4 - Query Writing

9 - Query.mp4

56:05

5 - Sample tables

10 - Banking tables Creation.mp4

40:04

6 - Joins in SQL

11 - Joins.mp4

01:03:37

12 - Self Join.mp4

27:48

7 - Sub Query

13 - Sub Query.mp4

33:18

8 - Derived Table

14 - Derived table.mp4

39:47

9 - Views

15 - Views.mp4

39:37

10 - Indexes

16 - Indexing.mp4

01:02:18

11 - Sored Procedures

17 - Stored Prcedure.mp4

38:17

18 - Stored Procedure 2.mp4

49:46

19 - Stored Procedure 3 Intro to Error Handling.mp4

38:03

12 - Error Handling

20 - Error HandlingException Handling.mp4

30:39

13 - Triggers

21 - Triggers Intro.mp4

42:07

22 - Triggers Part 2.mp4

33:13

23 - Triggers Part 3.mp4

42:28

14 - Functions

24 - Functions In SQL.mp4

54:32

25 - Functions Part 2.mp4

34:44

26 - Functions Part 3.mp4

33:21

15 - Transaction Control Language Data Control Language

27 - TCL DCL.mp4

34:30

28 - TCL DCL Part 2.mp4

13:57

16 - Cursors Wild Card Operators

29 - Cursors Wild Card.mp4

23:33

17 - Interview Questions

30 - Interview.mp4

01:07:13

Description

Every sql topic even the 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

Who is this for?

Beginner who is planning to learn mysql completely

What You Need to Know?

No programming knowledge required, Learner must have a laptop/computer to pracice

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

Software developer , Data Analyst And Trainer , Instructor at udemyTrained over 100s of students to boost up their skill and confidence from basic to advanced levels and to improve their confidence levels.Worked as a database developer in a huge software company for couple of years.Now continuing my journey as a advanced analytics engineer in a private firm.Also working as a mentor and trainer in multiple platforms.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.