In this Introduction to SQL course, you will learn how to optimize the accessibility and maintenance of data with the SQL programming language, including how to:
Write the SQL language to develop database applications
Build, query, and manipulate databases
Work with the PostgreSQL database product or Microsoft SQL Server
identify deviations from the standard in Oracle and Microsoft SQL Server
Introduction to SQL Training Delivery Methods
In-Person
Online
Introduction to SQL Training Benefits
Write SQL code based on Wrap in ANSI/ISO standards to build database structures
Update database content with SQL and transaction handling
Retrieve data with filter conditions and from multiple tables using various types of joins
Process data with row and aggregate functions
Choose from on-demand and instructor-led blended learning options
Gain access to an exclusive LinkedIn group for peer and community support
Leverage continued support with after-course one-on-one instructor coaching and computing sandbox
Introduction to SQL Instructor-Led Course Outline
Module 1: SQL Overview
Outlining SQL as the cornerstone of database activity
Applying the ANSI/ISO standards
Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys
Module 2: Building the Database Schema
Module 3: Manipulating Data
Module 4: Working with the SELECT Statement
Module 5: Querying Multiple Tables
Module 6: Employing Functions in Data Retrieval
Module 7: Constructing Nested Queries
Module 8: Developing In-Line and Stored Views
العربية