Price:  12 USD | Size: 11.97 GB | Duration : 27.24+  Hours |
BRAND: Expert TRAINING | ENGLISH | INSTANT DOWNLOAD
 
HOW TO DOWNLOAD THIS COURSE?
You can Instant Download a PDF file After successful payment, This PDF File Contains Course Download links. You can Download This Course immediately from that Links.
 
 
Sql For Beginners Learn Sql From Zero
 
Content
001_ Database Concepts (Database, DBMS, Data Models, RDBMS and SQL)
002_ Practice SQL without installing any Software
003_ Select Command
004_ Distinct keyword
005_ SQL is not case sensitive
006_ Semicolon
007_ Where Clause
008_ Using Relational Operators in Where Clause Condition
009_ Using Logical Operators (AND, OR, NOT)
010_ Between Operator
011_ Order By Clause (ASC, DESC)
012_ Using Between Operator with Text
013_ In Operator
014_ Like Operator and Wildcard Characters
015_ Aliases for Table Column Names AS Keyword
016_ Limit Keyword
017_ Breaking the Lengthy SQL Statement into multiple lines
018_ MySQL Built in Functions
019_ upper() MySQL String Function
020_ lower() MySQL String Function
021_ Length() MySQL String Function
022_ Instr() MySQL String Function
023_ Substr() MySQL String Function_
024_ Concat() MySQL String Function
025_ Trim() MySQL String Function
026_ Abs() MySQL Numeric Function
027_ Mod() MySQL Numeric Function
028_ Greatest() and least() MySQL Numeric Functions
029_ Truncate() MySQL Numeric Function
030_ Power() and sqrt() MySQL Numeric Functions
031_ Current_date(), curdate(), current_time(), curtime(), now() & sysdate()_
032_ Year(),month(),day(),month name(),day name() MySQL Date Time Functions
033_ Avg(), max(), min(), count() and sum() MySQL Aggregate Functions_
034_ Arithmetic Operators
035_ Installing MySQL Server and Workbench Client for Practice
036_ Creating, Deleting, viewing and using Databases
037_ Creating, Viewing, Describing and Deleting Tables
038_ Insert Into Statements (For inserting data into Tables)
039_ Data Types
040_ Null Value, Is Null Operator and Is Not Null Operator_
041_ Delete Statement (For Deleting the Records from Table)_
042_ Update Statement and Set Keyword (For Updating the Table Records
043_ Rename statement and To Keyword (For Renaming Table Name)_
044_ Alter Statement, Add, Modify Column, Rename Column, and Drop Column_
045_ Set Autocommit
046_ Commit Statement
047_ Rollback Statement
048_ Truncate Statement
049_ Single Line and Multi Line Comments
050_ Group By Clause
051_ Having Clause
052_ Sequence of using where, group by, having and order by clauses_
053_ Set Operators
054_ Union Operator
055_ Union All Operator
056_ Intersect Operator
057_ Minus Operator
058_ Tables and Aliases
059_ Joins (Inner Join, Left Join, Right Join, Full Join and Self Join)
060_ Sub Query (Single Row Sub Query explained by solving different problems)
061_ In Operator
062_ Using In Operator with Multi Row Sub Query
063_ Using Any Operator in Multi Row Sub Query
064_ Using All Operator in Multi Row Sub Query
065_ Exists Operator
066_ Using Sub Queries for retrieving the records from multiple tables_
067_ Using Multiple Sub Queries in a single SQL statement
068_ Integrity Constraints
069_ Not Null Integrity Constraint
070_ Unique Integrity Constraint_
071_ Primary Key Integrity Constraint
072_ Foreign Key Integrity Constraint
073_ Check Integrity Constraint
074_ Default Integrity Constraint
075_ Auto_increment
076_ Insert Into
077_ AS Keyword
078_ IfNull() function
079_ Case, When, Then and End Keywords
080_ Delimiter
081_ Delimiter usage in Stored Procedures
082_ Views
083_ Indexes
084_ JDBC (MySQL Database connection from Java Programs)
085_ ODBC (Object Database Connectivity) using SQL ODBC Query Client Tool
086_ MySQL Shell Command Line Tool
087_ MySQL Command Line Client
088_ Using default Windows Command Prompt for connecting to MySQL Server_
089_ Types of SQL Statements
090_ Grant and Revoke SQL Statements
100_ Oracle 11g Software, SQL Plus, SQL Developer and Executing SQL Queries_
101_ Oracle SQL Queries
102_ Oracle SQL Built in functions
103_ Oracle SQL Queries (Part 2)
104_ Oracle SQL Queries (Part 3)_
105_ Oracle SQL Queries (Part 4)
106_ Oracle SQL Queries (Part 5)
107_ DBeaver Universal DB Client Tool
108_ XAMPP for Practicing SQL
109_ Savepoint