This 3-day SQL intensive program will provide you with everything you need to know to jump-start your career in database management!
On Day 1, you'll learn SQL basics including defining instructions and composing basic queries. On the second day, you'll learn to create views, subqueries and conversion functions. By Day 3, you will create your own SQL database that you can use to organize and analyze data and reinforce what you've learned throughout the course. You'll also learn how to import and export data from Microsoft Office applications and automate workflow with stored procedures.
Courses in the SQL Bootcamp Program
This Level I course covers SQL fundamentals including relational database management systems (RDBMSs), Microsoft SQL Server, and the SQL programming language. Through this course, you'll gain an understanding of how data is stored and you'll learn how to write queries to make sense of complex data.
Build upon SQL basics to achieve easier and more targeted data analytics. You'll learn how to use views, subqueries, math functions, and logic statements to find data that meet specific search criteria. You'll also learn how to increase report readability by using data conversion functions to format data.
SQL III students learn how to build and maintain a highly efficient database that incorporates best practices in database management, including exporting external data, creating temporary tables, protecting data integrity, and maximizing procedural efficacy.