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 3
Altering Table Schema operations
Content Locked
Section 3
Updating rows in a table
Altering Table Schema operations: Updating rows in a table