The SQL fundamentals tutorial
4.2 (15 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.
2,523 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The SQL fundamentals tutorial to your Wishlist.

Add to Wishlist

The SQL fundamentals tutorial

SQL fundamentals tutorial with Practice Exercises + Quizzes
4.2 (15 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.
2,523 students enrolled
Created by Wilky Singh
Last updated 8/2017
English
Current price: $10 Original price: $25 Discount: 60% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Play with the SQL query
  • Play with the MYSQL database
  • Can build any complex applications that requires a Database Interaction
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

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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
29 Lectures
02:59:57
+
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 The 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 table
05:55

Where Clause
08:13

Or Operator
02:10

Update
08:39

Delete
08:16
+
Miscellaneous
12 Lectures 01:21:35
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

Basic to Intermediate Query Practicing

Quiz 1
10 questions
About the Instructor
Wilky Singh
4.3 Average rating
43 Reviews
3,481 Students
5 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.