
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.
- Using the SELECT statement to retrieve all / specific rows
- Column aliases
- Concatenations
- Arithmetic operations
- Using the DISTINCT keyword.
- using simple (=, <, >, <> etc.) and complex (IN, BETWEEN, LIKE etc.) operators
- Combining condition using AND and OR,
- Sorting the results using ORDER BY.
Using functions to manipulate strings, numbers and dates, converting data types, using conditional functions.
Using aggregate functions such as – AVG, SUM, MIN, MAX and COUNT, using the GROUP BY clause, restricting the results using the HAVING clause.
Combining data from multiple sources using INNER / OUTER and SELF join.
Using Single and Multiple row Subqueries
Add, modify, or remove data from a table using UPDATE, DELETE and INSERT
Using CREATE, ALTER and DROP.