24 Hours 
TDXBI-103 Course outline
Learning the SQL language is one of the most basic tasks required for the use of relational database. SQL proficiency is essential for business users, database developers, database administrators and any other d atabase professional. This course introduces the basics of the SQL language and the Relational Database Management System (RDBMS).
The first part of this course explains the logical models upon which a relational database is based on, and the various configurations and environments in which you may work with the SQL database. The next part focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this course covers the DDL, DML and transaction control portions of the SQL language that allow to create, maintain and manipulate application database objects and application data.
Upcoming meetings
There are no upcoming meetings for this course. Contact us to schedule this course, which will be customized specifically for your organization.
info@hackerupro.comModules
- Data Models
- Relational Model
- The Electronics Data Model
- Relational DBMS
- Creating tables
- Tables details
- Table columns
- Insert, Alter and Drop tables
- CRUD
- Alias
- Understanding Joins
- Querying with Inner Joins
- Querying with Outer Joins
- Querying with Cross Joins and Self Joins
- Sorting Data
- Filtering Data with a WHERE Clause
- Working with Unknown and Missing Values
- Writing Queries with Built I n Functions
- Using Conversion Functions
- Using Functions to Work with NULL
- Using Aggregate Functions
- Using the GROUP BY Clause
- Filte ring Groups with HAVING
Prerequisites
- 01 This course is designed for people with basic skills in Software (QA, Programming languages, technical support)
