Course Outline
Lesson 1: Querying with unions and advanced joins
- Querying multiple tables with unions
- Advanced Joins
- Calculating with COMPUTE
Lesson 2: Querying with subqueries
- Subqueries
Lesson 3: Adding data
- Inserting data
- SELECT INTO
Lesson 4: Updating and removing data
- Updating records
- Deleting records
- Deleting the contents of tables
Lesson 5: Manipulating tables and views
- Creating tables
- Modifying tables
- Deleting tables
- Adding and removing views
Lesson 6: Manipulating indexes
- Adding and removing indexes
Lesson 7: Ensuring data integrity with transactions
- Transactions
Lesson 8: Creating databases
- Creating a database with SQL
- Deleting a database
Requirements
SQL: Fundamentals of Querying or equivalent knowledge.
Testimonials (3)
During the training, all modules were discussed in great detail - for two days of training - and that was what I cared about the most.
Bernadetta - Urząd Komisji Nadzoru Finansowego
Machine Translated
- I really liked that the entire training was tailored to the level of all users and to different environments. It was cool to see how queries differ in different environments. - A huge advantage here is that the presenter's goal was to share his knowledge with us, and not to show the participants how smart he is:) - I also consider learning from my own and other people's mistakes to be very valuable because it significantly broadens your horizons.
Kasia
Course - SQL Advanced
Machine Translated
The scope of topics discussed, practical tasks, the instructor's approach, and the involvement of participants
Agnieszka Flis
Course - SQL Advanced
Machine Translated