Chooses your pricing

The Best Pricing We Offered

SQL AND MYSQL

Mspire

  • Basic DATABASE Concept and SQL

  • Restricting and Sorting Data

  • Single-Row Functions

  • JOINS

  • Multi-row Functions

  • Sub-queries

  • Reporting data using interface commands

  • Data Manipulation Language DML and Transaction Control Language TCL

  • Data Definition Language - DDL

  • Constraints

  • Views

  • Other Database Objects

  • DCL Commands

  • Dictionary Tables

  • SET Operators

  • Advanced Date-time Functions

  • Advanced Group BY Clause

  • Advanced Subqueries

  • Hierarchical Retrieval

  • Multi-table Insert

  • Data loader

  • Analytic Functions

  • Backup

  • General discussion

  • Theory, Terminology and Concepts

  • Client/Server Concepts

  • Database and Database Objects

  • Data Definition using SQL

  • Databases

  • Data Type

  • Tables

  • Constraints and Indexes

  • Views

  • Basic Data Manipulation using SQL

  • Recurring SQL Constructs

  • Adding data

  • Modifying data

  • Removing data

  • Searching data

  • Advanced Data Manipulation using SQL

  • Expressions

  • Grouping and Aggregate Functions

  • Joining Tables

  • Transactions

  • Transaction Concepts

  • SQL for working with Transaction

  • Import/Export

  • SQL for Import/Export

  • Tools for Import/Export