Programming with PHP and MYSQL course offers advanced knowledge in open source technologies MySQL and PHP to develop console and web applications. Gain hands-on training to use Connectors to access MySQL databases, query the database effectively, present data in...
Introduction to SQL Databases
Course Statuse
Registration Open
Duration
3 Days, 24 Hours
Timing
9:00 AM - 04:00 PM
Availability
Weekdays - Weekends
Course Id:
10985
Course Overview
SQL Databases introduction course is intended for people looking to move into a database professional role or whose job role is expanding to encompass database elements. You’ll learn the basic structure of relational databases, read and write SQL statements and advanced data manipulation techniques. The course describes fundamental database concepts including, database types, database languages, […]
Learning Outcome
Upon successful completion of SQL databases course, students will be able to:
- Describe key database concepts in the context of SQL Server.
- Understand and describe database languages used in SQL Server.
- Various data modeling techniques.
- Normalization and Denormalization techniques.
- Describe relationship types and effects in database design.
- Effects of database design on performance.
- Describe commonly used database objects.
Prerequisite
- Must have general computer literacy and interest in programming
Course Content
- Course Content
- Introduction to Databases
- Data Modeling
- Normalization
- Relationships
- Performance
- Database Objects
- SQL Labs
- Exploring and Querying SQL Server Databases
- Identify Components in Entity-Relationship Modeling
- Normalizing Data
- Planning and Implementing Referential Integrity
- Performance Issues
- Using SQL Server
(905) 212-9039
Enquire Now
Courses you maybe interested
CCNA Scaling Networks
CCNA Scaling Networks certification training advances your networking career and prepares you for networking analyst and engineering jobs. The course focuses on hands-on training to configure and troubleshoot routers and switches and resolve common issues with OSPF,...