{"product_id":"introduction-to-sql-course","title":"Introduction to SQL Course","description":"\u003cdiv\u003e\n\u003cp\u003eLearning Tree's Introduction to SQL Course is designed to provide an introduction to the SQL programming language, which is the standard language for relational database management systems. The course covers the basics of SQL, including creating tables, manipulating data, and querying databases. Students who complete the course will be equipped to write SQL queries, work with Microsoft SQL Server or \u003ca href=\"https:\/\/www.postgresql.org\/about\/\" title=\"What is PostgreSQL? | PostgreSQL\" rel=\"nofollow noopener\" target=\"_blank\"\u003ePostgreSQL\u003c\/a\u003e.\u003c\/p\u003e\r\n\u003cp\u003eThe course is suitable for beginners with no prior experience in SQL or database management, as well as professionals who want to refresh their skills. Overall, Learning Tree's Introduction to SQL Course is an excellent starting point for anyone looking to learn SQL and become proficient in database management and data engineering.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eIntroduction to SQL Course Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWrite SQL code based on Wrap in ANSI\/ISO standards to build database structures.\u003c\/li\u003e\n\u003cli\u003eUpdate database content with SQL and transaction handling.\u003c\/li\u003e\n\u003cli\u003eRetrieve data with filter conditions and from multiple tables using various types of joins.\u003c\/li\u003e\n\u003cli\u003eProcess data with row and aggregate functions.\u003c\/li\u003e\n\u003cli\u003eLeverage continued support with after-course one-on-one instructor coaching and computing sandbox.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eNone.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eIntroduction to SQL Instructor-Led Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: SQL Overview\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eOutlining SQL as the cornerstone of database activity\u003c\/li\u003e\n\u003cli\u003eApplying the ANSI\/ISO standards\u003c\/li\u003e\n\u003cli\u003eDescribing the fundamental building blocks: tables, columns, primary keys, and foreign keys\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Building the Database Schema\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eCreating tables and columns\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuilding tables with CREATE TABLE\u003c\/li\u003e\n\u003cli\u003eModifying table structure with ALTER TABLE\u003c\/li\u003e\n\u003cli\u003eAdding columns to an existing table\u003c\/li\u003e\n\u003cli\u003eRemoving tables with DROP TABLE\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eProtecting data integrity with constraints\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eGuaranteeing uniqueness with primary key constraints\u003c\/li\u003e\n\u003cli\u003eEnforcing integrity with foreign key constraints\u003c\/li\u003e\n\u003cli\u003eImposing business rules with check constraints\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eImproving performance with indexes\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExpediting data retrieval with indexes\u003c\/li\u003e\n\u003cli\u003eRecommending guidelines for index creation\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Manipulating Data\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eModifying table contents\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAdding table rows with INSERT\u003c\/li\u003e\n\u003cli\u003eChanging row content with UPDATE\u003c\/li\u003e\n\u003cli\u003eRemoving rows with DELETE\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eApplying transactions\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eControlling transactions with COMMIT and ROLLBACK\u003c\/li\u003e\n\u003cli\u003eDeploying BEGIN TRANSACTION in SQL Server\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Working with the SELECT Statement\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eWriting Single Table queries\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eRetrieving data with SELECT\u003c\/li\u003e\n\u003cli\u003eSpecifying column expressions\u003c\/li\u003e\n\u003cli\u003eSorting the result with ORDER BY\u003c\/li\u003e\n\u003cli\u003eHandling NULL values in expressions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eRestricting rows with the WHERE filter\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eTesting for equality or inequality\u003c\/li\u003e\n\u003cli\u003eApplying wildcard characters\u003c\/li\u003e\n\u003cli\u003eAvoiding NULL value pitfalls\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Querying Multiple Tables\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eApplying the ANSI\/ISO standard join syntax\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMatching related rows with INNER JOIN\u003c\/li\u003e\n\u003cli\u003eIncluding nonmatched rows with OUTER JOIN\u003c\/li\u003e\n\u003cli\u003eCreating a Cartesian product with CROSS JOIN\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eCombining results with set operators\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eStacking results with UNION\u003c\/li\u003e\n\u003cli\u003eIdentifying matching rows with INTERSECT\u003c\/li\u003e\n\u003cli\u003eUtilizing EXCEPT to find nonmatching rows\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Employing Functions in Data Retrieval\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eProcessing data with row functions\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eConditional formatting with the CASE expression\u003c\/li\u003e\n\u003cli\u003eUtilizing the CASE expression to simulate IF tests\u003c\/li\u003e\n\u003cli\u003eDealing with NULL values\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003ePerforming analysis with aggregate functions\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSummarizing data using SUM, AVG and COUNT\u003c\/li\u003e\n\u003cli\u003eFinding the highest\/lowest values with MAX and MIN\u003c\/li\u003e\n\u003cli\u003eDefining the summary level with GROUP BY\u003c\/li\u003e\n\u003cli\u003eApplying filter conditions with HAVING\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 7: Constructing Nested Queries\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eApplying subqueries in filter conditions\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCreating correlated vs. noncorrelated subqueries\u003c\/li\u003e\n\u003cli\u003eTesting the existence of rows\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eIncluding subqueries in expressions\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePlacing subqueries in the column list\u003c\/li\u003e\n\u003cli\u003eCreating complex expressions containing subqueries\u003c\/li\u003e\n\u003cli\u003eHandling subqueries that return no rows\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 8: Developing In-Line and Stored Views\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eBreaking down complex problems\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSelecting data from a query result set\u003c\/li\u003e\n\u003cli\u003eUsing subqueries in the FROM clause\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eCreating views in a database\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuilding reusable code\u003c\/li\u003e\n\u003cli\u003eCreating updateable vs. non-updateable views\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267C04US \/ 2026-07-29T09:00:00 \/ Austin","offer_id":47534176501979,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"268A16CN \/ 2026-08-12T09:00:00 \/ Ottawa","offer_id":47534177943771,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269B28US \/ 2026-09-02T09:00:00 \/ Herndon, VA","offer_id":47534177976539,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269A18CN \/ 2026-09-16T09:00:00 \/ Toronto","offer_id":47597097844955,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"266D28US \/ 2026-06-10T09:00:00 \/ Online","offer_id":48216541626587,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"268C76US \/ 2026-08-05T09:00:00 \/ New York","offer_id":48216541692123,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269C30US \/ 2026-09-09T09:00:00 \/ Washington, DC","offer_id":48216541724891,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AA95US \/ 2026-10-14T09:00:00 \/ Aurora, CO","offer_id":48216541757659,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AA96US \/ 2026-10-21T09:00:00 \/ Austin","offer_id":48216541790427,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AA97US \/ 2026-10-28T09:00:00 \/ New York","offer_id":48216541823195,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26BA17CN \/ 2026-11-04T09:00:00 \/ Ottawa","offer_id":48216541855963,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26BA91US \/ 2026-11-18T09:00:00 \/ Bellevue, WA","offer_id":48216541888731,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26BA92US \/ 2026-11-23T09:00:00 \/ Herndon, VA","offer_id":48216541921499,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26CA13CN \/ 2026-12-09T09:00:00 \/ Toronto","offer_id":48216541954267,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26CA74US \/ 2026-12-02T09:00:00 \/ Washington, DC","offer_id":48216541987035,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271A16CN \/ 2027-01-27T09:00:00 \/ Ottawa","offer_id":48216542019803,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271A99US \/ 2027-01-13T09:00:00 \/ Austin","offer_id":48216542052571,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271B00US \/ 2027-01-20T09:00:00 \/ New York","offer_id":48216542085339,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"272A59US \/ 2027-02-17T09:00:00 \/ Herndon, VA","offer_id":48270695497947,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"272A60US \/ 2027-02-24T09:00:00 \/ Washington, DC","offer_id":48294630654171,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"273A35CN \/ 2027-03-03T09:00:00 \/ Toronto","offer_id":48313105514715,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274A71US \/ 2027-04-07T09:00:00 \/ Austin","offer_id":48570238566619,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274A72US \/ 2027-04-14T09:00:00 \/ New York","offer_id":48591354134747,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274A33CN \/ 2027-04-21T09:00:00 \/ Ottawa","offer_id":48619708317915,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274A73US \/ 2027-04-28T09:00:00 \/ Aurora, CO","offer_id":48696377540827,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"275A82US \/ 2027-05-12T09:00:00 \/ Herndon, VA","offer_id":48762858340571,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"275A83US \/ 2027-05-19T09:00:00 \/ Washington, DC","offer_id":48783408660699,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"275A31CN \/ 2027-05-26T09:00:00 \/ Toronto","offer_id":48805415878875,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"276A82US \/ 2027-06-02T09:00:00 \/ San Francisco","offer_id":48825879199963,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269D25US \/ 2026-09-23T09:00:00 \/ Online","offer_id":48837148344539,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/products\/introduction-to-sql-course","provider":"Learning Tree International","version":"1.0","type":"link"}