Training Course:SQL Advanced QueryingSchool/Trainer:Computer Training Unit, North Carolina State University
Raleigh, North Carolina, United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' In this course you will be introduced to the advanced features of the SQL language, and how it can be used to query a database in order to answer business questions. In this course you will examine the following advanced features: querying with unions, advanced joins and subqueries, add, update and remove data, manipulate tables, views and various indexes, ensure data integrity with transactions, and create databases.
Fee: $225
Suggested Prerequisites: SQL Fundamentals of Querying
You Will Learn
Lesson 1: QUERYING WITH UNIONS AND ADVANCED JOINS
Querying Multiple Tables with Unions
Advanced Joins
Calculating with Compute Lesson 2: SUBQUERIES
Subqueries Lesson 3: ADDING DATA
Inserting Data and Select Into Lesson 4: UPDATING AND REMOVING DATA
Updating Records
Deleting Records
and Deleting the Contents of Tables Lesson 5: MANIPULATING TABLES AND VIEWS
Creating Tables
Modifying Tables
Deleting Tables
Adding and Removing Views Lesson 6: MANIPULATING INDEXES
Adding and Removing Indexes Lesson 7: ENSURING DATA INTEGRITY WITH TRANSACTIONS
Transactions Lesson 8: CREATING DATABASES
Creating a Database with SQL
Deleting a Database ...''
Please go to the school's official website for training price and schedule:
http://www.ncsu.edu/
http://www.ncsu.edu/ctu/
Phone:919.515.8163
School Address:
Computer Training Unit
NC State University
McKimmon Center
1101 Gorman Street
Raleigh, NC 27606 USA
Jobs & Resumes: Raleigh
Houses & Roommates: Raleigh
Other training courses offered by Computer Training Unit, North Carolina State University:
JavaScript Enhancing Web Pages
PHP 4
Visual Studio .NET
Visual Basic 6.0
XML: DTD
XML: Schema
ACT!
Crystal Reports 9.0
FileMaker Pro 5.0
Paradox 10
Acrobat 6.0: For Creative Professionals
Authorware
CorelDRAW
Corel Painter
Director MX
FrameMaker
FreeHand
Freelance Graphics
Illustrator CS2
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent. |
|
|
