Course: Introduction to SQL
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
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.
Sign In
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.
read more about the order process
Een zakelijk account aanmaken
Wanneer u besteld namens uw bedrijf doet u er goed aan om aan zakelijk account bij ons aan te maken. Tijdens het registratieproces kunt u hiervoor kiezen. U heeft vervolgens de mogelijkheden om de bedrijfsgegevens in te voeren, een referentie en een afwijkend factuuradres toe te voegen.
Betaalmogelijkheden
U heeft bij ons diverse betaalmogelijkheden. Bij alle betaalopties ontvangt u sowieso een factuur na de bestelling. Gaat uw werkgever betalen, dan kiest u voor betaling per factuur.
Cursisten aanmaken
Als u een zakelijk account heeft aangemaakt dan heeft u de optie om cursisten/medewerkers aan te maken onder uw account. Als u dus meerdere trainingen koopt, kunt u cursisten aanmaken en deze vervolgens uitdelen aan uw collega’s. De cursisten krijgen een e-mail met inloggegevens wanneer zij worden aangemaakt en wanneer zij een training hebben gekregen.
Voortgangsinformatie
Met een zakelijk account bent u automatisch beheerder van uw organisatie en kunt u naast cursisten ook managers aanmaken. Beheerders en managers kunnen tevens voortgang inzien van alle cursisten binnen uw organisatie.
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.