Step By Step Sql ( Mysql ) Best For Newbies 100+Practice Q

End to End installation | Basic to Advance Select queries | Table Operations | Data Operations | Joins |100+ Questions
What you'll learn
** Ready to work on different databases ***
** Ready to apply database skills in realtime project ***
Requirements
Basic understanding of database concepts
No specific prerequisite for this course
Description
MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).SQL is the most popular language for adding, accessing and managing content in a database. It is most noted for its quick processing, proven reliability, ease and flexibility of use. MySQL is an essential part of almost every open source PHP applicationThis course is specially designed for newbies who want to start career in DatabaseThis Course covers1. Setup and Installation2. Database related queries3. All type Select Queries4. Sorting and Grouping5. Group Functions6. Joins7. Delete commands8. Sub queries9. Advance Queries10. Interview Questions
Overview
Section 1: Step by Step Installation Instructions - Windows Machine
Lecture 1 MySQL Server Installation
Lecture 2 MySQL Client Installation : Workbench
Lecture 3 Sample Database URL
Lecture 4 Import Sample Database
Section 2: Retrieve data from tables : Simple Select Queries
Lecture 5 Select Query Basics : Fetch Data from Table
Lecture 6 Select data from table : Data filtration using WHERE Clause
Lecture 7 Select Query : Data Filtration : Where Clause with Logical AND and OR
Lecture 8 Select Query : Data Filtration using List and Range
Lecture 9 Fetch unique data from column and Table structure
Lecture 10 Display data with Column Alias
Lecture 11 Display data in Sorting order
Lecture 12 Queries of this complete section
Lecture 13 _________Practice Questions ____________
Section 3: Advance Select Queries
Lecture 14 Select data with Pattern Matching - Part 1
Lecture 15 Select data with Pattern Matching - Part 2
Lecture 16 SQL - SubQuery
Lecture 17 Select Query : Fetch Null data
Lecture 18 Arithmetic operations on Column data
Lecture 19 _______________ Practice Questions ____________________
Lecture 20 Queries of this complete section
Section 4: Delete Data from Table
Lecture 21 SQL - Delete data from tables( Delete | Drop | Truncate)
Lecture 22 Queries of this complete section
Section 5: Grouping
Lecture 23 Group Functions
Lecture 24 Display data with Grouping
Lecture 25 Filter data before and after Grouping
Lecture 26 Queries of this complete section
Lecture 27 _______________ Practice Questions ____________________
Section 6: Joins between tables
Lecture 28 What is Join
Lecture 29 Cross or Cartesian Join
Lecture 30 Inner Join | Equi Join | Simple Join
Lecture 31 Left Join | Left Outer Join
Lecture 32 Right Join | Right Outer Join
Lecture 33 Full Join | Full Outer Join
Lecture 34 Self Join
Lecture 35 _______________ Practice Questions ____________________
Lecture 36 Queries of this complete section
Section 7: Working with Tables
Lecture 37 Create Tables by Coping another Table
Lecture 38 Create Table
Lecture 39 Insert data into table
Lecture 40 Update data of a table
Lecture 41 Update Table Structure
Lecture 42 All Queries of this section
Section 8: Advance SQL
Lecture 43 SQL - Views
Lecture 44 SQL - Indexes
Lecture 45 Union and Union All
Lecture 46 Queries of this complete section
Section 9: Constraint
Lecture 47 SQL - Not Null constraint
Lecture 48 Check Constraint
Lecture 49 Default Constraint
Lecture 50 SQL - Unique Key constraint
Section 10: Advance Constraints
Lecture 51 Primary Key
Lecture 52 Foreign Key
Lecture 53 Difference between Primary Key and Unique Key
Section 11: SQL Interview Questions
Lecture 54 Copy a Table without Structure
Lecture 55 Find 2nd(Any number) Highest | Lowest Salary of Employee
Section 12: ____ Retired Content ______
Lecture 56 MySQL Server Installation : Community Version
Lecture 57 MySQL Query Browser Installation
Lecture 58 Office Table
Lecture 59 Empoyees Table
Lecture 60 Customer Table
Lecture 61 Setup Tables and Data for practice
Lecture 62 MySQL Structure
Lecture 63 Show all available Databases
Lecture 64 Create new Database
Lecture 65 Delete Databasse
Lecture 66 Show Selected Database
Lecture 67 Switch to different database
Lecture 68 Show database table Structure
Lecture 69 Select All data from Table
Lecture 70 Select few columns from table
Lecture 71 Select Column with Alias
Lecture 72 Select data with Concatenation
Lecture 73 Select Unique data from table
Lecture 74 Select Data with Group Functions -Min | Max | Avg | Sum | Count
Lecture 75 Data Sorting - One Column
Lecture 76 Data Sorting - Multiple Columns
Lecture 77 Select Data with Where clause
Lecture 78 Select Data | Filter with Logical OR
Lecture 79 Select Data | Filter with Logical AND
Lecture 80 Select Data | Filter in a List
Lecture 81 Select Data | Filter in Range | Between Keyword
Freshers looking opportunity in Software Development or Software Testing,Software Testers looking Opportunity in Database Testing


Homepage

https://www.udemy.com/course/sql-mysql-database/