
About This Course
Syllabus
About This Training
This training is designed to help users understand the basics of SQL, the most popular language for interacting with databases.
This training covers all the major features of SQL: SELECT statements, Filtering and Sorting, Using Functions, Join Methods, SubQueries, Modifying Data, and Designing New Objects (Tables, Indexes, Views, etc.)
In this training, we offer a solid working knowledge of the language, and demonstrate how to retrieve and manage data efficiently. Each module is reinforced with structured hands-on exercises.
Target Audience
This course is mainly intended for Database Administrators, Database Developers, Business Intelligence professionals, QA professionals, Data Analysts, and other roles responsible for querying the database.
Prerequisites
- Basic working knowledge of relational databases.
- Basic understanding of the Microsoft Windows operating system.
- Overview of SELECT statement usage
- Retrieving all or specific rows from a table
- Implementing column aliases for clarity
- Utilizing concatenation for data combination
- Performing arithmetic operations within queries
- Employing the DISTINCT keyword for unique results
- Applying simple comparison operators (e.g., =, <, >, <>)
- Implementing complex operators (e.g., IN, BETWEEN, LIKE)
- Combining conditions using
- AND and OR logic
Ordering query results with the - ORDER BY clause
- Manipulating strings, numbers, and dates with built-in functions
- Converting data types for compatibility
- Employing conditional functions for custom data manipulation
- Leveraging aggregate functions (e.g., AVG, SUM, MIN, MAX, COUNT)
- Grouping data using the GROUP BY clause
- Filtering grouped results with the HAVING clause
- Merging data from multiple sources using INNER JOIN and OUTER JOIN
- Implementing SELF JOIN for data comparisons within a single table
- Understanding single-row and multi-row subqueries
- Nesting subqueries for advanced data analysis
- Adding, updating, or deleting data with INSERT, UPDATE, and DELETE commands
- Designing new tables with the CREATE command
- Modifying existing tables using ALTER
- Removing tables with the DROP command