Flexi is a Video Recording of Live Online + Official Courseware + Hands-on Labs

Live Online
+
On Demand
=
Flexi

SQL Querying: Fundamentals

Includes:

  1. Power Packed 06 Hours (Edited from 8 hours of Live Training)
  2. 6 months access to recordings.
  3. Access via Laptop, Tab, Mobile, and Smart TV.
  4. Certificate of completion.
  5. Official Courseware
  6. Hands-on labs
You can also purchase an annual plan for USD 999. For one year, all Flexi Videos will be free for you. Buy Annual Plan

You will get access to Flexi Video instantly.

Flexi Video

USD 99

Official Courseware

N/A

Hands-On-Labs

NA

Total

USD 99

100% Refund for Flexi Video (courseware is non-refundable) if user is not satisfied with the Video and seeks refund within 30 days of purchase.

Download Course Contents
Module 1: Executing a Simple Query
  • Connect to the SQL Database using SQL Server Management Studio
  • Query a Database using the SELECT Statement
  • Query a Database using the SELECT Statement
  • Modify and Execute a Saved Query
  • Use the WHERE Clause to Search and Filter Data using One or More Conditions
  • Use the WHERE Clause to Search for a Range of Values with BETWEEN and IN Clauses
  • Search Text Data Based on Patterns using the LIKE Operator
  • Format and Manipulate Dates using Date Functions
  • Summarize Data using Aggregate Functions Like COUNT, SUM, AVG, MIN, MAX
  • Use Functions to Manipulate String Values
  • Sort Data using the ORDER BY Clause
  • Rank Data with the RANK and DENSE_RANK Clauses
  • Group Data with the GROUP BY Clause
  • Filter Grouped Data using the HAVING Clause
  • Summarize Grouped Data using ROLLUP and CUBE Clauses
  • Use PIVOT and UNPIVOT Operators
  • Combine the Results of Two Queries with the UNION Statement
  • Compare the Results of Two Queries with the INTERSECT and EXCEPT Statements
  • Query Data from Multiple Tables using the JOIN Clause
AVINASH TIWARI

Skills

 
Microsoft:Azure DatabricksMicrosoft:Database Administration Fundamentals
Microsoft:Database FundamentalsMicrosoft:DP 203 Exam Prep
Microsoft:DP-203T00: Data Engineering on Microsoft AzureMicrosoft:DP-300 Exam Prep
Open Source:Introduction to RMicrosoft:Introduction To SQL Databases-55315
Oracle:MySQL for Developers Ed 5Oracle:MySQL Fundamentals Ed 1
Oracle:MySQL Fundamentals Ed 2Oracle:Oracle Cloud Infrastructure Architect Associate
Oracle:Oracle Cloud Infrastructure Architect Professional WorkshopOracle:Oracle Cloud Infrastructure Foundations
Oracle:Oracle Database 11g: Advanced PL/SQLOracle:Oracle Database 12c : Administration Workshop
Oracle:Oracle Database 12c R1: New Features for Administrators Ed 2Oracle:Oracle Database 12c R2: Backup and Recovery Workshop Ed 3
Oracle:Oracle Database 12c R2: Program with PL/SQL Ed 2Oracle:Oracle Database 12c R2: SQL and PL/SQL Fundamentals Ed 2

Learn more about Koenig. Download Presentation Buy Other Flexi

FAQ's

Yes, you can pay from this web page.
Yes, the site is secure by utilizing Secure Sockets Layer (SSL) Technology. SSL technology enables the encryption of sensitive information during online transactions. We use the highest assurance SSL/TLS certificate, which ensures that no unauthorized person can get to your sensitive payment data over the web.
You will be provided access to LET ( Learning Enhancement Tool), where you will get the links to access all your purchases.
Flexi video for the new version will be provided free of cost.
Yes, c/w and Lab are not included in the annual plan. All Flexi videos are included.
It is only for one user.
Videos can only be streamed and not downloaded.
We do not track the pass rate of Flexi students. However, we trust it will be lower than for Live Online.
Presently, Flexi is only available in English.
6 months from the date of delivery.
Yes, you do. Flexi Videos do not include Courseware or Labs.
Yes, contact us for corporate packages.
We use the best standards in Internet security. Any data retained is not shared with third parties.
It’s a unique subscription plan where customers can avail unlimited Flexi courses within a year.
The subscription plan is valid for 1 year from the date of purchase.
No, this is limited to one user and its non-transferable.

Feedbacks from Clients