custom code gtranslate code

Essential SQL Training

Knowing how to code and manage relational databases and database-driven applications is a valuable skill for any career in tech. Completely updated for Essential SQL Training is designed to help users understand the most common language for database wrangling, SQL.
All the lessons have been recorded in SQLite Studio, an intuitive and easy-to install database manager. Our instructors provide all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and using sub selects and views. We offer a solid working knowledge of the language and shows how to retrieve and manage data efficiently. The final chapter includes a real world example of building a simple application using SQL.

Course Outlines

Module 1: Introduction
✓ Installation: Installing on Windows/Mac

Module 2: SQL
✓ About SQL
✓ Database Organization
✓ Select: Rows, Columns
✓ Counting Rows
✓ Inserting Data
✓ Updating Data
✓ Deleting Data

Module 3: Fundamental Concepts
✓ Creating Tables
✓ Deleting A Table
✓ Deleting Row
✓ The Null Value
✓ Constraining Columns
✓ Changing a Schema
✓ ID Columns
✓ Filters Data
✓ Removing Duplicates
✓ Ordering Output
✓ Conditional Expressions

Module 4: Relationships
✓ Understanding JOIN
✓ Accessing related tables
✓ Relating Multiple tables

Module 5: String
✓ About SQL Strings
✓ Strings: Length of string and finding the length, Selecting part of a string, Removing space, Folding case

Module 6: Numbers
✓ Numeric Types
✓ Types of Values
✓ Integer Division
✓ Rounding Numbers

Module 7: Data and Time
✓ Date and Times
✓ Functions related

Module 8: Aggregates
✓ What are aggregates
✓ Using Functions
✓ DISTINCT values

Module 9: Transactions
✓ What are Transactions
✓ Data integrity
✓ Performance

Module 10: Triggers
✓ Automating Data Triggers
✓ Preventing Updates

Module 11: Views and Subselects
✓ Crating a subselect
✓ Searching within results set
✓ Creating a view
✓ Creating a joined view

Module 12: Simple CRUD Application
✓ Embedding SQL
✓ SELECT Functions
✓ INSERT,UPATE, and DELETE functions

What you'll learn

Upon completion of this course the successful student will:
✓ How databases are organized
✓ Selecting rows and columns
✓ Creating new tables
✓ Inserting and updating data
✓ Sorting and filtering
✓ Accessing related tables with JOIN
✓ Working with strings
✓ Understanding numeric types
✓ Using aggregate functions and transactions
✓ Automating data with triggers
✓ Creating views
✓ Using CRUD function

Course Content

Upon completion of this course the successful student will:
✓ How databases are organized
✓ Selecting rows and columns
✓ Creating new tables
✓ Inserting and updating data
✓ Sorting and filtering
✓ Accessing related tables with JOIN
✓ Working with strings
✓ Understanding numeric types
✓ Using aggregate functions and transactions
✓ Automating data with triggers
✓ Creating views
✓ Using CRUD function

Customize a Course

We will be happy to assist you for inquiries about a customized scheduled or program:
Rachael McPherson, Director of Sales
☎(250)882-9549 📧rachael@qacademy.tech
Caroline Santos, Corporate and Custom Sales Manager- Eastern Canada
☎(514)771-3206 📧caroline.santos@qacademy.tech

Student Ratings & Reviews

Course Info

Prerequisites
Computer Skills
Duration
15 Hours

Enroll Now

For Group Class Options

Enroll Now

For Corporate and Funding Agencies
popup and lms tutor hidden code
X
Customize A Course
We will be happy to assist you for inquiries about a customized scheduled or program:
Tanvir Qureshi
Caroline Santos
Corporate and Custom Sales Manager
(Eastern Canada)
Phone Number
0(0)

Essential SQL Training

  • Course level: Beginner
  • Categories Coding
  • Total Enrolled 0
  • Last Update June 27, 2022

Description

Knowing how to code and manage relational databases and database-driven applications is a valuable skill for any career in tech. Completely updated for Essential SQL Training is designed to help users understand the most common language for database wrangling, SQL.
All the lessons have been recorded in SQLite Studio, an intuitive and easy-to install database manager. Our instructors provide all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and using sub selects and views. We offer a solid working knowledge of the language and shows how to retrieve and manage data efficiently. The final chapter includes a real world example of building a simple application using SQL.

About the instructor

0 (0 ratings)

81 Courses

0 students

Send your feedback

Phone Number

Request for Instructor Info

Phone Number

Become A Program Partner

Q Academy works with the most innovative, sustainable industries and we continue to review all the major skills gaps across the globe. We’re looking for industry leaders and academic partners to help us create courses for upgrading skills within growing sectors across globe. We’d love to work with you to build something great!

Phone Number

Become A Hiring Partner!

Phone Number

With so many companies looking for great talent why not look take your needs directly to Q Academy and ensure your candidates have all the most update skills they need. Hire Great Talent without the high costs of some job search platforms or services.

Become a Training Partner!

Q Academy works with thosands of business across the globe and we have become several business go to training partners for the past 5 years.

Phone Number

Inquire Now

Phone Number

Log in
Login / Signup