Learn My Sql from basics to advace
3.9 (50 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,062 students enrolled

Learn My Sql from basics to advace

Learn SQL and Database Development to work effectively in DBMS like MySQL, SQL Server, Oracle etc.
3.9 (50 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,062 students enrolled
Created by Rahul sohdey
Last updated 10/2019
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Become an In-demand SQL Master by creating complex databases and building reports through real-world projects
Course content
Expand 55 lectures 04:48:44
+ Introduction
55 lectures 04:48:44
Workbench and Command Line Client
05:45
Things You Need To Know About Tables
06:45
Create, Use and Drop Databases
05:01
Data-Types in SQL (Part-1)
05:11
Data-Types in SQL (Part-2)
06:41
Constraints in SQL
04:11
Create Table Statement
07:41
Creating Tables from Other Tables
05:45
Removing Tables from Database
03:00
Inserting Data Into Tables
09:59
Inserting Data Into a Table From Another Table
06:55
The SELECT Query
03:14
Arithmetic Operators
05:08
Comparison
10:47
Logical Operators (Part-1)
10:35
Logical Operators (Part-2)
06:52
The WHERE clause
04:04
AND & OR operators
03:48
The update Query
06:01
The DELETE Query
03:56
The Like Operator and Wildcard Characters
07:28
The TOP and LIMIT Clauses
03:32
The ORDER BY Clause
04:27
The GROUP BY Clause
08:00
The Dinstinct Keyword
02:22
Aliasing Through AS Clause
02:24
SQL JOINS
07:47
Using GROUP BY Clause with SQL JOINS
05:10
Left Outer Joins
03:33
Right Outer JOIN
03:08
ABS() Function
04:33
ROUND() Function
06:42
DIV() & MOD() Functions
03:59
Useful Numeric Functions Part-1
05:08
Useful Numeric Functions Part-2
04:20
The CONCAT() Function
04:03
UPPER() and LOWER() Functions
02:45
The TRIM() Function
02:27
SUBSTR(), RIGHT()
04:23
The LENGTH() & INSERT() Functions
04:33
REPEAT() & REPLACE() Functions
02:18
REVERSE()
03:12
Date
05:03
Date
05:27
Date
06:42
Views in SQL (Part-1)
05:28
Views in SQL (Part-2)
06:34
Views in SQL (Part-3)
03:15
Aggregate Functions (Part-1)
04:41
Aggregate Functions (Part-2)
02:02
The TRUNCATE TABLE Command
02:41
Subqueries in Sql
05:10
The Alert Table command
05:19
Requirements
  • all you need is just a pc
Description


You will learn SQL with practical examples. By learning structured query language, you will be able to work in any database system like MySQL, PostgreSQL, SQL Server, DB2, Oracle etc.

  • You will learn Database designing, Database modeling, SQL RDBMS concepts, Database relationships and much more, everything by using SQL commands.

  • You get a SQL video tutorial course which will teach you how to use structured query language statements in MySQL command line client tool. The SQL statements are common to all major database management systems.

  • Lightning fast support to all your queries: I personally respond to all
    the students queries via PM or on the discussion board within 1 hour to 24 hours. I respond on weekends too. So If you have any question feel free to PM me or ask on the discussion board.

  • Lifetime access to all the content and future updates of this course.

  • 30 days money back guarantee. (I am sure you will never need this.)


    You will understand how SQL works and learn effective database design for your applications.

    In this course we'll learn SQL with practical example on every topic. We will learn in more detail about,

    • Database Installation and SQL fundamentals.

    • Data Definition Language(DDL) and Data Manipulation Language(DML).

    • SQL Joins, SQL functions and SQL data types.

    • Database Relationships and Database Normalization.

    • Database Export and Import.

    • MySQL workbench.

Who this course is for:
  • anyone who wants to learn to code