SQL - Basics
Course
Online
*Indicative price
Original amount in USD:
$ 59
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
Start date
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.
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
Teacher
Course programme
- 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
- 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
- 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
- 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
- Creating data views
- Finding null data
- 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
- 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
2 hours 31 min
SQL - Basics
*Indicative price
Original amount in USD:
$ 59