X Online Skill Test

Arrange for a Callback

Name   Mobile
Email
Call us at:- +91-9958934646
Go

Create a free profile as



Sample Certificate

international-students
SQL_Basics.jpg

SQL - Basics

Indian : Rs.3835
International : $59
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.
OBJECTIVE
In 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.
CONTENT
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
LENGTH
2 hours 31 min
Frequently Asked Questions


traingtoatalcrse.png

Total Training

Total Training is a pioneer in innovative online and DVD-based training for leading creative design, digital video, and office productivity software programs.

Ranging from casual hobbyists to the most seasoned professionals, our users quickly learn new software applications and broaden their knowledge of programs currently used. Narrated in an entertaining format by industry experts and leading authors, our video-based software training titles are critical tools for anyone wanting to learn tips, techniques, and best practices from the most respected names in the business.

We currently offer affordable subscriptions to our All-Access Library, which contains hundreds of courses, thousands of clips, and project files so users can follow along.

Hot Courses

Our Partners

×