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 (4)
Podczas szkolenia zostały bardzo szczegółowe - jak na dwa dni szkolenia - omówione wszystkie moduły, a na tym mi najbardziej zależało.
Bernadetta - Urząd Komisji Nadzoru Finansowego
Course - SQL Advanced
- 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
Podobało mi się 1.ćwiczenia po każdej teorii, 2. Trener sprawdzał czy pracujemy 3.Można było zadać pytania, 4.Ilość przerw była wystarczająca, bo trzeba złapać oddech 5. Materiały bardzo dobrze przygotowane 6. Narzędzie również do prezentacji bardzo fajne, intuicyjne