MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL and Database for Analysts - Increase your team value

Course Summary

Learn basic SQL so you can communicate better with DBAs and Developers, and increase your value as a team member.


  • +

    Course Syllabus

    • Introductions: The course, databases and the tools
      • Introduction to the lecturer and the course
      • Introduction to Relational Databases
      • Downloading and installing MS SQL Server
      • Test yourself: Relational Databases
      • Exercise: Experiment with the spreadsheet
    • Structured Query Language (SQL), DML and SELECT
      • Overview of SQL
      • Reading from a table using SELECT
      • Some Hints
      • Exercise: Choose the information YOU want
      • Test yourself: The SELECT statement
      • Exercise: What else might you want to know?
    • Introducing Derived Columns and Functions
      • The database doesn't have to contain everything!
      • Derived columns
      • Functions (COUNT, MAX, MIN, AVG, SUM)
      • Exercise: Derived Columns and Functions
      • Test yourself: Derived Columns and Functions
    • Changing data in a table
      • DML: Data-changing statements
      • Adding new data: the INSERT statement
      • Removing data: the DELETE statement
      • Changing existing data: the UPDATE statement
      • INSERT, UPDATE and DELETE using Management Studio
      • Summary: INSERT, UPDATE and DELETE
      • Exercise: Experiment with changing data
      • Test yourself: INSERT, UPDATE and DELETE
    • More with SELECT
      • The ORDER BY clause
      • Working with text: the LIKE comparison
      • Functions and GROUP BY
      • Exercise: LIKE, ORDER BY and GROUP BY
      • ORDER BY, LIKE and GROUP BY
    • The Database Manager and the Database Administrator
      • The Database Manager and the Database Administrator
      • Exercise: Exploring Instance and Database settings
      • Test yourself: The Database Manager and the DBA
    • Defining the database: Data Definition Language (DDL)
      • Introducing DDL
      • Changing and changing a table
      • Create and changing a database
      • Exercise: Creating and changing the PhoneBook
      • Test yourself: DDL
      • Exercise: Do you always have a value?
    • NULL: a load of fuss over nothing!
      • What does NULL really mean?
      • What does NULL mean in practice?
      • Exercise: NULL
      • Test yourself: NULL
      • Exercise: Who is that? Which one is that? (identity)
    • A question of identity?
      • What's the problem? Double trouble!
      • The solution: "Identifiers" or "Keys"
      • Exercise: Identity and keys
      • Test yourself: Identity and keys
      • Exercise: Using a real phone book
    • Indexes
      • What is an index and what does it do?
      • Creating and using indexes
      • Exercise: Creating and Dropping INDEXes for yourself
      • Test yourself: INDEXes
      • Exercise: More (and more) information
    • Normalization, Data Modelling and JOIN
      • What's the problem with PhoneBook?
      • How do we "Normalize" PhoneBook?
      • Exercise: Examine the normalized database
      • The SELECT statement with JOIN
      • Exercise: Normalization, Data Modeling and JOIN
      • Test yourself: Normalization, Data Modelling and JOIN
    • Temporary tables and VIEWs
      • Temporary tables: SELECT INTO
      • Introducing VIEWs
      • Exercise: Temporary tables and VIEWs
      • Test yourself: Temporary tables and VIEWs
    • Securing the database: Data Control Language (DCL)
      • Introducing DCL
      • Making security more convenient with Roles
      • Exercise: DCL and User privileges
      • Test yourself: Security and DCL
    • Course review
      • What we've covered together
      • Next steps: Where do you go from here?


Course Fee:
USD 99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top