Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 10 hours
Course Outline
Introduction to SQL and Relational Databases
- Grasping database architectures
- A look at SQL syntax rules
- Managing tables and schemas
Fundamental Querying Methods
- Extracting and mapping data
- Narrowing results via the WHERE clause
- Ordering output with ORDER BY
Connecting Multiple Tables
- Inner, left, right, and full outer joins
- Merging data from various sources
- Defining join criteria
Aggregation and Grouping
- Leveraging COUNT, SUM, AVG, MIN, and MAX
- Utilizing GROUP BY for categorization
- Filtering aggregate sets using HAVING
Subqueries and Nested Logic
- Scalar subqueries
- Correlated subqueries
- Employing subqueries for filtering and computations
Data Manipulation and Editing
- Adding new entries
- Modifying current records
- Securely removing data
Database Objects and Constraints
- Comprehending primary and foreign keys
- Creating and using views
- Setting up constraints and validation rules
Advanced SQL Strategies
- Window functions
- Common Table Expressions (CTEs)
- Performance optimization and basic query tuning
Conclusion and Future Directions
Requirements
- A solid grasp of fundamental data principles
- Prior interaction with spreadsheets or tabular structures
- General familiarity with corporate applications
Target Audience
- Data analysts
- IT specialists
- Individuals responsible for managing, querying, and analyzing data
Testimonials (3)
Need more self-learning and exercise to improve my skill
Alvin Wilta - PT LENTERA DANA NUSANTARA
Course - SQL Intermediate
It was very interactive and it kept us interested.
Raluca Alexandra PUNGA
Course - SQL Fundamentals
Small group, in-person for 3 days,