Exam 98-364: Database Fundamentals
by Mark Long
Start the free chapterDatabase administration, design and development continue to be some of the most sought-after skills in Information Technology, but where do you start to learn such a big topic? rnrnIn this course, Mark Long teaches you the fundamentals about Microsoft's SQL Server database management system to help you take the first step on a path to becoming part of this exciting field. Mark has worked with SQL Server for almost 20 years and brings his experience along to present database fundamentals in an easy to understand manner to get you started. This course will also help you prepare to take Microsoft's 98-364 Database Fundamentals MTA exam so you can become Microsoft certified right away.
Course content
Welcome6 lessons
Course Prep8 lessons
Microsoft Resources4 lessons
Understanding Databases7 lessons
Transact SQL Language14 lessons
- TSQL Coding Basics5:521 credit or ad
- Lets Store Something3:251 credit or ad
- Creating a Database Using T-SQL5:311 credit or ad
- Creating a Database Graphically3:351 credit or ad
- The Database File5:221 credit or ad
- Creating a Table4:581 credit or ad
- Creating Table Using T-SQL4:461 credit or ad
- Creating a Table Graphically4:141 credit or ad
- Deleting Data5:051 credit or ad
- Understanding NULL6:111 credit or ad
- Graphical Queries3:001 credit or ad
- Retrieving Data4:291 credit or ad
- USE Command2:491 credit or ad
- Deleting Data5:071 credit or ad
Relational Basics10 lessons
- Relational Database Basics4:041 credit or ad
- What is Normalization?6:241 credit or ad
- Normalization Levels4:201 credit or ad
- Understanding Data Integrity5:331 credit or ad
- Understanding Primary Keys5:531 credit or ad
- Creating Primary Keys6:411 credit or ad
- Understanding Foreign Keys4:291 credit or ad
- Database Diagrams pt. 15:011 credit or ad
- Database Diagrams pt. 27:071 credit or ad
- Database Diagrams pt. 35:351 credit or ad
Indexes6 lessons
More Advanced T-SQL12 lessons
- Basic SELECT Statement6:281 credit or ad
- Adding Comments5:241 credit or ad
- Using ORDER BY3:571 credit or ad
- Using a Column Alias4:591 credit or ad
- T-SQL Concatenation4:181 credit or ad
- Using DISTINCT3:121 credit or ad
- Using TOP3:081 credit or ad
- Using LIKE and IN6:391 credit or ad
- COUNT SUM and AVG5:361 credit or ad
- SELECT INTO6:271 credit or ad
- Using the UNION Statement6:321 credit or ad
- Using the INTERSECT Statement3:531 credit or ad