55352AC : Introduction to SQL Databases

Duration: 3 Days (24 Hours)

55352AC : Introduction to SQL Databases Course Overview:

This 55352AC : Introduction to SQL Databases course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.

Audience Profile

The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.

At Course Completion

  • Describe key database concepts in the context of SQL Server
  • Describe database languages used in SQL Server
  • Describe data modelling techniques
  • Describe normalization and denormalization techniques
  • Describe relationship types and effects in database design
  • Describe the effects of database design on performance
  • Describe commonly used database objects

Module 1: Introduction to databases

This module introduces key database concepts in the context of SQL Server.

Lessons

  • Introduction to relational databases
  • Other types of database
  • Data analysis
  • Database languages

Lab 1: Querying SQL Server

  • Click here to enter text.

After completing this module, students will be able to:

  • Describe what a database is
  • Understand basic relational aspects
  • Describe database languages used in SQL Server
  • Describe data analytics
  • Describe database languages used in SQL Server

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

Introduction to SQL Databases Course Prerequisites:

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.

Q: What is 55352AC: Introduction to SQL Databases?

A: 55352AC : Introduction to SQL Databases is a training course that provides an introduction to SQL databases and the fundamentals of working with SQL Server. This course covers the basics of relational databases, SQL querying, and essential database management tasks.

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.

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability

Classroom

  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention

Onsite

  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Microsoft Certified Trainers (MCT).
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.
×