LINUXACADEMY_SQL_PRIMER_TUTORIAL-OXBRiDGE

Section

Appz

Group

OXBRiDGE

Size

1,15 GB

Files

27

Date

2017-05-18

NFO

                                           
░ ░▒▒▒▓▓█████▌░░ University of OXford & University of camBRiDGE ░░▐████▓▓▒▒▒░ ░
   ▄▄██▓▄ ▐███▌  ████▐███████▓▄ █████████▄ ▐███▌██████▓▄▄    ▄▄▓████▓ ▐████████
 ▄████████████  ▐███▌▐███▌▀████▌████▌ ▀███▓ ▀▀▀ ███▓▀▀████ ▄▓███▀     ▐███▓▀▀▀
▐███▀ ▀███▀███▓▄███▀ ▐███ ▄███▀▐███▓ ▄████▀▐███▌███▓   ███▓████       ▓███▌
███▌   ▐██▌ ▀████▀   ▓███████▄▄▐████████▓▄ ▐███▓███▓   ▐██████▌ ▀█████▓██████▓
████▄ ▄███▄▄███▀███▓ ████  ▀███▓███▓ ▀████▌████▐███▌   ███████▓    ▓██████▌
▐████████▀████▌  ███████▌  ▄███████▌   ████████▓███▌▄▄███▓▀█████▄▄████▓███▄▄▄▄▄
 ▀▀▓██▀▀ ▐████  ▐███▓████████▓▀████▌  ▐███████████████▓▀▀   ▀▀▓████▀▀░▓███████▌
  ...is a collective term for characteristics that the two institutions share.


     ·-- PUBLISHER -----·> Linux Academy                                      
     ·-- LECTURESHIP ---·> SQL Primer                                         
                                                                              
                                                                              

     ·-- LECTURE DATE --·> 05-2017           
                           2017    {Published}
    
     ·-- PERIOD in HRS--·> 03+                                 
     ·-- SCALE ---------·> 25x50mb                                           

     ·-- LECTURE LINK --·> https://goo.gl/bzggEr                     
                                                                                              
 
     
     Creation and Setup                                                      
      Introduction                                                           
     00:06:09                                                                
      Create Database                                                        
     00:14:24                                                                
      Create Table                                                           
     00:07:53                                                                
      Create Table With Constraints                                          
     00:07:23                                                                
      Oracle MySQL Installation: Ubuntu                                      
     00:06:26                                                                
      Oracle MySQL Secure Setup: Ubuntu                                      
     00:08:01                                                                
      Oracle MySQL Installation: CentOS                                      
     00:07:02                                                                
      Oracle MySQL Secure Setup: CentOS                                      
     00:12:08                                                                
      MariaDB Installation: Ubuntu                                           
     00:07:16                                                                
      MariaDB Secure Setup: Ubuntu                                           
     00:07:38                                                                
      MariaDB Installation: CentOS                                           
     00:07:15                                                                
      MariaDB Secure Setup: CentOS                                           
     00:07:15                                                                
     SQL Functions and Statements                                            
      Insert Into                                                            
     00:08:55                                                                
      Select From                                                            
     00:07:10                                                                
      Alter Table                                                            
     00:08:15                                                                
      Delete From                                                            
     00:05:50                                                                
      Create Index                                                           
     00:06:57                                                                
      Drop Table                                                             
     00:07:07                                                                
      Truncate Table                                                         
     00:04:40                                                                
      Auto Increment                                                         
     00:08:36                                                                
      Count Function                                                         
     00:07:10                                                                
      Average and Sum Functions                                              
     00:08:20                                                                
      Like Operator                                                          
     00:09:22                                                                
      Create View                                                            
     00:07:31                                                                
      Inner Join                                                             
     00:08:34                                                                
      Left Join                                                              
     00:07:59                                                                
      Right Join                                                             
     00:07:15                                                                
      Full Join                                                              
     00:05:02                                                                
      Unions                                                                 
     00:10:02                                                                
      Sorting Records                                                        
     00:06:31                                                                
      Minimum and Maximum Values                                             
     00:08:15                                                                
      Upper and Lower Case Conversions                                       
     00:05:31                                                                
      Now()                                                                  
     00:06:02                                                                
     

Files