🔥 MYSQL DBA Certification Training (Use Code “𝐘𝐎𝐔𝐓𝐔𝐁𝐄𝟐𝟎”): https://www.edureka.co/mysql-dba
🔥 Edureka Computer Science Bootcamp Program: https://www.edureka.co/masters-program/computer-science-bootcamp-program
This Edureka SQL Full Course video will cover all the topics of Structured Query Language (SQL) starting from scratch. This SQL tutorial for beginners is great for beginners who want to learn SQL and for professionals who want to brush up their SQL skills. The following topics are covered in this SQL tutorial:
00:00 Introduction
2:00 What is RDBMS?
2:54 Normalization in DBMS
3:44 Normalization Types in DBMS
10:00 Data Types in SQL
***Database Commands***
17:03 Create Database Objects
25:04 Alter Table Statements
30:47 Drop Table Statements
32:05 Various Constraints
57:54 Creating Views
***Table Commands***
1:02:18 Insert Statements
1:07:47 Insert – As- Select Statement
1:13:58 Update Statements
1:20:05 Delete Statements
1:22:47 Select Statement
1:28:01 Select Statement: Alias
1:31:39 Select Statement: Distinct Values
1:32:49 Sorting
1:36:20 Filtering
***Comparison Operators***
1:45:29 NOT IN
1:45:58 IN
1:48:10 Symbols
1:49:21 Example
1:29:29 LIKE
1:52:37 CASE Expression
***Joins***
1:56:23 Joins
1:57:15 Self-Join
1:58:36 Inner Join
2:14:24 Left outer Join
2:19:46 Right outer Join
2:24:32 Full outer join
2:28:12 Cross Join
***Functions***
2:34:17 SQL Built-in Functions
2:37:20 Conversion Function
2:42:16 Logical Functions
2:48:44 Math Function
2:54:45 Aggregate Functions
3:02:28 String Functions
3:09:00 Date & Time Functions
3:11:55 Custom Functions
3:19:01 Stored Procedure
3:43:44 User Defined Functions
4:02:57 Triggers
Subscribe to our Edureka YouTube channel and hit the bell icon to get video updates: https://goo.gl/6ohpTV
Introducing Edureka Elevate, a one of its kind software development program where you only pay the program fees once you get a top tech job. If you are a 4th year engineering student or a fresh graduate, this program is open to you! Learn more: http://bit.ly/2vQKVu6
————————
📌𝐓𝐞𝐥𝐞𝐠𝐫𝐚𝐦: https://t.me/edurekaupdates
📌𝐓𝐰𝐢𝐭𝐭𝐞𝐫: https://twitter.com/edurekain
📌𝐋𝐢𝐧𝐤𝐞𝐝𝐈𝐧: https://www.linkedin.com/company/edureka
📌𝐈𝐧𝐬𝐭𝐚𝐠𝐫𝐚𝐦: https://www.instagram.com/edureka_learning/
📌𝐅𝐚𝐜𝐞𝐛𝐨𝐨𝐤: https://www.facebook.com/edurekaIN/
📌𝐒𝐥𝐢𝐝𝐞𝐒𝐡𝐚𝐫𝐞: https://www.slideshare.net/EdurekaIN
📌𝐂𝐚𝐬𝐭𝐛𝐨𝐱: https://castbox.fm/networks/505?country=IN
📌𝐂𝐨𝐦𝐦𝐮𝐧𝐢𝐭𝐲: https://www.edureka.co/community/
——————-
How does it work?
1. This is a 4 Week Instructor-led Online Course.
2. The course consists of 24 hours of online classes, 25 hours of assignment, 20 hours of project
3. We have a 24×7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course.
4. You will get Lifetime Access to the recordings in the LMS.
5. At the end of the training, you will have to complete the project based on which we will provide you with a Verifiable Certificate!
– – – – – – – – – – – – – –
About the Course
MySQL DBA Certification Training trains you on the core concepts & advanced tools and techniques to manage data and administer the MySQL Database. It includes hands-on learning on concepts like MySQL Workbench, MySQL Server, Data Modeling, MySQL Connector, Database Design, MySQL Command line, MySQL Functions etc. End of the training you will be able to create and administer your own MySQL Database and manage data.
– – – – – – – – – – – – – –
Who should go for this course?
This course can be beneficial for people having the below professional background:
Database Developers
Application Developers
Database Designers
Database Administrators
– – – – – – – – – – – – – –
Project
In the project you will be creating a Database using MySQL on SALARY MANAGEMENT SYSTEM:-
• Employee list to be maintained having id, name, designation, experience
• Salary details having employee id, current salary
• Salary in hand details having employee id, CTC salary, pf deduction or any other deduction and net salary to be given and also maintain details of total savings of employee
• Salary increment to be given by next year if any depending upon constraints
• Deduction in monthly salary if any depending upon any discrepancy in work and amount to be deducted.
– – – – – – – – – – – – – –
Got a question on the topic? Please share it in the comment section below and our experts will answer it for you.
For more information, please write back to us at sales@edureka,in or call us at IND: 9606058406 / US: 18338555775 (toll-free).
when we split the data in the second normal form will it not violate the first normal form?
Can I get full course of Pl Sql
Thanks Edureka ! Can you please provide us with the PPT and Source Code it would be helpful for revision….
Thanks to edureka team for this DBMS series 😊
It is really good video which gave basic of SQl. Could you pl provide few queries, would like to try an dcreate query using this knowledge.
This is very informative. Covered all topics in appropriate way. Could you help with ppt and source code for practice purpose??
best video , thank you so much , keep up the good work ❤
This is a very informative and easy to learn tutorial. Could you please help with the PPT and source code for practice purpose.
Thankqq so much for this video sir
Thank you for sharing this wonderful video,
Pls share me the PPT and sheets and source code for my training
TOP!
Thank you edureka for sharing this wonderful SQL video, this help me too clear all my problems which I had faced . I hope that you can also share ppt and all other sheets related to the videos, Lot of thank you……..
Can you plz provide the code sheet and ppt?
Thank you very much I got lot of sql knowledge by this video.Please make a video for Java 8 also.thank you
Can u pls provide pdfs sir
H, this was a very uselful seesion.can you please provide the PPT nd source code ..which will be help full while revision.
Superb sir
Can you plz provide pdf??
Each and every topic covered very well along with good examples. Thanks for sharing the such beautiful video to us.
Thanks to edureka for continous efforts to offer such a wonder course
Hi edureka, great training. Will it be possible to get PPT and source code for this
❣️
Thanks to edureka for continous efforts to offer such a wonder presentation… And I request you to share the PPT and source code which will be great to have for training… Thanks again
Thank you so much for this tutorial…I got the link via Twitter and I really find it useful. I will appreciate it if I can get the source code and ppt so that I can practice and go through it in stages. Thank you
Thank you sir
Could you please provide the ppt of this tutorial
Way of presentation and explaining way very nice sir..
If possible please share ppt.
Excellent Course by EDUREKA .request you to share the PPT and source code which will be great to have for training… Thanks again…!!!
What is the meaning of scema_name
That u have included as (dbo. )In stored procedures 3:25:15
Can u explain me this sir ..
Thank you edureka for giving deep description about SQL. please can you share PPT to prepare.
Where to share an e-mail ID to get Database, plz reply
hey buddy please provides the empDB database that u used
Ty
I can't able to use the MONEY keyword in my MySQL Workbench tool, it showing an error what should I use instead of MONEY keyword, Sir.
Amazing Course.
Where should I send you mail id to receive the ppt used in this video?
& Thank you!
Request you to share the PPT & Source Code.
Thanks.
Thanks for the nice video.Can you share the hard copy?Thanks
Great Video Session for the beginners, Request you to share the PPT & Source Code which will help us during the revision.
very very useful thank u
Very nice explanation any hard copy is with u
Thanks for this course edureka can you please share the data sheets ??
Good explanation it helped me a lot… Could provide ppt for that explanation
Hello edureka the tutorial is really helpfull can you provide the ppt it will be really helpfull
TQ for helping you are doing really great where no one can do tq a lot
Hello Edurekha team, Amazing course content and very easy to understant from scratch. It will be more helpful if its possible to get this PPT for further learning process
Thank you
Awesome video, explanation is too good .
@edureka Can i get this slides ppt ….?
Please share the PPT
This is incredible video session for all other tutorial .In this session tells clearly topic wise ……thank you so much sir for ur time!!!!
Thank you edureka for this useful content to share and teach with us.I hope that you also share ppt or cheatsheet for more clear about it.
Thank u….
The Course was very helpfull. Thank you.
Could you provide the dataset and ppt
can you please provide the ppt and datasheets
Thanks for the video edureka! Kindly provide me with the PPTs if possible.
Great learning platform could u please share pdf or ppt
Hey edureka, Amazing course and easy to understand😄😄. Thank you so much for this.
It would be really helpful if you please share the PPT and source code.
what is foreign key
Thanks for the detailed explanations of each and every aspect! Would be really helpful if you can share the datasets and Ppt.
Awesome Explanation.
Can you please provide us with the PPT and Source Code it would be helpful for revision….
Please share the ppt sir
Thank you so much for this tutorial, it has covered all the topic. It was very easy for me to Learn thanks to this video. Best Video for SQL on youtube
Hey @edureka! good class.. could you provide me with the PPT and the source codes?
How to get a certificate sir,
Oracle fusion & cloud is available
Thanks for giving valuable content 👍👍
You are a good teacher. Thank you for sharing such a thorough video.
where to find the dataset for this tutorial?
Thank-you!!
This course begins or intermediate level covered
Thank you soo much….can you provide examples pdf…..
Great course. Very well explained. However, the explanation for data types and how and when to use each of those, could be better, because complete beginners who have never worked with data types will have a hard time understanding it.
Where will I get cheat sheet of this?
Is this enough tutorial for freshers please tell me friends
1.44 what is the difference betwee '!=' and '<>'
Can I get notes for this course ?
14.58 What about TRUNCATE command ?
Educating for free.that's nobel
hello, from where we download SQL & which version we suppose to download. i have already download one of from microsoft site, it not working in window 10. please advice
Very Informative.
Great Tutorial.
Thank you edureka ♥
Got intuition about SQL. Thank you
Like a gem to see this video
Hatss off
Helped me a lot to understand those concept.. Thank you
Nice explanations i have never seen this type of voice clearance and knowledge exploration. Thank you.
really good explanation and your having oracle dba course vedios please share me
Easy to learn, Crystal clear and time saving! Thanks a lot!
This is an excellent video session… !!!! Thanks to edureka for continous efforts to offer such a wonder presentation… And I request you to share the PPT and source code which will be great to have for training… Thanks again…!!!
Excellent tutorial to Learn SQL …… And the Instructor is doing owsm job ….Well …explained sir …. please make detailed this type of tutorial on ORACLE … ❤️❤️❤️❤️🌹
Sir, all 3 normal forms r different rules that's OK sir, but why ,
For what region and how that rules r created..
Excellent tutorial to learn SQL,,,
Great video,,, I need a pdf of video content for SQL if it's available,,help to work on it
This is a very good brief lecture before going to interview thank you so much ❤️
Thanks 👍💐
Can you provide a link to the ppts for better understanding in the upcoming future?
this is a very good course Edureka, thank you……. Have you provided the PPT of this presentation?
Compared to other channels this video is best
Topics are very well framed and explanation was very nice.👍👍
Can you please send me that presentation sir?
can you share the slides of this course in the description?
Great explanation 😊…
This video helped me alot to know about sql. Its explained in a very detailed and understandable manner. I liked this channel. Thanks alot ☺
Got a question on the topic? Please share it in the comment section below and our experts will answer it for you. For Edureka MySQL DBA training curriculum, Visit our Website: http://bit.ly/2B5EwLJ Use code "YOUTUBE20" to get Flat 20% Off on this training. The following topics are covered in this video:
2:00 What is RDBMS?
2:54 Normalization in DBMS
3:44 Normalization Types in DBMS
10:00 Data Types in SQL
**Database Commands**
17:03 Create Database Objects
25:04 Alter Table Statements
30:47 Drop Table Statements
32:05 Various Constraints
57:54 Creating Views
**Table Commands**
1:02:18 Insert Statements
1:07:47 Insert – As- Select Statement
1:13:58 Update Statements
1:20:05 Delete Statements
1:22:47 Select Statement
1:28:01 Select Statement: Alias
1:31:39 Select Statement: Distinct Values
1:32:49 Sorting
1:36:20 Filtering
**Comparison Operators**
1:45:29 NOT IN
1:45:58 IN
1:48:10 Symbols
1:49:21 Example
1:29:29 LIKE
1:52:37 CASE Expression
**Joins**
1:56:23 Joins
1:57:15 Self-Join
1:58:36 Inner Join
2:14:24 Left outer Join
2:19:46 Right outer Join
2:24:32 Full outer join
2:28:12 Cross Join
**Functions**
2:34:17 SQL Built-in Functions
2:37:20 Conversion Function
2:42:16 Logical Functions
2:48:44 Math Function
2:54:45 Aggregate Functions
3:02:28 String Functions
3:09:00 Date & Time Functions
3:11:55 Custom Functions
3:19:01 Stored Procedure
3:43:44 User Defined Functions
4:02:57 Triggers