This module describes data modelling techniques.

Lessons

• Data modelling
• ANSI/SPARC database model
• Entity relationship modelling

Lab 1: Entity relationship modelling

• Click here to enter text.

After completing this module, students will be able to:

• Understand the common data modelling techniques
• Describe the ANSI/SPARC database model
• Describe entity relationship modelling

This module describes normalization and denormalization techniques.

Lessons

• Why normalize data?
• Normalization terms
• Levels of normalization
• Denormalization

Lab 1: Normalizing raw data

• Click here to enter text.

After completing this module, students will be able to:

• Describe normalization benefits and notation
• Describe important normalization terms
• Describe the normalization levels
• Describe the role of denormalization

This module describes relationship types and effects in database design.

Lessons

• Schema mapping
• Referential integrity

Lab 1: Designing relationships

• Click here to enter text.

After completing this module, students will be able to:

• Describe relationship types
• Describe the use, types, and effects of referential integrity

This module introduces the effects of database design on performance.

Lessons

• Indexing
• Query performance
• Concurrency

Lab 1: Query performance

• Click here to enter text.

After completing this module, students will be able to:

• Discuss the performance effects of indexing
• Describe the performance effects of join and search types
• Describe the performance effects of concurrency

This module introduces commonly used database objects.

Lessons

• Tables
• Views
• Stored procedures
• Other database objects

Lab 1: Using SQL Server in a hybrid cloud

• Click here to enter text.

After completing this module, students will be able to:

• Describe the use of tables in SQL Server
• Describe the use of views in SQL Server
• Describe the use of stored procedures in SQL Server
• Describe other database objects commonly used in SQL Server

A: This 55352AC : Introduction to SQL Databases course is designed for beginners who have little to no prior experience with SQL databases. It is suitable for individuals interested in learning the basics of SQL databases, including aspiring database administrators, developers, data analysts, and anyone who wants to gain a foundational understanding of SQL and database management.

A: No prior experience or technical knowledge is required for this course. It is designed to introduce participants to the fundamentals of SQL databases from scratch. Familiarity with general computer usage and basic database concepts would be helpful but is not necessary.

A: The 55352AC : Introduction to SQL Databases course covers a range of topics, including an introduction to SQL and relational databases, creating and managing databases, basic SQL querying and data manipulation, retrieving data with SELECT statements, filtering and sorting data, working with multiple tables, and an overview of essential database management tasks.

A: The 55352AC : Introduction to SQL Databases course is typically instructor-led and combines lectures, demonstrations, hands-on exercises, and discussions. Participants will have access to course materials, practical exercises, and sample databases to reinforce their learning. The course provides a step-by-step learning path to help participants build their SQL skills gradually.

A: Yes, this 55352AC : Introduction to SQL Databases course focuses on SQL Server as the primary platform for learning SQL database concepts and techniques. However, the core concepts covered in the course are applicable to other relational database management systems as well.

A: While this course does not directly provide a certification, it serves as a solid foundation for individuals who may want to pursue certifications related to SQL and database administration, such as Microsoft Certified: Azure Database Administrator Associate or Oracle Database SQL Certification. The knowledge gained from this course will be valuable for those planning to pursue these certifications.

A: Yes, this course is available in both online and traditional classroom formats. Online courses offer the flexibility to learn at your own pace and convenience, while traditional classroom courses provide a more interactive and collaborative learning experience.

A: By completing this course, participants will gain a foundational understanding of SQL databases and be equipped with the essential skills to work with SQL Server. This knowledge is crucial for individuals who want to pursue careers in database administration, database development, or data analysis.

A: After completing this course, participants can explore more advanced topics related to SQL databases, such as advanced querying, database administration, or business intelligence. Microsoft and other training providers offer a range of specialized courses and certifications for different aspects of SQL databases.