Popis kurzu SQL Querying - Level 2 Advanced Querying
SQL Querying Advanced
In this course you will learn how to identify and use advanced querying techniques. You might find that you need to modifying the structure of a table; inserting, updating, deleting data and indexing tables to optimize query performance.
PŘEDPOKLADY SQL Querying Fundamentals
Nahoru CÍLOVÁ SKUPINA Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology.
TÉMATA KURZU In this course, you will work with advanced queries to manipulate and index tables. You will also create transactions so that you can choose to save or cancel the data entry process.
You will: Use subqueries to generate query output. Manipulate table data by inserting and updating records in a table and deleting records from a table. Manipulate the table structure. Create views, manipulate data through views, modify the view structure, and drop views. Create indexes on table columns and drop inefficient indexes. Mark the beginning of a transaction, roll back a transaction, and commit a transaction.
Nahoru OSNOVA KURZU 1 - USING SUBQUERIES TO PERFORM ADVANCED QUERYING Search Based on Unknown Values Compare a Value with Unknown Values Search Based on the Existence of Records Generate Output Using Correlated Subqueries Filter Grouped Data Within Subqueries Perform Multiple-Level Subqueries
2 - MANIPULATING TABLE DATA Insert Data Modify and Delete Data
3 - MANIPULATING THE TABLE STRUCTURE Create a Table Create a Table with Constraints Modify a Table's Structure Back Up Tables Delete Tables
4 - WORKING WITH VIEWS Create a View Manipulate Data in Views Create Aliases Modify and Delete Views
Aktuální osnova kurzu se může lišit v závislosti na pobočce, která ho nabízí. Více informací vám poskytnou naši obchodní zástupci. Nahoru Included Course Resources Learn TosVideo Spotlights Watch short video clips of courseware material to further your training, help with retention or test your skills. AssessmentAssessments Stay on track! Quiz yourself for comprehension of course material before or after class. eCoursewareeCourseware As a New Horizons student, you will have access to the latest version of the course content. LabsLabs Practice what you have learned on real equipment that replicates working with the top networking technologies, accessible from anywhere. ChecklistCheck Lists Quick reference for use while completing class activities, on the job, or studying for an exam. CollaborateCollaborate Instantly connect with other New Horizons students to discuss class content. MobileMobile Extend your classroom experience! Access key course content anytime, anywhere - right on your mobile device. SOUVISEJÍCÍ
*Objednávka kurzu či žádost o více informací je zaslána přímo dodavateli vzdělávání. Ceny kurzů bez slev na EduCity jsou stejné jako u dodavatelů. Uplatnění slev u LAST MINUTE a Akčních kurzů pouze při objednání přes EduCity.