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
Module 2: Data Modelling
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
Module 3: Normalization
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
Module 4: Relationships
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
Module 5: Performance
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
Module 6: Database Objects
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.
Q: Who is this course designed for?
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.
Q: Are there any prerequisites for this course?
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.
Q: What topics are covered in this course?
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.
Q: How is the course structured?
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.
Q: Does this course focus specifically on SQL Server?
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.
Q: Is this course certification-oriented?
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.
Q: Can I take this course online?
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.
Q: What are the benefits of taking this course?
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.
Q: Are there any recommended follow-up courses?
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!