You will learn to:
Databases drive nearly every Internet and Intranet Web site. Global IT’s Introduction to SQL and Database Design class teaches you how to master their power through a thorough grounding in SQL and sound database design fundamentals.
This course is designed for people with no relational database experience. The database that we use for the class is MySQL, an open source product that is gaining in popularity in the industry and SQL Server. However, the concepts are basic enough that they transfer easily to any standard database product that abides by the ANSI standards.
SQL (Structured Query Language) is used to retrieve, edit, remove and add data in relational databases. SQL programmers define and create relational database structures including tables, views etc.Good SQL skills are always in demand and are useful in a number of careers including database developers, report writers, business analysts, computer programmers, web developers, testers, data analysts, etc. Because an increasing number of companies are storing and analyzing an ever increasing amount of corporate data, the demand for SQL or database skills will continue to increase.
SQL has a shorter learning curve when compared to other skills like business analysis or computer programming or testing. Part of the reason is that SQL is a well-defined, standardized language that has been around for a number of years.
Database Basics
Database Design Fundamentals
Creating Tables
Single Table Queries
Multiple-Table Queries
Updating Data
Database Administration
SQL Functions and Procedures
Embed SQL commands in PL/SQL and T-SQL procedures
Real testimonials from our Students!
I am writing to thank all of the hardworking individuals at Global IT. Without your support, it would not have been possible for me to make such a smooth career transition. After being laid off from the tool making industry, I had the opportunity to enroll in the program at GIT. With a family to [...] Read more
Stewart Sykes
9/30/2020 G.I.T, Global Information Technology, one the “stomping grounds”, for me to get a head-start in my career in IT was very foundational. Coming from where I did-nonetheless, how I did, this school was ‘almost’ like a sanctuary for me to tune in, stay focused, and connect with individuals from all walks of life pursuing [...] Read more
William Jones
I was in the legal field for over 20 years (Secretary promoted to Paralegal). After being laid off from my last position, I decided I needed a change. I had used databases as a front end user during my legal field and was really interested in learning more. My passion for computers and database interest [...] Read more
Donna Zarzycki
Through this letter I want to thank Mr. Manish Modi and Global information Technology ( GIT) for helping me restart my career. I was working in the IT field and took a break for family reasons. After being a full time mom for 11 years, I recently decided to restart my career and wanted to [...] Read more
Sonal Shirodkar
I just wanted to express my feelings about Global Information Technology and their staff. First let me say I have never encountered an organization that cares about the students as much as GIT. After working many years for an automotive supplier in the auto industry I found myself unemployed, without a degree or any certifications [...] Read more
Aubrey Carvine