Live SQL Fundamentals Training Course
SQL Fundamentals - Part 1: Essential Querying Skills
| Course Number: |
#CED-1812 |
| Course Length: |
1 day |
Grants (discounts) are available for multiple students for the same or different courses. |
Instructor-Led
Certified Instructor
Includes all course materials
Instant Quote
Can't travel or you want to stay with your family or business. No problem!
Stay in your own city and save the additional expenses of roundtrip airfare, lodging, transportation, and meals and receive the same great instruction live from our instructors in our Live Instructor-Led Remote Classroom Training.
Remote Classroom Training
Our Remote Classroom Training is a live class with students observing the instructor and listening through your computer speakers.
You will see the instructor's computer, slides, notes, etc., just like in the classroom. You will be following along, doing work, labs, and individual assignments.
CED Solutions Rewards Points Program
"The boot camp offered by CED was the perfect solution for me. It enabled me to focus for two weeks, learn a tremendous amount and walk out with a premier certification. It was intense but extremely rewarding. Finally, the quality of the instructors at CED far exceeded that of any other training center I have ever experienced." -Jesse D. Sarlo, Zephyr Hills, FL
Over 70% of business decision-makers say their teams struggle with data access-most don't know how to use SQL effectively. This one-day beginner-level training course provides a hands-on introduction to SQL fundamentals using Microsoft SQL Server.
You'll learn SQL from the ground up, gaining the skills to write queries, filter and sort results, combine data from multiple tables, and manipulate output for analysis or reporting. Real-world exercises guide you through every step so you can confidently retrieve information from a relational database.
Course Objectives
After completing this course, you'll be equipped to use SQL to extract and manipulate data from relational databases. You'll gain practical experience writing queries, formatting results, and applying functions using SQL Server.
- Run basic SQL statements to retrieve data
- Apply conditions and logical filters using WHERE clauses
- Use string, numeric, and date functions for calculated results
- Organize and group query output
- Join tables and identify missing or unmatched records
Who Should Attend?
Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.
Course Prerequisites
- Basic computer literacy
- Basic PC operating system navigation skills
- Basic Internet usage skills
Class Outline:
Module 1: Executing Basic SQL Statements
- Connect to a SQL Server database
- Create, modify, and execute queries
- Save and reopen query files
Module 2: Filtering with Conditional Logic
- Limit results using comparison operators
- Combine multiple conditions
- Search for ranges, NULL values, and patterns
Module 3: Using Built-In SQL Functions
- Perform date and time calculations
- Manipulate strings and text fields
- Calculate summaries with aggregate functions
Module 4: Structuring and Summarizing Output
- Sort results and apply custom rankings
- Group data and filter grouped rows
- Pivot and unpivot results for advanced formatting
Module 5: Working Across Tables
- Merge data with inner and outer joins
- Identify records without matches
- Compare and combine multiple result sets
Module 6: Exporting Results and Creating Reports
- Format and save query results
- Generate basic XML output
- Review common reporting use cases
CED Solutions is your best choice for SQL Fundamentals,
SQL Fundamentals training,
SQL Fundamentals certification,
SQL Fundamentals boot camp,
SQL Fundamentals certification training,
SQL Fundamentals certification course,
SQL Fundamentals course,
SQL Fundamentals class.
|
Follow CED