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

[LeeAndro]

Last updated 3/2021MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 2.97 GB | Duration: 7h 21m

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 real 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 For 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://anonymz.com/https://www.udemy.com/course/sql-mysql-database/

DOWNLOAD

https://1dl.net/10ta702fwxb1/LraGzNJc__Step_By_St.part1.rar.html
https://1dl.net/8j568idyr7sn/LraGzNJc__Step_By_St.part2.rar.html
https://1dl.net/xbl8ej8bfpin/LraGzNJc__Step_By_St.part3.rar.html