Course Outline
Module 1: Querying using unions and advanced joins
- Querying across multiple tables via unions
- Advanced join mechanisms
- Performing calculations with COMPUTE
Module 2: Querying with subqueries
- Utilizing subqueries
Module 3: Data insertion
- Inserting new data
- Using SELECT INTO
Module 4: Modifying and removing data
- Updating existing records
- Deleting specific records
- Emptying table contents
Module 5: Managing tables and views
- Creating new tables
- Altering existing tables
- Removing tables
- Adding and deleting views
Module 6: Managing indexes
- Creating and dropping indexes
Module 7: Guaranteeing data integrity through transactions
- Managing transactions
Module 8: Database creation
- Creating a database using SQL
- Removing a database
Requirements
- A solid grasp of fundamental SQL syntax and core query methods
- Practical experience in constructing and running SQL queries, particularly SELECT statements
- Successful completion of SQL: Fundamentals of Querying or comparable foundational knowledge
Target Participants
- Database administrators looking to elevate their SQL proficiency
- Developers and analysts focused on designing and governing complex database schemas
- IT specialists aiming to streamline and manipulate data using advanced SQL methodologies
Testimonials (7)
What I liked the most, was the practical part.
Andreea - REGNOLOGY ROMANIA S.R.L.
Course - SQL Advanced
The pace and balance of the lecture and exercise part was very well done. The whole course was very easy going.
Sebastian - REGNOLOGY ROMANIA S.R.L.
Course - SQL Advanced
Very well structured, oriented towards exercises, applicability.
Brindusa-Angela - REGNOLOGY ROMANIA S.R.L.
Course - SQL Advanced
The exercises were a very good way to structure the information and the best way to make sure you understood/settle everything presented.
Raluca - REGNOLOGY ROMANIA S.R.L.
Course - SQL Advanced
Everything, the exercises, the thorough explanations, Philip is a great trainer!
Zsolt - REGNOLOGY ROMANIA S.R.L.
Course - SQL Advanced
Practical exercises
Bob - REGNOLOGY ROMANIA S.R.L.
Course - SQL Advanced
The teaching style, examples and the learning environment together with the way in which the exercises part was structured.
