A Beginners Guide To SQL. Master SQL Quickly
4.0 (37 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.
595 students enrolled
Wishlisted Wishlist

Please confirm that you want to add A Beginners Guide To SQL. Master SQL Quickly to your Wishlist.

Add to Wishlist

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 (37 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.
595 students enrolled
Last updated 1/2017
English
Current price: $10 Original price: $50 Discount: 80% off
15 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Learn the fundamentals of SQL - no matter what database you use
View Curriculum
Requirements
  • PC or Mac
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.

Who is the target audience?
  • Anyone who wants to work with a database of any kind
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 34 Lectures Collapse All 34 Lectures 03:20:12
+
Getting Started With Databases And SQL
6 Lectures 25:34



0104 Select Syntax And Examples
04:58

0105 Where Can I Use SQL?
05:35

0106 Installing Sample Databases And Working Files
04:12
+
Using SQL To Select And Filter Data
8 Lectures 48:38
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
+
Functions, Grouping And Summarizing
5 Lectures 31:45
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
+
Joining Tables
5 Lectures 27:24
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
+
Data Modification
3 Lectures 26:40
0501 Amend Data In Tables
08:29

0502 Adding Data To Tables With Insert
09:31

0503 Removing Data From Tables
08:40
+
Creating And Altering Database Objects
4 Lectures 22:20
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
+
SQL Summary
2 Lectures 12:37
0701 The Main Variances In SQL Between Databases
05:38

0702 The Powerful Subquery
06:59
+
Conclusions
1 Lecture 05:14
0801 Wrap Up
05:14
About the Instructor
Infinite Skills
4.4 Average rating
36,229 Reviews
678,324 Students
331 Courses
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.