Course #:WA3021 Introduction to SQL Training Download Sample Labs 06/28/2021 - 06/29/2021 USD$1,395.00 Instructor Led Virtual 08/09/2021 - 08/10/2021 USD$1,395.00 Instructor Led Virtual 08/16/2021 - 08/17/2021 USD$1,395.00 Instructor Led Virtual 09/07/2021 - 09/08/2021 USD$1,395.00 Instructor Led Virtual 09/27/2021 - 09/28/2021 USD$1,395.00 Instructor Led Virtual The ability to write the SQL language - the cornerstone of all relational database operations - is essential for anyone who develops database applications. Learn to leverage all that the SQL language has to offer. In this introduction to SQL training, you learn how to optimize the accessibility and maintenance of data with the SQL programming language, and gain a solid foundation for building, querying, and manipulating databases. Learn how to retrieve large amounts of data quickly and efficiently. Using SQL, you will be able to write basic to complex queries, build reporting solutions or implement data warehouses. Objectives What is SQL?Working with Relational DatabasesSELECT statementsAggregate FunctionsSQL Built-in FunctionsJoins and SubqueriesCASE Statements and Unions Prerequisistes No Prerequisites Duration 2 Days Outline of Introduction to SQL Training Chapter 1. Introduction to Relational Databases What is a Relational Database? Relational Database Management System (RDBMS) Popular RDBMS Products Relational Database Concepts Tables Rows/Records Columns/Fields Data Types Relationships Primary Keys Foreign Keys What is SQL? Brief History of SQL Data Definition Language (DDL) Data Manipulation Language (DML) Data Control Language (DCL) Different Flavors of SQL AdventureWorks and Northwind Lab 1: Exploring the Northwind Database Summary Chapter 2. Introduction to SELECT Statements What is a SELECT Statement? Comments Multi-line Comments Case Insensitivity SELECT Statement Syntax Minimal SELECT Statement Complete SELECT Statement Simple SELECT Statement Whitespace Multiple Statements Lab 2: Selecting Records Selecting Individual Columns Lab 3: Retrieving Data Sorting Rows using ORDER BY Clause Lab 4: Sorting Data Selecting Unique Rows using DISTINCT Keyword Lab 5: Retrieving Unique Data Summary Chapter 3. SELECT Statements with WHERE Clause Filtering Results using WHERE Clause Comparison Operators Lab 6: Comparison Operators NULL Values Testing for NULL ISNULL, NVL, IFNULL Lab 7: NULL Tests Combining WHERE and ORDER BY Clauses Lab 8: WHERE and ORDER BY Clauses Logical Operators - AND, OR Logical Operators – NOT Logical Operators - Order of Evaluation Lab 9: Multiple Conditions BETWEEN Operator IN Operator LIKE Operator Lab 10: Additional Operators Summary Chapter 4. SELECT Statements with Computed Columns What are Computed Columns? Simple Calculations Mixing Calculations and Columns Arithmetic Calculations Calculations on Columns Column Aliases Column Aliases Omitting the AS keyword Using Column Labels in ORDER BY Clause Concatenation Concatenating Text and Column Values CONCAT Alternatives Lab 11: Computed Columns Summary Chapter 5. Aggregate Functions What are Aggregate Functions? Aggregate Functions – COUNT Aggregate Functions – SUM and AVG Aggregate Functions – MIN and MAX Grouping Results Using GROUP BY Clause Grouping and Sorting Results Filtering Grouped Results using HAVING Clause Lab 12: Aggregate Functions Summary Chapter 6. SQL Built-in Functions Types of SQL Built-in Functions String Functions String Function Examples Date Functions Date Function Examples Math Functions Math Function Examples Math Function Examples Lab 13: SQL Built-in Functions Summary Chapter 7. Joins and Subqueries Primary Keys and Foreign Key Inner Joins Inner Join Examples Prefixing Columns with Table Names Using Table Aliases Alternate Inner Join Syntax Outer Joins Left Outer Joins Left Outer Join Examples Right Outer Joins Full Outer Joins Self Joins Self Join Example Lab 14: Inner and Outer Joins What is a Subquery? Subquery Examples Regular Subquery vs. Correlated Subquery Correlated Subquery Example Lab 15: Subqueries Summary Chapter 8. CASE Statements and UNIONs CASE Statements CASE Statement Examples Lab 16: UNION Clause UNION Example UNION ALL INTERSECT Clause EXCEPT/MINUS Clause Lab 17: Summary Lab Exercises Lab 1. Exploring the DatabaseLab 2. Selecting RecordsLab 3. Retrieving DataLab 4. Sorting DataLab 5. Retrieving Unique DataLab 6. Comparison OperatorsLab 7. NULL TestsLab 8. WHERE and ORDER BY ClausesLab 9. Multiple ConditionsLab 10. Additional OperatorsLab 11. Computed ColumnsLab 12. Aggregate FunctionsLab 13. SQL Built-in FunctionsLab 14. Inner and Outer JoinsLab 15. SubqueriesLab 16. CASE StatementsLab 17. UNIONs We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC. View Course Outline Share This Request On-Site or Customized Course Info Lab Setup Guide REGISTER FOR A COURSEWARE SAMPLE x Sent First Name Last Name Email Request On-Site or Customized Course Info x Sent First Name Last Name Phone Number Company Name Email Question
Course #:WA3021 Introduction to SQL Training Download Sample Labs 06/28/2021 - 06/29/2021 USD$1,395.00 Instructor Led Virtual 08/09/2021 - 08/10/2021 USD$1,395.00 Instructor Led Virtual 08/16/2021 - 08/17/2021 USD$1,395.00 Instructor Led Virtual 09/07/2021 - 09/08/2021 USD$1,395.00 Instructor Led Virtual 09/27/2021 - 09/28/2021 USD$1,395.00 Instructor Led Virtual The ability to write the SQL language - the cornerstone of all relational database operations - is essential for anyone who develops database applications. Learn to leverage all that the SQL language has to offer. In this introduction to SQL training, you learn how to optimize the accessibility and maintenance of data with the SQL programming language, and gain a solid foundation for building, querying, and manipulating databases. Learn how to retrieve large amounts of data quickly and efficiently. Using SQL, you will be able to write basic to complex queries, build reporting solutions or implement data warehouses. Objectives What is SQL?Working with Relational DatabasesSELECT statementsAggregate FunctionsSQL Built-in FunctionsJoins and SubqueriesCASE Statements and Unions Prerequisistes No Prerequisites Duration 2 Days Outline of Introduction to SQL Training Chapter 1. Introduction to Relational Databases What is a Relational Database? Relational Database Management System (RDBMS) Popular RDBMS Products Relational Database Concepts Tables Rows/Records Columns/Fields Data Types Relationships Primary Keys Foreign Keys What is SQL? Brief History of SQL Data Definition Language (DDL) Data Manipulation Language (DML) Data Control Language (DCL) Different Flavors of SQL AdventureWorks and Northwind Lab 1: Exploring the Northwind Database Summary Chapter 2. Introduction to SELECT Statements What is a SELECT Statement? Comments Multi-line Comments Case Insensitivity SELECT Statement Syntax Minimal SELECT Statement Complete SELECT Statement Simple SELECT Statement Whitespace Multiple Statements Lab 2: Selecting Records Selecting Individual Columns Lab 3: Retrieving Data Sorting Rows using ORDER BY Clause Lab 4: Sorting Data Selecting Unique Rows using DISTINCT Keyword Lab 5: Retrieving Unique Data Summary Chapter 3. SELECT Statements with WHERE Clause Filtering Results using WHERE Clause Comparison Operators Lab 6: Comparison Operators NULL Values Testing for NULL ISNULL, NVL, IFNULL Lab 7: NULL Tests Combining WHERE and ORDER BY Clauses Lab 8: WHERE and ORDER BY Clauses Logical Operators - AND, OR Logical Operators – NOT Logical Operators - Order of Evaluation Lab 9: Multiple Conditions BETWEEN Operator IN Operator LIKE Operator Lab 10: Additional Operators Summary Chapter 4. SELECT Statements with Computed Columns What are Computed Columns? Simple Calculations Mixing Calculations and Columns Arithmetic Calculations Calculations on Columns Column Aliases Column Aliases Omitting the AS keyword Using Column Labels in ORDER BY Clause Concatenation Concatenating Text and Column Values CONCAT Alternatives Lab 11: Computed Columns Summary Chapter 5. Aggregate Functions What are Aggregate Functions? Aggregate Functions – COUNT Aggregate Functions – SUM and AVG Aggregate Functions – MIN and MAX Grouping Results Using GROUP BY Clause Grouping and Sorting Results Filtering Grouped Results using HAVING Clause Lab 12: Aggregate Functions Summary Chapter 6. SQL Built-in Functions Types of SQL Built-in Functions String Functions String Function Examples Date Functions Date Function Examples Math Functions Math Function Examples Math Function Examples Lab 13: SQL Built-in Functions Summary Chapter 7. Joins and Subqueries Primary Keys and Foreign Key Inner Joins Inner Join Examples Prefixing Columns with Table Names Using Table Aliases Alternate Inner Join Syntax Outer Joins Left Outer Joins Left Outer Join Examples Right Outer Joins Full Outer Joins Self Joins Self Join Example Lab 14: Inner and Outer Joins What is a Subquery? Subquery Examples Regular Subquery vs. Correlated Subquery Correlated Subquery Example Lab 15: Subqueries Summary Chapter 8. CASE Statements and UNIONs CASE Statements CASE Statement Examples Lab 16: UNION Clause UNION Example UNION ALL INTERSECT Clause EXCEPT/MINUS Clause Lab 17: Summary Lab Exercises Lab 1. Exploring the DatabaseLab 2. Selecting RecordsLab 3. Retrieving DataLab 4. Sorting DataLab 5. Retrieving Unique DataLab 6. Comparison OperatorsLab 7. NULL TestsLab 8. WHERE and ORDER BY ClausesLab 9. Multiple ConditionsLab 10. Additional OperatorsLab 11. Computed ColumnsLab 12. Aggregate FunctionsLab 13. SQL Built-in FunctionsLab 14. Inner and Outer JoinsLab 15. SubqueriesLab 16. CASE StatementsLab 17. UNIONs We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC. View Course Outline Share This Request On-Site or Customized Course Info Lab Setup Guide REGISTER FOR A COURSEWARE SAMPLE x Sent First Name Last Name Email Request On-Site or Customized Course Info x Sent First Name Last Name Phone Number Company Name Email Question
