Learning SQL, MySQL & Databases is Easy
2.8 (2 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.
49 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learning SQL, MySQL & Databases is Easy to your Wishlist.

Add to Wishlist

Learning SQL, MySQL & Databases is Easy

Learn to manipulate MySQL, SQL Server, Access, Oracle, Sybase, DB2 and other databases, increase your skills & earn more
2.8 (2 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.
49 students enrolled
Created by Wil Tru
Last updated 7/2015
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Access and manipulate data in a variety of database systems including MySQL, SQL Server, Access, Oracle, Sybase, DB2, and others.
Understand databases to start or advance their careers and earn more money in tech, internet technology or at any company who stores their information in a database.
View Curriculum
Requirements
  • There is no pre-requisite information. It's best if students have access to some type of database to edit which can be setup online through a web hosting provider. However, it's possible to take this class with only a basic text editor like text edit, word pad or note pad.
Description

Learning to use SQL to access and manipulate MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems makes you a more valuable employee to any internet, tech or other company that stores their information in a database. That means when you learn SQL databases, you earn more money.

Understanding how to use databases can advance you on your current career path, help you start a new career or help you in building your own business. And it's both fun and easy to learn MySQL.

With experience working with databases for AutoZone, AutoAnything, Business dot com and a number of home brew websites, Wil can download his real work database experience directly to your brain. Get started learning databases today, so you can earn more tomorrow.

Who is the target audience?
  • Anyone looking to learn SQL or work with MySQL, SQL Server, Access, Oracle, Sybase, DB2 or other databases can benefit from this course.
  • Anyone looking to advance their career or make more money at companies that use databases.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 57 Lectures Collapse All 57 Lectures 04:12:47
+
SQL, MySQL & Databases
57 Lectures 04:12:47

What is SQL? Get a basic introduction in this lesson.

Preview 05:21

Learn how to use phpMyAdmin to work with SQL, MySQL and other database querying languages.

Preview 07:06

Learn how to use SQL, MySQL, DB2 and other querying languages.

SQL
05:10

Learn how to use the SELECT statement in SQL based querying languages.

SELECT Statement
06:58

In this lesson, we look at how to use SQL SELECT Distinct

SELECT Distinct
03:25

Learn about the SQL Where clause for SQL Server, MySQL, Access, Oracle, DB2, Sybase and other database systems.

SQL Where
06:44

Get to know SQL AND OR for various database systems.

And Or
06:17

Learn about SQL Order By.

Order By
07:05

Learn how to Insert Into in database systems like SQL Server, MySQL, Access, Oracle, DB2, Sybase and others.

Insert Into
05:49

Learn how to use Update in MySQL, SQL Server, Access, Oracle, DB2, Sybase and other database systems.

Update
05:21

Learn about SQL Delete.

Delete
03:14

Learn about database injection and how to avoid it in your database.

Injection
03:02

More information on database injection.

Injection Part 2
06:08

Learn about database injection prevention.

Injection Prevention
03:32

Learn about SQL Top & Limit.

Top & Limit
06:34

Learn about SQL Like & Not like in this quick lesson.

Like & Not Like
09:36

Learn how you can use SQL Wild Cards in your web development or database querying.

Wild Cards
04:06

Get to know the ins and outs of SQL between statements.

Between
05:20

Learn about SQL Alias for SQL Server, MySQL, Access, Oracle, DB2, Sybase and other database systems.

Alias
07:05

Let's talk about SQL insert.

Insert
00:45

Learn about SQL joins and inner joins.

Joins - Inner Join
04:49

What is a left join? Let's find out.

Left Join
03:06

More on left joins.

Left Join Cont.
02:44

Learn about full outer joins.

Full Outer Join
01:25

Let's look at UNION for SQL Server, MySQL, Access, Oracle, DB2, Sybase and other database systems.

Union
05:44

Let's take some time to learn about SQL SelectINTO for a variety of database systems.

SelectInto
04:34

This lesson covers SQL CreateDB.

CreateDB
00:51

This lesson covers SQL Create Table for Access, Oracle, SQL Server, MySQL, DB2, Sybase and other database systems.

Create Table
04:42

Learn about constraints in SQL Server, MySQL, Access, Oracle, DB2, Sybase and other database systems in this quick lesson.

Constraints
04:09

Let's take a look into SQL Unique.

Unique
05:28

What is a primary key? Let's find out.

Primary Key
04:22

What is a foreign key? Let's find out.

Foreign Key
08:05

Let's learn about default.

Default
05:26

Let's learn about drop and dropping a table, column or row from a database.

Drop
02:37

Let's learn about SQL Alter.

Alter
04:11

How to use Auto Increment in SQL, MySQL and other database systems.

Auto Increment
07:52

How to use view in database systems.

View
06:23

How to use date functions in SQL and other database systems like SQL Server, MySQL, Access, Oracle, DB2, Sybase.

Date
11:40

In this lesson, we cover how to use SQL IsNull.

IsNull
07:30

A little more on SQL IsNull.

Is Null2
03:41

What are SQL datatypes? Let's find out.

DataTypes
08:57

Let's learn about the AVG function in this quick lesson.

AVG Function
04:11

Let's learn about the SQL Count() function.

Count Function
03:56

What is SQL First? Let's find out.

first Function
02:59

What is SQL Last? Let's find out.

Last Function
01:37

In this lesson, we learn about SQL MaxMin.

MaxMin
02:19

Let's learn about SQL SUM for SQL Server, MySQL, Access, Oracle, DB2, Sybase and other database systems.

SUM
01:39

Let's learn about SQL GroupBy for SQL Server, MySQL, Access, Oracle, DB2, Sybase and other database systems.

GroupBy
02:34

Let's learn about SQL Having Count.

HavingCount
02:10

Let's study SQL ucase and look at how you can use it in your project.

Ucase
01:23

Let's learn about SQL Ucase for SQL Server, MySQL, Access, Oracle, DB2, Sybase and other database systems.

Ucase
00:33

SQL Mid instruction for various database systems.

Mid
01:50

Let's learn about SQL Len and how you can use it in querying.

Len
01:50

This lesson covers SQL Round.

Round
03:54

This lesson covers SQL Now() for a variety of database systems.

Now
01:32

This lesson covers SQL FORMAT for a variety of database systems.

Format
02:15
About the Instructor
Wil Tru
2.4 Average rating
17 Reviews
182 Students
7 Courses
CEO at Accomplish(dot)at

Wil has built technology and marketing programs for fortune 500 companies, top .com's and upstarts. He has over 10 years experience in business technology and marketing. He has worked in house or consulted for over 100 companies including AutoZone, Business(dot)com, AngiesList, CafePress, AutoAnything, WD40, Google and Adobe. Sign up for this class and download his brain as it relates to AngularJS, then use your new skill set to advance your career, build better technology and earn more money.