Planned training:
April 29
July 13
Price:
500€
Blended learning: study and from home ir from the class. Ability to change the format during training
Intensity: 68 hours
(all hours live, in real time with a lecturer)
Runtime: 4 weeks
Time: 4x/week 18:00-22:00
SQL is coded as "Structured Query Language" - a structured query language, that is, it is designed to "communicate" with the database. SQL can be used to create and manage a database ...
What will I learn?
What after training?
After these trainings, students are invited to continue participating in the school's mentoring program free of charge: for a whole month, if questions arise, they can both contact the school's lecturer and use the school's classrooms for independent study.
Training program
- What is SQL?
- History of SQL
- Importance of SQL and possible uses
- SQL Syntax
- SQL Databases
- Tables, Rows, Columns
- Data types
- SELECT
- WHERE Clause
- INSERT INTO
- UPDATED
- DELETE
- DISTINCT
- ORDER BY
- GROUP BY
- HAVING
- DISTINCT
- ORDER BY
- GROUP BY
- HAVING
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
- UNITY
- Subqueries in a WHERE clause in SQL
- Subqueries in a SELECT clause in SQL
- Subqueries in the FROM clause in SQL
- Indexes
- views
- Stored Procedures
- Date and time types
- Functions for dates and times
- SUM, AVG, MAX, MIN
- GROUP BY with Aggregation
- ROLLUP and CUBE
- OVER()
- PARTITION BY
- RANK(), ROW_NUMBER(), DENSE_RANK()
- BEGIN TRANSACTION, COMMIT, ROLLBACK
- Error handling in SQL queries
- Indexing strategies
- Query optimization tips
- An overview of NoSQL
- When to use SQL, when to use NoSQL
- Basic concepts of queries in NoSQL databases
1. Communication skills
• Active listening
• Effective communication
• Dealing with difficult customers
• Building a relationship
2. Problem solving strategies
• Problem analysis and diagnostics
• Determination of solutions
• Troubleshooting techniques
• Root cause analysis of the problem
• Latest problem solving
technologies
• How to get feedback from managers
• Professional development
3. Time management and organization
• Task prioritization
• Workload management
• Delegation and collaboration
4. Emotional intelligence
• Understanding and managing emotions
• Empathy and compassion
• Conflict resolution
• Stress management
5. How to learn more and faster and less
to forget
• 5 minute brain exercise
• Clear your “mental fog” with these 5
delicious brain foods
• Learn a powerful memory technique to
you would never miss a meeting
- The operation of artificial intelligence. How is it different from a human?
- Creating a request (Prompt). What is the difference between a good query and a bad one?
- Validation of results. Checking the received data for suitability in a specific case.
- Versioning Policy. Identification of the used software (vendor) version in the request.
- Artificial intelligence plugins in the code editor (IDE). Advantages and disadvantages.
- Generating comments using artificial intelligence.
- Creating tests with the help of a plugin.
- Code optimization with the help of a plugin.
Vilnius coding School CERTIFICATE
strong evidence that you are ready career ITEM!
Official certificate approved by the Education and Science Register
Recognized by the strongest Lithuanian and international companies
It proves that you have studied with the best specialists in your field
Reliable proof of acquired skills
Certificate issued by a company developing transparent activities in Lithuania
This certificate confirms that you attended at least 95% of the course lectures in real time with the lecturer, completed and defended the final thesis
Course lecturers
LUKA K.
Discount system
Normal cost of training
500 €
ALUMNI
we apply a 15% discount!
€ 425
(Full price
500 €)
Applies to all school graduates for all training and weekend workshops
RECOMMEND US TO A FRIEND
we apply a 10% discount!
€ 450
(Full price
500 €)
Applies if you come to study as a couple
