Course Description
Language of Instruction:English|Category: SQL Server: IT & Computers; Oracle: IT & Computers
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, 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 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 course:
- 30 LIVE interactive classes
- Access to class recordings
- Course Timings: Between 6 PM to 9 PM (IST)
Course outline:
- An Introduction to RDBMS
- Basic SQL Statements
- Restricting and Sorting Data
- SQL Functions
- SQL LAB-1
- 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
About course instructor:
Professor Rao works as a Computer Science Lecturer in PTU, Punjab. He is a professionally trained tutor and cleared OCP in Oracle 9i. He teaches Operating Systems, Linux, Testing Tools, RDBMS, Networking, C, C++, C#, Computer Graphics, Digital Electronics, Microprocessors & Software Engineering. He completed hi MCA from IGNOU, India in 2003. He did his B.Sc. in Computer Science from Acharya Nagarjuna Vishwavidhyalayamu, India.
He lives in Chandigarh, India.