SQL Essential Training

Rating:
1 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 5
Loading...
Please Log in or register to rate

SQL Essential Training

DB-105

SQL Essential Training is designed to help users understand the basics of SQL, the most common language used to interact 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, Ram offers a solid working knowledge of the language, and shows how to retrieve and manage data efficiently. Each module is reinforced with structured hands-on exercises.

Audience

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

Course Topics

Module 1 – Basic select statements: 
Using the SELECT statement to retrieve all / specific rows, column aliases, concatenations, arithmetic operations, the DISTINCT keyword

Module 2 – Filtering and sorting the results: 
using simple (=, <, >, <> etc.) and complex (IN, BETWEEN, LIKE etc.) operators, combining condition using AND and OR, sorting the results using ORDER BY

Module 3 –  Scalar Functions: 
Using functions to manipulate strings, numbers and dates, converting data types, using conditional functions

Module 4 – Group Functions:  
Using aggregate functions such as – AVG, SUM, MIN, MAX and COUNT, using the GROUP BY clause, restricting the results using the HAVING clause

Module 5 – Join methods: 
Combining data from multiple sources using INNER / OUTER and SELF join

Module 6 – Sub Queries: 
using Single and Multiple row Subqueries

Module 7 – Add, modify, or remove data from a table:
using UPDATE, DELETE and INSERT

Module 8 – Creating new tables:
using CREATE, ALTER and DROP

Module 9 – Designing Additional DB Objects:
Working with Views, Indexes, and Sequences

© Copyright - Skilit - Site by Dweb