A Beginners Guide To SQL. Master SQL Quickly

SQL is the language of all databases, this course offers an easy way to master the SQL fundamentals
4.0 (24 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.
565 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 34
  • Length 3.5 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 3/2014 English

Course Description

This SQL training course from Infinite Skills teaches you how to use SQL to manage data that is held in relational databases. This training course is designed for beginners who have no previous experience with SQL of any kind.


You will start by learning how to use SQL (Structured Query Language) to select and filter data from a database, including sorting the data, filtering date columns, and working with null or empty values. The course then teaches you about common SQL functions, such as text manipulation, and how to group and summarize. This video tutorial also covers topics such as joining tables, data modification, and creating new tables and views. Finally, you will learn about the powerful subquery, and the main variances in SQL between database types.

Once you have completed this computer based training course, you will have a fundamental knowledge of what SQL is and how you can apply it to different database types. Working files are included, allowing you to follow along with the author throughout the lessons.

What are the requirements?

  • PC or Mac

What am I going to get from this course?

  • Learn the fundamentals of SQL - no matter what database you use

What is the target audience?

  • Anyone who wants to work with a database of any kind

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: Getting Started With Databases And SQL
Important - Download These First - Working Files
Preview
Article
0101 Relational Databases And Key Terms Explained
Preview
08:08
0103 What Are The SQL Commands
02:40
0104 Select Syntax And Examples
04:58
0105 Where Can I Use SQL?
05:35
0106 Installing Sample Databases And Working Files
04:12
Section 2: Using SQL To Select And Filter Data
0201 Using Select To View Data
04:08
0202 Sorting The Data
05:57
0203 Adding A Where Clause To Filter Data
05:45
0204 Filtering Date Columns
04:33
0205 Working With Null Or Empty Values
06:50
0206 Using Comments Within SQL
06:01
0207 Use Of Wildcards In Filtering
09:14
0208 Multiple Criteria Using And Or In
06:10
Section 3: Functions, Grouping And Summarizing
0301 Add A Calculating Column To A SQL Statement
03:14
0302 Text Manipulation Functions
09:04
0303 Differences In Date Functions Within SQL
07:10
0304 Calculating Age
06:24
0305 Concatenate Data Columns
05:53
Section 4: Joining Tables
0401 Which Tables Can I Join And How?
06:25
0402 Joining More Than Two Tables
04:23
0403 Using Different Join Types
05:50
0404 The Special Cross Or Cartesian Join
03:43
0405 Group And Summaries Within Joined Table SQL
07:03
Section 5: Data Modification
0501 Amend Data In Tables
08:29
0502 Adding Data To Tables With Insert
09:31
0503 Removing Data From Tables
08:40
Section 6: Creating And Altering Database Objects
0601 Create A New Table
07:09
0602 Changing A Tables Structure
04:59
0603 What Is A View And How To Create One
07:00
0604 Alter Or Delete A View
03:12
Section 7: SQL Summary
0701 The Main Variances In SQL Between Databases
05:38
0702 The Powerful Subquery
06:59
Section 8: Conclusions
0801 Wrap Up
05:14

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Ready to start learning?
Take This Course