6-01-2023, 04:04 | view 👀:31 | 🙍 oneddl | redaktor: Baturi | Rating👍:

Sql Made Easy For Beginners

Last updated 6/2020
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 12.82 GB | Duration: 31h 48m
Step by Step, Easy, In Detailed, Well Organized Videos along with Interview Questions (Includes MySQL and Oracle)

Step by Step, Easy, In Detailed, Well Organized Videos along with Interview Questions (Includes MySQL and Oracle)
What you'll learn
SQL from Basics to the Advanced Level
Learning SQL on both popular MySQL and Oracle RDBMS Software
Requirements
All the pre-requisites are covered in this course itself.
Description
This course will teach you how to use the SQL language with MySQL and Oracle, by covering all the topics of SQL from scratch to advanced level in a detailed, step by step, practical, solution oriented and easiest manner. Check the course contents to see the number of topics I covered int this video course to make you an SQL expert by teaching the SQL from basics and scratch to the advanced level.
Overview
Section 1: Introduction
Lecture 1 Course Overview
Lecture 2 Database Concepts (Database, DBMS, Data Models, RDBMS and SQL)
Section 2: Practice different SQL Statements, Clauses, Keywords and Operators
Lecture 3 How to Practice SQL without installing any Software?
Lecture 4 Select Command
Lecture 5 distinct keyword
Lecture 6 SQL is not case sensitive
Lecture 7 Semicolon
Lecture 8 Where Clause
Lecture 9 Using Relational Operators in Where Clause Condition
Lecture 10 Using Logical Operators (AND, OR, NOT)
Lecture 11 Between Operator
Lecture 12 Order By Clause (ASC, DESC)
Lecture 13 Using Between Operator with Text
Lecture 14 In Operator
Lecture 15 Like Operator and Wildcard Characters
Lecture 16 Aliases for Table Column Names (AS Keyword)
Lecture 17 Limit Keyword
Lecture 18 Breaking the Lengthy SQL Statement into multiple lines
Section 3: MySQL Built-in Functions
Lecture 19 MySQL Built-in Functions
Lecture 20 upper() MySQL String Function
Lecture 21 lower() MySQL String Function
Lecture 22 length() MySQL String Function
Lecture 23 instr() MySQL String Function
Lecture 24 substr() MySQL String Function
Lecture 25 concat() MySQL String Function
Lecture 26 trim() MySQL String Function
Lecture 27 abs() MySQL Numeric Function
Lecture 28 mod() MySQL Numeric Function
Lecture 29 greatest() and least() MySQL Numeric Functions
Lecture 30 truncate() MySQL Numeric Function
Lecture 31 power() and sqrt() MySQL Numeric Functions
Lecture 32 current_date(), curdate(), current_time(), curtime(), now() and sysdate() MySQL
Lecture 33 year(),month(),day,monthname(),dayname() MySQL Date Time Functions
Lecture 34 avg(), max(), min(), count() and sum() MySQL Aggregate Functions
Lecture 35 Arithmetic Operators
Section 4: Practicing SQL on MySQL
Lecture 36 Installing MySQL Server and Workbench Client for Practising SQL
Lecture 37 Creating, Deleting, viewing and using Databases
Lecture 38 Creating,Viewing, Describing and Deleting Tables
Lecture 39 Insert Into Statements (For inserting data into Tables)
Lecture 40 Data Types
Lecture 41 Null Value, Is Null Operator and Is Not Null Operator
Lecture 42 Delete Statement (For Deleting the Records from Table)
Lecture 43 Update Statement and Set Keyword (For Updating the Table Records)
Lecture 44 Rename statement and To Keyword (For Renaming Table Name)
Lecture 45 Alter Statement, Add, Modify Column, Rename Column and Drop Column Keywords
Lecture 46 Set Autocommit
Lecture 47 Commit Statement
Lecture 48 Rollback Statement
Lecture 49 Truncate Statement
Lecture 50 Single Line and Multi-Line Comments
Lecture 51 Group By Clause
Lecture 52 Having Clause
Lecture 53 Sequence of using where, group by, having and order by clauses
Section 5: Set Operators
Lecture 54 Set Operators
Lecture 55 Union Operator
Lecture 56 Union All Operator
Lecture 57 Intersect Operator
Lecture 58 Minus Operator
Section 6: Sub Queries and Other Advanced Concepts
Lecture 59 Tables and Aliases
Lecture 60 Joins (Inner Join, Left Join, Right Join, Full Join and Self Join)
Lecture 61 Sub Query (Explaining Single Row Sub Query by solving different SQL problems)
Lecture 62 In Operator
Lecture 63 Using In Operator with Multi Row Sub Query
Lecture 64 Using Any Operator in Multi Row Sub Query
Lecture 65 Using All Operator in Multi Row Sub Query
Lecture 66 Exists Operator
Lecture 67 Using Sub Queries for retrieving the records from multiple tables
Lecture 68 Using Multiple Sub Queries in a single SQL statement
Section 7: Integrity Constraints and other advanced concepts
Lecture 69 Integrity Constraints
Lecture 70 Not Null (Integrity Constraint)
Lecture 71 Unique (Integrity Constraint)
Lecture 72 Primary Key (Integrity Constraint)
Lecture 73 Foreign Key (Integrity Constraint)
Lecture 74 Check (Integrity Constraint)
Lecture 75 Default (Integrity Constraint)
Lecture 76 auto_increment
Lecture 77 Insert Into
Lecture 78 AS Keyword
Lecture 79 IfNull() function
Lecture 80 Case, When,Then and End Keywords
Lecture 81 Delimiter
Lecture 82 Delimiter usage in Stored Procedures
Lecture 83 Views
Lecture 84 Indexes
Section 8: JDBC and ODBC
Lecture 85 JDBC (Connecting to MySQL Database from Java Programs)
Lecture 86 ODBC
Section 9: Client Tools and other topics
Lecture 87 MySQL Shell Command Line Tool
Lecture 88 MySQL Command Line Client
Lecture 89 Using default Windows Command Prompt for connecting to MySQL Server
Lecture 90 Types of SQL Statements
Lecture 91 Grant and Revoke SQL Statements
Lecture 92 Temporary Tables
Lecture 93 Show Columns,Show Indexes,Show Privileges and Show Grants Statements
Lecture 94 Inserting Null
Lecture 95 Using trim() for trimming the corner characters of the specified Table values
Lecture 96 Using wild-cards as normal characters
Lecture 97 Database Objects
Section 10: Using MySQL In Linux Machine and Putty Software
Lecture 98 Creating Linux Virtual Machine
Lecture 99 Installing MySQL Server in Linux Ubuntu Machine
Lecture 100 Using Putty for Connecting to a Remote Machine having MySQL and performing SQL
Section 11: Oracle SQL
Lecture 101 Oracle Database, SQL Plus, SQL Developer and Executing SQL Queries
Lecture 102 Oracle SQL Queries
Lecture 103 Oracle SQL Built-in functions
Lecture 104 Oracle SQL Queries (Part 2)
Lecture 105 Oracle SQL Queries (Part 3)
Lecture 106 Oracle SQL Queries (Part 4)
Lecture 107 Oracle SQL Queries (Part 5)
Section 12: Other Tools for SQL
Lecture 108 DBeaver Universal DB Client Tool
Lecture 109 XAMPP for Practicing SQL
Section 13: Interview Questions
Lecture 110 Question 1
Lecture 111 Question 2
Lecture 112 Question 3
Lecture 113 Question 4
Lecture 114 Question 5
Lecture 115 Question 6
Lecture 116 Question 7
Lecture 117 Question 8
Lecture 118 Question 9
Lecture 119 Question 10
Lecture 120 Question 11
Lecture 121 Question 12
Lecture 122 Question 13
Lecture 123 Question 14
Lecture 124 Question 15
Lecture 125 Question 16
Lecture 126 Question 17
Lecture 127 Question 18
Beginners who want to learn SQL from scratch to the advanced level
https://www.udemy.com/course/sql-made-easy-for-beginners/

Please Help Me Click Connect Icon Below Here and Share News to Social Network | Thanks you !

In today's era of digital learning, access to high-quality educational resources has become more accessible than ever, with a plethora of platforms offering free download video courses in various disciplines. One of the most sought-after categories among learners is the skillshar free video editing course, which provides aspiring creators with the tools and techniques needed to master the art of video production. These courses cover everything from basic editing principles to advanced techniques, empowering individuals to unleash their creativity and produce professional-quality content.

Sql Made Easy For Beginners

Comments (0)

Log in