SQL Tutorial - Learn SQL Online

Course Description

2011 was the year of Big Data. And, so will be 2012 and so on till foreseeable future. A report released by International Data Corporation (IDC) estimates that volume of digital data generated in 2011 (1.8 zettabytes) will fill 115 billion 16 GB iPADs. All this data is stored in large data centers in formats like HTML, Documents, Videos and Images. Although that data is important, the data businesses value in is stored somewhere else. In Databases.

SQL is the language that queries the data in database to give you results like “how many people in my database are above the age of 21 and interested in learning SQL”. Needless to say, more than 90% of all large software and web projects employ SQL in one form or the other.

When you learn SQL tutorial, you learn a language that has stood the test of time (there is no SQL killer in sight anywhere), is well in demand (ever increasing number of OCP certifications) and benefits everyone (developers, engineers, managers, marketing professionals and even system administrators).

By the end of this course, you can expect to access and manipulate data in MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems. This course is especially designed for beginners who have no background in DBMS. This course also benefits professionals keen to revise or learn specific SQL concepts.

This SQL tutorial course will be helpful for:

• Students who have completed or are pursuing B.S./ M.S./ B.Tech./ MCA/ PGDCA learn a valuable and an in demand practical skill
• Software developers, engineers and testers enhance their resume
• System administrators will be able to manage database projects and servers
• Web designers will be able to develop full projects themselves than outsourcing it (will need to learn PHP as well)
• Marketing and sales professionals will be able to mine data for business intelligence

What’s in the SQL tutorial course:

• 30 LIVE interactive classes
• Access to class recordings
• Includes one document and an Online Test

Course outline:

• An Introduction to RDBMS
• Relational Data Base concepts
• Definition of Relational DataBase
• Data Models
• ER Modeling
• Benefits of ER Modeling
• Relating Multiple Tables with Primary key and Foreign Key concepts
• RDBMS terminlology
• RDBMS Properties
• Relational Database Management System
• Basic SQL Statements
• To extract data from data base
• Note:- This lesson describes all the SQL statements needed to perform the actions Capabilities of SQL Statements such as SELECTION,PROJECTION and JOIN
• Restricting and Sorting Data
• SQL Functions
• SQL LAB-1
• This LAB covers Selecting all data from different tables, describing the structure of tables,performing arithmetic calculations and specifying column names.Selecting data and changing the order of rows displayed, restricting rows by using the WHERE clause, Sorting rows by using the ORDER BY clause.Creating Queries that require the use f numeric, character and date functions
• SQL Joins
• Subqueries
• Data Manipulation Language (SQL)
• SQL LAB-2
• SQL LAB-3
• Creating and Managing Tables
• Constarints in SQL
• Views - SQL
• Creating DataBase Objects
• Controlling User Access
• SQL LAB-4
• SQL LAB-5
• Restricting and Sorting Data
• SQL Functions
• SQL Joins
• Subqueries
• Data Manipulation Language (SQL)
• Creating and Managing Tables
• Constarints in SQL
• Views - SQL
• Creating Database Objects
• Controlling User Access

Advanced SQL



• Using SET operators in SQL
• Oracle Date time functions
• Enhancements to the GROUPBY clause
• Advanced sub queries
• Hierarchical Retrieval
• Oracle extensions to DML and DDL statements.