Introduction to SQL | | Software Development
Introduction to SQL
Duration
16 hours
Location
Online
Language
English
Code
DEV-010
29.05.2023 - 31.05.2023
400.00 *
Training for 7-8 or more people? Customize trainings for your specific needs
Description
This training offers an introduction to SQL and helps participants develop the necessary skills for searching and modifying data in SQL databases. It is aimed at developers, analysts and other specialists who need to learn SQL basics.
After completing the course, a certificate
is issued on the Luxoft Training form
is issued on the Luxoft Training form
Objectives
- Perform simple search operations
- Perform search using several tables
- Perform search with sorting
- Modify data in a database
Target Audience
Developers, analysts and other specialists who need to learn SQL basics.
Roadmap
- Introduction to relational databases. Normalization
- Basics of DDL. Creating tables and indexes. SQL Data types
- Referential integrity. Restricting column values to values present in referenced table only. Foreign keys and REFERENCES clause
- Queries. SELECT statement for single table, filtering rows with WHERE, built-in functions
- Practice
- Table joins. Selecting data from multiple linked tables
- Subqueries. Using other query results in filtering rows and calculating additional columns
- Sorting and grouping data
- Aggregate functions (COUNT, MIN, MAX, SUM)
- Practice
- Window functions. Complex aggregations
- Practice
- How are SQL queries handled? Execution plan
- Insert, update, and delete data (INSERT, UPDATE, DELETE). Using these operations with subqueries
- Practice
- General concepts of transactions and data integrity. COMMIT and ROLLBACK statements. ACID properties of transactions
- Practice
Schedule and prices
View:
Trainers
Riti Raul
Software Testing Consultant
Raul is currently working as a software tester in a financial software development project. He is responsible, among others, for creating and executing software test plans, cases and scripts. In addition, he also handles UI / UAT tests and DB tests as well as Defect & Bug tracking and reporting.
In the past he has worked for an e-commerce extension developer where he did manual testing and created technical documentation for these extensions. He is ISTQB certified and has previously delivered various courses on software testing.
For Luxoft Training, he also facilitates our software testing solutions such as ISTQB Foundation Level Preparation, Defect Management, Introduction to SQL for Testers and more.
Raul is currently working as a software tester in a financial software development project. He is responsible, among others, for creating and executing software test plans, cases and scripts. In addition, he also handles UI / UAT tests and DB tests as well as Defect & Bug tracking and reporting.
In the past he has worked for an e-commerce extension developer where he did manual testing and created technical documentation for these extensions. He is ISTQB certified and has previously delivered various courses on software testing.
For Luxoft Training, he also facilitates our software testing solutions such as ISTQB Foundation Level Preparation, Defect Management, Introduction to SQL for Testers and more.
Courses you may be interested in
Oracle® 11g, Basics of PL/SQL Language
The course is an introduction to the Oracle PL/SQL procedural language. The language version used in DBMS 11g is considered in this training.
