Course: Introduction to SQL

$199.00

$240.79 incl. vat

duration: 17 hours |

Language: English (US) |

access duration: 90 days |

Incompany available

Details

In this SQL training course you will learn the basics of Structured Query Language (SQL). You will learn how to create a default query, creating a more efficient database and the SQL security architecture.

Result

After finishing this training you are familiar with the basics of Structured Query Language (SQL).

Prerequisites

There is no specific knowledge required.

Target audience

Software Developer

Content

Introduction to SQL

17 hours

Introduction to SQL

start the course
identify a database and how it relates to SQL
describe the relational concepts of SQL, various database
types, and when and why they are used
use SQL to describe the differences between SQL and other
languages
describe in high level, structured query language and its
use
use SQL to create a simple statement
describe data types and their relation to SQL
use SQL to create a simple database example
describe tables and how to create them in SQL
use tables to further dive into the complexities of SQL
use the INSERT statement in SQL
use SQL to create more complex tables
use SQL to alter an existing table
use SQL to delete an existing table
use SELECT to take a look at a table
use the NULL statement in SQL
use the DEFAULT statement in SQL
use the SELECT statement in SQL queries
use SELECT to retrieve data from more than one table in
SQL
use SQL to create several data types
use DELETE to remove data from a table in SQL
use UPDATE to change data in SQL
use ORDER BY with results to sort data in SQL
use WHERE to filter data and retrieve requested results in
SQL
use all data management components in an example in SQL
describe SQL and the query while demonstrating how to create a
table and manipulate it

Introduction to SQL: Managing Table Design

start the course
use PRIMARY KEY in SQL
use both CREATE TABLE and add PRIMARY KEY constraint in SQL
use both ALTER TABLE AND PRIMARY KEY constraint in SQL
describe how to rename and alter a table in SQL
use SQL to ALTER and CHANGE data
describe DROP COLUMN and its use in SQL
describe a use case example of executing altering queries in SQL
describe the various math operators and functions
use SQL rounding numbers process
use SQL MIN and MAX processes
use SQL AVG and GROUP BY
use LIMIT and SELECT DISTINCT
use SQL arithmetic and grouping to create queries
describe the SUBSTRING() functioning in SQL
using the LENGTH function in SQL
use the REVERSE() function in SQL
use the TRIM() function in SQL
use date functions in SQL
use SOUNDEX() and DIFFERENCE() functions in SQL
use SQL string functions to create a query
manage data using SQL functions

Introduction to SQL: Multiple Tables and Advanced Queries

start the course
define multiple tables and describe their use in SQL
use SQL for the process of connecting tables
use FOREIGN KEY with CREATE in SQL architecture
describe relationships between tables and the different patterns
use composite keys and their relative values
describe the functional dependencies and their use
use functional dependencies in a example
use inner joins in SQL
use equijoins and non-equijoins and describe their differences in SQL architecture
use Outer Joins in SQL
use multiple joins and multiple conditions in SQL
use the UNION operator and describe how it combines results
describe a subquery and its use in SQL
use query as a SELECT column in SQL
use correlated and noncorrelated queries in SQL
use a query with a natural join
use IN, NOT IN commands in SQL
use correlated query with EXISTS and NOT EXISTS operators
use HAVING clause in SQL with queries
use queries with the UPDATE statement in SQL
use queries with the INSERT statement in SQL
use queries with the DELETE FROM statement in SQL
use SQL to create a more complex query
use SQL more efficiently with operational tips
describe the multiple layers of tables and their management in various SQL queries

Introduction to SQL: Views, Transactions, and SQL Security Architecture

start the course
describe views and their relation to the SQL architecture
use SQL to create a simple view
use the various views in SQL architecture
use SQL to update a view
use SQL to drop views
describe the various transactions and their use in SQL
describe the various ACID transactions and their use
use Transactions in SQL
use ROLLBACK statement in SQL
use the COMMIT statement in SQL
use ROLLBACK and COMMIT in an SQL query
use SQL to define Transact-SQL and the relation with transaction types
use transaction logs and define their purpose in SQL
describe locks and their use in SQL
use SQL to introduce the various levels of locking and their use
use SQL to describe the various lock modes
use SQL to identify the levels of locking
use SQL to create an implementation using locks
describe the various security concepts in SQL
use SQL to describe the philosophy behind User IDs and their use
use SQL to describe how to create a user and how to manage them
use SQL to describe the use of group IDs and roles in
use SQL to define the use of privileges and restrictions
use SQL security processes to create a user and a group with privileges
describe views, transactions, and the security model and the relation to SQL

Course options

We offer several optional training products to enhance your learning experience. If you are planning to use our training course in preperation for an official exam then whe highly recommend using these optional training products to ensure an optimal learning experience. Sometimes there is only a practice exam or/and practice lab available.

Optional practice exam (trial exam)

To supplement this training course you may add a special practice exam. This practice exam comprises a number of trial exams which are very similar to the real exam, both in terms of form and content. This is the ultimate way to test whether you are ready for the exam.

Optional practice lab

To supplement this training course you may add a special practice lab. You perform the tasks on real hardware and/or software applicable to your Lab. The labs are fully hosted in our cloud. The only thing you need to use our practice labs is a web browser. In the LiveLab environment you will find exercises which you can start immediately. The lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience.

WHY_ICTTRAININGEN

Via ons opleidingsconcept bespaar je tot 80% op trainingen

Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo

Spar met medecursisten en profileer je als autoriteit in je vakgebied.

Ontvang na succesvolle afronding van je cursus het officiële certificaat van deelname van Icttrainingen.nl

Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers

Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten

Orderproces

Once we have processed your order and payment, we will give you access to your courses. If you still have any questions about our ordering process, please refer to the button below.

What is included?

Certificate of participation	Yes
Monitor Progress	Yes
Award Winning E-learning	Yes
Mobile ready	Yes
Sharing knowledge	Unlimited access to our IT professionals community
Study advice	Our consultants are here for you to advice about your study career and options
Study materials	Certified teachers with in depth knowledge about the subject.
Service	World's best service

Platform

Na bestelling van je training krijg je toegang tot ons innovatieve leerplatform. Hier vind je al je gekochte (of gevolgde) trainingen, kan je eventueel cursisten aanmaken en krijg je toegang tot uitgebreide voortgangsinformatie.

FAQ

Niet gevonden wat je zocht? Bekijk alle vragen of neem contact op.

Cursusnaam
Looptijd
Rentebedrag financiering
Totaal bedrag
Maandbedrag

Vendors

Professions