Do It Yourself – Tutorials – SQL Full Course | SQL Tutorial For Beginners | Learn SQL (Structured Query Language) | Edureka

by | Oct 22, 2020 | 0 comments

Do It Yourself – Tutorials – SQL Full Course | SQL Tutorial For Beginners | Learn SQL (Structured Query Language) | Edureka

by | Oct 22, 2020 | Do It Yourself - Build Your Own Website | 0 comments

Do It Yourself – Website Tutorials



** MYSQL DBA Certification Training (Use code: YOUTUBE20) – https://www.edureka.co/mysql-dba **
This SQL Full Course video will cover all the topics of Structured Query Language (SQL) starting from scratch. This video 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 video:
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

——————————————————————————————————–
Instagram: https://www.instagram.com/edureka_learning
Facebook: https://www.facebook.com/edurekaIN/
Twitter: https://twitter.com/edurekain
LinkedIn: https://www.linkedin.com/company/edureka
——————————————————————————————————-
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 [email protected],in or call us at IND: 9606058406 / US: 18338555775 (toll-free).

source

0 Comments

Submit a Comment

What Our Clients Are Saying

British Columbia Coalition Of Motorcyclists

We've been working with Dieno Digital, for the past year and a half now and couldn't be happier with all...

Tara, British Columbia Coalition Of Motorcyclists

Dieno Digital Marketing Services
5
2018-04-27T22:05:28+00:00

Tara, British Columbia Coalition Of Motorcyclists

We've been working with Dieno Digital, for the past year and a half now and couldn't be happier with all the updates  to our website. Leland is always very responsive and able to answer all of questions or fix any issues in no time at all. We look forward to continuing to expanding and broadening our website with Dieno Digital.

Amplifylife.ca

Been working with Leland on a project for a Not-For-Profit organization and it is a pleasure to be able to...

Rob - Amplylife.ca

Dieno Digital Marketing Services
5
2018-05-03T19:49:40+00:00

Rob - Amplylife.ca

Been working with Leland on a project for a Not-For-Profit organization and it is a pleasure to be able to bring a high level of creativity, energy, expertise and professionalism to the project for their digital marketing needs. We are so excited for the chance to work more with Leland and Dieno Digital.

FS Designs

Leland is extremely knowledgeable and super pleasant to deal with. He helped me get my website running for my graphic...

F.S.

Dieno Digital Marketing Services
5
2018-06-19T18:50:18+00:00

F.S.

Leland is extremely knowledgeable and super pleasant to deal with. He helped me get my website running for my graphic design business and improved my SEO so that I appear more frequently and near the top of searches. He a great digital and web strategist and I would highly recommend his services.

Juju Hair Lounge

Great class! Not only was it very informative but it was also really entertaining! I can't wait to apply everything...

Leah

Dieno Digital Marketing Services
5
2018-07-09T03:06:21+00:00

Leah

Great class! Not only was it very informative but it was also really entertaining! I can't wait to apply everything I've learned to our Facebook business page!
5
4
Dieno Digital Marketing Services