Your Cart Is Empty
Desktop Applications >
SQL Querying >
SQL - Fundamentals of Querying
Having a fundamental understanding of SQL querying will help you ask the right questions and know what you're looking for in your data analysis tools.
The ability to write SQL is an essential job skill for those who need to manage large volumes of data, produce reports, mine data, or combine data from multiple sources. Even if someone else on your team creates reports for you, having a fundamental understanding of the fundamentals of SQL querying will help you ask the right questions and know what you're looking for in your data analysis tools.Organizations use large SQL databases to store information about clients, products, or sales. However, that data is locked into those databases until it is accessed by a business intelligence tool such as Power BI, Tableau or Crystal Reports. With the proper permissions, analysts can use SQL to select the data they need for additional analysis and reporting. This class, SQL - Fundamentals of Querying, provides an overview of the SQL commands that can be used to access that data.
Upon successful completion of the SQL - Fundamentals of Querying Training course, you will be able to: • Connect to the SQL Server database and execute a simple query ● Include a search condition in a simple query ● Use various functions to perform calculations on data ● Organize data obtained from a query before it is displayed on-screen ● Retrieve data from tables ● Format an output, save a result, and generate a report
Lesson 1: Executing a Simple QueryTopic 1A: Connect to the SQL DatabaseTopic 1B: Query the DatabaseTopic 1C: Save a QueryTopic 1D: Modify a QueryTopic 1E: Execute a Saved QueryLesson 2: Performing a Conditional SearchTopic 2A: Search Using a Simple ConditionTopic 2B: Compare Column ValuesTopic 2C: Search Using Multiple ConditionsTopic 2D: Search for a Range of Values and Null ValuesTopic 2E: Retrieve Data Based on PatternsLesson 3: Working with FunctionsTopic 3A: Perform Date CalculationsTopic 3B: Calculate Data Using Aggregate FunctionsTopic 3C: Manipulate String ValuesLesson 4: Organizing DataTopic 4A: Sort DataTopic 4B: Rank DataTopic 4C: Group DataTopic 4D: Filter Grouped DataTopic 4E: Summarize Grouped DataTopic 4F: Use PIVOT and UNPIVOT Operators
Lesson 5: Retrieving Data from TablesTopic 5A: Combine Results of Two QueriesTopic 5B: Compare the Results of Two QueriesTopic 5C: Retrieve Data by Joining TablesTopic 5D: Check for Unmatched RecordsTopic 5E: Retrieve Information from a Single Table Using JoinsLesson 6: Presenting Query ResultsTopic 6A: Save the Query ResultTopic 6B: Generate an XML ReportAppendix A: The OGCBooks Database
MCSA: SQL Server 2012/2014MCSA: SQL 2016 Database Development
Some familiarity with database terminology and structure is helpful.
Productivity Point Learning Solutions
evolved out of a desire to increase our outreach
both nationally and internationally.
Productivity Point Headquarters
1580 Sawgrass Corporate Parkway
Sunrise, Florida 33323