CareerVision Training

SQL – Basics

CareerVision Training
Online

£ 47 - (Rs 4,009)
VAT incl.

Important information

  • Training
  • Online
  • Duration:
    Flexible
  • When:
    Flexible
  • Online campus
Description

SQL – Basics Online Training Course Introduction
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.

Important information
Venues

Where and when

Starts Location
Flexible
Online

What you'll learn on the course

SQL Database
SQL Server
SQL Functions
Working with Dates
Creating and Structuring Databases
Searching Multiple Tables
Advanced Search Functions
SQL Basic

Course programme

SQL – Basics Online Training Course Introduction 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.

Course DescriptionIn this SQL – Basics training course, 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 Details
  • Length of Subscription: 12 Months Online On-Demand Access
  • Running Time: 2.31 Hours
  • Platform: Windows & MAC OS
  • Level: Beginner to Intermediate
  • Project Files: Included

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.


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