LANTEC Logo
BACK
SQL Querying (Fundamentals + Advanced)

SQL Querying (Fundamentals + Advanced)

$1,195
2 days
Audience
Prerequisites
Outline
Share
Print

Course Description:

Build practical SQL skills to retrieve, analyze, and manage information stored in relational databases. This two-day course combines SQL Querying: Fundamentals and Advanced using Third Edition courseware.

Begin with writing queries, filtering results, using functions, organizing data, combining information from multiple tables, and exporting results. Then expand into nested and correlated queries, data and table modifications, views, indexes, and transactions—including committing changes or rolling them back.


Course Objectives:

In this course, you will compose SQL queries to retrieve desired information from a database, work with advanced queries to manipulate and index tables, and create transactions so that you can choose to save or cancel the data entry process. You will: 

  • Connect to a SQL database and execute queries
  • Apply conditional logic to filter results
  • Use functions to perform calculations and manipulate data
  • Organize and summarize query results
  • Retrieve and combine data from multiple tables
  • Export query results
  • Construct nested and correlated queries
  • Insert, update, and delete data in tables
  • Create and modify database tables and structures
  • Use views to simplify data access
  • Apply indexing to improve query performance
  • Manage transactions to ensure data integrity

Scheduled Courses

Mar 29, 2027
vILT (Virtual)
Enroll
{
  "Params": {
    "source": "Event",
    "layout": "List for Course Detail Page",
    "filterby": "Course",
    "filtervalue": "23093",
    "sortby": "EventDateStart",
    "sortorder": "ASC",
    "limit": "9999",
    "enablepagination": "false",
    "emptymessage": "
This course isn't currently on the schedule, but we can add it.  Just let us know.
",
    "object": "collection",
    "type": "module"
  },
  "Pagination": {
    "CurrentPage": 0,
    "ItemsPerPage": 0,
    "NumberOfPages": 0,
    "TotalItemsCount": 0
  },
  "Parent": {
    "Id": 23093,
    "Name": "SQL Querying (Fundamentals + Advanced)",
    "Url": "/course/sql-querying-fundamentals-advanced",
    "Url_List": [
      "/course/sql-querying-fundamentals-advanced"
    ],
    "UrlSlug": "sql-querying-fundamentals-advanced",
    "ParentId": 5934,
    "ParentId_List": [
      -1
    ],
    "ParentName": "",
    "ParentUrl": "",
    "TemplateName": "",
    "Module_Alias": "Course",
    "Module_ID": 5934,
    "Enabled": true,
    "ReleaseDate": "2024-01-23T00:00:00",
    "ExpiryDate": "2099-12-31T00:00:00",
    "SiteSearchKeywords": [],
    "Description": "
Course Description:
Build practical SQL skills to retrieve, analyze, and manage information stored in relational databases. This two-day course combines SQL Querying: Fundamentals and Advanced using Third Edition courseware.
Begin with writing queries, filtering results, using functions, organizing data, combining information from multiple tables, and exporting results. Then expand into nested and correlated queries, data and table modifications, views, indexes, and transactions—including committing changes or rolling them back.

Course Objectives:
In this course, you will compose SQL queries to retrieve desired information from a database, work with advanced queries to manipulate and index tables, and create transactions so that you can choose to save or cancel the data entry process. You will: 
  • Connect to a SQL database and execute queries
  • Apply conditional logic to filter results
  • Use functions to perform calculations and manipulate data
  • Organize and summarize query results
  • Retrieve and combine data from multiple tables
  • Export query results
  • Construct nested and correlated queries
  • Insert, update, and delete data in tables
  • Create and modify database tables and structures
  • Use views to simplify data access
  • Apply indexing to improve query performance
  • Manage transactions to ensure data integrity
",
    "Weighting": 0,
    "DisableForSiteSearch": false,
    "CreatedByMemberId": "0",
    "ItemCategories": [
      "Courses/Courses-Technical",
      "Courses/Courses-Technical/Microsoft SQL Server"
    ],
    "ItemCategoryIdList": [
      8553,
      8590
    ],
    "ItemTags": [
      "Microsoft"
    ],
    "Author": 0,
    "Author_Name": "",
    "Author_Url": "",
    "Item_Rating": 0,
    "DnDOrder": 0,
    "CourseTitle": "SQL Querying Fundamentals + Advanced",
    "CourseFiles": "/SQL Querying Fundamentals Advanced Course Outline.pdf",
    "CourseFilesTitle": "Outline",
    "Intro": "Build practical SQL skills to retrieve, analyze, and manage information stored in relational databases. This two-day course combines SQL Querying: Fundamentals and Advanced using Third Edition courseware.  Begin with writing queries, filtering results, using functions, organizing data, combining information from multiple tables, and exporting results. Then expand into nested and correlated queries, data and table modifications, views, indexes, and transactions—including committing changes or rolling them back.",
    "Days": "2",
    "Prerequisites": "Basic computer skills and familiarity with database terminology and structure are required. The Fundamentals portion introduces the SQL skills used in the Advanced portion.",
    "Audience": "Individuals with basic computer skills and familiarity with database concepts who want to develop SQL querying skills for reporting, data analysis, and common database tasks.",
    "Cost": "$1,195",
    "GoogleAnalyticsCode": "",
    "Popular": false,
    "Photo": "",
    "Disclaimer": "",
    "ShowPageForSearchEngine": true,
    "MetaTitle": "",
    "SEOTitle": "",
    "MetaDescription": "",
    "CanonicalLink": "",
    "SocialMetaTags": "",
    "SeoPriority": 0.5,
    "EnableAMP": false,
    "AMPContent": "",
    "OpenGraphProperties": {
      "title": null,
      "type": null,
      "url": null,
      "locale": null,
      "image": null
    },
    "ExternalId": 0,
    "Params": {
      "type": "snippet",
      "alias": "_template_header",
      "name": "_Template - Header",
      "content": "
\r\n    
\r\n        
\r\n            
\r\n               
\r\n                    
{% component type: \"menu\", alias: \"social_menu\", layoutGroup: \"Default\" %}
\r\n                    
\r\n                        
\r\n                            
\r\n                                {% component type: \"menu\", alias: \"utility_menu\", layoutGroup: \"Default\" %} \r\n                            
\r\n                        
\r\n                    
\r\n                
\r\n            
\r\n        
\r\n    
\r\n    
\r\n          
\r\n               
\r\n                    \"LANTEC\r\n               
\r\n               
\r\n                    
\r\n                         
 \r\n                            {% component type:\"menu\", alias: \"main_menu\", layoutGroup: \"Default\" %}\r\n                        
\r\n                    
\r\n               
\r\n          
\r\n     
\r\n
\r\n
\r\n    
\"LANTEC
\r\n    \r\n
\r\n
\r\n    \r\n        {% assign brcr = \"BACK\"  %}\r\n    \r\n\t
\r\n\t    BACK\r\n\t
\r\n
",
      "enabled": true
    }
  },
  "Items": [
    {
      "Id": 28908,
      "Name": "SQL Querying Fundamentals and Advanced - VILT - 032927",
      "Url": "/event/sql-querying-fundamentals-and-advanced-vilt-032927",
      "Url_List": [
        "/event/sql-querying-fundamentals-and-advanced-vilt-032927"
      ],
      "UrlSlug": "sql-querying-fundamentals-and-advanced-vilt-032927",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2026-09-21T00:00:00",
      "ExpiryDate": "2027-03-29T17:00:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "a8aadbc0-9564-461f-bc1a-b6170076cd04",
      "Price": 1218.9000,
      "PriceHtml": "1,218.90",
      "priceWithTax": 1218.90,
      "priceWithTaxHtml": "1,218.90",
      "RecommendedPrice": 1195.0000,
      "RecommendedPriceHtml": "1,195.00",
      "RecommendedPriceWithTax": 1195.00,
      "RecommendedPriceWithTaxHtml": "1,195.00",
      "HideWhenFull": false,
      "AllowMultipleSubscriptionPerEmail": false,
      "Capacity": 0,
      "Allocation": 0,
      "EventDateStart": "2027-03-29T08:00:00",
      "EventDateEnd": "2027-03-30T17:00:00",
      "taxRate": 0.0,
      "VolumeDiscount": [
        {
          "Price": 1218.9000,
          "Quantity": 0
        }
      ],
      "CreatedByMemberId": "0",
      "ItemCategories": [],
      "ItemCategoryIdList": [],
      "ItemTags": [],
      "Author": 0,
      "Author_Name": "",
      "Author_Url": "",
      "Item_Rating": 0,
      "DnDOrder": 0,
      "Course": 23093,
      "Course_Name": "SQL Querying (Fundamentals + Advanced)",
      "Course_Url": "/course/sql-querying-fundamentals-advanced",
      "Location": "vILT",
      "ShowPageForSearchEngine": true,
      "MetaTitle": "",
      "SEOTitle": "",
      "MetaDescription": "",
      "CanonicalLink": "",
      "SocialMetaTags": "",
      "SeoPriority": 0.5,
      "EnableAMP": false,
      "AMPContent": "",
      "OpenGraphProperties": {
        "title": null,
        "type": null,
        "url": null,
        "locale": null,
        "image": null
      },
      "ExternalId": 0,
      "Params": {}
    }
  ]
}

Need to Request This Course On a Different Day?

LANTEC is very responsive to local client needs and unique or custom class demands. If you require a delivery date option for a class title on our schedule, please submit your specific request for immediate consideration. We can often accommodate countless additional courses NOT available on our public schedules, please inquire for personal assistance.
Want to schedule it?