Have a Question? Call 0800 689 3038 or Click here to email us.
Cart 0
SQL Basics Online Training Course

SQL Basics Online Training Course

[ TTSQLBASIC ]

£48.00

Seen this product cheaper elsewhere?
We'll beat any like-for-like training quote!
CLICK HERE


Course Description

In this SQL Basics training course, presenter Dan Fanella covers many of the SQL functions that allow you to manipulate the data within the database. Upon completion of this series you will be thoroughly versed in SQL and writing queries for your database.

You will learn how to write SQL statements that enable you to query databases. The series will start with basic queries showing how to display data within a database and then move to more complex queries involving multiple tables.


Course Outline

A. Getting Started

  • What you’ll learn in this training
  • Designing and structuring of database
  • Writing SQL statements
  • Selecting columns from a table
  • Removing duplicate entries from a selection
  • Selecting specific records
  • Ordering the recordset output
  • Inserting records into your database
  • Updating a record in a database
  • Deleting a record from a database

B. Advanced Search Functions

  • Limiting number of rows returned
  • Searching for specific values using wildcards
  • Exploring the difference between equals and like
  • Using wildcards to expand your search
  • Specifying multiple values using the where clause
  • Selecting a range of values

C. Searching Multiple Tables

  • Joining tables with at least one match
  • Creating left and right join queries
  • Creating full join queries
  • Combining the results of 2 separate select statements
  • Renaming a tables reference

D. Creating and Structuring Databases

  • Using SQL to create a Database
  • Using SQL to create a Database table
  • Backing up data using SQL
  • Constraining data using SQL
  • Creating a Primary and Foreign Key pt. 1
  • Creating a Primary and Foreign Key pt. 2
  • Limiting data entered into a column
  • Setting to default value of a record
  • Creating table indexes
  • Deleting and dropping tables and databases
  • Modifying tables and databases
  • Auto-incrementing record set data

E. Special Data Functions and Instructions

  • Creating data views
  • Finding null data

F. Working with Dates

  • Understanding the date data type
  • Returning the current date and time
  • Returning a specific part of a date
  • Adding and subtracting from a specific date pt. 1
  • Adding and subtracting from a specific date pt. 2
  • Returning the difference between two dates

G. SQL Functions

  • Returning the average value of a column
  • Returning the number of rows that match the data
  • Returning the first and last record in a table
  • Returning the highest or lowest value of a column
  • Summing up all values within a numeric column
  • Grouping by one or more columns
  • Returning specific data from aggregate functions
  • Converting strings to upper and lowercase
  • Returning the length of the values within a column
  • Rounding the value of data within a numeric column

Course Features

PACKAGE INCLUDES:

  • Length of Subscription: 12 Months Online On-Demand Access
  • Running Time: 2.31 Hours
  • Platform: Windows & MAC OS
  • Level: Beginner to Intermediate


Learn anytime, anywhere, at home or on the go.

Stream your training via the internet, or download to your computer and supported mobile device, including iPad, iPhone, iPod Touch and most Android devices.

If you'd like a Free Demo of this product then please complete the form here :
Need to train your Team? Contact Us for Discounts on Multiple Subscription Purchases.

More from this collection