The Advance SQL course with Interview Questions
4.7 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
144 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Advance SQL course with Interview Questions to your Wishlist.

Add to Wishlist

The Advance SQL course with Interview Questions

SQL Advance tutorial with lots of Practice Exercises and Quizzes including Interview Questions
Best Seller
4.7 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
144 students enrolled
Created by Wilky Singh
Last updated 8/2017
English
Current price: $12 Original price: $75 Discount: 84% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 22 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Play with the SQL query
  • Play with the MYSQL database
  • Can build any complex applications that requires a Database Interaction
  • They will be able to crack the SQL database interview
View Curriculum
Requirements
  • One who is able to use PC
  • One who can understand english and can follow the steps taught in the course
  • You should be inquisitive, so that search and play with different permutations and combinations
Description

If you want to explore databases but don't  know where to start, then this course is for you. This course is a basic but has a comprehensive introduction to MySQL, And without doubt it is one of the  highly in-demand skills in the business sector today.  

If you work in IT,sales or marketing,  or you run your own company, or you want to build your own apps, mastering MySQL is crucial to answering complex business problems and questions using insights from data. By getting a good grasp over the MYSQL you can open an unlimited opportunities to your way.As these days data is the big issue and everybody is running after data as it is becoming very crucial so to stand in the race ahead and be competitive you should learn it.

In this course, you will learn:

  • Basic SQL syntax
  • Analyze data using Aggregate Functions
  • Run complex queries using MySQL logical operators and string functions
  • Solve some critical and complex interview tricky questions
  • Use all the common SQL joins with confidence
  • Date functions in MYSQL
  • Various String Functions
  • Interview Questions
  • You will solve various MCQ's 

This course  also contains huge number of exercises, challenges  and opportunities for you to practice . For an example to find the highest paid person in the MNCs, the highest rated actor,Some critical information regarding the GDP's and sales and marketing and total revenue generation in the required area in a particular year.

Upon completing this course, you’ll be able to interact with and query any SQL database out there. You’ll also be able to generate reports with ease, answer company performance questions using data, and integrate MySQL into complete applications.

MySQL is the most popular open source SQL database out there, so it’s a great choice to begin your learning journey. 

More than 90% of the learning in this course is common in MYSQL,Oracle and POSTgre.

After completing this course, you’ll be able to interact with and query any SQL database out there. You’ll also be able to integrate MySQL into complete applications and can generate some important data related to organisation performance country wise

Best of luck guys!!

Happy Coding!!

Who is the target audience?
  • Anyone wants to learn SQL to help with their current job or to find a new role.
  • Business persons, people in sales and marketing roles who are interested to explore company data better.
  • Those who wants to build apps that needs a database like MYSQL
  • Those who wants to clear the SQL interview
  • Those who wants to solve complex data problems using RDBMS
  • Those who wants to write complex SQL queries
Compare to Other Interviewing Skills Courses
Curriculum For This Course
77 Lectures
05:40:14
+
SQL Fundamentals
7 Lectures 31:48


Tables
01:45

SQL commands
03:11

Fields and rows
02:11

Data Integrity
02:14

MYSQL
01:51
+
DDL
4 Lectures 20:57
Create Database
03:28

Drop Database
03:32

Create Table
09:34

Drop Table
04:23
+
DML
6 Lectures 45:37
Insert And Select
12:24

Populate one table using other
05:55

where
08:13

OR
02:10

Update
08:39

Delete
08:16
+
Advance Section 1
14 Lectures 01:37:22
Like
08:11

Limit
03:36

Order By
05:27

Distinct
07:58

Group By
07:49

Group By 2
03:22

Joins
09:01

Inner Join
13:13

Left Join
06:35

Right Join
04:37

Self Join
08:36

Cross Join
03:10

Union
07:13

Null and Not Null
08:34
+
Advance 2
11 Lectures 01:28:06
Primary Key
09:40

Alias
04:39

Alter
05:38

Truncate
03:59

Views
06:52

Views 2
06:52

Transactions
02:58

Date
12:53

Sub Query
10:09

Sub Query 2
15:50

Having
08:36
+
Advance 3
8 Lectures 35:38
Case
08:31

Auto_Increment
06:10

Max
02:46

Min
02:22

SUM
02:38

Avg
03:34

NULLIF
03:44

Coalesce
05:53
+
Exercises
22 Lectures 01:29
Practice -1
00:04

Solution-1
00:04

Practice-2
00:02

Solution-2
00:03

Practice-3
00:02

Solution-3
00:03

Practice-4
00:03

Solution-4
00:12

Practice-5
00:05

Solution-5
00:05

Practice-6
00:03

Solution-6
00:08

Practice-7
00:02

Solution-7
00:01

Practice -8
00:02

Solution-8
00:02

Practice- 9
00:01

Solution- 9
00:04

Practice- 10
00:03

Solution- 10
00:04

Practice- 11
00:01

Solution- 11
00:09
+
Objective Questions
5 Lectures 19:25
Question-1
04:23

Question-2
03:37

Question-3
05:09

Question-4
04:08

Question-5
02:08
+
Quiz 1
0 Lectures 00:00
Quiz 1
5 questions

Intermediated Sql Questions

Quiz 2
5 questions

Quiz 3
7 questions
About the Instructor
Wilky Singh
4.3 Average rating
75 Reviews
3,673 Students
8 Courses
Programming Instructor and Technology Enthusiast

Passionate Mobile,Game and Backend Developer.Had worked in top notch organisations like Paypal, Dell R & D,TCS in the past.Have over a decade of experience in programming and software development.

Had Developed over 15 apps and 20 Mobile games for various Clients.And worked extensively as a Full Stack developer for the last 10 years .Game and Mobile development really fascinates me and in my opinion its a future.AI when integrated with mobiles will really blow ones mind in the future.