Learning SQL, MySQL & Databases is Easy

Learn to manipulate MySQL, SQL Server, Access, Oracle, Sybase, DB2 and other databases, increase your skills & earn more
3.5 (3 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.
42 students enrolled
Instructed by Wil Tru Development / Databases
$19
$20
5% off
Take This Course
  • Lectures 57
  • Length 4 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2015 English

Course 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.

What are the 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.

What am I going to get from this course?

  • 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.

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: SQL, MySQL & Databases
Intro
Preview
01:11
05:21

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

07:06

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

05:10

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

06:58

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

03:25

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

06:44

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

06:17

Get to know SQL AND OR for various database systems.

07:05

Learn about SQL Order By.

05:49

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

05:21

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

03:14

Learn about SQL Delete.

03:02

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

06:08

More information on database injection.

03:32

Learn about database injection prevention.

06:34

Learn about SQL Top & Limit.

09:36

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

04:06

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

05:20

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

07:05

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

00:45

Let's talk about SQL insert.

04:49

Learn about SQL joins and inner joins.

03:06

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

02:44

More on left joins.

01:25

Learn about full outer joins.

05:44

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

04:34

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

00:51

This lesson covers SQL CreateDB.

04:42

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

04:09

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

05:28

Let's take a look into SQL Unique.

04:22

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

08:05

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

05:26

Let's learn about default.

02:37

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

04:11

Let's learn about SQL Alter.

07:52

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

06:23

How to use view in database systems.

11:40

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

07:30

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

03:41

A little more on SQL IsNull.

08:57

What are SQL datatypes? Let's find out.

04:11

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

03:56

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

02:59

What is SQL First? Let's find out.

01:37

What is SQL Last? Let's find out.

02:19

In this lesson, we learn about SQL MaxMin.

01:39

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

02:34

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

02:10

Let's learn about SQL Having Count.

01:23

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

00:33

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

01:50

SQL Mid instruction for various database systems.

01:50

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

03:54

This lesson covers SQL Round.

01:32

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

02:15

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Wil Tru, 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.

Ready to start learning?
Take This Course