SQL For Data Handling
Most of the world’s data lives in databases. To turn data into insights, you must know how to wrangle and extract it. SQL is the most popular and time-tested language to do this.
Description
Learn how to use SQL quickly and effectively with this course!
You'll learn how to read and write complex queries to a database using one of the most in demand skills - SQL. These skills are applicable to any major SQL database, such as Oracle, MySQL, Microsoft SQL Server and much more.
Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! In this course you'll learn quickly and receive challenges and tests along the way to improve your understanding!
In this course you will learn everything you need to become a SQL Pro! Including:
- Get started with SQL, one of the world's most popular database extraction tools
- Learn he basics of SQL syntax
- Analyzing data using aggregate functions with GROUPÂ BY commands
- Running advanced queries with string operations and comparison operations
- Learn to use logical operators to add logic flow to your SQLÂ queries
- Learn common SQLÂ JOIN commands
- Learn to create tables and databases with constraints on data entries
and much, much more!
Curriculum
- Introduction to Data, Analytics & SQL (64:32)
- Installation & Structure of RDBMS (66:13)
- LiveSql, Schemas, Data Dictionary and Select Command (58:43)
- Keywords (58:13)
- Arithmatic Operations, Aliases and Concatination (61:09)
- Working with Oracle Live SQL and More (62:31)
- Working With Live SQL Cont...Order By & Oracle Installation (60:24)
- Functions & Dual (51:48)
- Functions Cont... (65:34)
- User Creation & Number & Other Functions Cont... (59:46)
- Date & Time, Round, Trunc & Other Functions (57:15)
- Data Type Conversions (59:19)
- Conversion Function Use Cases (52:31)
- Joins (35:58)
- Equi - Joins (61:13)
- Non-Equi Joins, Inner Joins, Outer Joins (54:20)
- New 9i Joins - Cross, Natural, Full Outer- Inner & More (50:35)
- Aggregate Functions Or Multiple Row Functions, Group By & Order By Clause (48:21)
- Nesting Of Group By Function & Sub Queries (54:29)
- Sub Queries Cont... (56:22)
- Single - Multiple Row Subqueries & Comparison Operators (49:37)
- Multiple & Co-Related Sub Queries & Data Manipulation Language ( DML ) (53:55)
- DML - Insert, Update, Delete (52:32)
- DML - Create, Insert, Update, Delete Cont...... (61:40)
- Auto Committ & Auto Rollback & Data Definition Language ( DDL ) (59:47)
- DDL - Alter, Drop, Rename Statement (54:42)
- Truncate Statement, Constraints - Not Null, Unique, Check, Primary Key, Foreign Key (52:50)
- Data Dictionaries & Constraints Primary Key, Foreign Key Cont... (51:39)
- Column & Table Level Constraints & Constraints Enforcing & Views (61:20)
- Views, Synonyms, Sequences & Data Controlling Language ( DCL ) - Grant & Revoke Statement (39:10)
- 12 Months of all courses unlimited access
- +
- Completion Certificates
- Free access to new courses
- Internships/Projects
Connect with us
