SQL - Basics

Rapid Skillz

Course

Online

£ 47.42 VAT inc.

*Indicative price

Original amount in USD:

$ 59

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    Flexible

  • Start date

    Different dates available

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.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Database training
  • SQL
  • Database
  • Writing
  • Analytical
  • SQL Functions
  • Organization
  • Operational
  • Multiple tables
  • Problem-solving
  • SQL Operations
  • SQL Fundamentals
  • Structuring Databases

Teachers and trainers (1)

Name Name

Name Name

Teacher

Course programme

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

Additional information

LENGTH

2 hours 31 min

See related categories

SQL - Basics

£ 47.42 VAT inc.

*Indicative price

Original amount in USD:

$ 59

The best SQL Server courses

See all

See all