SQL Essentials
- Created By raju2006
- Last Updated December 11th, 2023
- Overview
- Prerequisites
- Audience
- Audience
- Curriculum
Description:
Master Database Management with Hands-On Training: Learn to Create, Delete, and Manage Tables, Grant/Revoke Access, and Perform Data Operations in MySQL. Get Ready for Practical Exercises with Pre-Class Software Installation Support
Course Code/Duration:
BDT159 / 6 hours (Two Sessions, 3-3-hours )
Learning Objectives:
The course includes presentations, demonstrations, and hands-on labs.
- Introduction to databases and MySQL
- SQL Commands Types (DDL, DML, DCL, TCL)
- Creating users and grant/revoke accesses
- Creating schemas and tables
- Inserting, deleting, and updating data
- Data Retrieval using the SELECT statement
- SQL conversion functions: CASE, DATE_FORMAT, NULLIF, COALESCE, etc.
- Sorting and filtering data, wildcard filtering, and regular expressions.
- Manipulating and aggregating data: SUM, AVG, MAX, MIN, COUNT, and DISTINCT
- Working with Subqueries
- Joining tables: Inner versus Outer Joins; Left/Right Joins; and Full Outer Joins
- UNION, INTERSECT, and MINUS Operators
Training material provided: Yes (Digital format)
- Basic understanding of Databases
- Analyst, programmer, business user or anyone interesting in getting started with SQL
- Analyst, programmer, business user or anyone interesting in getting started with SQL
The curriculum is empty
[INSERT_ELEMENTOR id="19900"]
