SQL Basics
- Created By raju2006
- Last Updated December 14th, 2023
- Overview
- Prerequisite
- Audience
- Audience
- Curriculum
Description:
"Unlock the power of data analysis with SQL Basics training. Dive into the world of structured query language and learn to harness the untapped potential of your data. Discover the key to analyzing the astonishing volume of data generated daily, as we explore the fundamentals of SQL. Don't miss out on the opportunity to master this essential skill and bridge the gap between data collection and analysis."
Course Code/Duration:
BDT193 / 6 Hours (Each Session 3 Hours, 2 Sessions)
Learning Objectives
- Grasp database structures.
- Launch and manage SQL Lite databases.
- Master SQL query fundamentals.
- Explore SQL functions.
- Employ operators for query refinement.
- Learn to work with multiple tables using SQL joins.
- Basic understanding of Databases
- Analysts, programmer, business user or anyone interesting in getting started with SQL
- Analysts, programmer, business user or anyone interesting in getting started with SQL
Course Outline:
The course includes presentations, demonstrations, and hands-on labs.
- SQL Terminology & Elements of Relational Databases
- Types of data
- SELECT statement
- Install SQLite
- Orientation of the SQLite environment
- Queries — comments, structure of a basic query, syntax and using the ORDER BY clause
- Comparison, logical and arithmetic operators
- Use the WHERE, LIKE, DATE(), AND, OR and CASE statements
- Understand Joins and how they interact with Relational Database Structure
- Use a Left Outer Join in SQLite
- Types of functions in SQL and add calculations
- Aggregate functions and nesting functions — Use the ROUND() functions with GROUP BY, WHERE, and HAVING clauses
Training material provided:
Yes (Digital format)
The curriculum is empty
[INSERT_ELEMENTOR id="19900"]
