A Beginners Guide To SQL. Master SQL Quickly

Name: A Beginners Guide To SQL. Master SQL Quickly
Rating: 4.2 (424 reviews)

SQL is the language of all databases, this course offers an easy way to master the SQL fundamentals

Created byInfinite Skills

Last updated 1/2017

English

What you'll learn

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

Course content

8 sections • 34 lectures • 3h 20m total length

Important - Download These First - Working Files0:01
0101 Relational Databases And Key Terms Explained8:08
0103 What Are The SQL Commands2:40
0104 Select Syntax And Examples4:58
0105 Where Can I Use SQL?5:35
0106 Installing Sample Databases And Working Files4:12

0201 Using Select To View Data4:08
0202 Sorting The Data5:57
Master sorting data with the order by clause in SQL Server, ordering by surname, first name, or email, using ascending or descending and multi-column sorts, and converting data types.
0203 Adding A Where Clause To Filter Data5:45
Master sql quickly by learning to filter data with the where clause, compare text and numeric fields, and order results using practical examples like gender, name, and salary.
0204 Filtering Date Columns4:33
0205 Working With Null Or Empty Values6:50
Learn to handle null or empty values in SQL by filtering for missing data and replacing nulls with defaults in select statements, using as for meaningful column aliases.
0206 Using Comments Within SQL6:01
0207 Use Of Wildcards In Filtering9:14
0208 Multiple Criteria Using And Or In6:10

0301 Add A Calculating Column To A SQL Statement3:14
0302 Text Manipulation Functions9:04
Master text manipulation in sql with left, right, and substring functions to extract initials, postcodes, and email prefixes from text fields, using char index to locate separators across sql variants.
0303 Differences In Date Functions Within SQL7:10
0304 Calculating Age6:24
0305 Concatenate Data Columns5:53
Learn how to concatenate data columns in SQL Server and Access, including adding spaces, using delimiters, and handling different data types with convert and format functions.

0601 Create A New Table7:09
Create a new table with the create table syntax, define fields and data types, and use identity for auto increment in sql server, with notes on access differences.
0602 Changing A Tables Structure4:59
0603 What Is A View And How To Create One7:00
Learn how to create and use views in SQL Server to pre-compile complex queries, rename columns, join tables, and filter data for efficient, reusable data retrieval.
0604 Alter Or Delete A View3:12

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 this course is for:

Anyone who wants to work with a database of any kind

A Beginners Guide To SQL. Master SQL Quickly

What you'll learn

Explore related topics

Course content

Getting Started With Databases And SQL6 lectures • 26min

Using SQL To Select And Filter Data8 lectures • 49min

Functions, Grouping And Summarizing5 lectures • 32min

Joining Tables5 lectures • 27min

Data Modification3 lectures • 27min

Creating And Altering Database Objects4 lectures • 22min

SQL Summary2 lectures • 13min

Conclusions1 lecture • 5min

Requirements

Description

Who this course is for: