SQL Querying - Basic Course Outline | Certstaffix® Training

SQL


SQL Querying - Basic Course


Attend Our Classes From Home - No Software Needed - Learn More...

SQL Querying - Basic

by Certstaffix® Training

SQL Query Training

Length: 2 day(s)      Public Class Price: $990/person (USD)      Group Class Price: Request Quote      Course Category: SQL


SQL Training
In this course you will compose basic SQL queries to retrieve desired information from a database. You will explore database concepts, write simple SELECT queries, use built-in functions and expressions, join tables, build subqueries and unions, and finally perform some advanced where clauses.

This course is taught using Microsoft SQL Server, but students using versions of SQL such as Oracle or MySQL will benefit by attending. The courseware and lab environment provided will be Microsoft SQL Server.
Course Description: Print It | Download PDF | Email It

Certstaffix® Training public classes are instructor-led, live online training you attend from your location or our training labs. Our live online instructors teach you from a remote location while being able to interact with students as in a traditional classroom setting.

  • A real, live instructor teaching you from another location
  • Hands-on learning with the software/skills you are being taught
  • Interaction with all students in the class at other locations
  • Any needed software for class provided in online lab environment
  • Easy assistance from the instructor
  • Attend from your location or our training labs

 Register ➥   March 8, 2022     
 Register ➥   May 9, 2022     
 Register ➥   May 31, 2022     
 Register ➥   June 22, 2022     
 Register ➥   July 11, 2022     

Group Onsite Training
At Your Organization

OR

Private Online Training
Live Online Instruction

Have a group of several students needing the same training? Then onsite or private online group training is a perfect option for you. We'll either come onsite to your office or deliver a private live online class so you don't have to travel. You'll be able to fully customize a course to your needs. Lastly, you can save per student versus our public classes.


  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be fully customized to your training needs
  • Course is scheduled based on dates you provide (Subject to instructor availability)

SQL Training Reviews by Certstaffix® Training

Certstaffix® Training collects detailed class reviews via a formal post-class evaluation in all our instructor-led courses. Below are a sample of abbreviated reviews from real students from our past classes. If you would like more reviews or ones with even further detail, please contact us and we would be happy to show you the high quality of our training services.


Certstaffix® Class Reviews

Student Average:
4.77 out of 5 from 254 students

4.73 out of 5

Wonderful content and instructor. Sheila also assisted me in getting scheduled for the class.I would highly recommend!


- attended our SQL Querying - Basic class

4.71 out of 5

Try to reference the the text more, we did not seem to use the text at all


- attended our SQL Querying - Basic class

4.95 out of 5

This was the best virtual training class I have taken. Instructor kept everyone involved and could tell if anyone was struggling. It required everyone to keep up with the class as if they were in the classroom.The only thing I would say is that I didn't feel this was "Advanced" material. The concepts that were in this class should already be known if you're taking an advanced SQL class. Wish there was a more advanced class maybe more stored procedure driven?


- attended our SQL Querying - Advanced class

4.66 out of 5

This was the best course that I have taken online. Very organized and professionally managed.


- attended our SQL Querying - Basic class

4.41 out of 5

This is the second SQL course I've taken with Serge Belich. He does a great job of explaining the database logic as well as how the topics can be applied in the real world. Serge starts with basic syntax then increases the complexity so you understand how each step impacts the end result. The course is engaging and extremely hands on. I was very pleased with the course and instructor - would definitely recommend to others!


- attended our SQL Querying - Advanced class

5.00 out of 5

This is my second course through Certstaffix and I would gladly sign up for others in the future.


- attended our SQL Querying - Advanced class

4.82 out of 5

This class was great and I feel confident that I can use most of what I have learned in my work environment! I think it would have helped if there was a short summary/review in the beginning to differentiate functions, statements, commands, etc. I still don't understand why some are blue or pink and why some need parenthesis while others don't. However, I have a feeling that with practice and reviewing the manual, I will catch on to the trend and figure this out.


- attended our SQL Querying - Basic class

5.00 out of 5

The SQL Query for beginners course was great. The teacher did a wonderful job in balancing between allowing the students to work on the queries by themselves and stepping in to assist. Also great sense of humor and very willing to answer any questions along the way. Definitely would recommend Cerstaffix.


- attended our SQL Querying - Basic class

4.63 out of 5

The presenter was awesome.


- attended our SQL Querying - Basic class

4.85 out of 5

The only issue I had was I already knew much of the material. Otherwise it was a really good course.The instructor was excellent!


- attended our SQL Querying - Basic class



  Detailed Course Topics

Course Description: Print It | Download PDF | Email It

Suggested Follow-Ons


Course Topics

Exploring Database Concepts
What Is SQL Server?
Databases in the Cloud
Service vs. Application
Database as Container
Data Is Stored in Tables
Data Types
Normalization
Understanding Indexes
Database Schemas

Writing Simple SELECT Queries
Using the SELECT Statement
Selecting a Literal Value
Retrieving from a Table
Generating a Select-List
Mixing Literals and Column Names
Filtering Data
Adding a WHERE Clause
Using WHERE Clauses with Alternate Operators
Using BETWEEN
Using BETWEEN with NOT
Filtering on Date and Time
Using WHERE Clauses with Two Predicates
Using the IN Operator
Working with NULL
Sorting Data
Thinking About Performance
Taking Advantage of Indexes
Viewing Execution Plans

Using Built-In Functions and Expressions
Expressions Using Operators
Concatenating Strings
Concatenating Strings and NULL
CONCAT
ISNULL and COALESCE
Concatenating Other Data Types to Strings
Using Mathematical Operators
Using String Functions
RTRIM and LTRIM
LEFT and RIGHT
LEN and DATALENGTH
CHARINDEX
SUBSTRING
CHOOSE
REVERSE
UPPER and LOWER
REPLACE
Nesting Functions
Using Date and Time Functions
GETDATE and SYSDATETIME
DATEADD
DATEDIFF
DATENAME and DATEPART
DAY, MONTH, and YEAR
CONVERT
FORMAT
DATEFROMPARTS
EOMONTH
Using Mathematical Functions
ABS
POWER
SQUARE and SQRT
ROUND
RAND
Logical Functions and Expressions
The CASE Expression
IIF
COALESCE
Administrative Functions
Using Functions in the WHERE and ORDER BY Clauses
The TOP Keyword
Thinking About Performance

Joining Tables
Using INNER JOIN
Joining Two Tables
Avoiding an Incorrect Join Condition
Joining on a Different Column Name
Joining on More Than One Column
Joining Three or More Tables
Using OUTER JOIN
Using LEFT OUTER JOIN
Using RIGHT OUTER JOIN
Using OUTER JOIN to Find Rows with No Match
Adding a Table to the Right Side of a LEFT JOIN
Adding a Table to the Main Table of a LEFT JOIN
FULL OUTER JOIN
CROSS JOIN
Self-Joins
Thinking About Performance

Grouping and Summarizing Data
Aggregate Functions
The GROUP BY Clause
Grouping on Columns
Grouping on Expressions
The ORDER BY Clause
The WHERE Clause
The HAVING Clause
DISTINCT Keyword
Using DISTINCT vs. GROUP BY
DISTINCT Within an Aggregate Expression
Aggregate Queries with More Than One Table
Aggregate Functions and NULL
Thinking About Performance

Building on Subqueries and Unions
Writing Subqueries
Using a Subquery in an IN List
Using a Subquery and NOT IN
Using a Subquery Containing NULL with NOT IN
Using EXISTS
Using CROSS APPLY and OUTER APPLY
Writing UNION Queries
Using EXCEPT and INTERSECT

Advanced WHERE Clauses
Using CONTAINS
Using Multiple Terms with CONTAINS
Searching Multiple Columns
Using FREETEXT
Thinking About Performance
Course Description: Print It | Download PDF | Email It

SQL Courses By City:

AL - Birmingham       GA - Columbus       NC - Raleigh       RI - Providence      
AL - Huntsville       GA - Savannah       NC - Winston-Salem       SC - Greenville      
AL - Mobile       HI - Honolulu       ND - Fargo       SC - Myrtle Beach      
AR - Bentonville       IA - Des Moines       NE - Lincoln       SC - North Charleston      
BC - Vancouver       IA - Iowa City       NE - Omaha       SD - Sioux Falls      
CA - Bakersfield       ID - Boise       NH - Bedford       SK - Regina      
CA - Fresno       IL - Chicago       NJ - Bridgewater       SK - Saskatoon      
CA - Los Angeles       IN - Fort Wayne       NM - Albuquerque       TN - Chattanooga      
CA - Modesto       IN - Indianapolis       NS - Halifax       TN - Knoxville      
CA - Oakland       KS - Topeka       NV - Henderson       TN - Memphis      
CA - Oxnard       KY - Lexington       NV - Reno       TN - Nashville      
CA - Rancho Cucamonga       KY - Louisville       NY - Albany       TX - Amarillo      
CA - Sacramento       LA - Baton Rouge       NY - Buffalo       TX - Austin      
CA - Salinas       LA - Lafayette       NY - New York City       TX - Beaumont      
CA - San Diego       LA - New Orleans       NY - Rochester       TX - Corpus Christi      
CA - San Jose       LA - Shreveport       NY - Syracuse       TX - Dallas      
CA - Santa Rosa       MA - Burlington       OH - Cincinnati       TX - El Paso      
CA - Stockton       MA - Springfield       OH - Columbus       TX - Fort Worth      
CO - Boulder       MA - Westborough       OH - Dayton       TX - Houston      
CO - Colorado Springs       MB - Winnipeg       OH - Highland Heights       TX - Killeen      
CO - Denver       MD - Largo       OH - Toledo       TX - Laredo      
CT - Cheshire       MD - Laurel       OK - Oklahoma City       TX - Longview      
CT - New Haven       ME - Portland       OK - Tulsa       TX - Lubbock      
CT - Stamford       MI - Ann Arbor       ON - Ottawa       TX - McAllen      
DE - Wilmington       MI - Grand Rapids       ON - Toronto       TX - Midland      
FL - Daytona Beach       MI - Lansing       OR - Beaverton       TX - San Antonio      
FL - Fort Lauderdale       MI - Livonia       OR - Bend       TX - Tyler      
FL - Fort Myers       MN - Minnetonka       OR - Eugene       TX - Waco      
FL - Gainesville       MO - Columbia       OR - Medford       UT - Ogden      
FL - Jacksonville       MO - Kansas City       PA - Allentown       UT - Salt Lake City      
FL - Lakeland       MO - St. Louis       PA - Erie       VA - Glen Allen      
FL - Miami       MS - Biloxi       PA - Harrisburg       VA - Roanoke      
FL - Naples       MS - Jackson       PA - Malvern       VA - Virginia Beach      
FL - Pensacola       MT - Billings       PA - Philadelphia       VT - Burlington      
FL - Sarasota       NB - Moncton       PA - Pittsburgh       WA - Seattle      
FL - Tallahassee       NB - Saint John       PA - Reading       WA - Spokane      
FL - Tampa       NC - Asheville       PA - Scranton-Wilkes Barre       WI - Green Bay      
FL - Winter Park       NC - Charlotte       PA - York       WI - Madison      
GA - Atlanta       NC - Greensboro       QC - Montreal       WI - Milwaukee      
GA - Augusta