SQL

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using ‘Content here, content here’, making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for ‘lorem ipsum’ will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).

Show More

What Will You Learn?

  • Gaining a detailed understanding of relational databases.
  • Filtering and summarizing data using SQL code.
  • Working with multiple tables and creating table joins.
  • Using subqueries and modifying datasets

Course Content

SQL For Beginners

  • Overview on Database, DBMS/RDBMS, SQL |Database Components | SQL for Testers
    36:55
  • Installing MySQL, Working with SQL Workbench & Command Line Clients
    22:53
  • Create Database, Table, Inserting Records and Retrieving Data
    55:54
  • Filtering Rows (Where Clause), Operators & Pattern Matching
    40:59
  • DDL (Data Definition Language) Commands
    41:26
  • MySQL Built-in Functions in SQL
    36:17
  • Group By, Having & Order by Clauses in SQL
    35:32
  • Union & Union All in SQL
    12:45
  • SQL Joins and Sub Queries
    12:45
  • Integrity Constraints
    01:25:06
  • Auto Increment & Limit
    13:17
  • SQL Views & Index
    13:35
  • TCL Commands | Commit | Rollback
    13:27
  • JDBC | Java Database Connectivity with MySQL
    29:54
  • ODBC | Open Database Connectivity with MySQL
    10:46
  • MySQL Command Line ToolsClients Connecting to Remote MySQL Database Server
    17:10
Shopping Cart