Master the fundamentals of SQL Server 2019, the industry-leading database management platform from Microsoft. In this course, instructor Adam Wilbert equips beginners with the core skills they need to create and manage SQL Server databases. Adam begins with the basics, showing how to install SQL Server and log into a local database server. He then discusses how to create new databases, design tables, define relationships, write queries, and use stored procedures and built-in functions. Plus, he demonstrates how to perform crucial database administration tasks, such as backups and restores, security enhancements, and performance monitoring.
Learn More- Seek Your Pathways
- Explore Academics
- Anthropology
- Communication
- Economics
- Journalism
- Landscape Architecture
- Legal Studies
- Managerial Economics
- Political Science
- Public Policy
- Environmental & Natural Resource Economics
- Social Thought & Political Economy (STPEC)
- Sociology
- Sustainable Community Development
- SBS Exploratory Track
- Minors, Certificates, and More
- SBS 4+1 Accelerated Masters Programs
- Explore Careers
- What are Career Communities?
- Advertising / Public Relations / Marketing
- Business / Entrepreneurship / Management / Consulting
- Health / Research / Education / Culture
- Environment / Natural Resources / Sustainability
- Finance / Investment / Real Estate / Insurance
- Government / Public Policy / International Relations
- Law / Legal Services / Criminology / Forensics
- Media / Journalism / Entertainment
- Non-Profit / Social Justice / Activism
- Technology / Data / Analytics
- Our Diverse Communities
- What Are Diverse Communities?
- SBS RISE: Remedying Inequity through Student Engagement
- Black, Indigenous & Students of Color
- First Generation Students
- International Students
- LGBTQIA+ Students
- Student Athletes
- Students with Disabilities
- Students with Financial Need
- Transfer Students
- Veterans
- Women in the Workforce
- Post-Grad Planning
- Who We Serve
- How do I?
- Complete Academic/Degree Tasks
- Apply for Scholarships and Awards
- Declare an SBS Major
- Meet with an Academic Advisor
- Meet with an Academic Dean
- Suggest New Courses
- Petition for Late Add
- Petition for Pass/Fail
- Withdraw from a Class/Petition for Late Withdrawal
- Petition for Course Credit Overload
- Release Academic Information (FERPA)
- Withdraw from the University
- Explore Majors, Experiential, and Professional Pathways
- Apply for Funding for Internships, Study Abroad, Research, and other High-impact Opportunities
- Assess My Skills and Interests
- Explore Majors
- Find an Undergraduate Research Opportunity
- Get Involved on Campus
- Learn about Different Career Paths
- Study Abroad
- Take Courses through the Five Colleges
- Domestic Exchange
- Get Career Ready
- Apply for Scholarships to Support Research or Internships
- Develop My Job Search Skills & Strategy
- Look for Internships and Jobs
- Meet with a Career Advisor
- Negotiate an Offer
- Network and Connect with Mentors
- Prepare a Resume and Cover Letter
- Prepare for/Navigate a Career Fair
- Prepare for an Interview
- Register an Internship for Credit
- Write a Personal Statement for Graduate School
- Complete Academic/Degree Tasks