1

SQL Training-Oracle SQL/MYSQL/MSSQL

SQL Training-Oracle SQL/MYSQL/MSSQLThis course is designed to provide a comprehensive introduction to the SQL programming language, which is the standard language for relational database management systems. Whether you’re a beginner with no prior experience in SQL or database management, or a professional looking to refresh your skills, this course is perfect for you.


Key leranings:

By the end of this course, learners will be able to:

  • Write effective SQL queries to extract and manipulate data
  • Design and create databases using SQL
  • Analyze data using SQL
  • Troubleshoot common SQL errors and issues
  • Apply best practices for writing effective SQL queries

Course Content:

 Module1Basics

  • Selection of all columns/fields
  • Selection of certain columns/fields
  • Use of distinct/unique
  • Selection of certain rows/records
  • Selection of values in a range
  • Selection of values matching a pattern mask
  • Selection of values within a list
  • Treatment of null values
  • How to sort and order data
  • Selection of calculated and derived values
  • How to control column headings in query results
  • How to send query results to external files

 Module2-Joining Tables

  • Principles of joining tables:
    • Use of cartesian join
    • Use of inner join
    • Use of non-equi join
    • Use of outer join

 Module3-Joining Queries

  • Union operator
  • Intersect operator
  • Except operator

 Module4-Simple Functions

  • Conversion functions
  • Date functions
  • Number functions
  • Text functions
  • Group/summary/aggregate functions

 Module5- Sub-Queries

  • Principles of sub-queries
  • How to filter rows from main query
  • Use of nested sub-query
  • Use of multi-column sub-query
  • Use of correlated sub-query
  • Use of sub-query as an inline view and common table expression
  • Use of sub-query as a column in main query

 Module6-Case Statements

  • Principles of case statements
  • Use of case statement to derive column values
  • Use of nested case statements
  • Use of case statements to produce pivot tables
  • Use of case statement with sub-queries

 Module-7Data Manipulation

  • How to insert values into a table
  • How to copy values between tables
  • How to update values
  • How to delete records
  • How to change data via views
  • Use of transactions
  • How to lock rows and tables

 Module-8Data Definition

  • Principles of a relational database and data normalisation
  • Use of primary key and foreign key relationships and constraints
  • How to create tables
  • How to alter tables
  • How to create views
  • Use of synonyms
  • How to remove tables and views

Prerequisites

None


International student Fess: USD300$


Job Interview Preparation  (Soft Skills Questions & Answers)


Stay connected even when you’re apart

Join our WhatsApp Channel – Get discount offers

 500+ Free Certification Exam Practice Question and Answers

 Your FREE eLEARNING Courses (Click Here)


Internships, Freelance and Full-Time Work opportunities

 Join Internships and Referral Program (click for details)

Work as Freelancer or Full-Time Employee (click for details)

Hire an Intern


Flexible Class Options

  • Week End Classes For Professionals  SAT | SUN
  • Corporate Group Trainings Available
  • Online Classes – Live Virtual Class (L.V.C), Online Training

SQL Courses

MySQL Course – Learn SQL Step-By-Step With Examples

MySQL Boot camp – SQL Beginner to Expert

Introduction to SQL Database

MySQL Database (for Beginners)
Java Programming for Beginners

PHP Programming (for Beginner)

Computer Networking (for Beginners)

 

KEY FEATURES

Flexible Classes Schedule

Online Classes for out of city / country students

Unlimited Learning - FREE Workshops

FREE Practice Exam

Internships Available

Free Course Recordings Videos

Register Now