McTimothy Associates

SQL Programming

Why Attend

With this workshop, you will acquire some seriously marketable programming skills! You can’t consider yourself a complete end-to-end developer until you can code in SQL. Today, data has become the hottest topic in technology and a company’s biggest asset is its data. All databases require the language SQL to store and retrieve data.

265,000.0000 VAT

Event Date: 26/03/2025 – 29/03/2025

Total:

More Dates

06/08/2025 – 09/08/2025

Price: 265,000.0000 VAT

Database Basics

  • Overview of Relational Database Concepts
  • What is a relational database management system?
  • Databases! Why do we need them?
  • Data Modeling and Design
  • Relational Database Structures
  • Brief overview of typical databases: Microsoft Access and SQL Server
  • Database building blocks: Tables, Columns, Primary key, Foreign Keys, Data Types, Indexes
  • Building a database

Single Table Queries

  • Retrieving Data using the SELECT Clause
  • Using the WHERE Clause in Query
  • Using Operators in the WHERE Clause
  • Combining WHERE, AND, & OR WITH OPERATORS
  • Query Filtering Continued BETWEEN, IN and NULL
  • Query Filtering Conditions & Operator Precedence
  • Ordering, Concatenating & Aliasing Query Results

 Single Row Functions

  • Single Row Function Using the Dual Table
  • Using Functions in Where and Character Based
  • Numeric and Date Data type single-row functions
  • Conversion single row function and Date formatting
  • More Date functions
  • Conclusion of Single row functions & NULL/NULLIF functions

Grouping Functions

  • Grouping Functions MIN, MAX, AVG, COUNT
  • GROUP BY Clause & HVING Clause

Multi-Table Queries and Joins

  • SELECT within SELECT(Subqueries)
  • Relating Tables Together Using JOINS
  • Joins Continued INNER & OUTER Joins
  • Correlated Subqueries with EXIST & NOT

Creating, Altering, and Updating Objects using SQL

  • Creating Your Tables& Design
  • Inserting Data into our Table
  • Create a Table with a Primary key Constraint
  • Using ALTER to modify the table structure
  • Create a Table with SELECT+UPDATE Data
  • Primary and Foreign Keys
  • DELETE, TRUNCATE, DROP, AND COMMANDS
  • Working With Database Index
  • System Tables, Pseudo Columns& Deleting Duplicates
  • Views and Other Objects and Commands
  • Granting and Revoking Privileges

Other Courses