Learn SQL and MySQL in 3 Hours

Learn SQL and MySQL in 3 Hours, available at $34.99, has an average rating of 4, with 46 lectures, 6 quizzes, based on 316 reviews, and has 2132 subscribers.

You will learn about Create SQL/MySQL based applications for companies of all shapes and sizes Understand all concepts of SQL and databases Analyze tons of data in few seconds Make better fact based decisions Spot trends and patterns easily in pile of data This course is ideal for individuals who are Marketing professional who wants to make better fact based decisions or University students working towards computer science or IT degree or Analytic Users or Someone who loves learning everything about technology or Anyone who wants to know how major IT companies stores all your data It is particularly useful for Marketing professional who wants to make better fact based decisions or University students working towards computer science or IT degree or Analytic Users or Someone who loves learning everything about technology or Anyone who wants to know how major IT companies stores all your data.

Enroll now: Learn SQL and MySQL in 3 Hours

Summary

Title: Learn SQL and MySQL in 3 Hours

Price: $34.99

Average Rating: 4

Number of Lectures: 46

Number of Quizzes: 6

Number of Published Lectures: 45

Number of Published Quizzes: 6

Number of Curriculum Items: 52

Number of Published Curriculum Objects: 51

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Create SQL/MySQL based applications for companies of all shapes and sizes

Understand all concepts of SQL and databases

Analyze tons of data in few seconds

Make better fact based decisions

Spot trends and patterns easily in pile of data

Who Should Attend

Marketing professional who wants to make better fact based decisions

University students working towards computer science or IT degree

Analytic Users

Someone who loves learning everything about technology

Anyone who wants to know how major IT companies stores all your data

Target Audiences

Marketing professional who wants to make better fact based decisions

University students working towards computer science or IT degree

Analytic Users

Someone who loves learning everything about technology

Anyone who wants to know how major IT companies stores all your data

Master SQL in less than 3 Hours :

Do You Want to Become a professional Software / Web Application Developer and increase your income Exponentially ?

Are you a Marketing Professional Who wants to use SQL for making Better Marketing Decisions ?

Are you a University Student Working Towards a Computer Science or Information Technology Degree ?

Then look no further as you have come to the right place. I have been working with SQL for more than 7 Years now and am currently working as an Application developer. This in-depth course on SQL taught by me covers everything from the very basic definitions to very complex concepts of RELATIONAL DATABASES , FOREIGN KEYS and JOINS so that by the time this course ends, You will have an excellent understanding of all the important concepts of SQL to get things rolling for you.

SQL can be used in almost all fields in today’s technology driven world whether you are into your own business or into marketing or into development of Web / Mobile applications. You can use SQL to Analyze tons and tons of data within milliseconds and use the results of analysis to make better fact and data based decision thereby increasing the chances of arriving at a correct decision.

I can assure you that you will enjoy this course and hope that you would make the most of the knowledge you would have gained by the end of this course. Thanks and hope to see you in Lectures.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: SQL Powerpoint Presentation ( For your reference )

Lecture 3: What is SQL ?

Lecture 4: What is MySQL ? How does it Differ from SQL ?

Lecture 5: Installation in Mac , Windows and Linux Machines

Lecture 6: Possible Installation Problem

Lecture 7: Further Installation instructions for Mac

Lecture 8: What is DB and Table ?

Lecture 9: How to create DB and Tables ?

Chapter 2: Inserts , Selects and Updates

Lecture 1: add Data with INSERT

Lecture 2: See Data with SELECT

Lecture 3: LIMIT

Lecture 4: conditions with WHERE clause

Lecture 5: modify Data with Update

Lecture 6: Table structure change with ALTER

Lecture 7: AND as well as OR Clause

Lecture 8: Sort result using ORDER BY Clause

Lecture 9: IN Clause

Lecture 10: Find Patterns in Data with LIKE Clause

Lecture 11: Selecting specific Fields / Columns

Lecture 12: DISTINCT

Lecture 13: ALIAS

Lecture 14: Test – INSERTS , SELECTS and UPDATES

Chapter 3: MySQL Datatypes and Constraints

Lecture 1: Datatypes

Lecture 2: Constraints

Chapter 4: JOINS and UNIONS

Lecture 1: Creating base for Future Lectures

Lecture 2: Relational Databases ?

Lecture 3: What is a FOREIGN KEY Constraint ?

Lecture 4: What are JOINS ?

Lecture 5: LEFT JOIN

Lecture 6: RIGHT JOIN

Lecture 7: INNER JOIN

Lecture 8: UNION

Lecture 9: Subquery . Query inside another Query

Chapter 5: GROUPS and MySQL Functions

Lecture 1: MySQL Functions

Lecture 2: GROUP BY Clause

Lecture 3: HAVING Clause

Chapter 6: VIEWS

Lecture 1: What are VIEWS and how to Create Them ?

Lecture 2: ALTER and DROP VIEWS

Lecture 3: Test – CREATE , ALTER and DROP VIEWs

Chapter 7: DELETEs , DROPs and TRUNCATEs

Lecture 1: DELETE data from tables

Lecture 2: TRUNCATE Tables , DROP Tables and Database

Lecture 3: 25+ Sample Queries

Lecture 4: Importing Tables and Data to your local PhpMyAdmin

Lecture 5: 30+ Sample Queries

Instructors

Umang Shah
Software / Web Application developer and now a teacher

Rating Distribution

1 stars: 5 votes

2 stars: 3 votes

3 stars: 38 votes

4 stars: 114 votes

5 stars: 156 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!