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).
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
Relational Databases & Data Models
- Data Models
- Relational Model
- The Electronics Data Model
- Relational DBMS
Tables & Data In tables
- Creating tables
- Tables details
- Table columns
- Insert, Alter and Drop tables
- CRUD
- Alias
Querying Multiple Tables
- Understanding Joins
- Querying with Inner Joins
- Querying with Outer Joins
- Querying with Cross Joins and Self Joins
Sorting and Filtering Data
- Sorting Data
- Filtering Data with a WHERE Clause
- Working with Unknown and Missing Values
Using Built In Functions
- Writing Queries with Built I n Functions
- Using Conversion Functions
- Using Functions to Work with NULL
Sorting and Filtering Data
- Using Aggregate Functions
- Using the GROUP BY Clause
- Filte ring Groups with HAVING
Prerequisites
- This course is designed for people with basic skills in Software (QA, Programming languages, technical support)