Book Image

Learn SQL and Database Testing from Scratch (including Unix Material) [Video]

By : Rahul Shetty
Book Image

Learn SQL and Database Testing from Scratch (including Unix Material) [Video]

By: Rahul Shetty

Overview of this book

<p><span id="description" class="sugar_field">This course covers: Introduction to SQL, MySQL overview, start up commands to setup databases and tables, database testing to validate Schema, altering table schema operations, queries to retrieve data logical operators on queries, wild cards usage in Qqeries, SQL functions with real time scenarios, the importance of group by in SQL, advanced SQL concepts, sub-queries in syntax and usage, SQL joins usage and its advantages, the importance of views in databases, SQL string functions, data constraints with database testing perspective, practice exercises for interviews with solutions, and an SQL glossary on the discussed topics.</span></p> <h2><span class="sugar_field">Style and Approach</span></h2> <p><span class="sugar_field"><span id="trade_selling_points_c" class="sugar_field"><span id="trade_selling_points_c" class="sugar_field">On course completion, you will have Mastered the SQL Language with Database Testing and will be able implement these new skills successfully intoyour workplace.</span></span></span></p>
Table of Contents (10 chapters)
8
Practise Exercises for Interviews with Solutions
Chapter 4
Getting Started with Queries to retrieve Data
Content Locked
Section 1
Select distinct keyword in queries
Getting Started with Queries to retrieve Data: Select distinct keyword in queries